MAINHACK

Viewing / Editing File: all-results.php

<?php include('header.php');
$val=base64_decode($_REQUEST['search']);

<div class="banner-inner">
	<img src="images/inner-banner.jpg" alt="" class="banner-img">
</div>

<div class="results-in">	
    <div class="title-section text-center">
		<h3 class="w3ls-title">Welcome to <span> <?=$company_name?></span></h3>
	</div>
	
	<div class="container">	
        <div class="row">

<?php 
$val_name=explode("|",$val);
$clause="where food_maker.locality like'%".$_SESSION['location']."%'";
//$sq=$show->readAll_clause('food_maker',$clause);
$name_v=trim($val_name[0]);
$s1="select * from food_maker where name like '$name_v%' order by id desc ";// echo $s1;
$sq=$con->prepare($s1);
$sq->execute();
$num1=$sq->rowCount();
if($num1>0){
	while($row=$sq->fetch(PDO::FETCH_ASSOC)){
  $banner=$row['banner']==''?'noimg.png':$row['banner'];
  $profile_pic=$row['profile_pic']==''?'noimg.png':$row['profile_pic'];

?>	
            <div class="col-md-3 col-sm-4 col-xs-12">
               <div class="results-box">
                   <div class="results-box-lt">
                       <img src="<?=$pic_img?>/<?=$banner?>" alt="" class="results-cook">
                   </div>
                   <div class="results-box-rt">
                        <h4><?=$row['title']?></h4>
                        <ul class="product-review">
  	   <?php
	//	echo $uid;	
$count=1;
$sr='review';
$stmt =$show->readwithdata($sr,'maker_id',$row['maker_id']);
$num = $stmt->rowCount();
 if($num>0){ $num=$num. "+ ";}else{ $num="No "; }
 $av="select sum(rating) as s,count(id) as c from review where maker_id='".$row['maker_id']."'";
 $sav=$con->prepare($av);
 $sav->execute();
 $row_av=$sav->fetch(PDO::FETCH_ASSOC); echo $row_av['rating'];
 $average=round($row_av['s']/$row_av['c']);
// echo $average;
 ?>  
        
                                  
                            <li><img src="images/star<?=$average?>.png"><sub><?=$num?> Review</sub></li>
                        </ul>
                        <a href="food-single.php?makid=<?=base64_encode($row['maker_id'])?>">
                            View Menu
                        </a>
                   </div>                   
               </div>
            </div>
<?php } } ?>            
           
        </div>
	</div>
</div>

<?php include('footer.php');?>

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: all-results.php

Server Info

System Features

User Info