ikan Uploader :
Directory : /home/u956822991/domains/salsabeelwatertech.com/public_html/
Upload File : |
| Current File : /home/u956822991/domains/salsabeelwatertech.com/public_html/offersmail.php |
<?php
session_start();
include "db.php";
if (isset($_POST["email"])) {
$email = $_POST['email'];
$emailValidation = "/^[_a-zA-Z0-9-]+(\.[_a-zA-Z0-9-]+)*@[a-zA-Z0-9]+(\.[a-zA-Z]{2,4})$/";
if(empty($email)){
echo "
<div class='alert alert-warning'>
<br>
<a href='#' class='close' data-dismiss='alert' aria-label='close'>×</a><b><h3>PLease Fill this field..!</b>
</br>
</div>
";
exit();
}else{
if(!preg_match($emailValidation,$email)){
echo "
<div class='alert alert-warning'>
<br>
<a href='#' class='close' data-dismiss='alert' aria-label='close'>×</a>
<b><h3>this $email is not valid..!</b></br>
</div>
";
exit();
}
$sql = "SELECT user_id FROM newsletter WHERE email = '$email' LIMIT 1" ;
$check_query = mysqli_query($con,$sql);
$count_email = mysqli_num_rows($check_query);
if($count_email > 0){
echo "
<div class='alert alert-danger'>
<br>
<a href='#' class='close' data-dismiss='alert' aria-label='close'>×</a>
<b><h3>Email Address is already available</b>
</br>
</div>
";
exit();
}else{
$sql = "INSERT INTO `newsletter`
(`user_id`, `email`)
VALUES (NULL, '$email')";
$run_query = mysqli_query($con,$sql);
echo "<div class='alert alert-success'>
<br>
<a href='#' class='close' data-dismiss='alert' aria-label='close'>×</a>
<b><h3>Thanks for subscribing</b>
</br>
</div>";
}
}
}
?>
........