/home/techb158/workloadmatch.com/workloadmatch.com/BackUp/Manager/Inc
Edit: /home/techb158/workloadmatch.com/workloadmatch.com/BackUp/Manager/Inc/Assign_Category_To_User.php (2733B)
query($query);
$row = $result->fetch_assoc();
$Category_ID = $row['Category_ID'];
$Admin_ID = $row['Admin_ID'];
$Master_ID = $row['Master_ID'];
$Manager_ID = $row['Manager_ID'];
$Broker_ID = $row['Broker_ID'];
$User_Type_ID = $row['User_Type_ID'];
$datepickerx = date("Y-m-d", strtotime($datepicker));
$query = "SELECT * FROM User_Access_Categories Where Admin_ID ='".$Admin_ID."' AND Master_ID ='".$Master_ID."' AND Manager_ID ='".$Manager_ID."' AND Broker_ID ='".$Broker_ID."' AND User_Access_Category_ID ='".$Category_ID."'";
$result = $mysqli->query($query);
$Managers = $result->fetch_assoc();
$ID = $Managers['Broker_ID'];
if ($ID >= 1) {
header('Location: managecategory.php?error=Assign Category is already exist.');
exit();
}else
{
$datetime =date("Y/m/d") . ' ' . date('H:i:s') ;
if ($insert_stmt = $mysqli->prepare("INSERT INTO User_Access_Categories (Category_ID, Admin_ID, Master_ID, Manager_ID, Broker_ID, User_Type_ID, Titel, First_Name, Last_Name, User_Name, Email, Home_Phone, Cell_Phone, Address, Reg_Date, Login_Date, Logout_Date) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)")) {
//header('Location: addclient.php?error=file name already exists'.$user_n.'');
$insert_stmt->bind_param('sssssssssssssssss',$Category_ID, $Admin_ID, $Master_ID, $Manager_ID, $Broker_ID, $User_Type_ID, $Titel, $First_Name, $Last_Name, $Client_Name, $Email, $Home_Phone, $Cell_Phone, $Address, $datetime, $datetime, $datetime);
// Execute the prepared query.
if (! $insert_stmt->execute()) {
//header('Location: addclient.php?error='.$mysqli->error);
header('Location: managecategory.php?error=Registration failure to Assign Category!');
//header('Location: addassist.php?error='.$Managers_ID.'');
exit();
}else
{
header('Location: managecategory.php?error=New Assign Category successfully registered!');
exit();
}
}else{
//header('Location: addclient.php?error='.$mysqli->error);
}
}
}else{
header('Location: addclient.php?error=Registration failure please insert all informaion!');
exit();
}
}