include_once("library/config.php"); ?> $scode_msg=""; if(isset($_POST['btn_subscribe'])) { extract($_POST); if(isset($_SESSION['security_code'])) { if($_SESSION['security_code'] == $_POST['scode']) { $email = escapeString($email); $sql_chk = "SELECT email FROM newsletter_subscribers WHERE email='$email' "; $rs_chk = $db->ExecuteQuery($sql_chk); $rows_chk = $rs_chk->GetSelectedRows(); if($rows_chk > 0) // already subscribed { header("location: msg.php?action=nalreadysubscribed"); exit; } else { // insert into newsletter subscribers $sql_insert = "INSERT INTO newsletter_subscribers (fname, lname, email, datetime) VALUES ('$fname', '$lname', '$email', now()) "; $db->ExecuteQuery($sql_insert); header("location: msg.php?action=nsubscribed"); exit; } } else { $fname = base64_encode($fname); $lname = base64_encode($lname); $email = base64_encode($email); header("location: news.php?serror=1&f=$fname&l=$lname&e=$email#nsubscribe"); exit; } } } ?>
if(strlen($description) > $news_desc_limit) { echo (substr($description, 0, $news_desc_limit)). "... " ?>MORE } else { echo nl2br($description); } ?>