Welcome Guest, Not a member yet? Register   Sign In
like wildcards when using query binding problem
#1

[eluser]dcallan[/eluser]
Does anyone know how I should write queries with like statements when I want to use query binding? The code snippet I have is below::

Code:
$Query = "select itemCode, itemName from OITM where itemCode like %?% or itemName like %?%";
$Result = $this->sapDB->query($Query, array($searchSubstring, $searchSubstring));

However it produces an error with the follwoing query:
select itemCode, itemName from OITM where itemCode like %'lamp'% or itemName like %'lamp'%

when valid SQL is something like

select itemCode, itemName from OITM where itemCode like '%lamp%' or itemName like '%lamp%'

Thanks in advance.
#2

[eluser]Jaketoolson[/eluser]
You could use the Active Record Class.
Code:
$this->db->like('title', 'match');
$this->db->or_like('body', $match);
$this->db->select('itemCode, itemName');
$query = $this->db->get('OITM');




Theme © iAndrew 2016 - Forum software by © MyBB