MAINHACK

Viewing / Editing File: insertEmployment.php

<?php include("db.php");
   $timezome = 'Africa/Africa';
  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');

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

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

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

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

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

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

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

if(empty($first_name)){
         echo json_encode(['status' => 'error', 'message' => 'Employees first name is required']);
      exit;
       }elseif(empty($last_name)){

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

} else {

$stmt = $con->prepare("insert into employees (first_name,last_name,phone_number,email,dob,gender,department,monthly_salary,status,address,business_name) values (?,?,?,?,?,?,?,?,?,?,?)");
$stmt->execute(array($first_name,$last_name,$phone_number,$email,$dob,$gender,$department,$monthly_salary,$status,$address,$shopname));

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

}

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: insertEmployment.php

Server Info

System Features

User Info