MAINHACK

Viewing / Editing File: insertSuppler.php

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

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

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

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

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

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

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

if(empty($supplier_name)){
 echo json_encode(['status' => 'error', 'message' => 'Supplier name is required']);
      exit;
} elseif($supplier_name === $dbvendor){

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

else {

$date = date("Y-m-d h:i");

$stmt = $con->prepare("insert into supplier (supplier_name,supplier_email,supplier_number,address,business_name,supp_date) values(?,?,?,?,?,?) ");
$stmt->execute(array($supplier_name,$supplier_email,$supplier_number,$address,$shopname,$date));

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

}

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: insertSuppler.php

Server Info

System Features

User Info