代码和phpmyadmin的图像:http://www.dodaj.rs/f/Z/d0/2BO43myA/dwm-2015-04-08-19-27-19-.png
我认为错误在$query = $db->query
。。。
我有两个错误:
Notice: Trying to get property of non-object in C:'xampp32'htdocs'Ceragem'search.php on line 78
Notice: Trying to get property of non-object in C:'xampp32'htdocs'Ceragem'search.php on line 82
PHP代码
<?php
require_once 'connect.php';
if(isset($_GET['qsearch'])){
$search = $db->escape_string($_GET['qsearch']);
$query = $db->query("
SELECT ime, prezime
FROM data_users
WHERE body LIKE'%{$search}%'
OR ime LIKE '%{$search}%'
");
?>
<div class="naso_res">
Nadjeno je <?php echo $query->num_rows;?> // Line 78
</div>
<?php
if($query->num_rows){ // Line 82
while($r = $query->fetch_object()){
?>
<div class="rezultati">
<a href="#"><?php echo $r->ime;?></a>
</div>
<?php
}
}
}
?>
您的查询错误。
您的表没有body
属性
WHERE body LIKE'%{$search}%'
也应该是没有{}
的LIKE '%$search%'
看看这份文件。