Mysqli error - data fetch

Asked Oct 28 '15 at 01:32

Active May 11 '20 at 06:23

Viewed 33 times

I am having an error message when I am trying to fetch data from my database to display on my website.

mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in C:\wamp\www\wb\display.php on line 17

What is the problem?

// Create connection
$conn = new mysqli($db_host, $db_user , $db_pass); 
// Check connection
if (!$conn) {
    die("Connection failed: " . mysqli_connect_error());
}

$sql = "SELECT* FROM wd_table";
$result = mysqli_query($conn, $sql);

if (mysqli_num_rows($result) > 0) {
    // output data of each row
    while($row = mysqli_fetch_assoc($result)) {
        echo "Booking Number: " . $row["bookingID"] . "First Name " .         $row["firstName"] . "Last Name : " . $row["lastName"] . "Email: " . $row["email"] . "ID Number : " . $row["idNumber"] . "ID  Type : " . $row["idType"] . "Phone: " . $row["phone"] . "<br>";
    }
}           
else {
    echo "0 results";
}

mysqli_close($conn);
?>

edited May 11 '20 at 00:00

Dharman

30,962
25
85
135

asked Oct 28 '15 at 01:32

Nawshad Ghannoo

1

Look here: http://stackoverflow.com/questions/12769982/reference-what-does-this-error-mean-in-php – jpaljasma Oct 28 '15 at 01:35
Specifically - http://stackoverflow.com/questions/12769982/reference-what-does-this-error-mean-in-php/12770072#12770072 – user2182349 Oct 28 '15 at 01:36
2

simple; you didn't select a database – Funk Forty Niner Oct 28 '15 at 01:37
sorry sorry I am still learning php. I will have to check out how to properly write the code. Thanks a lot FRED, i have added the db name and its working now. – Nawshad Ghannoo Oct 28 '15 at 01:44
Read this tutorial http://w3code.in/2015/10/how-to-insert-and-select-data-in-php-and-mysql-beginner-guide/ – Ricky Oct 28 '15 at 01:51

Mysqli error - data fetch

0 Answers0