MySQLi - multiple LIKE %colname% in recordset
I am converting a current recordset to MySQLi. I worked perfectly before..
$colname2_booking = "-1";
if (isset($_GET['S_Name'])) {
$colname2_booking = $_GET['S_Name'];
}
$colname3_booking = "-1";
if (isset($_GET['S_Tel'])) {
$colname3_booking = $_GET['S_Tel'];
}
$colname5_booking = "-1";
if (isset($_GET['S_Email'])) {
$colname5_booking = $_GET['S_Email'];
}
mysql_select_db($database_georgeconnect, $georgeconnect);
$query_booking = sprintf("SELECT carpark.*, contractcar.ContractID FROM carpark LEFT JOIN contractcar ON carpark.CarID=contractcar.ID WHERE Company='Ascars' AND carpark.name LIKE %s AND (carpark.tel LIKE %s OR carpark.mobile LIKE %s) AND carpark.email LIKE %s ORDER BY Date DESC", GetSQLValueString("%" . $colname2_booking . "%", "text"),GetSQLValueString("%" . $colname3_booking . "%", "text"),GetSQLValueString("%" . $colname3_booking . "%", "text"),GetSQLValueString("%" . $colname5_booking . "%", "text"));
$booking = mysql_query($query_booking, $georgeconnect) or die(mysql_error());
$row_booking = mysql_fetch_assoc($booking);
$totalRows_booking = mysql_num_rows($booking);
I have researched how you do LIKE %colname% with MySQLi and it works if there is just 1 search field but returns no results if I have multiple LIKE %colname%
$booking = new WA_MySQLi_RS("booking",$georgeconnect_i,0);
$booking->setQuery("SELECT carpark.*, contractcar.ContractID FROM carpark LEFT JOIN contractcar ON carpark.CarID=contractcar.ID WHERE Company='Ascars' AND carpark.email LIKE CONCAT('%%',?,'%%') AND carpark.name LIKE CONCAT('%%',?,'%%') AND Tel LIKE CONCAT('%%',?,'%%') ORDER BY Date DESC");
$booking->bindParam("s", "".$_GET['S_Email'] ."", "-1"); //colname1
$booking->bindParam("s", "".$_GET['S_Name'] ."", "-1"); //colname2
$booking->bindParam("s", "".$_GET['S_Tel'] ."", "-1"); //colname3
$booking->execute();