เว็บบอร์ด PHP เว็บส่งเสริมการเรียนรู้ Hosting CRM ERP Server Programming ถาม-ตอบปัญหา

Code: Select all

<? 
    include("include/connection.php");
    include ("chk_session.php");
    include ("include/function.php");
    
    
    
    $sql ="
            DELETE FROM orders 
            WHERE orders_id = '$id'
    ";

    mysql_query($sql) or die( mysql_error() );
    
    
    $sql ="
            SELECT *
            FROM orders_detail
            WHERE orders_id = '$id';
    
    ";
    $result = mysql_query($sql) or die(mysql_error());
    while( $data = mysql_fetch_array($result)) {
        
            $productid  =$data['product_id'];
            $ordersquantity  =$data['orders_detail_quantity'];
                    
            $sql ="
                    SELECT *
                    FROM product
                    WHERE product_id = '$productid';
            
            ";
            $result = mysql_query($sql) or die(mysql_error());
            $data = mysql_fetch_array($result);
            
            $productquantity = $data['product_quantity'];
            
            $restore = $productquantity+$ordersquantity;
            
            $sql = "
                    UPDATE product
                    SET product_quantity = '$restore'
                    WHERE product_id = '$productid' 

            ";
            mysql_query($sql) or die( mysql_error() );
        
    }
    
            $sql ="
                    DELETE FROM orders_detail
                    WHERE orders_id = '$id'
            ";
        
            mysql_query($sql) or die( mysql_error() );


?>

Code: Select all

$result = mysql_query($sql) or die(mysql_error()); 

Code: Select all

<? 
	include("include/connection.php");
	include ("chk_session.php");
	include ("include/function.php");
	
	
	
	$sql ="
			DELETE FROM orders 
			WHERE orders_id = '$id'
	";

	mysql_query($sql) or die( mysql_error() );
	
	
	$sql ="
			SELECT *
			FROM orders_detail
			WHERE orders_id = '$id';
	
	";
	$result = mysql_query($sql) or die(mysql_error());
	$query = mysql_query($sql);
	
	while( $data = mysql_fetch_array($result)) {
			
			$productid[]  =$data['product_id'];
			$ordersquantity[]  =$data['orders_detail_quantity'];		
	}
	
	for($i=0;$i<count($productid);$i++){
		
			echo "\$productid".$productid[$i]."<br/>"; 
			echo "\$ordersquantity".$ordersquantity[$ei]."<br/>";
				
			$sql ="
					SELECT *
					FROM product
					WHERE product_id = '$productid[$i]';
			
			";
			$result = mysql_query($sql) or die(mysql_error());
			$data = mysql_fetch_array($result);
			
			$productquantity = $data['product_quantity'];
			
			$restore = $productquantity+$ordersquantity[$i];
			
			$sql = "
					UPDATE product
					SET product_quantity = '$restore'
					WHERE product_id = '$productid[$i]' 

			";
			mysql_query($sql) or die( mysql_error() );
			
	}
	
			$sql ="
					DELETE FROM orders_detail
					WHERE orders_id = '$id'
			";
		
			mysql_query($sql) or die( mysql_error() );


?>

Code: Select all

<?
echo "test ว่าเหนเปน สี code  อิอิ";
?>

Code: Select all

            $sql ="
                    SELECT *
                    FROM product
                    WHERE product_id = '$productid';
            
            ";
            $result2 = mysql_query($sql) or die(mysql_error());
            $data = mysql_fetch_array($result2);