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
| link rel="stylesheet" type="text/css" href=".../style/style.css" />
<meta charset="utf-8" />
<?php
include "BDD/identifiant.php";
if(isset($_POST['submit']))
{
//Connexion au serveur
$connexion=mysqli_connect($SERVER,$USER,$PASSWORD);
/*Vérification de la connexion
if(mysqli_connect_errno())
{
printf("Echec de la connexion", mysqli_connect_error());
exit();
}else echo '<center><p>Inscription réussi.</center></p>';*/
//Les différents input.
$pseudo = utf8_decode($_POST['pseudo']);
$mdp = utf8_decode($_POST['mdp']);
$rmdp = utf8_decode($_POST['rmdp']);
$email = utf8_decode($_POST['email']);
$nom = utf8_decode($_POST['nom']);
$prenom = utf8_decode($_POST['prenom']);
$annee = ($_POST['annee']);
$sexe = utf8_decode($_POST['sexe']);
$adresse = utf8_decode($_POST['adresse']);
$cp = utf8_decode($_POST['cp']);
$ville = utf8_decode($_POST['ville']);
$telephone = utf8_decode($_POST['telephone']);
$categorie = utf8_decode($_POST['categorie']);
$club = utf8_decode($_POST['club']);
$licence = utf8_decode($_POST['licence']);
$compte = utf8_decode($_POST['compte']);
if ($mdp == $rmdp)
{
//Rentrer les valeurs dans la base.
$sql = "INSERT INTO `bdd`.`inscription` (`id`, `pseudo`, `mdp`, `email`, `nom`, `prenom`, `annee`, `sexe`, `adresse`, `cp`, `ville`, `telephone`, `categorie`, `club`, `licence`, `compte`) VALUES ('', ?, PASSWORD(?) ,?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
$stmt = mysqli_prepare($connexion, $sql);
//Paramètres : chaines de caractères dans l'ordre
mysqli_stmt_bind_param($stmt, 'sssssssssssssss', $pseudo , $mdp, $email, $nom, $prenom, $annee, $sexe, $adresse, $cp, $ville, $telephone, $categorie, $club, $licence, $compte); //Permet de renseigner les paramètres repéré par les "?" dans l'ordre.
//Exécution
mysqli_stmt_execute($stmt); //Execute la requête.
echo "<center><p>Inscription réussi.</center></p>";
}else echo '<center><a class="a">Les mots de passes ne sont pas identiques.</center></a>';
}
?> |
Partager