// Recherche des enregistrements et affichade du nombre de pages
$table="bateau";
echo("
");
echo("
Fiches bateaux
");
echo('
');
echo("Votre recherche : ");
switch($mode){
case 2:
// Recherche par mot-cles
$sauve=stripslashes(filter_form($motcles));
$mot = filter_form($mot);
if($injection == FALSE){
$motcles=stripslashes(str_replace("'","%",filter_form($motcles)));
echo("".$sauve."");
$query = "SELECT * FROM $table WHERE";
$decoupe=explode(" ",$motcles);
$passage=0;
foreach($decoupe as $mot)
{
if($passage==0)
{
$query=$query." (MODELE LIKE \"%$mot%\" OR ARMATEUR LIKE \"%$mot%\" OR COMMENTAIRE LIKE \"%$mot%\")";
$passage=1;
}
else
{
$query=$query." AND (MODELE LIKE \"%$mot%\" OR ARMATEUR LIKE \"%$mot%\" OR COMMENTAIRE LIKE \"%$mot%\")";
}
}
}
break;
case 3:
$query = "SELECT * FROM $table WHERE";
$passage=0;
$bateau = filter_form($bateau);
$libelle = filter_form($libelle);
// BATEAU
if($bateau<>0 && $injection == FALSE)
{
$table2="bateau";
$query2="SELECT * FROM $table2 WHERE CLE=$bateau";
$result2=mysqli_query($conn, $query2) OR DIE ("LECTURE IMPOSSIBLE ".$table2);
$row2 = mysqli_fetch_row($result2);
$libelle=stripslashes($row2[1]);
echo(" Bateau ".$libelle."");
if($passage==0)
{$query=$query." CLE=$bateau";
$passage=1;
}
else
{
$query=$query." AND CLE=$bateau";
}
}
// CATEGORIE
$cat = filter_form($cat);
if($cat<>0 && $injection == FALSE)
{
$table2="bat_cat";
$query2="SELECT * FROM $table2 WHERE CLE=$cat";
$result2=mysqli_query($conn, $query2) OR DIE ("LECTURE IMPOSSIBLE ".$table2);
$row2 = mysqli_fetch_row($result2);
$libelle=stripslashes($row2[1]);
echo(" Catégorie ".$libelle."");
if($passage==0)
{$query=$query." IDCAT=$cat";
$passage=1;
}
else
{
$query=$query." AND IDCAT=$cat";
}
}
// COQUE
$coque = filter_form($coque);
if($coque<>0 && $injection == FALSE)
{
$table2="bat_coque";
$query2="SELECT * FROM $table2 WHERE CLE=$coque";
$result2=mysqli_query($conn, $query2) OR DIE ("LECTURE IMPOSSIBLE ".$table2);
$row2 = mysqli_fetch_row($result2);
$libelle=stripslashes($row2[1]);
echo(" - Coque ".$libelle."");
if($passage==0)
{$query=$query." IDCOQUE=$coque";
$passage=1;
}
else
{
$query=$query." AND IDCOQUE=$coque";
}
}
break;
}
// LONGUEUR
if($longueur<>0 )
{
$longueur = filter_form($longueur);
if($injection == FALSE)
{
$table2="bat_longueur";
$query2="SELECT * FROM $table2 WHERE CLE=$longueur";
$result2=mysqli_query($conn, $query2) OR DIE ("LECTURE IMPOSSIBLE ".$table2);
$row2 = mysqli_fetch_row($result2);
$libelle=stripslashes($row2[1]);
echo(" - Longueur ".$libelle."");
if($passage==0)
{$query=$query." IDLONGUEUR=$longueur";
$passage=1;
}
else
{
$query=$query." AND IDLONGUEUR=$longueur";
}
}
}
//TA
if($ta<>0)
{
$ta =filter_form($ta);
$table2="bat_ta";
$query2="SELECT * FROM $table2 WHERE CLE=$ta";
$result2=mysqli_query($conn, $query2) OR DIE ("LECTURE IMPOSSIBLE ".$table2);
$row2 = mysqli_fetch_row($result2);
$libelle=stripslashes($row2[1]);
echo(" - Tirant d'air ".$libelle."");
if($passage==0)
{$query=$query." IDTA=$ta";
$passage=1;
}
else
{
$query=$query." AND IDTA=$ta";
}
}
//TE
if($te<>0)
{
$te =filter_form($te);
if($injection == FALSE){
$table2="bat_te";
$query2="SELECT * FROM $table2 WHERE CLE=$te";
$result2=mysqli_query($conn, $query2) OR DIE ("LECTURE IMPOSSIBLE ".$table2);
$row2 = mysqli_fetch_row($result2);
$libelle=stripslashes($row2[1]);
echo(" - Tirant d'eau ".$libelle."");
if($passage==0)
{$query=$query." IDTE=$te";
$passage=1;
}
else
{
$query=$query." AND IDTE=$te";
}
}
}
// ARGUS
if($argus<>0)
{
$argus = filter_form($argus);
if($injection == FALSE)
{
$table2="bat_argus";
$query2="SELECT * FROM $table2 WHERE CLE=$argus";
$result2=mysqli_query($conn, $query2) OR DIE ("LECTURE IMPOSSIBLE ".$table2);
$row2 = mysqli_fetch_row($result2);
$libelle=stripslashes($row2[1]);
echo(" - Argus ".$libelle."");
if($passage==0)
{
$query=$query." (IDARGUS_MOI=$argus)";
$passage=1;
}
else
{
$query=$query." AND (IDARGUS_MOI=$argus)";
}
}
}
//PRIX NEUF
if($prixneuf<>0)
{
$prixneuf = filter_form($prixneuf);
switch($prixneuf)
{
case 1:
echo(" - Prix neuf inférieur de 15000 Euros");
break;
case 2:
echo(" - Prix neuf entre 15000 Euros et 45000 Euros");
break;
case 3:
echo(" - Prix neuf entre 45000 Euros et 76000 Euros");
break;
case 4:
echo(" - Prix neuf entre 76000 Euros et 150000 Euros");
break;
case 5:
echo(" - Prix neuf supérieur à 150000 Euros");
break;
}
if($injection == FALSE){
if($passage==0)
{
$query=$query." IDBAT_PRIXNEUF=$prixneuf";
$passage=1;
}
else
{
$query=$query." AND IDBAT_PRIXNEUF=$prixneuf";
}
}
}
if($injection == FALSE){
$query=$query." AND FICHEACTIVE=1 ORDER BY MODELE";
}
$result = mysqli_query($conn, $query); // print $query . "
" . $_GET['mode'];
$nbenr = mysqli_num_rows($result);
$nbpage= (ceil($nbenr/9));
if (isset($page)){
mysqli_data_seek($result,($page*9)-9);
}else{
$page=1;
}
if($nbpage<>1){
echo(" (".$nbpage." pages)");
}
echo('
');
if ($nbpage > 1) {
$mode = filter_form($mode);
$motcles = filter_form($motcles);
$cat = filter_form($cat);
$longueur = filter_form($longueur);
$argus = filter_form($argus);
$te = filter_form($te);
$ta = filter_form($ta);
$coque = filter_form($coque);
$prixneuf = filter_form($prixneuf);
if($injection == FALSE){
echo "
";
for($i=1;$i<=$nbpage;$i++) {
if ($i > 1) echo " | ";
if($i==$page){
echo('- '.$i.'
');
}
else{
echo('- '.$i.'
');
}
}
echo('
');
}
}
$compteur=1;
echo ('
');
while($row = mysqli_fetch_row($result) AND ($compteur<10)) {
$batModel = str2url($row[1]);
if (intval($compteur/2)==($compteur/2)) {$classe = 'line_color1';} else {$classe = 'line_color2';}
echo("- ");
echo($row[1]."
");
echo("Pour en savoir + ");
$compteur++;
}
if ($nbenr == 0) echo "- Nous n'avons trouvé aucun résultat correspondant à votre recherche. Merci de redéfinir vos critères.";
echo("
");
if ($nbpage > 1) {
$mode = filter_form($mode);
$motcles = filter_form($motcles);
$cat = filter_form($cat);
$longueur = filter_form($longueur);
$argus = filter_form($argus);
$te = filter_form($te);
$ta = filter_form($ta);
$coque = filter_form($coque);
$prixneuf = filter_form($prixneuf);
if($injection == FALSE){
echo "
";
for($i=1;$i<=$nbpage;$i++) {
if ($i > 1) echo " | ";
if($i==$page){
echo('- '.$i.'
');
}
else{
echo('- '.$i.'
');
}
}
echo('
');
}
}
echo('