搜索引擎错误


Search engine error?

代码和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%'

看看这份文件。