请看这里,
查询成功的表达方式
if ($conn->query($sql) === TRUE) {
echo "新记录插入成功";
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
请看我的代码:
<form action="" type="text" method="get">
<div>
查找留言:请输入关键字
<input type="text" name="keyword">
<select id="" name="sel">
<option value="title">文章标题</option>
<option value="content">文章内容</option>
<input type="submit" value="查询">
</select>
</div>
</form>
<?php
require('conn.php');
$keyword = trim($_GET['keyword']);
$sel = $_GET['sel'];
$sql = "SELECT * FROM lyb where $sel " . " like '%$keyword%'";
if ( $mysqli->query($sql) === TRUE) {
echo "查询成功<br />";
} else {
echo "查询失败</br />" . $mysqli->error;
}
$result = $mysqli->query($sql);
echo "$result->num_rows"."<br />";
var_dump($result);
?>
查询失败
20
object(mysqli_result)#2 (5) { ["current_field"]=> int(0) ["field_count"]=> int(8) ["lengths"]=> NULL ["num_rows"]=> int(20) ["type"]=> int(0) }
前后矛盾哈,
1.查询失败了,为何还有20个结果?
2.查询失败的话,为何. $mysqli->error 没有输出?
===true ?