PHP查询数据库数据时出现异常
日期：2014-05-17 浏览次数：20460 次
PHP查询数据库数据时出现错误
PHP 查询数据库books中的books表时出现以下错误！
Notice: Trying to get property of non-object in D:\wamp\Apache\htdocs\php\results.php on line 33
Fatal error: Call to a member function fetch_assoc() on a non-object in D:\wamp\Apache\htdocs\php\results.php on line 35
代码如下：
上述问题那微微大虾能给个解决方案！
------解决方案--------------------
PHP 查询数据库books中的books表时出现以下错误！
Notice: Trying to get property of non-object in D:\wamp\Apache\htdocs\php\results.php on line 33
Fatal error: Call to a member function fetch_assoc() on a non-object in D:\wamp\Apache\htdocs\php\results.php on line 35
代码如下：
- PHP code
<html>
<head>
<title> Book-O-Rama Catalog Search</title>
</head>
<body>
<h1>Book-O-Rama Catalog Search</h1>
<?php
//create short variable names
$searchtype=$_POST['searchtype'];
$searchterm=trim($_POST['searchterm']);
if (!$searchtype || !$searchterm) {
exit('You have not entered search detais,please go back again');
}
if (!get_magic_quotes_gpc()){
$searchtype=addslashes($searchtype);
$searchterm=addslashes($searchterm);
}
@ $db=new mysqli('localhost','root','password','books');
if (mysqli_connect_errno()){
echo "could not connect to database,please try again later.".mysqli_connect_errno();
exit;
}else {
$sql ="select * from books where".$searchtype."like'%".$searchterm."%'";
$result=$db->query($sql);
$num_result=$result->num_rows;
for ($i=0;$i<=$num_result;$i++){
$row=$result->fetch_assoc();
echo "<p>".($i+1)."title:";
echo htmlspecialchars(stripslashes($row['author']));
echo "Author:".stripslashes($row->newsauthor);
echo "ISBN:".stripslashes($row->newsISBN);
echo "price:".stripslashes($row->newsprice)."</p>";
}
}
$result->free();
$db->colse();
?>
</body>
</html>
上述问题那微微大虾能给个解决方案！
------解决方案--------------------
- PHP code
$sql ="select * from books where ".$searchtype." like '%".$searchterm."%'";
if ($result=$db->query($sql)) {
$num_result=$result->num_rows;
for ($i=0;$i<=$num_result;$i++){
$row=$result->fetch_assoc();
echo "<p>".($i+1)."title:";
echo htmlspecialchars(stripslashes($row['author']));
echo "Author:".stripslashes($row->newsauthor);
echo "ISBN:".stripslashes($row->newsISBN);
echo "price:".stripslashes($row->newsprice)."</p>";
}
}else{
echo "fail.";
exit;
}
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
