[RESOLVED] Search Function

cybertank378

Hello Please Help Me

I got some error and when i trace it the error is in here //DB QUERY: get total count

$record_count = mysqli_fetch_array(mysqli_query($conn, $query));

// ------------------------------------------------------------	
	// CALCULATE TOTAL COUNT BASED ON SERCH QUERY
	// ------------------------------------------------------------	
	if( isset($_POST['txbSearch']) && !empty($_POST['txbSearch']) && !is_numeric($_POST['txbSearch']) )
	{
		$_SESSION['search_q'] = mysqli_real_escape_string($conn, strip_tags($_POST['txbSearch']));
		$search_q = $_SESSION['search_q'];
		$query_string = "SELECT COUNT(*) AS TotalCount FROM $tableName WHERE like (name= , email) against ('$search_q' IN BOOLEAN mode)";
	}
	elseif(isset($_SESSION['search_q']))
	{
		$search_q = $_SESSION['search_q'];
		$query_string = "SELECT COUNT(*) AS TotalCount FROM $tableName WHERE like (name, email) against ('$search_q' IN BOOLEAN mode)";
	}
	else
	{
		$query_string = "SELECT COUNT(*) AS TotalCount FROM $tableName";
	}

// DB QUERY: get total count
// ------------------------------------------------------------
$query = $query_string;

$record_count = mysqli_fetch_array(mysqli_query($conn, $query));
$record_count = $record_count['TotalCount'];

Any Ones had a sugestions?

cybertank378

sorry im forgot some thing

here is the error message

Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in E:\xampp\htdocs\acp\admin\controls\search\search.php on line 68

bradgrafelman

As the error message states, you passed a boolean rather than a result resource. Looking at the manual page for [man]mysqli_query/man (the result of which is used as parameter 1), you'll find that the function returns boolean FALSE if an error occurs. For that reason....

.. You should always be checking the return value of [man]mysqli_query/man to see if it is boolean FALSE and, if so, output/log (whichever is appropriate) the SQL error message (see: [man]mysqli_error/man) and perhaps the SQL query itself (helps to debug a query if you can actually see it).

cybertank378

bradgrafelman;10990885 wrote:
As the error message states, you passed a boolean rather than a result resource. Looking at the manual page for [man]mysqli_query/man (the result of which is used as parameter 1), you'll find that the function returns boolean FALSE if an error occurs. For that reason....

.. You should always be checking the return value of [man]mysqli_query/man to see if it is boolean FALSE and, if so, output/log (whichever is appropriate) the SQL error message (see: [man]mysqli_error/man) and perhaps the SQL query itself (helps to debug a query if you can actually see it).

Ok Thanks For Your Advice

Now I Had Resolved My problem

Thanks You Very much