Why Does `mysqli_fetch_array()` Return \'mysqli_result Required, boolean given\'?

mysqli_fetch_array() Parameter Mismatch: mysqli_result Required

When executing the following code, you may encounter the error "mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given":

$check1_task = "SELECT * FROM `users` WHERE `fb_id` = " . $fb_id . " LIMIT 0, 30 ";
$check1_res = mysqli_query($con, $check1_task);

This error occurs because mysqli_fetch_array() expects a valid mysqli_result as its first parameter, which is the result of a successful query execution. However, in the given code, mysqli_query() is not returning a mysqli_result.

To resolve this issue, check the return value of mysqli_query(). If it returns false, the query failed and you need to investigate the cause using mysqli_error():

if (!$check1_res) {
    trigger_error(mysqli_error($con), E_USER_ERROR);
}

By doing so, you can determine the actual reason for the query failure and address it accordingly. Remember that mysqli_fetch_array() can only be used on a valid mysqli_result, so ensure that the query executes successfully first.

The above is the detailed content of Why Does `mysqli_fetch_array()` Return \'mysqli_result Required, boolean given\'?. For more information, please follow other related articles on the PHP Chinese website!