connect_error) die("Connection failed: " . $conn->connect_error);
mysqli_set_charset($conn,"utf8");
$stmt = $conn->prepare("INSERT INTO ".$GLOBALS['arif_ac']." (`AA_ACTYPE`,`AA_NAME`, `AA_PHONE`, `AA_EMAIL`, `AA_ADDRESS`) VALUES (?, ?, ?, ?, ?)");
$stmt->bind_param("sssss" ,$ca["ac_type"],$ca["ac_name"],$ca["ac_phone"],$ca["ac_mail"],$ca["ac_address"]);
if($stmt->execute()){
$lid=$conn->insert_id;$ca["ac_no"]=$ca["ac_no"].$lid;
if($conn->query("UPDATE `".$GLOBALS['arif_ac']."` SET `AA_ACNO` = '".$ca["ac_no"]."' WHERE `AA_ID` =".$lid.";"))
$GLOBALS['alert_info']= '
Yes! Entry Saved successfully
';
}else{
$GLOBALS['alert_info']= '
Sorry! Unable to process db
';
}
$stmt->close();
$conn->close();
}
?>