<?php
$servername = "localhost";
$username = "kdc";
$password = "kdcd";
$dbname = "kdc";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if  ($conn->connect_error)  {
     die("Connection failed: " . $conn->connect_error);
}
//Declare Variables
 $sts = test_input($_POST["sts"]);
                      $date1 = test_input($_POST["date1"]);
                       $cust = test_input($_POST["cusname"]);
                        $it1 = "1 Litre Packet";
                         $it2 = "2 Litre Packet";
                          $it3 = "300 ml Packet";
                           $qt1 = test_input($_POST["qty1"]);
                            $qt2 = test_input($_POST["qty2"]);
                             $qt3 = test_input($_POST["qty3"]);

        function test_input($data) {
        $data = trim($data);
         $data = stripslashes($data);
          $data = htmlspecialchars($data);
        return $data;
     }
 session_start();
     if ($_SERVER["REQUEST_METHOD"] == "POST") {

    $sql1 = $conn->query("SELECT stock FROM stock WHERE item = '$it1'");
     while ($row = $sql1->fetch_assoc()):
   $stock =  $row['stock'];
   endwhile;
    $stock1 = $stock - $qt1;
     $sql2 = $conn->query("SELECT stock FROM stock WHERE item = '$it2'");
     while ($row = $sql2->fetch_assoc()):
   $stock =  $row['stock'];
   endwhile;
    $stock2 = $stock - $qt2;
      $sql3 = $conn->query("SELECT stock FROM stock WHERE item = '$it3'");
     while ($row = $sql3->fetch_assoc()):
   $stock =  $row['stock'];
   endwhile;
    $stock3 = $stock - $qt3;
                  $amt1 = 110 * $qt1;
                  $amt2 = 110 * $qt2;
                  $amt3 = 290 * $qt3;
                  $amt = $amt1 + $amt2 + $amt3;

   /*$sql1 = "UPDATE stock SET stock = '$stock1' WHERE item = '$it1'";
   if ($conn->query($sql1) === TRUE) {
   $sql2 = "UPDATE stock SET stock = '$stock2' WHERE item = '$it2'";
   }
   elseif ($conn->query($sql2) === TRUE) {
   $sql3 = "UPDATE stock SET stock = '$stock3' WHERE item = '$it3'";
   }
   elseif ($conn->query($sql3) === TRUE) {
   $sql4 = "INSERT INTO transaction (date, cus_cde, 1L, 2L, 300ml, sts, amount)
            VALUES ('$date1', '$cust', '$qt1', '$qt2', '$qt3', '$sts', '$amt')";*/
    $sql = "INSERT INTO transaction (date, cus_cde, 1L, 2L, 300ml, sts, amount) values ('$date1', '$cust', '$qt1', '$qt2', '$qt3', '$sts', '$amt')";
  $sql1 =  "UPDATE stock SET stock = '$stock1', '$stock2', '$stock3'";
                    $ok =  $conn->query( $sql ) ;
        $ok1 =  $conn->query( $sql1 ) ;
        if ( $ok && $ok1) === TRUE;
        {
echo  "<div style ='font:28px/28px Arial,tahoma,sans-serif;color:#98CB29;centre'>Your Data has been saved.Thank you for your Valuable time. Please close this window.</div>";

} else {
echo "Error: " . $sql . "<br>" . $conn->error;
$conn->close();
                     exit;
         }
         }
?>