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 32 33
| //Vérification email
$internaute = $bdd->prepare('SELECT email FROM profil WHERE email = ? ');
$internaute->execute(array($_GET['email']));
if (empty($internaute->fetch()) {
//Insertion profil
$req = $bdd->prepare('INSERT INTO profil(prenom, nom, email, tel, adresse, code_postal, ville, password, ip) VALUES(:prenom, :nom, :email, :tel, :adresse, :code_postal, :ville, :password, :ip)');
$req->execute(array(
'prenom' => $prenom,
'nom' => $nom,
'email' => $email,
'tel' => $tel,
'adresse' => $adresse,
'code_postal' => $code_postal,
'ville' => $ville,
'password' => $password,
'ip' => $ip
));
}
else {
//Update profil
$req = $bdd->prepare('UPDATE profil SET prenom = :prenom, nom = :nom, email = :email, tel = :tel, adresse = :adresse, code_postal = :code_postal, ville = :ville, password = :password, ip = :ip');
$req->execute(array(
'prenom' => $prenom,
'nom' => $nom,
'email' => $email,
'tel' => $tel,
'adresse' => $adresse,
'code_postal' => $code_postal,
'ville' => $ville,
'password' => $password,
'ip' => $ip
));
} |
Partager