MAINHACK

Viewing / Editing File: insertStock.php

<?php include("db.php");
   $timezome = 'Africa/Africa';
  date_default_timezone_set($timezome);

$username = $_SESSION['username_Xw211qAAsq4'];
$shopname = $_SESSION['business_name_Xw211qAAsq4'];

$pro_id = filter_input(INPUT_POST, 'pro_id', FILTER_SANITIZE_STRING);
$pro_id = htmlspecialchars($pro_id, ENT_QUOTES, 'UTF-8');

$qty = filter_input(INPUT_POST, 'qty', FILTER_SANITIZE_STRING);
$qty = htmlspecialchars($qty, ENT_QUOTES, 'UTF-8');

$date = filter_input(INPUT_POST, 'date', FILTER_SANITIZE_STRING);
$date = htmlspecialchars($date, ENT_QUOTES, 'UTF-8');

if(empty($pro_id)){
 echo json_encode(['status' => 'error', 'message' => 'Select supplier']);
     exit;

}elseif(empty($qty)){
echo json_encode(['status' => 'error', 'message' => 'Enter stock qty']);
      exit; 
}elseif(empty($date)){
     echo json_encode(['status' => 'error', 'message' => 'Enter stock date']);
      exit; 
}
 else {
$stmt = $con->prepare("insert into stock (pro_id,qty,date,business_name) values(?,?,?,?) ");
$stmt->execute(array($pro_id,$qty,$date,$shopname));

$stmtCheckClient = $con->prepare("SELECT * FROM products WHERE pro_id = ?");
$stmtCheckClient->execute(array($pro_id));
$client_result = $stmtCheckClient->fetch();

$db_qty = $client_result["qty"];

$qtytotal = $db_qty + $qty;

$stmt = $con->prepare("update  products set qty = ?  where pro_id = ? ");
 $stmt->execute(array($qtytotal,$pro_id));

echo json_encode(['status' => 'success', 'message' => 'Product stock added']);
      exit;
}

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: insertStock.php

Server Info

System Features

User Info