1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
| $mailclient = htmlentities($_POST['mailclient']);
//$mailclient = mysqli_escape_string($mailclient);
function verifmail ($mail){
return ereg("^[a-zA-Z0-9._-]+@[a-zA-Z0-9.-]{2,}[.][a-zA-Z]{2,4}$", $mail);
}
if (verifmail($mailclient)){
// on regarde si l'url existe déjà
$sql = "SELECT id FROM ge_mail_infos WHERE email='$mailclient'";
//$req = mysql_query($sql) or die('Erreur SQL !'.$sql.'<br>'.mysql_error());
$req = mysqli_query($c, $sql) or die('Erreur SQL !'.$sql.'<br>'.mysqli_error());
// recherche //
$res = mysqli_num_rows($req);
//$res = mysql_num_rows($req);
//
if($res!=0){
echo "validation=".utf8_encode("Ce mail existe déjà dans notre base.");
}else {
$sql = "INSERT INTO ge_mail_infos (id,email) VALUES('','$mailclient')";
/// mysql_query($sql) or die('Erreur SQL !'.$sql.'<br>'.mysql_error());
mysqli_query($c, $sql) or die('Erreur SQL !'.$sql.'<br>'.mysqli_error());
echo "validation=".utf8_encode("Votre adresse mail a bien été enregistrée");
/* echo "<script language='javascript'>
alert('Votre adresse mail a bien été enregistrée');
</script>";*/
}
// mysql_close();
mysqli_close();
}else {
echo "validation=".utf8_encode("Adresse mail incorrecte"); |
Partager