/** * This function is used to insert news letter subscription * * . * * @return string */ function addNewsletterSubscription() { $email = $_POST['email']; if ($_POST['email'] == '' || $_POST['email'] == 'Your Email') { $output = '<div class="alert alert-error"> <button data-dismiss="alert" class="close" type="button">×</button> ' . Core_CLanguage::_(REQUIRED) . ' </div>'; return $output; } elseif ($_POST['email'] != '') { $query = new Bin_Query(); $sql = 'select count(*) as count from newsletter_subscription_table where email="' . $email . '"'; $query->executequery($sql); if ($query->records[0]['count'] > 0) { $output = '<div class="alert alert-info"> <button data-dismiss="alert" class="close" type="button">×</button> ' . Core_CLanguage::_(SCBSCRIBE_NEWS_LETTER_ALREADY_EMAIL_EXISTS) . ' </div>'; return $output; } $checkemail = Core_CUserRegistration::validateEmailAddress($email); if ($checkemail) { $sql = "insert into newsletter_subscription_table(email,status) values('" . $email . "',1)"; if ($query->updateQuery($sql)) { $output = '<div class="alert alert-success"> <button data-dismiss="alert" class="close" type="button">×</button> ' . Core_CLanguage::_(YOUR_REQUEST_FOR_NEWLETTER_ADDED) . ' </div>'; return $output; } else { $output = '<div class="alert alert-error"> <button data-dismiss="alert" class="close" type="button">×</button> ' . Core_CLanguage::_(INVALID_EMAIL_FOR_NEWSLETTER) . ' </div>'; return $output; } } elseif (!$checkemail) { $output = '<div class="alert alert-error"> <button data-dismiss="alert" class="close" type="button">×</button> ' . Core_CLanguage::_(INVALID_EMAIL_FOR_NEWSLETTER) . ' </div>'; return $output; } } }