IndCareer WhatsApp +91 9561 204 888
Please insert Phone number/div>";
}else{
$phone = preg_replace("/ /","",$phoneS);
$phone = preg_replace("/^0/", "", $phone);
$phone = preg_replace("/\+91/","",$phone);
if(is_numeric($phone)) {
$phone = substr($phone, -10);
if(strlen($phone) < 10){
$msg = "
Please Insert Proper Number
";
$error = 1;
}
}else{
$msg = "Please Insert Proper Number
";
$error = 1;
}
}
if($error != 1){
$query = "SELECT COUNT(*) as total FROM phoneAlerts WHERE phone='$phone'";
$db->query($query);
$db->next_record();
$total = $db->f("total");
if($total > 0){
$query = "UPDATE phoneAlerts SET fullName='$fullName',email='$email',phone='$phone',university='$university',college='$college',state='$state',course='$course',created='$creted' WHERE phone='$phone'";
$db->query($query);
$msg = "Update Successfully for $phone
";
}else{
$query = "INSERT INTO phoneAlerts SET fullName='$fullName',email='$email',phone='$phone',university='$university',college='$college',state='$state',course='$course',created='$creted'";
$db->query($query);
$msg = "New Record Insert Successfully
";
}
}
echo "$msg";
}
?>