[noobCoder]

i am creating a register page for my website and i wish to create some kind of validation upon the email box so that only people with a valid domain can become a member and then use my website.

So only people with domains such as @bathspa.ac.uk etc... can join the site.

So i have created my database table to contain the domain names of all the universities within the UK and the table is called 'domain' and the feilds are called 'domain_id' to uniqely identify each domain with the table and 'domain_name' which contains the domain extension such as @bathspa.co.uk.

now i have looked at scripts on the internet and i dont want to use javascript due to personal development reasons, so i am looking to use a PHP script.

I was unsure how to start but i have found some code below which i understands checks if a email is correct but i wish to check the second part of the string after the '@' against the list in my database table.

PHP Code:

<?php
if (eregi("^[a-zA-Z0-9_]+@[a-zA-Z0-9\-]+\.[a-zA-Z0-9\-\.]+$]", $email)) 
{
   return FALSE;
}
?>

if anyone could help ASAP i would be most grateful

Kind Regards

noobCoder

[wirehopper]

You might want to check out some of the existing scripts.

Search Listings | Hot Scripts

You may choose to use them or just learn from some of them.

[vitro012]

[QUOTE=noobCoder;187923]i am creating a register page for my website and i wish to create some kind of validation upon the email box so that only people with a valid domain can become a member and then use my website.

So only people with domains such as @bathspa.ac.uk etc... can join the site.

So i have created my database table to contain the domain names of all the universities within the UK and the table is called 'domain' and the feilds are called 'domain_id' to uniqely identify each domain with the table and 'domain_name' which contains the domain extension such as @bathspa.co.uk.

now i have looked at scripts on the internet and i dont want to use javascript due to personal development reasons, so i am looking to use a PHP script.

I was unsure how to start but i have found some code below which i understands checks if a email is correct but i wish to check the second part of the string after the '@' against the list in my database table.


<?php
if (eregi("^[a-zA-Z0-9_]+@[a-zA-Z0-9\-]+\.[a-zA-Z0-9\-\.]+$]", $email))

************************************************** **************************************************

eregi is precated

you can use:

if (!preg_match('/^[^0-9][a-zA-Z0-9_]+[@][a-zA-Z0-9_]+([.][a-zA-Z0-9_]+)*[.][a-zA-Z]{2,4}$/',$correo))
{
return $msj="incorrect mail ";
}else
{
return $msj= "well done";
}




Saludos

[Jcbones]

PHP Code:

<?php
 ////////////////////////////
 /////DB connection///
 // ******** EDIT CONNECTION INFORMATION BELOW  ************

$hostname = "localhost";
$database = "ptalk";
$username = "root";
$password = "";


// *********** END EDIT CONNECTION INFORMATION ************
$con = mysql_connect($hostname, $username, $password);
mysql_select_db($database, $con);

$sql = "SELECT `domain_name` FROM `domain`";
$result = mysql_query($sql);
if(mysql_num_rows($result) > 0) {
    while($r = mysql_fetch_row($result)) {
        $domains[] = str_replace('@','',$r[0]);
    }
}
else {
    $domains = array();
}
/////////End DB interaction//////////////////

/////////Start form interaction//////////////

//Get form variables
$email = (isset($_POST['email'])) ? $_POST['email'] : 1.1;

//Split out the domain.
$email_domain = ($email != 1.1) ? explode('@',$email) : '@nowhere.com';

//email matching pattern.
$pattern = '/^([\w\-\.]+)@((\[([0-9]{1,3}\.){3}[0-9]{1,3}\])|(([\w\-]+\.)+)([a-zA-Z]{2,4}))$/';

if(!preg_match($pattern,$email)) { //If email doesn't match the pattern.
    echo 'You have entered an incorrectly formatted email address.';
}
elseif(!in_array($email_domain[0],$domains)) { //If the domain doesn't exist in the database array.
    echo 'You\'re email isn\'t registered with our site!';
}
else {
    //Do all the registration stuff.
}

?>

[noobCoder]

Hi people thank you for the feedback, i manged to get the solution from Jcbones help and my friends help