php - Search engine error? -

php - Search engine error? -

image of code , phpmyadmin: http://www.dodaj.rs/f/z/d0/2bo43mya/dwm-2015-04-08-19-27-19-.png

i thing error in $query = $db->query...

i have 2 errors:

notice: trying property of non-object in c:\xampp32\htdocs\ceragem\search.php on line 78 notice: trying property of non-object in c:\xampp32\htdocs\ceragem\search.php on line 82

php code

<?php require_once 'connect.php'; if(isset($_get['qsearch'])){ $search = $db->escape_string($_get['qsearch']); $query = $db->query(" select ime, prezime data_users body like'%{$search}%' or ime '%{$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 } } } ?>

your query wrong.

your table has no body attribute

body like'%{$search}%'

also shoud like '%$search%' without {}

take @ document.

php search