Petit soucis, je n'ai aucune insertion en bdd comment ça se fait svp, merci pour votre aide
<?php
session_start();
if(!empty($_SESSION['membre']))
{
header('Location: index.php');
}
if(!empty($_POST))
{
extract($_POST);
$valid = true;
if(empty($city))
{
$valid = false;
$erreurcity = 'Indiquez une ville';
}
if(empty($street))
{
$valid = false;
$erreurstreet = 'Indiquez un nom de rue';
}
if(empty($postcode))
{
$valid = false;
$erreurpostcode = 'Indiquez un code postal';
}
if(empty($phone))
{
$valid = false;
$erreurphone = 'Indiquez un téléphone';
}
try{
$bdd = new PDO('mysql:host=***********;dbname=***********','********','*****') or die(print_r($bdd->errorInfo()));
$bdd->exec('SET NAMES utf8');
}
catch(Exeption $e){
die('Erreur:'.$e->getMessage());
}
$req = $bdd->prepare('INSERT INTO `orders` (`user_id`,`created`, `titre`, `phone`, `street`, `postcode`, `city`)
VALUES ( :user_id, NOW(), :titre, :phone, :street, :postcode, :city)');
$req->execute(array(
'user_id' => $_POST['membre'],
'titre'=>$_POST['titre'],
'phone'=>$_POST['phone'],
'street'=>$_POST['street'],
'postcode'=>$_POST['postcode'],
'city'=>$_POST['city']
));
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta http-equiv="Content-type" content="text/html; charset=utf-8" />
<title>Stripe Getting Started Form</title>
</head>
<body>
<form action="buy.php" method="POST" id="payment-form">
<!-- Ville de la sortie -->
<label>Ville *</label>
<input class="form-control" type="text" name="city" value="<?php if(isset($_POST['city'])) echo $_POST['city'];?>" />
<div class="error"><?php if(isset($erreurscity['city'])) echo $erreurscity['city'];?></div>
<!-- Ville de la sortie -->
<label>Rue</label>
<input class="form-control" type="text" name="street" value="<?php if(isset($_POST['street'])) echo $_POST['street'];?>" />
<div class="error"><?php if(isset($erreursstreet['street'])) echo $erreursstreet['street'];?></div>
<!-- Code postal de la sortie -->
<label>Code postal *</label>
<input class="form-control" type="text" name="postcode" value="<?php if(isset($_POST['postcode'])) echo $_POST['postcode'];?>" />
<div class="error"><?php if(isset($erreurspostcode['postcode'])) echo $erreurspostcode['postcode'];?></div>
<label>Télephone</label>
<input class="form-control" type="text" name="phone" value="<?php if(isset($_POST['phone'])) echo $_POST['phone'];?>" />
<div class="error"><?php if(isset($erreursphone['phone'])) echo $erreursphone['phone'];?></div>
<input name="membre" type="text" value="<?php echo $_SESSION['user']['id'] ?>" />
<button type="submit" class="submit-button">Submit Payment</button>
</form>J'ai essayé ça mais le résultat est le même rien en bdd:
?php
$req = $bdd->prepare('INSERT INTO orders (user_id,titre,phone,street,postcode,city) VALUES ( :user_id, :titre, :phone, :street, :postcode, :city)');
$req->execute(array(
'user_id'=>$user_id,
'titre'=>$titre,
'phone'=>$phone,
'street'=>$street,
'postcode'=>$postcode,
'city'=>$city
));
}
?>
.