Their one (Shortened):
$sql = 'SELECT * FROM PRODUCTS WHERE PRODUCTNAME LIKE "'.$searchTerm.'"';

My one (Shortened):
$sql = "SELECT * FROM PRODUCTS WHERE PRODUCTNAME LIKE '%$searchTerm%'";