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>
