MAINHACK

Viewing / Editing File: addCustomer.php

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

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

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

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

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

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

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

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

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

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

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

$sele = mysqli_query($new,"SELECT * FROM clients WHERE client_email = '$email' AND business_name = '$shopname'");
$conrow = mysqli_fetch_array($sele);
$dbvendor = $conrow['email'];
$phone = $conrow['phone_number'];

if($email === $dbvendor){
   echo json_encode(['status' => 'error', 'message' => 'Email already  Exist']);
      exit;

}elseif($phone === $phone_number) {
      echo json_encode(['status' => 'error', 'message' => 'Phone number already  Exist']);
      exit;
      
   } else {

$date = date("Y-m-d");

$stmt = $con->prepare("insert into clients (first_name,last_name,phone_number,client_email,date,gender,DOB,anniversary,address,location,business_name) values (?,?,?,?,?,?,?,?,?,?,?)");
$stmt->execute(array($first_name,$last_name,$phone_number,$email,$date,$gender,$DOB,$anniversary,$address,$location,$shopname));
 echo json_encode(['status' => 'success', 'message' => 'Customer is added']);
      exit;
}

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: addCustomer.php

Server Info

System Features

User Info