Example #1
0
 static function findOrderedCountries($continent, $region, $surface_min, $surface_max, $population_min, $population_max, $life_expectancy, $government_form, $city_count, $languages)
 {
     if ($continent == "") {
         $continent = '-1';
     }
     if ($region == "") {
         $region = '%';
     }
     if ($surface_min == "") {
         $surface_min = '-1';
     }
     if ($surface_max == "") {
         $surface_max = '9000000000';
     }
     if ($population_min == "") {
         $population_min = '-1';
     }
     if ($population_max == "") {
         $population_max = '9000000000';
     }
     if ($life_expectancy == "") {
         $life_expectancy = "-1";
     }
     if ($government_form == "") {
         $government_form = '%';
     }
     if ($city_count == "") {
         $city_count = '-1';
     }
     //if(empty($languages)){echo 'ba aper';}
     $con = new ConnectDB(ProjectGlobals::$IPADDRESS, ProjectGlobals::$USER, ProjectGlobals::$PASSWORD, ProjectGlobals::$DATABASE);
     $result = $con->findOrderedCountries($continent, $region, $surface_min, $surface_max, $population_min, $population_max, $life_expectancy, $government_form, $city_count, $languages);
     $output = GenerateHTML::generateList($result, 'countryInfo.php?country');
     return $output;
 }