PHP affichageParListeDe15 예제들

예제 #1

파일: rechercheComplementaire.php 프로젝트: k0pernicus/TP_Licence_Master_Info

function recherchePopMaxEtMin($bdd, $populationMax, $populationMin, $page)
{
    $stmt = $bdd->prepare("SELECT region, dept, comm, nom, population, latitude, longitude FROM public.communes WHERE population <= {$populationMax} AND population >= {$populationMin}");
    $stmt->execute();
    $stmt->setFetchMode(PDO::FETCH_ASSOC);
    //Affichage
    affichageParListeDe15('null', 'null', $populationMin, $populationMax, $stmt->fetchAll(), $page);
}

예제 #2

파일: rechercheRegionDepartement.php 프로젝트: k0pernicus/TP_Licence_Master_Info

function rechercheRegionDepartement($bdd, $resultat, $page)
{
    $code_region_dept = $resultat;
    $stmt = $bdd->prepare("SELECT region, dept, comm, nom, population, latitude, longitude FROM public.communes WHERE region='{$code_region_dept}' OR dept='{$code_region_dept}'");
    $stmt->execute();
    $stmt->setFetchMode(PDO::FETCH_ASSOC);
    //Affichage
    affichageParListeDe15($code_region_dept, 'null', 'null', 'null', $stmt->fetchAll(), $page);
}