Ele57885fddfgdfgfghgقفغفغفقhfg555434536

kohjhjhصثقصثقصثقgdfgdg Ele57885fddfgdfgfghgقفغفغفقhfg555434536

<?php 
	session_start();
	$uid = $_SESSION["uid"];
	include('db.php');
	
	
	
	
	$orderItemSqlw = "SELECT id,amnt FROM p12 WHERE id='$uid'";
 $orderItemResultw = $db->query($orderItemSqlw);

$orderResultw = $db->query($orderItemSqlw);
$orderDataw = $orderResultw->fetch_array();

$amct = $orderDataw[1];

$datncwt = date("d-m-Y");
	
	
	
	
	
	
		if(isset($_POST['addToProduct'])){
			
			
			$pid=$_POST['proId'];
			
			
			
			
		//	$pro_price=$_POST['rate'];
			
		//	$discount=$_POST['discount'];
			
			
			
			$amntqty=1000;
			
			$pidww = "p14w ".$pid. "";
			
			
			
			
			
			
			if($pid == 12 || $pid == 13 || $pid == 14)
			
			
			
			
			
			
			
			
			
			
			
			
			{
			    
				$discount=30;
			//	$insert = $db->query("update p12 set amnt='$discountw' where id='$uid'");
		//	}
		//	elseif($amct==$discountw)
			
		//	{
			    
		//		$discount=$discountw;
				
			}
			
			
			
		else
			{
			    	$discount=$_POST['discount'];
			    
			    
			
			
			
			
			    
			}
			$sql = "SELECT * FROM cart WHERE p_id = '$pid' AND user_id = '$uid' ";
			
			$run_query=mysqli_query($db,$sql);
			
			$count=mysqli_num_rows($run_query);
			
			if($count>0)
			{
		
			
			
				
			}
			else
			{
				$sql = "SELECT * FROM p15 WHERE id = '$pid'";
				$run_query = mysqli_query($db,$sql);
				$row = mysqli_fetch_array($run_query);
				$id = $row["id"];
				
				$amnt = $row["name"];
				
				
				$pro_title = mysqli_real_escape_string($db, $row["name7"]);
				$qnwt = $row["name8"];
				
				$unit = $row["name10"];
				
				
				
				
				
				
				
				
				
				
				
				
				
				
				
				
				
				
				
				
				
				$amwtqnt = $row["tsldqnt"];
				
				
				$color = $row["color"];
				
				$nameawnt = $row["nameawnt"];
				
				$pro_image = $row["file1"];
				
			    $pro_price = $row["name12"]-($row["name12"]*$row["name11"]/100);

$sql="INSERT INTO cart(p_id,cid,user_id,product_title,product_image,qty,price,total_amount,amnt,unit,qnwt,amntqty,datncwt,color,awnt,nameawnt) VALUES('$pid','$pidww','$uid','$pro_title','$pro_image','1','$pro_price','$pro_price','$amnt','$unit','$qnwt','$amntqty','$datncwt','$color','Productview','$nameawnt')";
				
				$run_query = mysqli_query($db,$sql);
				
				
				
				
				
				
				
				
				
				
				
				
				
				
			}
		
		
		
		
		echo $count;
		
		
		}
		
		
		
		
		
		if(isset($_POST['addToProductqtny'])){
			
			
			$pid=$_POST['proId'];
			
			
			$fileqtny=$_FILES["fileqtny"]["name"];
		move_uploaded_file($_FILES["fileqtny"]["tmp_name"],"../Admin-Panel/image/customized/".$_FILES["fileqtny"]["name"]);
			
		//	$pro_price=$_POST['rate'];
			
		//	$discount=$_POST['discount'];
			
			
			
			$amntqty=1000;
			
			$pidww = "p14w ".$pid. "";
			
			
			
			
			
			
			if($pid == 12 || $pid == 13 || $pid == 14)
			
			
			
			
			
			
			
			
			
			
			
			
			{
			    
				$discount=30;
			//	$insert = $db->query("update p12 set amnt='$discountw' where id='$uid'");
		//	}
		//	elseif($amct==$discountw)
			
		//	{
			    
		//		$discount=$discountw;
				
			}
			
			
			
		else
			{
			    	$discount=$_POST['discount'];
			    
			    
			
			
			
			
			    
			}
			$sql = "SELECT * FROM cart WHERE p_id = '$pid' AND user_id = '$uid' ";
			
			$run_query=mysqli_query($db,$sql);
			
			$count=mysqli_num_rows($run_query);
			
			if($count>0)
			{
				echo "<p>Click the button to display an alert box.</p>";
				
			}
			else
			{
				$sql = "SELECT * FROM p15 WHERE id = '$pid'";
				$run_query = mysqli_query($db,$sql);
				$row = mysqli_fetch_array($run_query);
				$id = $row["id"];
				
				$amnt = $row["name"];
				
				
				$pro_title = mysqli_real_escape_string($db, $row["name7"]);
				
				
				
				
				$qnwt = $row["name8"];
				
				$unit = $row["name10"];
				
				
				
				
				
				
				
				
				
				
				
				
				
				
				
				
				
				
				
				
				
				$amwtqnt = $row["tsldqnt"];
				
				
				$color = $row["color"];
				
			
				$qtny = $row["qtny"];
				
				$awntwtnt = $row["awntwtnt"];
				
					$fileawnt = $row["file1"];
				
				if($fileawnt==""){
				    
				
				$orderItemSqlqnty = "SELECT name,id FROM p15 WHERE name7='$pro_title' and color='$color' and approve <> 'rejected'";
 $orderItemResultqnty = $db->query($orderItemSqlqnty);

$orderResultqnty = $db->query($orderItemSqlqnty);
$orderDataqnty = $orderResultqnty->fetch_array();

$qnty = $orderDataqnty[1];

$orderItemSqlqntyawnt = "SELECT id,file1 FROM p370 WHERE name7='$qnty' and approve <> 'rejected'";
 $orderItemResultqntyawnt = $db->query($orderItemSqlqntyawnt);

$orderResultqntyawnt = $db->query($orderItemSqlqntyawnt);

$orderDataqntyawnt = $orderResultqntyawnt->fetch_array();

$pro_image = $orderDataqntyawnt[1];

} else {
				    
				    
			$pro_image = $fileawnt;	    
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
				}	
				
				$pro_price = $row["name12"];

$sql="INSERT INTO cart(p_id,cid,user_id,product_title,product_image,qty,price,total_amount,amnt,unit,qnwt,amntqty,datncwt,color,awntwtnt,awnt,qtny,fileqtny) VALUES('$pid','$pidww','$uid','$pro_title','$pro_image','1','$pro_price','$pro_price','$amnt','$unit','$qnwt','$amntqty','$datncwt','$color','$awntwtnt','Productview','$qtny','$fileqtny')";
				
				$run_query = mysqli_query($db,$sql);
				
				
				
				
				
				
				
				
				
				
				
				
					$tsldqnt = $amwtqnt-1;
				$insert = $db->query("update p15 set tsldqnt='$tsldqnt' where id = '$id'");
				if($run_query){
					echo "
						<div>
  					<button type='button'><span aria-hidden='true'>&times;</span></button>
  					<strong>Success!</strong> Product added to cart!
				</div>
					";
				}
			}
		
		
		
		
		}
		
		
		if(isset($_POST['addToProductqtnyatnyawnt'])){
			
			
			$pid=$_POST['proId'];
			
			
			
			
	      	$pro_price=$_POST['totalant'];
			
		//	$discount=$_POST['discount'];
			
			
			
			$amntqty=1000;
			
			$pidww = "p14w ".$pid. "";
			
			
			
			
			
			
			if($pid == 12 || $pid == 13 || $pid == 14)
			
			
			
			
			
			
			
			
			
			
			
			
			{
			    
				$discount=30;
			//	$insert = $db->query("update p12 set amnt='$discountw' where id='$uid'");
		//	}
		//	elseif($amct==$discountw)
			
		//	{
			    
		//		$discount=$discountw;
				
			}
			
			
			
		else
			{
			    	$discount=$_POST['discount'];
			    
			    
			
			
			
			
			    
			}
			$sql = "SELECT * FROM cart WHERE p_id = '$pid' AND user_id = '$uid' ";
			
			$run_query=mysqli_query($db,$sql);
			
			$count=mysqli_num_rows($run_query);
			
			if($count>0)
			{
				echo "<p>Click the button to display an alert box.</p>";
				
			}
			else
			{
				$sql = "SELECT * FROM p15 WHERE id = '$pid'";
				$run_query = mysqli_query($db,$sql);
				$row = mysqli_fetch_array($run_query);
				$id = $row["id"];
				
				$amnt = $row["name"];
				
				
				$pro_title = mysqli_real_escape_string($db, $row["name7"]);
				
				
				
				
				$qnwt = $row["name8"];
				
				$unit = $row["name10"];
				
				
				
				
				
				
				
				
				
				
				
				
				
				
				
				
				
				
				
				
				
				$amwtqnt = $row["tsldqnt"];
				
				
				$color = $row["color"];
				
			
				$qtny = $row["qtny"];
				
				$awntwtnt = $row["awntwtnt"];
				
					$fileawnt = $row["file1"];
				
				if($fileawnt==""){
				    
				
				$orderItemSqlqnty = "SELECT name,id FROM p15 WHERE name7='$pro_title' and color='$color' and approve <> 'rejected'";
 $orderItemResultqnty = $db->query($orderItemSqlqnty);

$orderResultqnty = $db->query($orderItemSqlqnty);
$orderDataqnty = $orderResultqnty->fetch_array();

$qnty = $orderDataqnty[1];

$orderItemSqlqntyawnt = "SELECT id,file1 FROM p370 WHERE name7='$qnty' and approve <> 'rejected'";
 $orderItemResultqntyawnt = $db->query($orderItemSqlqntyawnt);

$orderResultqntyawnt = $db->query($orderItemSqlqntyawnt);

$orderDataqntyawnt = $orderResultqntyawnt->fetch_array();

$pro_image = $orderDataqntyawnt[1];

} else {
				    
				    
			$pro_image = $fileawnt;	    
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
				}	
				
				//$pro_price = $row["name12"];

$sql="INSERT INTO cart(p_id,cid,user_id,product_title,product_image,qty,price,total_amount,amnt,unit,qnwt,amntqty,datncwt,color,awntwtnt,awnt,qtny) VALUES('$pid','$pidww','$uid','$pro_title','$pro_image','1','$pro_price','$pro_price','$amnt','$unit','$qnwt','$amntqty','$datncwt','$color','$awntwtnt','Productviewoffer','$qtny')";
				
				$run_query = mysqli_query($db,$sql);
				
				
				
				
				
				
				
				
				
				
				
				
					$tsldqnt = $amwtqnt-1;
				$insert = $db->query("update p15 set tsldqnt='$tsldqnt' where id = '$id'");
				if($run_query){
					echo "
						<div>
  					<button type='button'><span aria-hidden='true'>&times;</span></button>
  					<strong>Success!</strong> Product added to cart!
				</div>
					";
				}
			}
		
		
		
		
		}
		
		
		
		if(isset($_POST['addToProductwt'])){
			
			$pid=$_POST['proId'];
			
			
			$pro_price=$_POST['rate'];
			//$discount=$_POST['discount'];
			$pidww = "p14w ".$pid. "";
			
			
			$sql = "SELECT * FROM cart WHERE p_id = '$pid' AND user_id = '$uid' ";
			$run_query=mysqli_query($db,$sql);
			$count=mysqli_num_rows($run_query);
			if($count>0)
			{
				echo "<p>Click the button to display an alert box.</p>";
				
			}
			else
			{
				$sql = "SELECT * FROM p15 WHERE id = '$pid'";
				$run_query = mysqli_query($db,$sql);
				$row = mysqli_fetch_array($run_query);
				$id = $row["id"];
				
				$amnt = $row["name"];
				
				
				$pro_title = mysqli_real_escape_string($db, $row["name7"]);
				$qnwt = $row["name8"];
				
				$unit = $row["name10"];
				
				$fileawnt = $row["file1"];
				
				if($fileawnt==""){
				    
				
				$orderItemSqlqnty = "SELECT name,id FROM p15 WHERE name7='$pro_title' and color='$color' and approve <> 'rejected'";
 $orderItemResultqnty = $db->query($orderItemSqlqnty);

$orderResultqnty = $db->query($orderItemSqlqnty);
$orderDataqnty = $orderResultqnty->fetch_array();

$qnty = $orderDataqnty[1];

$orderItemSqlqntyawnt = "SELECT id,file1 FROM p370 WHERE name7='$qnty' and approve <> 'rejected'";
 $orderItemResultqntyawnt = $db->query($orderItemSqlqntyawnt);

$orderResultqntyawnt = $db->query($orderItemSqlqntyawnt);

$orderDataqntyawnt = $orderResultqntyawnt->fetch_array();

$pro_image = $orderDataqntyawnt[1];

$orderData7 = $orderResult7->fetch_array();

$price = $orderData7[7];

$total = $quantity4*$price;
			if($count>0)
			{
			    
			    
			    $sql = "SELECT * FROM p15 WHERE id = '$pid'";
				$run_query = mysqli_query($db,$sql);
				$row = mysqli_fetch_array($run_query);
				$id = $row["id"];
				$amwtqnt = $row["tsldqnt"];
				
			    
			   
			    
			    
			    
			    $insert = $db->query("update cart set qty='$quantity4',total_amount='$total' where p_id = '$pid' AND user_id = '$uid'");
			    if ($quantityamwt == "1") {
			    	$tsldqnt = $amwtqnt-1;
			    }	elseif ($quantityamwt == "2") {
			        $tsldqnt = $amwtqnt+1;
			    } else {
			        $tsldqnt = $amwtqnt+1;
			        
			    }
			    
				$insert = $db->query("update p15 set tsldqnt='$tsldqnt' where id = '$id'");
				
				
				echo "<p>Click the button to display an alert box.</p>";
				
		
			}
			else
			{
			    
			    
			    
			    
			    
			    
			    
			    
			    
			    
			    
			    
			    
			    
				$sql = "SELECT * FROM p15 WHERE id = '$pid'";
				$run_query = mysqli_query($db,$sql);
				$row = mysqli_fetch_array($run_query);
				$id = $row["id"];
				
				$amnt = $row["name"];
				
				
				$pro_title = mysqli_real_escape_string($db, $row["name7"]);
				$qnwt = $row["name8"];
				
				$unit = $row["name10"];
				
				$fileawnt = $row["file1"];
				
				if($fileawnt==""){
				    
				
				$orderItemSqlqnty = "SELECT name,id FROM p15 WHERE name7='$pro_title' and color='$color' and approve <> 'rejected'";
 $orderItemResultqnty = $db->query($orderItemSqlqnty);

$orderResultqnty = $db->query($orderItemSqlqnty);
$orderDataqnty = $orderResultqnty->fetch_array();

$qnty = $orderDataqnty[1];

$orderItemSqlqntyawnt = "SELECT id,file1 FROM p370 WHERE name7='$qnty' and approve <> 'rejected'";
 $orderItemResultqntyawnt = $db->query($orderItemSqlqntyawnt);

$orderResultqntyawnt = $db->query($orderItemSqlqntyawnt);

$orderDataqntyawnt = $orderResultqntyawnt->fetch_array();

$pro_image = $orderDataqntyawnt[1];

} else {
				    
				    
			$pro_image = $fileawnt;	    
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
			
				}	
				
				
				$amwtqnt = $row["tsldqnt"];
				$pro_price = $row["name12"];

$sql="INSERT INTO cart(p_id,cid,user_id,product_title,product_image,qty,price,total_amount,amnt,unit,qnwt,datncwt) VALUES('$pid','$pidww','$uid','$pro_title','$pro_image','1','$pro_price','$pro_price','$amnt','$unit','$qnwt','$datncwt')";
				
				$run_query = mysqli_query($db,$sql);
					$tsldqnt = $amwtqnt-1;
				$insert = $db->query("update p15 set tsldqnt='$tsldqnt' where id = '$id'");
				if($run_query){
					echo "
						<div>
  					<button type='button'><span aria-hidden='true'>&times;</span></button>
  					<strong>Success!</strong> Product added to cart!
				</div>
					";
				}
			}
			
			
		
		
		
		
			
		
		
		
		
		
		
		}
	
       if(isset($_POST['addToProductww'])){
			
			$pid=$_POST['proId'];
				$quantity4=$_POST['quantity4'];
			$sql = "SELECT * FROM p15 WHERE id = '$pid'";
				$run_query = mysqli_query($db,$sql);
				$row = mysqli_fetch_array($run_query);
				$id = $row["id"];
				$amwtqnt = $row["tsldqnt"];
				
			    
			   
			    
			    
			    
			   
			    if ($quantityamwt == "1") {
			    	$tsldqnt = $amwtqnt-1;
			    }	elseif ($quantityamwt == "2") {
			        $tsldqnt = $amwtqnt+1;
			    } else {
			        $tsldqnt = $amwtqnt+1;	
			    }
				$insert = $db->query("update p15 set tsldqnt='$tsldqnt' where id = '$id'");
			 mysqli_query($db,"delete from cart where id = '$pid' AND user_id = '$uid'");
			
			
			
			
		
		
			
		}
		
		
	if(isset($_POST['updateProduct1']))
	{
		$pid=$_POST['pid'];
		$uid = $_SESSION["uid"];
		$qty=$_POST['qty'];
		$price=$_POST['price'];
		$total=$_POST['total'];
		$sql="UPDATE cart SET qty='$qty', price='$price', total_amount='$total' WHERE p_id='$pid' AND user_id='$uid'";
		$run_query=mysqli_query($db,$sql);

}

if(isset($_POST['addToProduct1w'])){
			
			$pid=$_POST['proId'];
				$quantity4=$_POST['quantity4'];
			
			
			$sql = "SELECT * FROM cart WHERE id = '$pid' AND user_id = '$uid' ";
			$run_query=mysqli_query($db,$sql);
			$count=mysqli_num_rows($run_query);
			
			
			
			
			
			
			
			
			
			
			$orderResult7 = $db->query($sql);

$orderData7 = $orderResult7->fetch_array();

$price = $orderData7[7];

$total = $quantity4*$price;
			if($count>0)
			{
			    
			    
			    
			    
			    
			    
			    
			    
			    $insert = $db->query("update cart set qty='$quantity4',total_amount='$total' where id = '$pid' AND user_id = '$uid'");
				//echo "<p>Click the button to display an alert box.</p>";
				
				
				
				$retawntwtnt=mysqli_query($db,"select * from cart where user_id='$uid' and awnt='Productview' and qtnyatny='Offer'");
while($rowawntwtnt=mysqli_fetch_array($retawntwtnt))

{
   $pidqtny =$rowawntwtnt['p_id'];
   
   $awntqtny =$rowawntwtnt['amnt'];
   
   
   
   
   
   
   
   $name1 =$rowawntwtnt['qtnynameawnt'];
   
   
   
   $name2 =$rowawntwtnt['qtnyatnywtntwtnt'];
   
   
   $qtyawntwtntwtnt =$rowawntwtnt['qty'];
   
   
   
   $orderItemSql = "SELECT id,name12,stock FROM p15 WHERE id='$pidqtny'";
     
 $orderItemResult = $db->query($orderItemSql);

$orderResult = $db->query($orderItemSql);

$orderData = $orderResult->fetch_array();

$rateawnt = $orderData[1];
   
   
  
  
  $stockawnt = $orderData[2]; 
  
  
  
  
  
  
  
  
  if($stockawnt<=0){
   
  
  
  
  // mysqli_query($db,"delete from cart where p_id='$pid' and user_id='$uid' and awnt='Productview'");
    
    
    
  }
  
  
  
  else {
      
      
      if($stockawnt< $qtyawntwtntwtnt){
          
          
    
    
    
    $qty = $stockawnt;
      } else {
          
          
          
          
          
        $qty = $qtyawntwtntwtnt;  
      }
      
      
      
      
      
      
      
      
      
      
      
      
      
      
     $orderItemSqlqtny = "SELECT id,name3,name4 FROM p39 WHERE name='$awntqtny' and name1='$name1' and name2='$name2'";
     
     
 
 $orderItemResultqtny = $db->query($orderItemSqlqtny);

$orderResultqtny = $db->query($orderItemSqlqtny);

$orderDataqtny = $orderResultqtny->fetch_array();

$rateqtny = $orderDataqtny[1];
 $rateqtnyawnt = $orderDataqtny[2];  
   
  
  
  
  
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   
   $orderItemSqlqtnyatny = "SELECT id,sum(qty) FROM cart WHERE qtnynameawnt='$name1' and user_id='$uid'";
     
     
     
 $orderItemResultqtnyatny = $db->query($orderItemSqlqtnyatny);

$orderResultqtnyatny = $db->query($orderItemSqlqtnyatny);

$orderDataqtnyatny = $orderResultqtnyatny->fetch_array();

$qtnyatny = $orderDataqtnyatny[1];
   
   if($qtnyatny>$rateqtny){
    
    
    
     $rateatny=$rateawnt-$rateqtnyawnt;	  
       
   } else {
       
       $rateatny=$rateawnt;
    
       
   }
  
  
      $awntwtnt=$qty*$rateatny;

$insert = $db->query("update cart set qty='$qty',price='$rateatny',total_amount='$awntwtnt',amntqty='$stockawnt' where p_id = '$pidqtny' AND user_id = '$uid' and awnt='Productview'");
  }
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
}
				
			}
			else
			{
			    
			    
			    
			    
			    
			    
			    
			    
			    
			    
			    
			    
			    
			    
				$sql = "SELECT * FROM p15 WHERE id = '$pid'";
				$run_query = mysqli_query($db,$sql);
				$row = mysqli_fetch_array($run_query);
				$id = $row["id"];
				
				$amnt = $row["name"];
				
				
				$pro_title = mysqli_real_escape_string($db, $row["name7"]);
				$unit = $row["name10"];
				
				$fileawnt = $row["file1"];
				
				if($fileawnt==""){
				    
				
				$orderItemSqlqnty = "SELECT name,id FROM p15 WHERE name7='$pro_title' and color='$color' and approve <> 'rejected'";
 $orderItemResultqnty = $db->query($orderItemSqlqnty);

$orderResultqnty = $db->query($orderItemSqlqnty);
$orderDataqnty = $orderResultqnty->fetch_array();

$qnty = $orderDataqnty[1];

$orderItemSqlqntyawnt = "SELECT id,file1 FROM p370 WHERE name7='$qnty' and approve <> 'rejected'";
 $orderItemResultqntyawnt = $db->query($orderItemSqlqntyawnt);

$orderResultqntyawnt = $db->query($orderItemSqlqntyawnt);

$orderDataqntyawnt = $orderResultqntyawnt->fetch_array();

$pro_image = $orderDataqntyawnt[1];

$sql="INSERT INTO cart(p_id,cid,user_id,product_title,product_image,qty,price,total_amount,amnt,unit,datncwt) VALUES('$pid','$pidww','$uid','$pro_title','$pro_image','1','$pro_price','$pro_price','$amnt','$unit','$datncwt')";
				
				$run_query = mysqli_query($db,$sql);
				
			}
			
			
		
		
		
		
			$orderItemSqlawnt = "SELECT id,SUM(total_amount) FROM cart WHERE user_id='$uid'";
 
 $orderItemResultawnt = $db->query($orderItemSqlawnt);

$orderResultawnt = $db->query($orderItemSqlawnt);

$orderDataawnt = $orderResultawnt->fetch_array();

$totalamount = $orderDataawnt[1];
		
		
	
	
	
		echo $totalamount;
		
		
		
		}
	if(isset($_POST['cartcount'])){
		
		$uid = $_SESSION["uid"];
		$sql="SELECT * FROM cart WHERE user_id='$uid'";
		$run_query=mysqli_query($db,$sql);
		$count=mysqli_num_rows($run_query);
		echo $count;
		
	}

if(isset($_POST['cartcount1'])){
		
		$uid = $_SESSION["uid"];
		
	$orderItemSql7 = "SELECT id,count(id),SUM(total_amount) FROM cart WHERE user_id='$uid'";
 
 $orderItemResult7 = $db->query($orderItemSql7);

$orderResult7 = $db->query($orderItemSql7);

$orderData7 = $orderResult7->fetch_array();

$count = $orderData7[2];
		echo $count;
		
	}
	
	
	
	if(isset($_POST['cartcount2'])){
		
		$uid = $_SESSION["uid"];
		
		
		$pid=$_POST['amount'];
		
	$orderItemSql7 = "SELECT id,count(id),name1 FROM p228 WHERE name='$pid'";
 
 $orderItemResult7 = $db->query($orderItemSql7);

$orderResult7 = $db->query($orderItemSql7);

$orderData7 = $orderResult7->fetch_array();

$count = $orderData7[2];
		echo $count;
		
	}
 ?>