leonidassavvides
07-14-2008, 10:44 AM
I am trying to built a complex website: http://www.poliscarhire.com/ ,
currently setting up the NewsLetters function, but when in homepage above(and to all pages) I insert a valid email to subscribute a message from email validation says always: "InValid email address. Please retry ! " , well ? code to subscribute.php below:
<html>
.....<strong>
<?php
$email = $_POST['email'];
include("../dbinfo.php");
$linkid = @mysql_connect($hostname,$username,$password) or die( "Unable to connect to Database Server. Please try again later.");
@mysql_select_db($database,$linkid) or die( "Unable to select database. Please try again later,"); // @
if ($_POST['unsubscribute']) {
$query = "SELECT * FROM $NewslettersTable";
$result = @mysql_query($query,$linkid) or die( "Unable to execute query. Please try again later.");
$count = @mysql_num_rows($result);
for ($j=0;$j<$count;$j++) {
$row = mysql_fetch_row($result);
if ($email != $row['email']) {
echo "This email address does NOT exist, in the database !";
break;
}
$query = "DELETE FROM $NewslettersTable WHERE email='$email'";
$result = @mysql_query($query,$linkid) or die( "Unable to execute query. Please try again later.");
echo "You have successfully UnSubscribute from our 'Newsletter (Latest Offers)' as: \n". $email;
}
}
else {
if (eregi("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$", $email)) {
$query = "SELECT * FROM $NewslettersTable";
$result = @mysql_query($query,$linkid) or die( "Unable to execute query. Please try again later.");
$count = @mysql_num_rows($result);
for ($j=0;$j<$count;$j++) {
$row = mysql_fetch_row($result);
if ($email == $row['email']) {
echo "This email address already exist, in the database !";
break;
}
// mysql_free_result($result);
$query = "INSERT INTO $NewslettersTable VALUES(NULL,'$email')";
$result = @mysql_query($query,$linkid) or die( "Unable to execute query. Please try again later.");
echo "You have successfully Subscribute to our 'Newsletter (Latest Offers)' as: \n". $email;
} // end for
} else {
echo "InValid email address. Please retry !";
} // end if
} // end if main
// mysql_free_result($result);
mysql_close($linkid);
?>
</strong>
....
</html>
currently setting up the NewsLetters function, but when in homepage above(and to all pages) I insert a valid email to subscribute a message from email validation says always: "InValid email address. Please retry ! " , well ? code to subscribute.php below:
<html>
.....<strong>
<?php
$email = $_POST['email'];
include("../dbinfo.php");
$linkid = @mysql_connect($hostname,$username,$password) or die( "Unable to connect to Database Server. Please try again later.");
@mysql_select_db($database,$linkid) or die( "Unable to select database. Please try again later,"); // @
if ($_POST['unsubscribute']) {
$query = "SELECT * FROM $NewslettersTable";
$result = @mysql_query($query,$linkid) or die( "Unable to execute query. Please try again later.");
$count = @mysql_num_rows($result);
for ($j=0;$j<$count;$j++) {
$row = mysql_fetch_row($result);
if ($email != $row['email']) {
echo "This email address does NOT exist, in the database !";
break;
}
$query = "DELETE FROM $NewslettersTable WHERE email='$email'";
$result = @mysql_query($query,$linkid) or die( "Unable to execute query. Please try again later.");
echo "You have successfully UnSubscribute from our 'Newsletter (Latest Offers)' as: \n". $email;
}
}
else {
if (eregi("^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,3})$", $email)) {
$query = "SELECT * FROM $NewslettersTable";
$result = @mysql_query($query,$linkid) or die( "Unable to execute query. Please try again later.");
$count = @mysql_num_rows($result);
for ($j=0;$j<$count;$j++) {
$row = mysql_fetch_row($result);
if ($email == $row['email']) {
echo "This email address already exist, in the database !";
break;
}
// mysql_free_result($result);
$query = "INSERT INTO $NewslettersTable VALUES(NULL,'$email')";
$result = @mysql_query($query,$linkid) or die( "Unable to execute query. Please try again later.");
echo "You have successfully Subscribute to our 'Newsletter (Latest Offers)' as: \n". $email;
} // end for
} else {
echo "InValid email address. Please retry !";
} // end if
} // end if main
// mysql_free_result($result);
mysql_close($linkid);
?>
</strong>
....
</html>