Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in

Question

1.00/5 (1 vote)

See more:

<?php
include 'openCon.php' ;

$sql = "SELECT id,price,table,unitTable,chair,unitChair,lightingFan,unitLightingFan,Decoration, unitDecoration FROM packagea";
$result = mysqli_query($conn,$sql) ;
if(mysqli_num_rows($result) > 0) {
while($row = mysqli_fetch_assoc($result))
{
$id = $row['id'];
$price = $row['price'];
$table = $row['table'];
$unitTable = $row['unitTable'];
$chair = $row['chair'];
$unitChair = $row['unitChair'];
$lightingFan = $row['lightingFan'];
$unitLightingFan = $row['unitLightingFan'];
$Decoration = $row['Decoration'];
$unitDecoration = $row['unitDecoration'];

echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";
echo "";

}

}
?>

Bil	Price	Table	Unit	Chair	Unit	Lighting & Fan	Unit	Decoration	Unit
$id	$price	$table	$unitTable	$Chair	$unitChair	$lightingFan	$unitLightingFan	$Decoration	$unitDecoration

->I HAVE PROBLEM AT THIS LINE = if(mysqli_num_rows($result) > 0) {

What I have tried:

I HAVE TRY GOOGLE FOR THE SOLUTION BUT EVERYTHING I TRY IT DOESNT FIX MY ERROR

Posted 19-Jun-18 23:33pm

Member 13879644

Updated 19-Jun-18 23:47pm

Add a Solution

Comments

Richard MacCutchan 20-Jun-18 6:15am

The first thing you should try (which you obviously didn't) is to read the documentation, where it clearly explains what type of result you get from each command.

1 solution

Add a Solution

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

Jochen Arndt · Answer 1 · 2018-06-19T23:48:00

This a FAQ (Frequentyl Asked Question) which has been asked and answered multiple times and can be also solved by reading the documentation:

PHP: mysqli::query - Manual[^]:

Return Values

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.

You have to check the return value of mysqli_query() as shown in the examples at the above link before passing it to other functions like mysqli_num_rows().

Upon failures report the error message to know what went wrong. Usual errors sources are invalid SQL commands and the message provided by mysqli_error($conn) will tell you what was wrong. Because I don't know about your database, I can only guess. Here it might be a typo in one of the column names or the table name.

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in

1 solution

Solution 1

Add your solution here

Preview 0

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given in

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us