bnmbertsurrttrtrtrtrjhjhjjhjhhjhjhjhf'tdfg

hjkhghtjhjjhjhjhjhjjhjhjjhrrtrtoirh bnmbertsurrttrtrtrtrjhjhjjhjhhjhjhjhf'tdfg

<?php

//fetch_data.php

require_once('tracker_help_files/control.php');
 
$servername = "localhost";
$username = "websutil_laces_admin";
$password = "websutil_laces_admin";

try {
  $connect = new PDO("mysql:host=$servername;dbname=websutil_laces_admin", $username, $password);
  // set the PDO error mode to exception
  $connect->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  //echo "Connected successfully";
} catch(PDOException $e) {
  echo "Connection failed: " . $e->getMessage();
}
 
//echo $_SESSION['get_id'];
//$keyword = $_SESSION['keyword'];
/*echo "<pre>";
print_r($_GET);*/
if(isset($_SESSION['get_id']) && $_SESSION['get_id']>0)
{
      $query = "
		SELECT * FROM product_tbl WHERE status = '1' and parent_id='".$_SESSION['get_id']."'";
	}
	else
	{
	  $query = "
		SELECT * FROM product_tbl WHERE status = '1'";	
	}

if(isset($_SESSION['sort_by_price']) && $_SESSION['sort_by_price']=='Below')
{
        $query = "
		SELECT * FROM `product_tbl` WHERE `product_price`<=500 and status = '1'";
	}
	else if(isset($_SESSION['sort_by_price']) && $_SESSION['sort_by_price']=='Above')
	{
	     $query = "
		SELECT * FROM `product_tbl` WHERE `product_price`<=15000 and status = '1'";
	}
	else if(isset($_SESSION['sort_by_price']) && $_SESSION['sort_by_price2']>0)
	{
       $query = "
		SELECT * FROM `product_tbl` WHERE `product_price` BETWEEN '".$_SESSION['sort_by_price']."' AND '".$_SESSION['sort_by_price2']."' AND `status`='1'";
	}

if(isset($_POST["minimum_price"], $_POST["maximum_price"]) && !empty($_POST["minimum_price"]) && !empty($_POST["maximum_price"]))
	{
		$query .= "
		 AND product_price BETWEEN '".$_POST["minimum_price"]."' AND '".$_POST["maximum_price"]."'
		";
	}
	if(isset($_POST["brand"]))
	{
		$brand_filter = implode("','", $_POST["brand"]);
		$query .= "
		 AND brand_id IN('".$brand_filter."')
		";
	}
	 if(isset($_POST["color"]))
	{
		$color_filter = implode("','", $_POST["color"]);
		$query .= "
		 AND color_id IN('".$color_filter."')
		";
	}
	if($_SESSION['keyword']!='' && $_SESSION['keyword_catagory']!='') {
	    $query .=" and parent_id like '%".$_SESSION['keyword_catagory']."%' and product_name like '%".$_SESSION['keyword']."%'";
}

function get_color_name($connect, $id){
			$result = $connect->query("select color_name from color_tbl where id = '".$id."' ");
			$row=$result->FETCH(PDO::FETCH_ASSOC);
			$number_of_rows = $result->fetchColumn();
			return $row['color_name'];
	 }

function get_brand_name($connect, $id){
			$result = $connect->query("select brand_name from brand_tbl where id = '".$id."' ");
			$row=$result->FETCH(PDO::FETCH_ASSOC);
			return $row['brand_name'];
	 }

if(isset($_REQUEST["order"]))
	{
	 $query= "SELECT * FROM product_tbl WHERE status = '1' order by product_price asc";
	}

if(isset($_REQUEST["high-to-low"]))
	{
	 $query= "SELECT * FROM product_tbl WHERE status = '1' order by product_price desc";
	}

if(isset($_REQUEST["Popularity"]))
	{
	 $query= "SELECT * FROM product_tbl WHERE status = '1' and `is_new`='1'";
	}

if(isset($_REQUEST["Newest"]))
	{
	 $query= "SELECT * FROM product_tbl WHERE status = '1' and `is_feature`='1'";
	}

$statement = $connect->prepare($query);
	$statement->execute();
	$result = $statement->fetchAll();
	$total_row = $statement->rowCount();
	$_SESSION['filter']=$total_row;
	$output = '';
	$dtl_link = get_prod_dtl_link($cat_row3['id']);
	if($total_row > 0)
	{
		foreach($result as $row)
		{
	 $sess_arr=explode("~",$_SESSION['member']);
     $member_id=$sess_arr[0];
	 $img1=''; 
	 $imgurlpath_small='';
	//$cnt++;
	$dtl_link = get_prod_dtl_link($row['id']);
	$product_img = $row['product_image'];

if(!empty($product_img)){
		$img_arr = explode("~",$product_img);
		$tot_img = count($img_arr);
		$img1 = $img_arr[0];
	}

$output .= '
			<div class="col-sm-4 col-lg-3 col-md-3">
				<div style="border:1px solid #ccc; border-radius:5px; padding:16px; margin-bottom:16px;">
				   <a href="'.get_prod_dtl_link($row['id']).'">
					<img src="'.SITE_URL.'/uploaded/product_images/'.$img1.'" alt="" class="img-responsive" ></a>
					<p align="center"><strong><a href="'.get_prod_dtl_link($row['id']).'">'. $row['product_name'] .'</a></strong></p>
					<h4 class="price" ><i class="fa fa-rupee-sign" aria-hidden="true"></i> '. format_currency_price($row['product_price']) .'</h4>
					';
					if($row['color_id']>0)
					{
					   $output .='<p class="details-color">Color : '.get_color_name($connect,$row['color_id']).' <br /> '; 
					}
					else
					{
					     
					}
					 
					
					$output .= 'Brand : '.get_brand_name($connect,$row['brand_id']).' <br />
					 
					 
				</div>

</div>
			';
		}
	}
	else
	{
		$output = '<h3>No Data Found</h3>';
	}
	echo $output;