Saturday, January 29, 2022

[FIXED] How to include multiple condition on get_where in codeigniter?

Issue

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 :)



Answered By - Eleven

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.