fiche inscription n'envois rien a la bd ???
Posté : 17 mars 2016, 15:18
bonjours a vous, donc voila mon probleme je fait une page d'inscription pour enregistrer des clients sur un site pour un projet de cours, et le truc c'est que quand je clic su rle bouton , mon message de confirmation de fonctionne pas et rien n'es envoyer la BD.
voici le code
voici le code
<?php
$pdo = new PDO('mysql:dbname=b_carchan;host=localhost', 'root', '');
?>
<?php
if(!empty($_POST)){
$errors = array();
//VERIFICATION nom
if(empty($_POST['nom']) || !preg_match('/^[a-zA-Z0-9_]+$/', $_POST['nom'])){
$errors['nom'] = "Votre nom n'est pas valide (alphanumérique)";
}
else{
$req = $pdo->prepare('SELECT * FROM t_client WHERE nom = ?');
$req->execute([$_POST['nom']]);
$user = $req->fetch();
if($user){
$errors['nom'] = 'Ce nom est déjà pris';
}
}
//VERIFICATION email
if(empty($_POST['email']) || !filter_var($_POST['email'], FILTER_VALIDATE_EMAIL)){
$errors['email'] = "Votre email n'est psa valide";
}
else{
$req = $pdo->prepare('SELECT * FROM t_client WHERE email = ?');
$req->execute([$_POST['email']]);
$user = $req->fetch();
if($user){
$errors['email'] = 'Cet email est déjà utilisé pour un autre compte';
}
}
//VERIFIACTION MOT DE PASSE
if(empty($_POST['mdp']) || $_POST['mdp'] != $_POST['password_confirm']){
$errors['mdp'] = "Vous devez rentrer un mot de passe valide";
}
// VERIFICATION TEL
if(empty($_POST['tel']) || !preg_match('/^[0-9]+$/', $_POST['tel'])){
$errors['tel'] = "Votre tel n'est pas valide (alphanumérique)";
}
else{
$req = $pdo->prepare('SELECT * FROM t_client WHERE tel = ?');
$req->execute([$_POST['tel']]);
$user = $req->fetch();
if($user){
$errors['tel'] = 'Ce tel est déjà pris';
}
}
if(empty($errors)){
$req = $pdo->prepare("INSERT INTO t_client SET civilite = ?, nom_cli = ?, prenom_cli = ?, telephone = ?, email = ?, mdp = ?, type_cb = ?, num_cb = ?, date_expire = ?, crypto = ?");
$password = password_hash($_POST['mdp'], PASSWORD_BCRYPT);
$req->execute([$_POST['civilite'], $_POST['nom_cli'], $_POST['prenom_cli'], $_POST['telephone'],$_POST['email'],$password,$_POST['type_cb'],$_POST['num_cb'],$_POST['date_expire'],$_POST['crypto'] ]);
die ("Le compte a bien été crée");
}
}
?>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<script type="text/javascript" src="http://cdnjs.cloudflare.com/ajax/libs/jquery/2.0.3/jquery.min.js"></script>
<script type="text/javascript" src="http://netdna.bootstrapcdn.com/bootstrap/3.3.4/js/bootstrap.min.js"></script>
<link href="http://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.3.0/css/font-awesome.min.css"
rel="stylesheet" type="text/css">
<link href="http://pingendo.github.io/pingendo-bootstrap/themes/default/bootstrap.css"
rel="stylesheet" type="text/css">
<link href="https://bootswatch.com/yeti/bootstrap.min.css" rel="stylesheet"
type="text/css">
</head>
<body>
<div class="section">
<div class="container">
<div class="row">
<div class="col-md-12">
<form class="form-horizontal" role="form">
<div >
<div class="col-sm-2">
<label for="inputEmail3" class="control-label">Civilité</label>
</div>
<div class="col-sm-10">
<input type="text" class="form-control" id="inputEmail3" placeholder="Civilité" name="civilite">
</div>
</div>
<div >
<div class="col-sm-2">
<label for="inputPassword3" class="control-label">Nom</label>
</div>
<div class="col-sm-10">
<input type="text" class="form-control" id="inputPassword3" placeholder="Nom" name="nom_cli">
</div>
</div>
<div >
<div class="col-sm-2">
<label class="control-label">Prénom</label>
</div>
<div class="col-sm-10">
<input type="text" class="form-control" placeholder="Prénom" name="prenom_cli">
</div>
</div>
<div >
<div class="col-sm-2">
<label class="control-label">Tél</label>
</div>
<div class="col-sm-10">
<input type="text" class="form-control" placeholder="Tél" name="telephone">
</div>
</div>
<div >
<div class="col-sm-2">
<label class="control-label">Email</label>
</div>
<div class="col-sm-10">
<input type="email" class="form-control" placeholder="[email protected]" name="email">
</div>
</div>
<div >
<div class="col-sm-2">
<label class="control-label">Mot de passe</label>
</div>
<div class="col-sm-10">
<input type="password" class="form-control" placeholder="Mot de passe" name="mdp">
</div>
</div>
<div >
<div class="col-sm-2">
<label class="control-label">Confirmation</label>
</div>
<div class="col-sm-10">
<input type="password" class="form-control" placeholder="Confirmation mot de passe" name="password_confirm">
</div>
</div>
<div >
<div class="col-sm-2">
<label class="control-label">Identification bancaire</label>
</div>
<div class="col-sm-10">
<input type="text" class="form-control" placeholder="Visa / Master / American Express" name="type_cb">
</div>
</div>
<div >
<div class="col-sm-2">
<label class="control-label">Numéros de carte</label>
</div>
<div class="col-sm-10">
<input type="text" class="form-control" placeholder="1234567891234567" name="num_cb">
</div>
</div>
<div >
<div class="col-sm-2">
<label class="control-label">Date d'expiraion</label>
</div>
<div class="col-sm-10">
<input type="text" class="form-control" placeholder="05-1996" name="date_expire">
</div>
</div>
<div >
<div class="col-sm-2">
<label class="control-label">Cryptograme</label>
</div>
<div class="col-sm-10">
<input type="text" class="form-control" placeholder="012345" name="crypto">
</div>
</div>
<button type="submit" class="btn btn-primary">Valdier</button>
</form>
</div>
</div>
</div>
</div>
</body>
</html>