Bonjour,
je ne comprend pas pourquoi je n'ai aucun affichage de resultat sur une requete mysql, j'utilise un même code pour deux formulaire en recherche multicritères , cela marche sur l'un et pas sur l'autre, je ne comprend pas pourquoi, je n'obtient aucun message d'erreur, juste aucun resultat.
voici ma requete en php:
<?php
if(isset($_POST['comida']) && $_POST['comida'] !="todos" && isset($_POST['bairro']) && $_POST['bairro'] !="todos" && isset($_POST['preco']) && $_POST['preco'] !="todos" && isset($_POST['tipo']) && $_POST['tipo'] !="todos")
{
try
{
$preco = ($_POST['preco']);
$bairro = ($_POST['bairro']);
$comida = ($_POST['comida']);
$tipo = ($_POST['tipo']);
$pdo_options[PDO::ATTR_ERRMODE] = PDO::ERRMODE_EXCEPTION;
$bdd = new PDO('mysql:host=localhost;dbname=o_jeitinho', 'root', '', $pdo_options);
$req = $bdd->prepare('SELECT * FROM restaurantes WHERE bairro = %?% AND comida = %?% AND preco = ? AND tipo = %?% ');
$req->execute(array($_POST['bairro'], $_POST['comida'], $_POST['preco'], $_POST['tipo']));
while ($donnees = $req->fetch())
{
?>
<strong>Nome :</strong> <?php echo $donnees['nome_rest']; ?><br />
<strong>Bairro :</strong> <?php echo $donnees['bairro']; ?> <br/>
<strong>Comida : </strong><?php echo $donnees['comida']; ?><br/>
<strong>Tipo : </strong><?php echo $donnees['tipo']; ?><br/>
<strong>Valor : </strong><?php echo $donnees['preco']; ?><br/>
<strong>Endereço :</strong><?php echo $donnees['endereco']; ?><br/>
<strong>Telefone :</strong><?php echo $donnees['telefone']; ?><br/>
<strong>Comentario :</strong><?php echo $donnees['comentario']; ?><br/>;
<?php
}
$req->closeCursor();
}
catch(Exception $e)
{
die('Erreur : '.$e->getMessage());
}
}
?>
et mon formulaire:
<form method="post" action="traitement_restaurant2.php" name="formulaire">
<p><h3>Bairro:<select name="Bairro" tabindex="10" onchange="diri()">
<option value="todos">todos</option>
<option value="barra">Barra</option>
<option value="pelorinho">Pelorinho</option>
<option value="pituba">Pituba</option>
<option value="rio vermelho">Rio Vermelho</option>
<option value="itapuao">Itapuão</option>
<option value="bella vista">Bella Vista</option>
<option value="stiep">Stiep</option>
<option value="campo grande">Campo Grande</option>
</select><br/></h3></p>
<p><h3>Comida: <select name="comida" tabindex="20" onchange="diri()">
<option value="todos">todos</option>
<option value="bahiana">Bahiana</option>
<option value="caseira">Caseira</option>
<option value="gaucha">Gaucha</option>
<option value="carioca">Carioca</option>
<option value="mineira">Mineira</option>
<option value="italiana">Italiana</option>
<option value="francesa">Francesa</option>
<option value="chinesa">Chinesa</option>
<option value="portuguesa">Portuguesa</option>
<option value="mexicana">Mexicana</option>
</select><br/></h3></p>
<p><h3> Preço:
<select name="preco" tabindex="30" onchange="diri()">
<option value="todos">todos</option>
<option value="$">$</option>
<option value="$$">$$</option>
<option value="$$$">$$$</option>
<option value="$$$$">$$$$</option>
<option value="de graca">de graça!</option>
</select><br/></h3></p>
<p><h3> Tipo:
<select name="tipo" tabindex="40" onchange="diri()">
<option value="todos">todos</option>
<option value="rodizio">Rodizio</option>
<option value="a la carte">A la carte</option>
<option value="a quilo">A quilo</option>
</select><br/></h3></p>
<p><h3>
<input type="image" name="photo" src="image/button.png" action="traitement_restaurant2.php"></input>
</form>
Afficher la suite