Bien sur, php:
[code]<?php
$content = "../../view/frontend/trouver.phtml";
$title = "Trouver un jardin";
function coupe($text, $nb = 170)
{
if (strlen($text) > $nb) {
$pos = $nb;
while ($text[$pos] <> ' ') {
$pos--;
};
$text = substr($text, 0, $pos) . '...';
};
return $text;
};
require_once("../../controller/controller.php");
$req = ("SELECT `id`, `type_de_jardin`, `selected` FROM `recherche_type`");
$stm = $sqlQuery->prepare($req);
$stm->execute();
$rechercheType = $stm->fetchall(PDO::FETCH_ASSOC);
$req = ("SELECT `id`, `taille`, `selected` FROM `recherche_taille`");
$stm = $sqlQuery->prepare($req);
$stm->execute();
$rechercheTaille = $stm->fetchall(PDO::FETCH_ASSOC);
$req = ("SELECT `id`, `zone`, `selected` FROM `recherche_zone`");
$stm = $sqlQuery->prepare($req);
$stm->execute();
$rechercheZone = $stm->fetchall(PDO::FETCH_ASSOC);
$req = ("SELECT `id`, `prix`, `selected` FROM `recherche_prix`");
$stm = $sqlQuery->prepare($req);
$stm->execute();
$recherchePrix = $stm->fetchall(PDO::FETCH_ASSOC);
if (isset($_POST["action"]) && $_POST["action"] == "search") {
$req = "SELECT jardins.id, jardins.image, jardins.alt, jardins.titre, jardins.description, jardins.prix FROM jardins JOIN recherche_jardin ON jardins.id = id_jardin WHERE id_recherche_type = :idType AND id_recherche_taille = :idTaille AND id_recherche_zone = :idZone AND id_recherche_prix = :idPrix";
$stm = $sqlQuery->prepare($req);
$postValue = $_POST["action"];
unset($postValue["action"]);
$stm->execute($postValue);
$rechercheJardins = $stm->fetchall(PDO::FETCH_ASSOC);
header("location: trouver_un_jardin");
};
// En attendant que la requête de recherche fonctionne
$req = "SELECT `id`, `image`, `alt`, `titre`, `description`, `taille_jardin`, `prix` FROM `jardins`";
$stm = $sqlQuery->prepare($req);
$stm->execute();
$jardin = $stm->fetchall(PDO::FETCH_ASSOC);
require_once("layout.php");
[/code]
phtml:
[code] <main class="page">
<section class="d-block d-sm-none" style="height: 40px"></section>
<section class="d-none d-sm-block" style="height: 20px"></section>
<section class="clean-block features background-header">
<div class="container mt-4">
<div class="block-heading">
<h1 class="text-info font-weight-bold">Trouver un jardin</h1>
<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nunc quam urna, dignissim nec auctor in, mattis vitae leo.</p>
</div>
<div class="flex-row align-items-center row justify-content-center">
<div class="col-12 col-md-6">
<!-- Formulaire de recherche de terrain -->
<form class="text-center" action="trouver_un_jardin" method="POST">
<h2 class="pt-3"><b>Recherher un jardin</b></h2>
<div class="form-group px-3">
<select name="idType" class="form-control my-5">
<?php foreach ($rechercheType as $searchType) : ?>
<option <?php echo $searchType["selected"] ?> value="<?php echo $searchType["id"] ?>"><?php echo $searchType["type_de_jardin"] ?></option>
<?php endforeach ?>
</select>
<select name="idTaille" class="form-control my-5">
<?php foreach ($rechercheTaille as $searchTaille) : ?>
<option <?php echo $searchTaille["selected"] ?> value="<?php echo $searchTaille["id"] ?>"><?php echo $searchTaille["taille"] ?></option>
<?php endforeach ?>
</select>
<select name="idZone" class="form-control my-5">
<?php foreach ($rechercheZone as $searchZone) : ?>
<option <?php echo $searchZone["selected"] ?> value="<?php echo $searchZone["id"] ?>"><?php echo $searchZone["zone"] ?></option>
<?php endforeach ?>
</select>
<select name="idPrix" class="form-control my-5">
<?php foreach ($recherchePrix as $searchPrix) : ?>
<option <?php echo $searchPrix["selected"] ?> value="<?php echo $searchPrix["id"] ?>"><?php echo $searchPrix["prix"] ?></option>
<?php endforeach ?>
</select>
</div>
<div class="form-group px-5">
<button class="btn btn-form btn-block" type="submit" name="action" value="search">Trouver</button>
</div>
<?php var_dump($rechercheJardins) ?>
</form>
<!-- Fin formulaire de recherche de terrain -->
</div>
</div>
</div>
</section>
<section class="background-footer">
<div class="container">
<div class="row text-center pb-5 justify-content-around">
<?php foreach ($jardin as $jard) : ?>
<div class="col-md-6 col-lg-4 mb-3">
<div class="card h-100">
<div class="card-body">
<img class="card-img-top w-100 d-block rounded" src="<?php echo $jard["image"] ?>" alt="<?php echo $jard["alt"] ?>">
<h4 class="card-title mt-4 " style="height: 50px"><?php echo $jard["titre"] ?></h4>
<p class="card-text"><?php echo coupe($jard["description"]) ?></p>
<h5 class="text-muted card-subtitle my-3"><b>Taille:</b> <?php echo $jard["taille_jardin"] ?>m²</h6>
<h5 class="text-muted card-subtitle my-3"><b>Prix:</b> <?php echo $jard["prix"] ?>€</h6>
<a class="card-link btn btn-form mt-3" style="width: 150px" href="jardin<?php echo $jard["id"] ?>">Voir le jardin</a>
</div>
</div>
</div>
<?php endforeach ?>
</div>
</div>
</section>
</main>[/code]
Tu veux aussi les layout?
