1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
|
<?php
function req($zeDB,$zeQuery,$zeLogin,$zePwd)
{
$zePort=3309;
$mysqli = new mysqli('localhost',$zeLogin,$zePwd,$zeDB,$zePort);
$result = $mysqli->query($zeQuery);
$cpt=0;
$row=array();
while($rowTemp[$cpt] = $result->fetch_assoc())
{
$row[$cpt]=$rowTemp[$cpt];
$cpt++;
}
$result->close();
return $row;
}
$zeQuery="SELECT DISTINCT region.reg_id, region.reg_nom FROM region INNER JOIN attraction ON region.reg_id = attraction.att_fk_region";
$region=req($zeDatabase,$zeQuery,$zeLogin,$zePwd);
for($ind=0;$ind<count($region);$ind++)
{
echo "<li>".$region[$ind]['reg_nom']."</li>";
}
?> |
Partager