MAINHACK

Viewing / Editing File: fetch.php

<?php
//$connect = new PDO("mysql:host=localhost;dbname=itsweb_jabu", "itsweb_jabu", "hackit_321");
include('admin@yadass/inc/database.php');
include('admin@yadass/inc/db.php');
include('admin@yadass/inc/oops.php');

$database = new Db();
$db = $database->getConnection();
$test=new Oops($db);

if(isset($_POST["action"]))
{
 $query = "
 select * from product inner join product_img on product.product_id=product_img.product_id inner join product_size on product.product_id=product_size.product_id ";

if(isset($_POST["minimum_price"], $_POST["maximum_price"]) && !empty($_POST["minimum_price"]) && !empty($_POST["maximum_price"]))
 {
  $query .= "
   AND product_size.price BETWEEN ".$_POST["minimum_price"]." AND ".$_POST["maximum_price"]."
  ";
 }

if(isset($_POST["main_category"]))
 {
    $query .=" where product.main_category='".$_POST["main_category"]."' ";

} 
  if(isset($_POST["category"]))
 {
    $query .=" AND product.category='".$_POST["category"]."' ";

} 
 $query .=' group by product_size.product_id  order by product.product_id desc ';
//echo $query;
 $statement = $con->prepare($query);
 $statement->execute();
 $result = $statement->fetchAll();
 $total_row = $statement->rowCount();
 $output = '';
 if($total_row > 0)
 {
  foreach($result as $row)
  {
//      echo $row['price'];

$output .= '<form method="post" class="cart_single" action="index.php?product_id='.$row['product_id'].'&action=add&code='.$row['product_id'].'&price='.$row['price'].'">

<div class="col-md-2 col-xs-6">
            <div class="hover14 column">
                <div class="agile_top_brand_left_grid">
                    <div class="agile_top_brand_left_grid1">
                        <figure>
                            <div class="snipcart-item block">
                                <h6 class="off">'.$row['discount'].'% off</h6>
                                <div class="snipcart-thumb">
                                    <a href="single.php?product_id='.$row['product_id'].'&price='.$row['price'].'"><img title="" alt=" " src="admin@yadass/imgs/'.$row['image'].'"></a>      
                                    <p>'.$row['name'].'</p>
                                    <h4> '.$row['category'].'</h4>
                                    <h4>Rs :'.$row['discount_price'].' | <span>Rs :'.$row['price'].'</span></h4>
                                    <h5>Size :'.$row['size'].'</h5>
                                    
                                </div>
                                <div class="snipcart-details top_brand_home_details">
                                    <div class="snipcart-details top_brand_home_details">
                                          <fieldset>
                                              <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" id="item_price">
                                              <input type="hidden" name="code" value="'.$row['product_id'].'">

<a href="single.php?product_id='.$row['product_id'].'&price='.$row['price'].'"class="button">Buy Now</a>
                                          </fieldset>
                                     </div>
                                   
                                </div>
                            </div>
                        </figure>
                    </div>
                </div>
            </div>
        </div>
 </form>
   ';
  }
 }
 else
 {
  $output = '<span><h3></h3></span>';
 }
 echo $output;
}

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: fetch.php

Server Info

System Features

User Info