LIKE query using multiple keywords from search field using PDO prepared statement
Prepared statements protect you from sql injection, so sql code in the parameters will not be interpreted. You will have to build a sql query with the correct number of AND itemTitle LIKE ? before calling prepare(). $keywords = preg_split(‘/[\s]+/’, $keywords); $totalKeywords = count($keywords); $query = “SELECT * FROM prodsTable WHERE itemTitle LIKE ?”; for($i=1 … Read more