After making the switch from using mysql_ functions to PDO, I've encountered a bit of a challenge that I'm hoping to get some help with.
The issue I'm facing is with the search query. Currently, I have it set up like this:
$result = $DB->prepare('SELECT * FROM `posts` WHERE `title` LIKE :searchterm OR `tags` LIKE :searchterm LIMIT '.$start.', '.MAX_ITEMS);
$result->bindParam(':searchterm',$searchterm);
$result->execute();
Given that the query size can vary based on the user's search input, how can I modify it to achieve something like this:
$array = explode(' ',$searchterm);
$query = 'SELECT * FROM posts WHERE ';
foreach($array as $word){
if( strlen($word)>2 ){
$query .= ' (`title` LIKE "%'.$word.'%" OR `tags` LIKE "%'.$word.'%") AND';
}
}
$query = substr($query,0,-3);
$query .= 'ORDER BY `date` DESC';
// How do I use bindParam() in this scenario?
I would really appreciate a small example to help me get started.
Thank you! ;)