passer une variable dans une requete
Posté : 24 avr. 2014, 08:46
<?php
try{
$db = new PDO('mysql:host=localhost;dbname=gite', 'root', '');
$db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_WARNING);
}catch(Exception $e){
echo 'Impossible de se connecter à la base de donnée';
echo $e->getMessages();
die();
}
$sejour = $_POST['sejour'];
$sql = 'SELECT id FROM sejour WHERE type= '.$sejour.'';
$req = $db->query($sql);
while($d = $req->fetch(PDO::FETCH_ASSOC)){
echo '<pre>';
print_r($d);
echo '<pre>';
}
?>
<html>
<head>
<title></title>
</head>
<body>
<!--Ma selection-->
<form action="index.php" method="post">
<h4>Votre sejour</h4>
<input type="radio" name="sejour" value="chambre" checked>chambre
<input type="radio" name="sejour" value="bungalo">bungalo
<P>
<input type="submit" value="Valider">
</form>
<!--Fin de selection-->
</body>
</html>