提示错误信息是:
Notice: Trying to get property of non-object in D:\ruanjiananzhuang\wamp\www\n2000\results.php on line 49
对应代码是:$num_results = $result->num_rows;
Fatal error: Call to a member function free() on a non-object in D:\ruanjiananzhuang\wamp\www\n2000\results.php on line 69
对应代码是: $result->free();
请各位前辈帮小弟看看问题出在哪里
以下是完整代码:
<html>
<head>
<meta charset="utf-8">
<title>资源查询结果</title>
</head>
<body>
<h1>资源查询结果</h1>
<?php
// create short variable names
$searchtype=$_POST['searchtype'];
$searchterm=trim($_POST['searchterm']);
if (!$searchtype || !$searchterm) {
echo '您尚未输入搜索内容,请返回重新输入!';
exit;
}
// echo " $searchtype</br>";
// echo " $searchterm</br>";
if (!get_magic_quotes_gpc()){
$searchtype = addslashes($searchtype);
$searchterm = addslashes($searchterm);
}
// echo " $searchtype</br>";
// echo " $searchterm";
@ $db = new mysqli('localhost', 'root', '', 'test');
if (mysqli_connect_errno()) {
echo '错误:连接数据库失败,请重试!';
exit;
}
$query = "select * from haoma where ".$searchtype." like '%".$searchterm."%'";
?>
<table width="980">
<tr>
<th>用户号码</th><th>设备标识</th>
<?php
$result = $db->query($query);
$num_results = $result->num_rows;
echo "$result</br>";
echo "$num_results</br>";
echo "<p>查询到的数据条目: ".$num_results."</p>";
for ($i=0; $i <$num_results; $i++) {
$row = $result->fetch_assoc();
echo "<p><strong>".($i+1).". 用户号码: ";
echo htmlspecialchars(stripslashes($row['用户号码']));
echo "<br />设备标识: ";
echo stripslashes($row['设备标识']);
echo "</p>";
}
$result->free();
$db->close();
?>
</table>
</body>
</html>