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
|
$billet = "son_mail";
try
{
$bdd = new PDO('mysql:host=localhost;dbname=tabase', 'root', '');
$bdd->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch(Exception $e)
{
die('Erreur : '.$e->getMessage());
}
$req = $bdd->prepare('SELECT * FROM user WHERE UserMail = ?');
$req->execute(array($billet));
if(!$donnees = $req->fetch())
{
//============c' est OK existe pas donc on crée================
$result = $bdd->prepare("INSERT INTO `user`
( `UserNom`,`UserMail`, `UserPas`)
VALUES (:UserN, :UserM, :UserP)");
$result->execute(array(':UserN' => $UserNom, ':UserM' => $billet,':UserP' => $UserPas));
}
else
{
echo "Désolé ".$billet." existe déjas";
} |
Partager