phpcodeigniterwhere-clausequery-builder

How to include multiple condition on get_where in codeigniter?

Im trying to include to conditions on my get_where but its not working. Single condition works but I need two conditions. Any idea?

Here's my code:

$query = $this->db->get_where($this::DB_TABLE, array("$column = " => $id, " $column2 = " => $id2, ));
Solution

  • instead, I just did this:

    $query = "select * from ".$this::DB_TABLE." name where $column=? and $column2 = ?";

$sql = $this->db->query($query, array($id,$id2));

    Thanks, Shaiful Islam :)