Validation?

[wut]

im looking to validate an email address before it gets sent to mysql database

currently my code checks if an email address is present and if an email address already exists

how do you check to see if an address contains a . and a @ symbol?

if($email == '') {
	$errmsg_arr[] = 'Email is missing';
	$errflag = true;
}

if($email != '') {
	$qry = "SELECT * FROM users WHERE email='$email'";
	$result = mysql_query($qry);
	if($result) {
		if(mysql_num_rows($result) > 0) {
			$errmsg_arr[] = 'Email address already in use';
			$errflag = true;
		}
		@mysql_free_result($result);
	}
	else {
		die("Query failed");
	}
}

 

Thanks in advance

[plznty]

strpos - http://php.net/manual/en/function.strpos.php

[batwimp]

You may also want to check into this:

http://us3.php.net/manual/en/filter.filters.validate.php

Though some say it has some problems. Read the comments.

[wut]

if(!filter_var($email, FILTER_VALIDATE_EMAIL)){
$errmsg_arr[] = 'Email is not valid';
$errflag = true;
}

This seems to have done the trick nicely!

Thanks!