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 38 39 40 41 42 43 44 45 46 47 48 49
|
// [...]
require ("connexion.php");
// on recherche si ce login est déjà utilisé par un autre membre
$log_in = $_POST['login'];
$reqcount = "SELECT count(*) FROM users WHERE user_login=:log";
$sth = $bdd->prepare($reqcount);
$sth->bindParam(':log', $log_in);
$sth->execute();
$result = $sth->fetchColumn();
//echo $result;
//$sql = 'SELECT count(*) FROM membre WHERE login="'.mysql_escape_string($_POST['login']).'"';
if ($result>0)
{
$nom = $_POST['name'];
$pseudo = $_POST['login'];
$motdepasse = $_POST['pass'];
$email = $_POST['email'];
$localisation = $_POST['location'];
$site = $_POST['website'];
$pass = hash("sha256",$motdepasse);
$query = 'INSERT INTO users (user_login, user_password, user_email, user_name, user_foundation, user_location, user_website) VALUES (:pseudo, :pass, :email, :nom, now(), :localisation, :site)';
$stmt = $bdd->prepare($query);
$stmt->bindParam(':pseudo', $pseudo);
$stmt->bindParam(':pass', $pass);
$stmt->bindParam(':email', $email);
$stmt->bindParam(':nom', $nom);
$stmt->bindParam(':localisation', $localisation);
$stmt->bindParam(':site', $site);
$passed = $stmt->execute();
if($passed){
echo "passed";
}
else {
echo "failed";
}
exit();
}
else
{
$erreur = 'Un membre possède déjà ce login.';
}
// [...] |
Partager