mysqli preparedstatement for SQL LIKE for php has some small bugs. You have to use CONCAT to solve this part. Perfect for those people in php development shifting from mysql to mysqli