-
Notifications
You must be signed in to change notification settings - Fork 4
/
Copy pathInsc.php
67 lines (63 loc) · 2.21 KB
/
Insc.php
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
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
<?php session_start(); ?>
<?php
if ((isset($_POST['Pseudo'])) AND(isset($_POST['Pass']))AND (isset($_POST['Ville']))AND(isset($_POST['Confi']))AND(isset($_POST['Mail']))) {
}
else{header('Location: Inscription4.php');}
if (($_POST['Pseudo']=="") OR ($_POST['Pass']=="") OR ($_POST['Ville']=="") OR ($_POST['Confi']=="") OR ($_POST['Mail']=="")){
include("Inscription4.php");
}
else{
if ((isset($_POST['Pseudo'])) AND(isset($_POST['Pass']))AND (isset($_POST['Ville']))AND(isset($_POST['Confi']))AND(isset($_POST['Mail']))) {
include('TTT_BDD.php');
$reqo = $bdd->prepare('SELECT NomUtilisateur FROM utilisateurs WHERE NomUtilisateur = ?');
$reqo->execute(array($_POST['Pseudo']));
if($donnees = $reqo->fetch()){
include("Inscription2.php");
$reqo->closeCursor();
}
else{
$reqb = $bdd->prepare('SELECT Mail FROM utilisateurs WHERE Mail = ?');
$reqb->execute(array($_POST['Mail']));
if ($don = $reqb->fetch()) {
include("Inscription6.php");
$reqb->closeCursor();
}
else{
if ($_POST['Pass']==$_POST['Confi']) {
$reqo->closeCursor();
$reqa = $bdd->prepare('SELECT ville_id FROM villes_france_free WHERE ville_nom_reel = ?');
$reqa->execute(array($_POST['Ville']));
if($donne = $reqa->fetch()){
$time=date('Y-m-d', time());
$Ville=$donne['ville_id'];
$reqa->closeCursor();
$req = $bdd->prepare('INSERT INTO utilisateurs(NomUtilisateur, DroitAdmin, ville_id, Mail, MotDePass, Nom, Prenom, Telephone, derniere_connexion) VALUES(:NomUtilisateur, 0, :ville_id, :Mail, :MotDePass, :Nom, :Prenom, :Telephone, :derniere_connexion)');
$req->execute(array(
'NomUtilisateur' => $_POST['Pseudo'],
'ville_id' => $Ville,
'Mail' => $_POST['Mail'],
'MotDePass' => MD5($_POST['Pass']),
'Nom' => $_POST['Nom'],
'Prenom' => $_POST['Prenom'],
'Telephone' => $_POST['Telephone'],
'derniere_connexion' => $time
));
$req->closeCursor();
}
else{
$reqa->closeCursor();
include("Inscription5.php");
}
}
else{
include("Inscription3.php");
}
}
}
}
else{
include("Inscription4.php");
}
include("Bienvenue.php");
}
?>