PHP Classes

not being able to bind values

Recommend this page to a friend!

      YSPDO  >  All threads  >  not being able to bind values  >  (Un) Subscribe thread alerts  
Subject:not being able to bind values
Summary:yspdo does not bind all of my values
Messages:3
Author:hossein
Date:2017-12-19 13:45:38
 

  1. not being able to bind values   Reply   Report abuse  
Picture of hossein hossein - 2017-12-19 13:45:38
hi there!
thanks for your great job here :)

I have encountered a problem in binding values where there is like in my statement beside another keys

for example I want to select all news with cat=blah and cr_date <=blah

no matter what I do the cr_date=blah does not work ! and question mark stays untouched in the sql statement .

any suggestions ?

  2. Re: not being able to bind values   Reply   Report abuse  
Picture of hossein hossein - 2017-12-19 13:48:49 - In reply to message 1 from hossein
and my values are ...
[
'LIKE' => [
"cat" => '%(125)%'
],
"cr_date{<=}" => "2017-11-23",
'LIMIT' => '500',
'ORDER' =>'id desc'

]

  3. Re: not being able to bind values   Reply   Report abuse  
Picture of hossein hossein - 2017-12-19 13:55:58 - In reply to message 2 from hossein
sql statement created by yspdo :

SELECT * FROM `sitenews` WHERE `cat` LIKE '%(125)%' AND `cr_date`=? ORDER BY id desc LIMIT 500