Query not successful while there is 2 records available in database and also mysql_fetch_assoc() error occurred

Question

I found this error whenever I query from the database.

Connected successfully0 resultsDatabase error: Query was empty Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in C:\xampp\htdocs\digicraft\index.php on line 20

There are 2 records in my table & when I want to fetch that it says that Query was empty.

$servername = "localhost";
$username = "admin";
$password = "";

// Create connection
$conn = new mysqli($servername, $username, $password);

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
echo "Connected successfully";

//Query
$query = "SELECT * FROM pages WHERE id = 1";
$result = mysqli_query($dbc, $query);
if (! $result){
    echo ('Database error: ' .mysql_error());
}
while($row = mysql_fetch_assoc($result)){
    //handle rows.
    $title = $row['title'];
    $header = $row['header'];
    $body = $row['body'];

}

phpmyadmin screenshot:

browser error view:

I believe you forgot to select the correct DB after connection — Julien Lachal, Oct 10 '17 at 09:50
but the connection is successfully established. and sorry i don't get your answer please can you explain it? — Hadi Hassan, Oct 10 '17 at 09:53
Please pass last parameter database name. === $mysqli = mysqli_connect("example.com", "user", "password", "database"); — JavidRathod, Oct 10 '17 at 09:53
You DB connection get connected using `$conn` but in your `mysqli_query($dbc, $query)` you use `$dbc` which is not not your connection variable use as `mysqli_query($conn, $query)`. And personally I think you copy pates the above code. Also dont mix `mysql` with `mysqli` so replace `mysql_fetch_assoc` with `mysqli_fetch_assoc`. — S4NDM4N, Oct 10 '17 at 09:57

score 2 · Answer 1 · edited Jun 19 '20 at 23:41

You have forget to select the database also you have some syntax error like mysql_fetch_assoc, it should be mysqli_fetch_assoc.Put below code and replace your database name it will be working fine.

$servername = "localhost";
$username = "admin";
$password = "";
$db = "demos";//Put your database name

// Create connection
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$conn = new mysqli($servername, $username, $password, $db);
$conn->set_charset('utf8mb4');


echo "Connected successfully";

$query = "SELECT * FROM pages WHERE id = 1";

$result = mysqli_query($conn, $query);

foreach($result as $row) {  
    echo '<br>';
    echo $title = $row['title'] . '<br>';
    echo $header = $row['header'] . '<br>';
    echo $body = $row['body'] . '<br>';
}

never mind, Jay did it for you. https://stackoverflow.com/revisions/46664438/2 — Funk Forty Niner, Oct 10 '17 at 12:30

JavidRathod · Answer 2 · 2017-10-10T11:21:22.603

Please add last parameter for select database like below.

$mysqli = mysqli_connect("example.com", "user", "password", "database");

and also use below function for fetch data

mysqli_fetch_assoc()

Please read from below link :

https://en.wikipedia.org/wiki/MySQLi

Please try below code.

ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
define("DB_SERVER", "localhost");
define("DB_USER", "root");
define("DB_PASSWORD", "root");
define("DB_DATABASE", "atomcms");
$dbc = mysqli_connect(DB_SERVER , DB_USER, DB_PASSWORD, DB_DATABASE) OR die('Could not connect because: '.mysqli_connect_error());
$query = "SELECT * FROM pages";
$result = mysqli_query($dbc, $query);
if (! $result){ echo ('Database error: ' .mysqli_error()); }
while($row = mysqli_fetch_assoc($result)){
  //handle rows.
  $title = $row['title'];
  $header = $row['header'];
  $body = $row['body'];
}

score 0 · Answer 3 · answered Oct 10 '17 at 10:04

First, mysqli_connect have 4 parameters(server name,username,password,database)

$conn = new mysqli_connect($servername, $username, $password, yourdatabasename);

and mysqli_query($dbc, $query);

use $result = mysqli_query($conn, $query); $conn is our connection variable.

I hope this is useful.

Query not successful while there is 2 records available in database and also mysql_fetch_assoc() error occurred

3 Answers3