cant find data by id in php and mysql through wildcard

Question

here is the query:

 $query = "
  SELECT * FROM cbs_tasks 
  WHERE team_member_id = $uid and task_title LIKE '%".$search."%'
  OR task_desc LIKE '%".$search."%' 
  OR task_cat LIKE '%".$search."%' 
  OR task_priority LIKE '%".$search."%' 
  OR status LIKE '%".$search."%'
 ";

What is your expected output and what is your table structure? — Ankur Tiwari, Feb 26 '19 at 10:22
Please read about prepared statements in PHP: http://php.net/manual/en/mysqli.quickstart.prepared-statements.php — Tim Biegeleisen, Feb 26 '19 at 10:23
what fetching method you are using in PHP to fetch the query. — chaitanya, Feb 26 '19 at 10:23
Are you sure $uid is set correctly? Echo the statement and show... die($query); — Dieter Kräutl, Feb 26 '19 at 10:24
[How can I prevent SQL injection in PHP?](https://stackoverflow.com/questions/60174/how-can-i-prevent-sql-injection-in-php). Also edit the question with updates. — danblack, Feb 26 '19 at 10:34

score 0 · Accepted Answer · answered Feb 26 '19 at 10:35

put the OR section in brackets and you will get the desired output.

$query = "
  SELECT * FROM cbs_tasks 
  WHERE team_member_id = $uid and (task_title LIKE '%".$search."%'
  OR task_desc LIKE '%".$search."%' 
  OR task_cat LIKE '%".$search."%' 
  OR task_priority LIKE '%".$search."%' 
  OR status LIKE '%".$search."%' )
 ";

cant find data by id in php and mysql through wildcard

1 Answers1