Esempio n. 1
0
    /**
     * 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;
            }
        }
    }