1#@!#!123s

��JFIF�� 1#@!#!123s
: / var / www / html / projects / app.eltorofashions.com / demo /
Filename : get_product.php
back
<?php
session_start();
if(isset($_SESSION['login'])){
include "main.php"; 

$prod_name=$_POST['term'];

	// $sql="SELECT pid,productname,amount,product_image FROM `product` where productname like '%$prod_name%' and del=1";
    $sql="select p.pid, CONCAT(p.productname, '-', pd.print_description) as productname, p.amount, p.product_image from product p, print_description pd where p.productname like '%$prod_name%' and p.print = pd.pd_id and p.del=1";
	$result = $conn->query($sql);

	  $mainarray=array();
      
    while($row=$result->fetch_assoc()){
    	$subarray['value']=$row['productname'];
    	$subarray['id']=$row['pid'];

        $pid = $row['pid'];

          $sql4 = "select sum(quantity) as q from delivery_in_products where pid='$pid' and status='1'";
            $result4 = $conn->query($sql4);
            while($row4=$result4->fetch_assoc()){
             $inquantity=$row4['q'];
            }


            $sql4 = "select sum(quantity) as q from delivery_out_products where pid='$pid' and status='1'";
            $result5 = $conn->query($sql4);
            while($row5=$result5->fetch_assoc()){
             $outquantity=$row5['q'];
            }

             $pstock=$inquantity-$outquantity;

        $subarray['tot_quan'] = $pstock;


        $subarray['amount']=$row['amount'];
        $subarray['product_image']=$row['product_image'];
    	 array_push($mainarray, $subarray);

    }

     echo json_encode($mainarray);

}
else
{
    header ('location:index.php');
}


?>