php mysql 重复提交数据_php – 防止将重复数据输入mysql数据库

我正在尝试使我的电子邮件订阅服务拒绝我的数据库中已存在的电子邮件,因此用户不会订阅相同的电子邮件两次.这是我的,但它不起作用,任何想法？

if(!isset($_POST['submit']))

exit();

$vars = array('email');

$verified = TRUE;

foreach($vars as $v) {

if(!isset($_POST[$v]) || empty($_POST[$v])) {

$verified = FALSE;

}

}

if(!$verified) {

echo "

*Email required*

";

exit();

}

$email = $_POST['email'];

if($_POST['submit']) echo "

*Check your inbox*

";

// Create connection

$con=mysqli_connect("mysql.host","user","password","dbname");

// Check connection

if (mysqli_connect_errno($con))

{

echo "Failed to connect to MySQL: " . mysqli_connect_error();

}

$sql="INSERT INTO emails (email) VALUES ('$_POST[email]')";

if (!mysqli_query($con,$sql))

{

die('Error: ' . mysqli_error($con));

}

$query = mysql_query("SELECT * FROM emails WHERE email='$email'",($con));

if(mysql_num_rows($query) != 1)

{

echo "email already exists";

// redirect back to form and populate with

// data that has already been entered by the user

}

mysqli_close($con);

?>