php中result的值,php – 警告：mysqli_num_rows()期望参数1为mysqli_result,[复制]中给出布尔值...

参见英文答案 >

PHP & MySQL: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given                                    2个

挣扎着我的网页设计任务.我一直在按照教程添加我的网站的搜索功能,但我一直收到以下错误：

警告：mysqli_num_rows()要求参数1为mysqli_result,第31行的/search.php中给出布尔值

第31行是(或是)

if(mysqli_num_rows($results) >= 1)

那是原来的错误.根据评论中的说明,我已经修改了代码：

//capture search term and remove spaces at its both ends if the is any

$searchTerm = trim($_GET['keyword']);

//check whether the name parsed is empty

if($searchTerm == "")

{

echo "Enter the name/brand of what you're looking for.";

exit();

}

//database connection info

$host = "localhost";

$db_name = "sookehhh_shopsy_db";

$username = "sookehhh_shopsy";

$password = "xxxx";

//connecting to server and creating link to database

$link = mysqli_connect($host, $username, $password, $db_name) or die('Could not connect: ' . mysqli_connect_error());

//MYSQL search statement

$query = "SELECT * FROM sookehhh_shopsy_db WHERE name LIKE '%" . mysqli_real_escape_string($link, $searchTerm) . "%'";

// original query$query = "SELECT * FROM sookehhh_shopsy_db WHERE name LIKE '%$searchTerm%'";

$results = mysqli_query($link, $query);

//added suggestion below - not sure if correct place?

if (!$result) {

die(mysqli_error($link));

}

/* check whethere there were matching records in the table

by counting the number of results returned */

if(mysqli_num_rows($results) >= 1)

{

$output = "";

while($row = mysqli_fetch_array($results))

{

$output .= "Product Name: " . $row['name'] . "
";

$output .= "Price: " . $row['price'] . "
";

}

echo $output;

}

else

echo "There was no matching record for that item " . $searchTerm;

?>

做了必要的更改并再次更新 –

现在我收到的唯一错误信息是“表’sookehhh_shopsy_db.sookehhh_shopsy_db’不存在”

我假设我需要更改用户名,也许是因为它太相似了？

无论如何,感谢你的帮助到目前为止,我为我的完全无知而道歉.

我一直在努力教自己,但不幸的是,时间是我现在所没有的奢侈品.