how to fix pdo mysql query for search?

Asked Mar 07 '17 at 05:40

Active Mar 07 '17 at 05:51

Viewed 41 times

$stmt = $db->prepare("select * from article where concat_ws(' ',title,text)
                      like :search order by rank");
$stmt->bindValue(':search','%'.$data.'%'); 
$stmt->execute();

This search query doesn't work properly.is it correct the way i passing value to the query? i means binding part.if there is another way to do that give me that advice also.

edited Mar 07 '17 at 05:51

Your Common Sense

156,878
40
214
345

asked Mar 07 '17 at 05:40

user7614902

http://stackoverflow.com/questions/2722136/mysql-pdo-how-to-bind-like – yogesh84 Mar 07 '17 at 05:42
Possible duplicate of [mysql PDO how to bind LIKE](http://stackoverflow.com/questions/2722136/mysql-pdo-how-to-bind-like) – madhan kumar Mar 07 '17 at 06:44

how to fix pdo mysql query for search?

0 Answers0