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

Question

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.

@Robert Refer this link to check the connection is correct or not http://stackoverflow.com/questions/34877694/php-mysqli-query-error-in-syntax/34877731#34877731 — AnkiiG, Jan 20 '16 at 07:10
db: http://pastebin.com/Yf3WzaKc dbc: http://pastebin.com/VWepjuYg — Robert, Jan 20 '16 at 07:11
i don't think I have any tables, not really sure how to create them @Matt — Robert, Jan 20 '16 at 07:12
@Robert If you don't have any table then how the query will work? — AnkiiG, Jan 20 '16 at 07:13
@AnkiiG I'm using an old script of mine, I'm also kind of new to all this so I'm not sure how to create tables. — Robert, Jan 20 '16 at 07:14
Go to your phpMyAdmin (localhost/phpmyadmin) and , follow to your database , then see your settings table — , Jan 20 '16 at 07:14
As Ankiig is saying we need to see db.php i suspect you your connection fails try to handle connection erros as described in the manual http://php.net/manual/en/mysqli.query.php — Joaquin Javi, Jan 20 '16 at 07:20
@JoaquinJavi The connection is valid, it looks like it's a problem with the database tables. (Their are none) — Robert, Jan 20 '16 at 07:21
So there is the error you're trying to fetch 0 rows so its returns false — Joaquin Javi, Jan 20 '16 at 07:26
@Robert do you have table structure? Are you able to create that? — AnkiiG, Jan 20 '16 at 07:27
@AnkiiG no i don't think there is a table structure. is it possible to upload my .zip here? i might have it but i'm not sure — Robert, Jan 20 '16 at 07:31
Please add some code as shown in my answer for properly intercepting connection errors. Displaying **$con->connect_errno** and **$con->connect_error** would give us more information about the reason the connection is failing. — hherger, Jan 20 '16 at 08:45

hherger · Answer 1 · 2016-01-20T08:57:35.397

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.

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

1 Answers1