MAINHACK

Viewing / Editing File: insertCate.php

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

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

if(isset($_POST['submit'])){

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

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

$select = mysqli_query($new,"SELECT * FROM service_categories WHERE category_name = '$category_name' and business_name = '$shopname'");
 $dbmail = mysqli_fetch_array($select);

$mail = $dbmail['category_name'];

if(empty($category_name)){
  echo json_encode(['status' => 'error', 'message' => 'Category name is required']);
      exit;
  } elseif($mail == $category_name){
    echo json_encode(['status' => 'error', 'message' => 'Category name exist']);
    exit;
 } else {
   $date = date("Y-m-d h:i");

$stmt = $con->prepare("insert into service_categories (category_name,cat_status,business_name,date) values(?,?,?,?)");
$stmt->execute(array($category_name,$status,$shopname,$date));

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

}

Cancel / Back

[ MAINHACK ]

Viewing / Editing File: insertCate.php

Server Info

System Features

User Info