警告：mysqli_fetch_array（）要求参数1为mysqli_result，在第7行的../中给出布尔值[复制]

Question

This question already has an answer here:

• Reference - What does this error mean in PHP? 34 answers
• mysql_fetch_array()/mysql_fetch_assoc()/mysql_fetch_row()/mysql_num_rows etc… expects parameter 1 to be resource or result 32 answers

I'm having some problems with my website. The domain is bitcointap.xyz. On the /register & /login page. I'm having some PHP errors. On the /register page (bitcointap.xyz/register) I get the error:

"Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in ../ on line 7"

Register.php: http://pastebin.com/4pqvyiL1

Another problem I'm having is with the Login.php page. I get the error;

mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in ../ on line 9

Login.php: http://pastebin.com/ednfCE1y

Any help is greatly appreciated. Thank you.

</div>

Answer 1

My guess: the connection failed. The result then will be false (boolean).
In consequence, mysql_query($con, …) tries to use a connection handle which is false.
The manual says:

Returns FALSE on failure. For successful SELECT, SHOW, DESCRIBE or EXPLAIN queries mysqli_query() will return a mysqli_result object. For other successful queries mysqli_query() will return TRUE.

$con = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);
if ($con===false) {
    echo 'Connection failed (' . $con->connect_errno . '): ' . $con->connect_error;
    exit(1);
}
$result = mysqli_query($con, "SELECT * FROM `settings`");
if ($result===false) {
    echo 'Selection failed :' . $con->error;
    exit(2);
}
$settings = mysqli_fetch_array($result);
// ...

So, you should look at your includes include 'db.php' and include 'dbc.php', which define the connection parameters.