Validate email field against database records

I have a standard registration form with an email field that is validated to be a correct email entry. Now I'd like to add an additional validation to the email field. The email address that the user enters show be validated against a list of allowed email endings like:

@ibm.com
@apple.com
@webassist.com

I've tried to use the server validation at insert, with like entry as validation type and the recordset field as server variable. But the validation does not seem to work...

Thx for any help.

you will need to use the regular expression validation type for this and use the following regular expression:

/^[A-Z0-9._%-]+@(apple.com|ibm.com|webassist.com)$/i

Thx Jason. How do I connect this expression with my database table where all the mail endings are saved?

(apple.com|ibm.com|webassist.com ... are all located in a mysql table)

the validation toolkit wizard does not support using dynamic data in regular expression validation. It will require some hand coding to accomplish, and depends on how the database is set up.


Is the database set up so that one record contains a pipe separated listing of the domains:

+----------|----------------------------------+
| domainID | domainNames                      |
+----------|----------------------------------+
| 1        | apple.com|ibm.com|webassist.com  |
+----------|----------------------------------+

or is there a separate record for each allowed domain?

+----------|---------------+
| domainID | domainNames   |
+----------|---------------+
| 1        | apple.com     |
+----------|---------------+
| 2        | ibm.com       |
+----------|---------------+
| 3        | webassist.com |
+----------|---------------+

Once i know the answer to that question, i can give you instructions for modifying the validation code.

Thx Jason.

There is a separate record for each allowed domain.

But if it's easier to do it the other way, I can also just use one record that contains a pipe separated listing of the domains.

ok, you will need to create a recordset to return the allowed domains. After the recordset code, add the following code to loop through it and create a new variable that contains a pipe separated list of domains:

<?php 

$okDomains = "";

do {

    $okDomains .= $row_recordsetName['domainName']."|";

} while ($row_recordsetName = mysql_fetch_assoc($recordsetName)); 

$okDomains = substr_replace($okDomains,"",-1);

?>

when you add the regular expression validation it will create a line similar to this:

$WAFV_Errors .= WAValidateRX(((isset($_POST["emailField"]))?$_POST["emailField"]:"") . "","/^[A-Z0-9._%-]+@(apple.com|ibm.com|webassist.com)$/i",true,1);

edit that to use the $okDomains variable instead of the static listing of domains:

$WAFV_Errors .= WAValidateRX(((isset($_POST["emailField"]))?$_POST["emailField"]:"") . "","/^[A-Z0-9._%-]+@(".$okDomains.")$/i",true,1);

make sure that the code order is correct, the validation may be placed before the recordset. The order needs to be:
-recordset
-do to create the $okDomains variable
-Validation

Works perfect! Thanks a lot Jason.