Jump to content
xisto Community
alex1985

Verifying Your Email Address A Simple PHP Tutorial.

Recommended Posts

Hi, everyone. I'm offering the next PHP tutorial that verifies an email address of an user who wants to register on your site.
This is how it works. When someone, went to registration page and filled out all of the details such as Name, Password, email and so on and submit those details to a server. The user is getting unique registration code to his or her email account, the one has to be clicked to activate the account.

1. Outline:

a) You need to create or build the following files:

-config.php (The configuration file)
-signup.php (Initial Registration)
-signup_ac.php (Post Registration)
-confirmation.php (The confirmation link)

^_^ You need to create 2 databases:

-temp_members (The temporary members stored in, the confirmation link is sent to them)
-registered_members (The registered members, who pressed the confirmation link, and became registered)

CREATE TABLE `temp_members_db` (
`confirm_code` varchar(65) NOT NULL default '',
`name` varchar(65) NOT NULL default '',
`email` varchar(65) NOT NULL default '',
`password` varchar(15) NOT NULL default '',
`country` varchar(65) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



CREATE TABLE `registered_members` (
`id` int(4) NOT NULL auto_increment,
`name` varchar(65) NOT NULL default '',
`email` varchar(65) NOT NULL default '',
`password` varchar(65) NOT NULL default '',
`country` varchar(65) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;



2. Creating the configuration file (config.php):

<?$host="localhost"; // Host name$username="yourusername"; // Mysql username$password="yourpasword"; // Mysql password$db_name="yourdatabasename"; // Database name//Connect to server and select database.mysql_connect("$host", "$username", "$password")or die("cannot connect to server");mysql_select_db("$db_name")or die("cannot select DB");?>
3. Creating the initial registration file (signup.php)

<table width="350" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><form name="form1" method="post" action="signup_ac.php">
<table width="100%" border="0" cellspacing="4" cellpadding="0">
<tr>
<td colspan="3"><strong>Sign up</strong></td>
</tr>
<tr>
<td width="76">Name</td>
<td width="3">:</td>
<td width="305"><input name="name" type="text" id="name" size="30"></td>
</tr>
<tr>
<td>E-mail</td>
<td>:</td>
<td><input name="email" type="text" id="email" size="30"></td>
</tr>
<tr>
<td>password</td>
<td>:</td>
<td><input name="password" type="password" id="password" size="30"></td>
</tr>
<tr>
<td>Country</td>
<td>:</td>
<td><input name="country" type="text" id="country" size="30"></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><input type="submit" name="Submit" value="Submit">  
<input type="reset" name="Reset" value="Reset"></td>
</tr>
</table>
</form></td>
</tr>
</table>



3. Creating the post registration file (signup_ac.php) where an user's information details as well as confirmation code are said to be stored in database.



// table name
$tbl_name=temp_members_db;

// Random confirmation code
$confirm_code=md5(uniqid(rand()));

// values sent from form
$name=$_POST['name'];
$email=$_POST['email'];
$country=$_POST['country'];

// Insert data into database
$sql="INSERT INTO $tbl_name(confirm_code, name, email, password, country)VALUES('$confirm_code', '$name', '$email', '$password', '$country')";
$result=mysql_query($sql);

// if suceesfully inserted data into database, send confirmation link to email
if($result){[/sql]

// send e-mail to ...
$to=$email;

// Your subject
$subject="Your confirmation link here";

// From
$header="from linenums:0'><?include('config.php');// table name$tbl_name=temp_members_db;// Random confirmation code$confirm_code=md5(uniqid(rand()));// values sent from form$name=$_POST['name'];$email=$_POST['email'];$country=$_POST['country'];// Insert data into database$sql="INSERT INTO $tbl_name(confirm_code, name, email, password, country)VALUES('$confirm_code', '$name', '$email', '$password', '$country')";$result=mysql_query($sql);// if suceesfully inserted data into database, send confirmation link to emailif($result){[/sql]// send e-mail to ...$to=$email;// Your subject$subject="Your confirmation link here";// From$header="from: your name <your email>";// Your message$message="Your Comfirmation link \r\n";$message.="Click on this link to activate your account \r\n";$message.="http://forums.xisto.com/no_longer_exists/ send email$sentmail = mail($to,$subject,$message,$header);}// if not foundelse {echo "Not found your email in our database";}// if your email succesfully sentif($sentmail){echo "Your Confirmation link Has Been Sent To Your Email Address.";}else {echo "Cannot send Confirmation link to your e-mail address";}?>
4. Creating the confirmation file page (confirmation.php), when it is clicked, the user is registered.



// Passkey that got from link
$passkey=$_GET['passkey'];

$tbl_name1="temp_members_db";

// Retrieve data from table where row that match this passkey
$sql1="SELECT * FROM $tbl_name1 WHERE confirm_code ='$passkey'";
$result1=mysql_query($sql1);

// If successfully queried
if($result1){

// Count how many row has this passkey
$count=mysql_num_rows($result1);

// if found this passkey in our database, retrieve data from table "temp_members_db"
if($count==1){

$rows=mysql_fetch_array($result1);
$name=$rows['name'];
$email=$rows['email'];
$password=$rows['password'];
$country=$rows['country'];

$tbl_name2="registered_members";

// Insert data that retrieves from "temp_members_db" into table "registered_members"
$sql2="INSERT INTO $tbl_name2(name, email, password, country)VALUES('$name', '$email', '$password', '$country')";
$result2=mysql_query($sql2);
}

// if not found passkey, display message "Wrong Confirmation code"
else {
echo "Wrong Confirmation code";
}

// if successfully moved data from table"temp_members_db" to table "registered_members" displays message "Your account has been activated" and don't forget to delete confirmation code from table "temp_members_db"
if($result2){

echo "Your account has been activated";

// Delete information of this user from table "temp_members_db" that has this passkey
$sql3="DELETE FROM $tbl_name1 WHERE confirm_code = '$passkey'";
$result3=mysql_query($sql3);

}

}
?> linenums:0'><?include('config.php');// Passkey that got from link$passkey=$_GET['passkey'];$tbl_name1="temp_members_db";// Retrieve data from table where row that match this passkey$sql1="SELECT * FROM $tbl_name1 WHERE confirm_code ='$passkey'";$result1=mysql_query($sql1);// If successfully queriedif($result1){// Count how many row has this passkey$count=mysql_num_rows($result1);// if found this passkey in our database, retrieve data from table "temp_members_db"if($count==1){$rows=mysql_fetch_array($result1);$name=$rows['name'];$email=$rows['email'];$password=$rows['password'];$country=$rows['country'];$tbl_name2="registered_members";// Insert data that retrieves from "temp_members_db" into table "registered_members"$sql2="INSERT INTO $tbl_name2(name, email, password, country)VALUES('$name', '$email', '$password', '$country')";$result2=mysql_query($sql2);}// if not found passkey, display message "Wrong Confirmation code"else {echo "Wrong Confirmation code";}// if successfully moved data from table"temp_members_db" to table "registered_members" displays message "Your account has been activated" and don't forget to delete confirmation code from table "temp_members_db"if($result2){echo "Your account has been activated";// Delete information of this user from table "temp_members_db" that has this passkey$sql3="DELETE FROM $tbl_name1 WHERE confirm_code = '$passkey'";$result3=mysql_query($sql3);}}?>
Finish. That's the simple tutorial in PHP.

There are more explanation points inside the code.

If anyone, can improve please let me know.

Share this post


Link to post
Share on other sites
HELP OF CODEVerifying Your Email Address

I need to build system which can verify the email of the one who log on is true or not. Example:- Write a PHP program that tests whether an email address, user id, name, address and passwords (6 alphanumeric characters) has been entered correctly. Verify the input begins with series of characters, followed by the @ character, another series of character, a period * and a final series of characters. Test your program, using both valid and invalid e-mail addresses. Store those email addresses and related information into your MySQL database.

-reply by STEPHAN NGOBAI

Share this post


Link to post
Share on other sites

some corrections in the file signup.php

 

 

// if suceesfully inserted data into database, send confirmation link to email

if($result){[/sql]

 

 


please refer to file singup.php--around line 20 - as above

 

this code must me change to

 

if($result){($sql);

 

If you do not do this, it will not work properly

 

// jika anda tidak melakukan seperti ini , dia tidak akan berfungsi dengan baik

 

ok thanks

 

jutaones.com

Share this post


Link to post
Share on other sites

some corrections in the file signup.php

 

 

 

please refer to file singup.php--around line 20 - as above

 

this code must me change to

 

if($result){($sql);

 

If you do not do this, it will not work properly

 

// jika anda tidak melakukan seperti ini , dia tidak akan berfungsi dengan baik

 

ok thanks

 

jutaones.com

 

Here is my code for confirmation.php but it is not sending the email nor is it inserting to the tempUser table

 

session_start();include('../php-bin/dbConn.php');//include('authenticateEmail.php');// table name$tbl_name=tempUser;// Random confirmation code$confirm_code=md5(uniqid(rand()));//post variables//mysql_query("INSERT into `AL_userInfo` VALUES ('".$_POST['userId']."',$userId = $_POST['userId'];													   $access_level = $_POST['access_level'];$timestamp =    $_POST['timestamp'];$reg_date =     $_POST['reg_date'];$paymentType =  $_POST['paymentType'];$group =        $_POST['group'];$x_first_name = $_POST['x_first_name']; $x_last_name = $_POST['x_last_name'];$x_company = $_POST['x_company']; $x_address = $_POST['x_address']; $x_city = $_POST['x_city'];$x_state = $_POST['x_state']; $x_zip = $_POST['x_zip'];$x_country = $_POST['x_country']; $x_phone = $_POST['x_phone']; $x_email = $_POST['x_email']; $x_dl_num = $_POST['x_dl_num']; $x_resale_num = $_POST['x_resale_num']; $x_card_num = $_POST['x_card_num']; $x_card_code = $_POST['x_card_code']; $x_exp_date = $_POST['x_exp_date']; $x_description = $_POST['x_description']; $reg_username = $_POST['reg_username']; $reg_password = $_POST['reg_password'];$reg_first_name = $_POST['reg_first_name']; $reg_last_name = $_POST['reg_last_name'];$reg_company = $_POST['reg_company']; $reg_address = $_POST['reg_address']; $reg_city = $_POST['reg_city']; $reg_zip = $_POST['reg_zip']; $reg_state = $_POST['reg_state']; $reg_country = $_POST['reg_country']; $reg_phone = $_POST['reg_phone'];$reg_email = $_POST['reg_email'];$reg_resale_num = $_POST['reg_resale_num']; $reg_dl_num = $_POST['reg_dl_num']; $bioImageName = $_POST['bioImageName']; $bioText = $_POST['bioText']; $reg_fax = $_POST['reg_fax']; $reg_website = $_POST['reg_website'];//$confirm_code = $_POST['confirm_code'];$reg_alt_phone = $_POST['reg_alt_phone'];//SQL Insert to temp DB$sql="INSERT INTO $tbl_name (userId, access_level, timestamp, reg_date, paymentType, group, x_first_name, x_last_name, x_company, x_address, x_city, x_state, x_zip, x_country, x_phone, x_email, x_dl_num, x_resale_num, x_card_num, x_card_code, x_exp_date, x_description, reg_username, reg_password, reg_first_name, reg_last_name, reg_company, reg_address, reg_city, reg_zip, reg_state, reg_country,, reg_phone, reg_email, reg_resale_num, reg_dl_num, bioImageName, bioText, reg_fax, reg_website, confirm_code, reg_alt_phone) VALUES ('$userId', '$access_level', '$timestamp', '$reg_date', '$paymentType', '$group', '$x_first_name', '$x_last_name', '$x_company', '$x_address', '$x_city', '$x_state',  '$x_zip', '$x_country', '$x_phone', '$x_email', '$x_dl_num', '$x_resale_num', '$x_card_num','$x_card_code', '$x_exp_date', '$x_description', '$reg_username', '$reg_password', '$reg_first_name', '$reg_last_name', '$reg_company', '$reg_address', '$reg_city', '$reg_zip', '$reg_state', '$reg_country', '$reg_phone', '$reg_email', '$reg_resale_num', '$reg_dl_num', '$bioImageName', '$bioText', '$reg_fax', '$reg_website', $confirm_code', '$reg_alt_phone')";$result=mysql_query($sql);// if suceesfully inserted data into database, send confirmation link to emailif($result)  {($sql);// send e-mail to ...$to=$reg_email;// Your subject$subject="Your confirmation link here";// From$header="from: your name <your email>";// Your message$message="Your Comfirmation link \r\n";$message.="Click on this link to activate your account \r\n";$message.="alamedapointantiquesfaire.com/email_reg/confirmation.php?passkey=$confirm_code;;// send email$sentmail = mail($to,$subject,$message,$header);}// if not foundelse {echo "Not found your email in our database";}// if your email succesfully sentif($sentmail){echo "Your Confirmation link Has Been Sent To Your Email Address.";}else {echo "Cannot send Confirmation link to your e-mail address";}

Share this post


Link to post
Share on other sites

Hi, everyone. I'm offering the next PHP tutorial that verifies an email address of an user who wants to register on your site.This is how it works. When someone, went to registration page and filled out all of the details such as Name, Password, email and so on and submit those details to a server. The user is getting unique registration code to his or her email account, the one has to be clicked to activate the account.

1. Outline:

a) You need to create or build the following files:

-config.php (The configuration file)
-signup.php (Initial Registration)
-signup_ac.php (Post Registration)
-confirmation.php (The confirmation link)

^_^ You need to create 2 databases:

-temp_members (The temporary members stored in, the confirmation link is sent to them)
-registered_members (The registered members, who pressed the confirmation link, and became registered)

CREATE TABLE `temp_members_db` (
`confirm_code` varchar(65) NOT NULL default '',
`name` varchar(65) NOT NULL default '',
`email` varchar(65) NOT NULL default '',
`password` varchar(15) NOT NULL default '',
`country` varchar(65) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;



CREATE TABLE `registered_members` (
`id` int(4) NOT NULL auto_increment,
`name` varchar(65) NOT NULL default '',
`email` varchar(65) NOT NULL default '',
`password` varchar(65) NOT NULL default '',
`country` varchar(65) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;



2. Creating the configuration file (config.php):

<?$host="localhost"; // Host name$username="yourusername"; // Mysql username$password="yourpasword"; // Mysql password$db_name="yourdatabasename"; // Database name//Connect to server and select database.mysql_connect("$host", "$username", "$password")or die("cannot connect to server");mysql_select_db("$db_name")or die("cannot select DB");?>
3. Creating the initial registration file (signup.php)

<table width="350" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td><form name="form1" method="post" action="signup_ac.php">
<table width="100%" border="0" cellspacing="4" cellpadding="0">
<tr>
<td colspan="3"><strong>Sign up</strong></td>
</tr>
<tr>
<td width="76">Name</td>
<td width="3">:</td>
<td width="305"><input name="name" type="text" id="name" size="30"></td>
</tr>
<tr>
<td>E-mail</td>
<td>:</td>
<td><input name="email" type="text" id="email" size="30"></td>
</tr>
<tr>
<td>password</td>
<td>:</td>
<td><input name="password" type="password" id="password" size="30"></td>
</tr>
<tr>
<td>Country</td>
<td>:</td>
<td><input name="country" type="text" id="country" size="30"></td>
</tr>
<tr>
<td> </td>
<td> </td>
<td><input type="submit" name="Submit" value="Submit">  
<input type="reset" name="Reset" value="Reset"></td>
</tr>
</table>
</form></td>
</tr>
</table>



3. Creating the post registration file (signup_ac.php) where an user's information details as well as confirmation code are said to be stored in database.



// table name
$tbl_name=temp_members_db;

// Random confirmation code
$confirm_code=md5(uniqid(rand()));

// values sent from form
$name=$_POST['name'];
$email=$_POST['email'];
$country=$_POST['country'];

// Insert data into database
$sql="INSERT INTO $tbl_name(confirm_code, name, email, password, country)VALUES('$confirm_code', '$name', '$email', '$password', '$country')";
$result=mysql_query($sql);

// if suceesfully inserted data into database, send confirmation link to email
if($result){[/sql]

// send e-mail to ...
$to=$email;

// Your subject
$subject="Your confirmation link here";

// From
$header="from linenums:0'><?include('config.php');// table name$tbl_name=temp_members_db;// Random confirmation code$confirm_code=md5(uniqid(rand()));// values sent from form$name=$_POST['name'];$email=$_POST['email'];$country=$_POST['country'];// Insert data into database$sql="INSERT INTO $tbl_name(confirm_code, name, email, password, country)VALUES('$confirm_code', '$name', '$email', '$password', '$country')";$result=mysql_query($sql);// if suceesfully inserted data into database, send confirmation link to emailif($result){[/sql]// send e-mail to ...$to=$email;// Your subject$subject="Your confirmation link here";// From$header="from: your name <your email>";// Your message$message="Your Comfirmation link \r\n";$message.="Click on this link to activate your account \r\n";$message.="http://forums.xisto.com/no_longer_exists/ send email$sentmail = mail($to,$subject,$message,$header);}// if not foundelse {echo "Not found your email in our database";}// if your email succesfully sentif($sentmail){echo "Your Confirmation link Has Been Sent To Your Email Address.";}else {echo "Cannot send Confirmation link to your e-mail address";}?>
4. Creating the confirmation file page (confirmation.php), when it is clicked, the user is registered.



// Passkey that got from link
$passkey=$_GET['passkey'];

$tbl_name1="temp_members_db";

// Retrieve data from table where row that match this passkey
$sql1="SELECT * FROM $tbl_name1 WHERE confirm_code ='$passkey'";
$result1=mysql_query($sql1);

// If successfully queried
if($result1){

// Count how many row has this passkey
$count=mysql_num_rows($result1);

// if found this passkey in our database, retrieve data from table "temp_members_db"
if($count==1){

$rows=mysql_fetch_array($result1);
$name=$rows['name'];
$email=$rows['email'];
$password=$rows['password'];
$country=$rows['country'];

$tbl_name2="registered_members";

// Insert data that retrieves from "temp_members_db" into table "registered_members"
$sql2="INSERT INTO $tbl_name2(name, email, password, country)VALUES('$name', '$email', '$password', '$country')";
$result2=mysql_query($sql2);
}

// if not found passkey, display message "Wrong Confirmation code"
else {
echo "Wrong Confirmation code";
}

// if successfully moved data from table"temp_members_db" to table "registered_members" displays message "Your account has been activated" and don't forget to delete confirmation code from table "temp_members_db"
if($result2){

echo "Your account has been activated";

// Delete information of this user from table "temp_members_db" that has this passkey
$sql3="DELETE FROM $tbl_name1 WHERE confirm_code = '$passkey'";
$result3=mysql_query($sql3);

}

}
?> linenums:0'><?include('config.php');// Passkey that got from link$passkey=$_GET['passkey'];$tbl_name1="temp_members_db";// Retrieve data from table where row that match this passkey$sql1="SELECT * FROM $tbl_name1 WHERE confirm_code ='$passkey'";$result1=mysql_query($sql1);// If successfully queriedif($result1){// Count how many row has this passkey$count=mysql_num_rows($result1);// if found this passkey in our database, retrieve data from table "temp_members_db"if($count==1){$rows=mysql_fetch_array($result1);$name=$rows['name'];$email=$rows['email'];$password=$rows['password'];$country=$rows['country'];$tbl_name2="registered_members";// Insert data that retrieves from "temp_members_db" into table "registered_members"$sql2="INSERT INTO $tbl_name2(name, email, password, country)VALUES('$name', '$email', '$password', '$country')";$result2=mysql_query($sql2);}// if not found passkey, display message "Wrong Confirmation code"else {echo "Wrong Confirmation code";}// if successfully moved data from table"temp_members_db" to table "registered_members" displays message "Your account has been activated" and don't forget to delete confirmation code from table "temp_members_db"if($result2){echo "Your account has been activated";// Delete information of this user from table "temp_members_db" that has this passkey$sql3="DELETE FROM $tbl_name1 WHERE confirm_code = '$passkey'";$result3=mysql_query($sql3);}}?>
Finish. That's the simple tutorial in PHP.

There are more explanation points inside the code.

If anyone, can improve please let me know.
Hi all I have successfully implimented this code with my own as seen below.
<?PHPinclude('../php-bin/dbConn.php');//$tbl_name1="email_subscribe_temp";// Passkey that got from link$email=$_GET["reg_email"];// Retrieve data from table where row that match this passkey$sql="SELECT * FROM AL_email_subscribe WHERE reg_email ='$email'";$resultemail=mysql_query($sql);if($resultemail){// Count how many row has this passkey$count=mysql_num_rows($resultemail);// if found this passkey in our database, retrieve data from table "temp_members_db"if($count==1){$rows=mysql_fetch_array($resultemail);$email=$rows['reg_email'];echo "The email '$reg_email' is already established in our records";  }  else{	  echo "";  }}// Passkey that got from link$passkey=$_GET["passkey"];// Retrieve data from table where row that match this passkey$sql1="SELECT * FROM email_subscribe_temp WHERE confirm_code ='$passkey'";$result1=mysql_query($sql1);//If successfully queriedif($result1){// Count how many row has this passkey$count=mysql_num_rows($result1);// if found this passkey in our database, retrieve data from table "temp_members_db"if($count==1){$rows=mysql_fetch_array($result1);$id=$rows['id'];$reg_date=$rows['reg_date'];$reg_first_name=$rows['reg_first_name'];$reg_last_name=$rows['reg_last_name'];$reg_city=$rows['reg_city'];$reg_email=$rows['reg_email'];$group=$rows['group'];$confirm_code=$rows['confirm_code'];	//Insert data that retrieves from "AL_userInfo-2" into table "AL_userInfo"$sql2 = "INSERT INTO AL_email_subscribe VALUES ('$id', '$reg_date', '$reg_first_name', '$reg_last_name', '$reg_city', '$reg_email', '$group', '$confirm_code')";$result2=mysql_query($sql2);}// if not found passkey, display message "Wrong Confirmation code"else {echo "The Confirmation code was not a match.";}// if successfully moved data from table"temp_members_db" to table "registered_members" displays message "Your account has been activated" and don't forget to delete confirmation code from table "temp_members_db"if($result2){echo "Thank you for confirming your account. Keep an eye out for upcoming newsletters from Alameda Point Antiques Faire";// Delete information of this user from table "temp_members_db" that has this passkey$sql3="DELETE FROM email_subscribe_temp WHERE confirm_code = '$passkey'";$result3=mysql_query($sql3);}//If the email is already in the main table then delete anyway from temp tableelseif ($result4){$count2=mysql_num_rows($result4);if($count2==1){		$sql5="DELETE FROM email_subscribe_temp WHERE confirm_code = '$passkey'";	$result5=mysql_query($sql5);		echo "We see that your email is already registered, thank you";}	}  }?><!-- InstanceEndEditable --></div></div><div id="columns-bottom"> </div></div><br /><div class="auctions" id="bottomAuctions"><!-- InstanceBeginEditable name="bottomAuctions" --><!-- InstanceEndEditable --><br /></div><div class="auctions" id="bottommichaans">  <table width="100%" border="0" cellspacing="2" cellpadding="2">    <tr>      <td align="center"><img src="../images/footerNavBG.png" width="900" height="225" border="0" align="absmiddle" usemap="#Map" /></td>    </tr>    <tr>      <td align="center" style="font-size:12px; font-weight:200">© Copyright 2010-2011 Antiques By The Bay, Inc.. All Rights Reserved<a href="http://jsm-inc.com" title="JSM-inc" target="_blank">. Website Design by JSM-inc</a></td>    </tr>  </table></div><script type="text/javascript">if (!gaJsHost) {  var gaJsHost = (("https:" == document.location.protocol) ? "https://ssl." : "http:///cgi-sys/defaultwebpage.cgi;);  document.write(unescape("%3Cscript src='" + gaJsHost + "google-analytics.com/ga.js' type='text/javascript'%3E%3C/script%3E"));}</script><map name="Map" id="Map">  <area shape="rect" coords="285,34,415,164" href="http://http://www.michaans.com/events/2010/auct_12052010.php; target="_blank" alt="Estate Auction" />  <area shape="rect" coords="436,35,567,166" href="http://http://www.michaans.com/events/2010/auct_12072010.php; target="_blank" alt="Annex Auction" />  <area shape="rect" coords="584,35,715,166" href="http://http://www.michaans.com/events/2010/event_11242010.php; target="_blank" alt="Appraisal event" />  <area shape="rect" coords="734,35,864,165" href="http://71.6.53.130/FMPro?-db=ABTB_Inventory.fp5&-lay=www_current_catalog&-format=/abtb/inv_c_search.html&-view" target="_blank" alt="Michaan's Catalog" /></map><script type="text/javascript">var weeblyPageTracker = _gat._getTracker("UA-7870337-1");weeblyPageTracker._setDomainName("none");weeblyPageTracker._trackPageview();</script></body><!-- InstanceEnd --></html>

Where I run into some issues is that I would like to also validate up against the AL_email_subscribe as well as the confirm code. The confirm code is authenticating against the temp table which is fine, but I have some guests that are registering from past years that are not being deleted from the temp table when they re-register. I want the registration to validate to make sure they are not in the regular table as well and if they are then delete the temp and echo a statement that they are already registered.

I tried accomplishing that in the code above but I am unable to get it to work. The code echos the statement that they are already registered but it will not delete if the email has been found in the regular table.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.