mysql 检验email @,检查电子邮件是否存在于MySQL数据库中

I am using the following PHP code to store data in my MySQL database, everything works perfect but I would like to build in a check; if the email already exists in the database then redirect to another page. (I'm a rookie when it comes to PHP)

if(empty($_POST['name']))

{} else {

define('DB_NAME', 'dbname');

define('DB_USER', 'dbuser');

define('DB_PASSWORD', 'dbpass');

define('DB_HOST', 'host');

$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);

if (!$link) { die('could not connect: ' . mysql_error()); }

$db_selected = mysql_select_db(DB_NAME, $link);

if (!$db_selected) { die('can not use ' . DB_NAME . ': ' . mysql_error()); }

$sql="INSERT INTO game (name, lastname, company, email, time) VALUES

('".$_POST['name']."','".$_POST['lastname']."','".$_POST['company']."','".$_POST['email']."','".$_POST['time']."')";

if (!mysql_query($sql)) { die('Error: ' . mysql_error()); }

mysql_close();

}

?>

解决方案

if(!filter_var($_POST['email'], FILTER_VALIDATE_EMAIL)) {

exit('Invalid email address'); // Use your own error handling ;)

}

$select = mysqli_query($connectionID, "SELECT `email` FROM `game` WHERE `email` = '".$_POST['email']."'") or exit(mysqli_error($connectionID));

if(mysqli_num_rows($select)) {

exit('This email is already being used');

}

Stick that in above the insert query