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.';
}
// [...] |
migration de mysql vers pdo
R�pondre avec citation
Envoy� par Black_Layer
Partager