MAINHACK

Viewing / Editing File: ajax_check.php

<?php
include('settings/settings.php');

if(isset($_POST['status']))
{
$st=trim($_POST['status']);
$id=$_POST['id'];
$table=$_POST['table'];
$stmt=$con->prepare("update $table set status='".$st."' where id='".$id."'");
$stmt->execute();

}
if(isset($_POST['search']))
{
$name=trim($_POST['search']);
$query2="SELECT food_maker.maker_id,food_maker.title,menu_items.maker_id,menu_items.name as menu FROM food_maker inner join menu_items on food_maker.maker_id=menu_items.maker_id  WHERE food_maker.title LIKE '$name%' OR menu_items.name  LIKE '%$name%'  OR menu_items.name  LIKE '$name% '";
//echo $query2;
$r=$con->prepare($query2);
$r->execute();
echo "<ul>";
while ($query3 = $r->fetch(PDO::FETCH_ASSOC)){
{
?>
<li class='show_search' align='left' onclick='fill_search("<?php echo $query3['title']; ?> | <?php echo $query3['menu']; ?>")'><?=$query3['title'];?><?=" | ".$query3['menu'];?></li>
<?php
}
echo "</ul>";
}

}
if(isset($_POST['location_session']))
{
$_SESSION['location']=$_POST['location_session'];

}
if(isset($_POST['search_loc']))
{
$name=trim($_POST['search_loc']);
$city=trim($_POST['city']);

$query2="SELECT * FROM district WHERE city='$city' and (locality LIKE '%$name%' OR locality LIKE '$name%' OR locality LIKE '$name%')";
$r=$con->prepare($query2);
$r->execute();
echo "<ul>";
while ($query3 = $r->fetch(PDO::FETCH_ASSOC)){
{
?>

<li class='show11' align='left' onclick='fill_location("<?php echo $query3['locality']; ?>","<?php echo $query3['pincode']; ?>")'><?=$query3['locality'];?>| <?=$query3['pincode'];?></li>
<?php
}
echo "</ul>";
}
}
if(isset($_POST['maker_id']))
{
$_SESSION['maker_id']=$_POST['maker_id'];

}
if(isset($_POST['unset_maker_id']))
{
unset($_SESSION['maker_id']);
	unset($_SESSION["cart_item"]);
}
if(isset($_POST['locality']))
{
$name=trim($_POST['locality']);
$a=trim($_POST['dynamic_num']);
$city=trim($_POST['city']);

<li class='show11' align='left' onclick='filld("<?=$a?>","<?php echo $query3['locality']; ?>")'><?=$query3['locality'];?>| <?=$query3['district'];?></li>
<?php
}
echo "</ul>";
}
}
if(isset($_POST['promo']))
{
$sq="select coupon_id from coupon_used where coupon_id='".$_POST['promo']."'";
$r1=$con->prepare($sq);
$r1->execute();
$num1= $r1->rowCount();
if($num==1){
    echo "Oops ! you already used this coupon.";
}else{
$query2="SELECT discount,max_discount,min_amount FROM coupon WHERE (coupon.code='".$_POST['promo']."') and (curdate() >=coupon.open_date and curdate() <=coupon.close_date)";   
$r=$con->prepare($query2);
$r->execute();
$num = $r->rowCount();
if($num>0){
 while($row =$r->fetch(PDO::FETCH_ASSOC))
 {
  $data["discount"] = $row["discount"];
  $data["max_discount"] = $row["max_discount"];
  $data["min_amount"] = $row["min_amount"];
 $data['applicable']='YES';
 }

echo json_encode($data);
}else{ $data['applicable']='NO'; echo json_encode($data);}
    
}
    
}
if(isset($_POST['locality_search']))
{
$name=trim($_POST['locality_search']);

$query2="SELECT * FROM district WHERE locality LIKE '%$name%' OR locality LIKE '$name%' OR locality LIKE '$name%'";
$r=$con->prepare($query2);
$r->execute();
echo "<ul>";
while ($query3 = $r->fetch(PDO::FETCH_ASSOC)){
{
?>

<li class='show11' align='left' onclick='fill("<?php echo $query3['locality']; ?>")'><?=$query3['locality'];?>| <?=$query3['district'];?></li>
<li class='show11' align='left' onclick='fill("other")'>Other|Other</li>
<?php
}
echo "</ul>";
}
}
if(isset($_POST['district'])){
$show=new Oops($db);
?>
	
<select name="city"  id="city" >
<option value="">City</option>
<?php  
$stmt=$show->readwithdata('city','district',$_POST['district']);
$num=$stmt->rowCount();
if($num>0){
	while($row=$stmt->fetch(PDO::FETCH_ASSOC)){
		
  echo "<option value='".$row['city']."'>".$row['city']."</option>";
	}
}else{
    echo"";
}

?>
 </select>

<?php 
}
if(isset($_POST['email_id']))
{
$sq="select email,customer_id from customers where email='".$_POST['email_id']."'";
$r1=$con->prepare($sq);
$r1->execute();
$num1= $r1->rowCount();
$row=$r1->fetch(PDO::FETCH_ASSOC);
if($num1==1){
    echo "L";
     $_SESSION['Logged'] = 1;
    $_SESSION['login_user'] = $_POST['name'];
    $_SESSION['username'] = $_POST['email_id'];
    $_SESSION['login_id'] =$row['customer_id'];
}else{
    $uid=$show->getid('ids','CM');
     $data = array(
    'customer_id' => $uid, 
    'name' => htmlentities(strip_tags($_POST['name'])), 
    'email' => htmlentities(strip_tags($_POST['email_id'])), 
    'password' =>md5('12345678'),
    'created_at'=>date('d-m-Y'),
    'update_by'=>'SELF',
    'login_type'=>'GOOGLE',
    'status'=>'ACTIVE',
    );
    $_SESSION['Logged'] = 1;
    $_SESSION['login_user'] = $_POST['name'];
    $_SESSION['username'] = $_POST['email_id'];
    $_SESSION['login_id'] =$uid;

$r2=$show->insert('customers',$data);
    echo "S";
}    
}
if(isset($_POST['email_id_cook']))
{
$sq="select email,maker_id from food_maker where email='".$_POST['email_id_cook']."'";
$r1=$con->prepare($sq);
$r1->execute();
$num1= $r1->rowCount();
$row=$r1->fetch(PDO::FETCH_ASSOC);
if($num1==1){
    echo "L";
     $_SESSION['Logged'] = 1;
    $_SESSION['login_user'] = $_POST['name'];
    $_SESSION['username'] = $_POST['email_id_cook'];
    $_SESSION['login_id'] =$row['maker_id'];
}else{
    $uid=$show->getid('ids','FDM');
     $data = array(
    'maker_id' => $uid, 
    'name' => htmlentities(strip_tags($_POST['name'])), 
    'email' => htmlentities(strip_tags($_POST['email_id_cook'])), 
    'password' =>md5('12345678'),
    'created_at'=>date('d-m-Y'),
    'update_by'=>'SELF',
    'login_type'=>'GOOGLE',
    'status'=>'ACTIVE',
    );
    $_SESSION['Logged'] = 1;
    $_SESSION['login_user'] = $_POST['name'];
    $_SESSION['username'] = $_POST['email_id_cook'];
    $_SESSION['login_id'] =$uid;

$r2=$show->insert('food_maker',$data);
    echo "S";
}    
}
if(isset($_POST['maker_category']))
{
    $cat=$_POST['maker_category'];
$sq="select * from menu_items where category='".$cat."' and maker_id='".$_POST['maker_id']."' and status= 'ACTIVE' order by id desc";
$r1=$con->prepare($sq);
$r1->execute();
$num_s= $r1->rowCount();
if($num_s>0){
while($row=$r1->fetch(PDO::FETCH_ASSOC)){
		$open=$_POST['open'];

?>
 <div class="recommended-foodblock-product">
						   <form method="post" class="index-add" action="food-single.php?makid=<?=base64_encode($mid)?>&menu_id=<?=$row['menu_id'];?>&action=add&code=<?=$row['menu_id']?>&price=<?=$row['price']?>">
            
    					<img src="<?=$pic_img?>/<?=$row['image']?>" alt="single-img" class="templates-cook">
    					    <?php if($row['type']=="Veg"){ ?>
                                        <img src="images/veg-icon.png" alt="single-img" class="prod-veg">
                                    <?php }else{ ?>    
                                        <img src="images/non-veg-icon.png" alt="veg-non" class="prod-veg">
                                    <?php } ?>
    				
    				
    				
    					<h4><?=$row['name']?></h4>
    					<h5>Rs : <b> <?=$row['price']?>/-</b></h5>
    					 <input type="hidden" name="img" value="<?=$row['image']?>">
                                    <input type="hidden" name="quantity" value="1">
                                    <input type="hidden" name="product_name" value="<?=$row['name']?>">
                                    <input type="hidden" name="price" value="<?=$row['price']?>">
                                    <input type="hidden" name="menu_id" value="<?=$row['menu_id']?>">
                                    <input type="hidden" name="serves" value="<?=$row['serves']?>">
                                    <input type="hidden" name="comisn" value="<?=$comission?>">
                                     <input type="hidden" name="code" value="<?=$row['menu_id']?>">
                                   <input type="hidden" name="maker_id" value="<?=$mid?>">
     <input type="submit" value="Add" name="submit" class="button" onclick="runMyFunction();return true">
	</form>
        			</div>
    
<?php     
}
}else{
    echo "No items found under this category";
}
}

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: ajax_check.php

Server Info

System Features

User Info