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 34 35 36 37
| <?php
if(isset($_POST['nom']) AND isset($_POST['prenom']) AND isset($_POST['pseudo'])AND isset($_POST['Email']) AND isset($_POST['password1']) AND isset($_POST['password2']));
{
$_POST['Email'] = htmlspecialchars($_POST['Email']);
if ((preg_match("#^[a-z0-9._-]+@[a-z0-9._-]{2,}\.[a-z]{2,4}$#", $_POST['Email'])) AND ($_POST['password1']==$_POST['password2']))
{
try
{
$bdd = new PDO('mysql:host=localhost;dbmane=bts_projet','root','');
$bdd -> setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
}
catch(PDOException $e)
{
$msg = 'ERREUR PDO dans ' . $e->getFile() . ' L.' . $e->getLine() . ' : ' . $e->getMessage();
die($msg);
}
if($bdd)
{
$trouve = false;
$reponse = $bdd->query('SELECT Nom, Prenom, Email, Password, Pseudo FROM inscrit');
while($donnee = $reponse -> fetch() AND !$trouve)
{
if(($_POST['nom']=$donnee['Nom']) AND ($_post['prenom']=$donnee['Prenom']) AND ($_POST['Email']=$donnee['Email']))
{
$trouve=true;
}
}
$reponse -> closeCursor();
if(!$trouve)
{
$req = $bdd ->prepare('INSERT INTO inscrit (Nom, Prenom, Email, Password, Pseudo, Date_inscription) VALUES(?, ?, ?, ?, ?,NOW())');
$req -> execute(array($_POST['nom'],$_POST['prenom'],$_POST['Email'],$_POST['password1'],$_POST['pseudo']));
}
}
}
}
?> |
Partager