Can't build a query using CodeIgniter query builder

Question

I need to build this query :

SELECT p.*, c.nazwa, c.url 
FROM posty p 
INNER JOIN posty_kategorie pc
ON pc.id_posta = p.id 
INNER JOIN kategorie c 
ON c.id = pc.id_kategorii
WHERE p.url = "przykladowy-tytul-strony"

Using CodeIgniter's Query Builder class.

All I have for now is:

return $this->db->from('posty')
                ->join('posty_kategorie', 'posty_kategorie.id_posta = posty.id', 'inner')
                ->join('kategorie', 'kategorie.id = posty_kategorie.id_kategorii')
                ->where('posty.url', $url)
                ->get()->row();

But it this doesn't work like I want it to. It has to make this query:

SELECT p.*, c.nazwa, c.url 
FROM posty p 
INNER JOIN posty_kategorie pc
ON pc.id_posta = p.id 
INNER JOIN kategorie c 
ON c.id = pc.id_kategorii
WHERE p.url = "przykladowy-tytul-strony"

But I do not know how to put this all together : < .

Have you tried: ->result_array(); insted of ->get()->row(); ? — xsami
– xsami, Commented May 30, 2017 at 15:20
Query isn't finished yet. I have no Idea how to put all this things, this whole query, into CI_Query-Builder's query syntax — Adrianno Barello
– Adrianno Barello, Commented May 30, 2017 at 15:24

xsami · Accepted Answer · 2017-05-30 16:05:36Z

1

You can try this :

$this->db->select('p.*,c.nazwa,c.url');
$this->db->from('posty p');
$this->db->join('posty_kategorie pc ', 'pc.id_posta = p.id','inner');
$this->db->join('kategorie c ', 'c.id_posta = pc.id_kategorii','inner');
$this->db->where('p.url','przykladowy-tytul-strony');
$query = $this->db->get();
return $query->result();

edited May 30, 2017 at 16:05

xsami

1,32816 silver badges32 bronze badges

answered May 30, 2017 at 15:38

Pradeep

9,70713 gold badges29 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Can't build a query using CodeIgniter query builder

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related