Liste des bases de location de la région " . $row[1] . "");
} else {
$table = "voienav";
$query = "SELECT * FROM $table WHERE cle=$numvoie";
$result = mysqli_query($conn, $query);
$row = mysqli_fetch_row($result);
$nomvoie = stripslashes($row[4]);
echo("
Bases de location proches de la voie " . $nomvoie . "
");
}
// Recherche des enregistrements et affichage du nombre de pages
include("../../cnx/fluvial.php");
$table = "loueur_adr";
if ($numvoie <> 0)
$query = "SELECT * FROM $table WHERE cle_nav1=$numvoie OR cle_nav2=$numvoie OR cle_nav3=$numvoie OR cle_nav4=$numvoie OR cle_nav5=$numvoie OR cle_nav6=$numvoie OR cle_nav7=$numvoie OR cle_nav8=$numvoie OR cle_nav9=$numvoie OR cle_nav10=$numvoie OR cle_nav11=$numvoie OR cle_nav12=$numvoie ORDER BY SOCIETE";
else
$query = "SELECT * FROM $table WHERE cle_bas1=$bassin OR cle_bas2=$bassin ORDER BY SOCIETE";
$result = mysqli_query($conn, $query);
$nbenr = mysqli_num_rows($result);
$nbpage = (ceil($nbenr / 10));
echo("
" . $nbpage . " page(s)
");
if (isset($page))
mysqli_data_seek($result, ($page * 10) - 10);
else
$page = 1;
?>
echo("
");
$compteur = 1;
while ($row = mysqli_fetch_row($result) and ($compteur < 11)) {
$table2 = "stat_loueur";
$date = date("Y-m-j");
$nom = addslashes($row[8]);
$ville = addslashes($row[13]);
$query2 = "INSERT INTO $table2 (cle_loueur,nom,cp,ville,date,type) VALUES ('$row[0]','$nom','$row[12]','$ville','$date','L')";
$result2 = mysqli_query($query2) or die ("AJOUT IMPOSSIBLE " . $table2);
$urlFicheLoueur = "/location-bateaux/" . str2url(stripslashes($row[8])) . "/" . $row[0];
if (intval($compteur / 2) == ($compteur / 2)) {
$classe = 'line_color1';
} else {
$classe = 'line_color2';
}
echo("- ");
echo(stripslashes($row[8]) . " - ");
echo($row[12] . " - " . $row[13] . "
");
echo("");
echo("Pour en savoir + ");
echo("");
echo(" ");
$compteur++;
}
echo('
');
?>
if ($nbpage > 1) {
echo("
");
for ($i = 1; $i <= $nbpage; $i++) {
if ($i > 1) echo " | ";
if ($i == $page) echo('- ' . $i . '
');
else echo('- ' . $i . '
');
}
echo('
');
}
?>