MAINHACK

Viewing / Editing File: insertProduct.php

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

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

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

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

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

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

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

$notificationType = "error";
$sucess = "success";

$sele = mysqli_query($new,"SELECT * FROM products WHERE product_name = '$product_name' AND business_name = '$shopname'");
     $conrow = mysqli_fetch_array($sele);
      $dbvendor = $conrow['product_name'];

if(empty($product_name)){
    echo json_encode(['status' => 'error', 'message' => 'Product name required']);
      exit;
  }

elseif(empty($qty)){

echo json_encode(['status' => 'error', 'message' => 'Product Qty is required']);
      exit;
 }

elseif(empty($price)){

echo json_encode(['status' => 'error', 'message' => 'Product price is required']);
      exit;
 }

elseif(empty($date)){
 echo json_encode(['status' => 'error', 'message' => 'Date is required']);
      exit;
 }

elseif(empty($supplier_id)){

echo json_encode(['status' => 'error', 'message' => 'Select supplier name']);
      exit;
 }

elseif($product_name === $dbvendor ){

echo json_encode(['status' => 'error', 'message' => 'Product name already exist']);
      exit;
 }

else {

$stmt = $con->prepare("insert into products (product_name,qty,price,supplier,date,business_name) values(?,?,?,?,?,?) ");
$stmt->execute(array($product_name,$qty,$price,$supplier_id,$date,$shopname));

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

}

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: insertProduct.php

Server Info

System Features

User Info