PHPFixing
  • Privacy Policy
  • TOS
  • Ask Question
  • Contact Us
  • Home
  • PHP
  • Programming
  • SQL Injection
  • Web3.0

Saturday, January 29, 2022

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

 January 29, 2022     codeigniter     No comments   

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
  • Share This:  
  •  Facebook
  •  Twitter
  •  Stumble
  •  Digg
Newer Post Older Post Home

0 Comments:

Post a Comment

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

Total Pageviews

Featured Post

Why Learn PHP Programming

Why Learn PHP Programming A widely-used open source scripting language PHP is one of the most popular programming languages in the world. It...

Subscribe To

Posts
Atom
Posts
Comments
Atom
Comments

Copyright © PHPFixing