Hello, I am trying to run my database table and getting this error on result page.

Question

1.00/5 (1 vote)

See more:

Connected successfully
( ! ) Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, bool given in C:\wamp64\www\database\db.php on line 16

What I have tried:

<pre><!DOCTYPE html>
<html>
<body>

<?php
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "db";

include("connection.php");

$sql = "SELECT id, firstname, lastname FROM myguests";
$result = mysqli_query($conn, $sql);

if (mysqli_num_rows($result) > 0) {
    // output data of each row
    while($row = mysqli_fetch_assoc($result)) {
        echo "id: " . $row["id"]. " - Name: " . $row["firstname"]. " " . $row["lastname"]. "<br>";
    }
} else {
    echo "0 results";
}

mysqli_close($conn);
?>

</body>
</html>

Posted 28-Jan-20 17:35pm

Member 14729284

Updated 28-Jan-20 17:52pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2020-01-28T17:54:00

Solution 1

One possible reason seems to be that you don't investigate if the query fails. Try changing

PHP

...
if ($result = mysqli_query($conn, $sql)) {
...

Posted 28-Jan-20 17:54pm

Wendelius

Comments

Member 14729284 28-Jan-20 23:59pm

Thank you for solution i tried above query after that i got this kind of result:
Connected successfully 0 results...I didn't get a table that i made in phpmyadmin(MySQL).

Wendelius 29-Jan-20 11:01am

If the if statement returned false, it means that the query has failed. To check the syntax, run it directly in the MySQL database. Perhaps you have misspelled a column or the table