require('includes/application_top.php');
$email_address = fun_db_prepare_input($_POST['email_address']);
$firstname = fun_db_prepare_input($_POST['firstname']);
$lastname = fun_db_prepare_input($_POST['lastname']);
$company = fun_db_prepare_input($_POST['company']);
$newsletter = fun_db_prepare_input($_POST['newsletter']);
if(isset($_POST['submit']) && $_POST['submit']=="Submit"){
if($newsletter=="1"){
if(findNewsletterEmail($email_address)){
$sql_update_news = "UPDATE tbl_newsletter SET status='".$newsletter."' WHERE email='".$email_address."'";
@mysql_query($sql_update_news) or die("Error: Invalid SQL");
$msg = "Sorry! You have already subscribed our newsletter.";
}else{
$sql_insert_news = "INSERT INTO tbl_newsletter(id, firstname, lastname, company , email, date, status) VALUES(null, '".$firstname."', '".$lastname."', '".$company."', '".$email_address."', '".date("Y-m-d")."', '1')";
@mysql_query($sql_insert_news) or die("Error: Invalid SQL");
$message = "Thank you for subscription.";
}
}
if($newsletter=="2"){
if(findNewsletterEmail($email_address)){
$sql_update_news = "UPDATE tbl_newsletter SET status='".$newsletter."' WHERE email='".$email_address."'";
@mysql_query($sql_update_news) or die("Error: Invalid SQL");
$message = "You have been unsubscribed successfully.";
}else{
$msg = "Sorry! You have never subscribed our newsletter.";
}
}
if($message)
{
$message=urlencode($message);
header("Location: message_page.php?message=$message");
exit;
}
}
?>
TITLE
include('header.php');?>
include('left-nav.php');?> |
Latest Newsletter - Latest for Nursery Admissions in Delhi Schools, Top Ten Schools Nursery Admissions in Delhi |
|
|
include('footer.php');?>