检查数据库中是否已存在值[重复]

Question

This question already has an answer here:

• Can I mix MySQL APIs in PHP? 4 answers

I need to make an error, if an email already exists in my database.

I have made this code, but it doesn't work

`<?php`

// CONNECT TO DATABASE

$mysqli = new mysqli("database", "username", "password","database_name"); // creates 

$mail = $_POST['mail']; //from input
$result = mysql_query("SELECT * FROM Newsmail WHERE mail='" . $mail . "'");
if (mysql_num_rows($result) == 1)
{
echo "Error";
}


else {
//sql
$sql = "INSERT INTO `database_name`.`Newsmail` (`newsmail_id`, `mail`) VALUES (NULL, \'" . $_GET['mail'] . "\');";

//INSERT TO DATABASE
$insert =  $mysqli->query($sql);

}

?>

</div>

Answer 1

If email is an unique key, Try INSERT IGNORE

$mail = mysql_real_escape_string($mail);
$sql="INSERT IGNORE INTO Newsmail (email) VALUES ('$email')";
mysql_query($sql) or trigger_error(mysql_error()." ".$sql);

if (mysql_affected_rows()) {
echo 'registration successfully';
} else {
echo 'already exists';
}