function outputCountriesWithVisits($dbAdapter)
{
    $id = $_GET[continent];
    if (!empty($id) && !is_numeric($id) && strlen($id) == 2 && ctype_upper($id)) {
        $gateCountry = new CountryTableGateway($dbAdapter);
        $result = $gateCountry->findCountriesWithCountsById($id);
        echo '<table class="mdl-data-table mdl-js-data-table mdl-shadow--2dp">
          <thead>
            <tr>
              <th class="mdl-data-table__cell--non-numeric">Country</th>
              <th>Visits</th>
            </tr>
          </thead>
          <tbody>';
        foreach ($result as $row) {
            echo '<tr>
          <td class="mdl-data-table__cell--non-numeric">' . $row->CountryName . '</td>
          <td>' . $row->VisitsFromCountry . '</td>
          </tr>';
        }
        echo '</tbody>
            </table>';
    } else {
        echo "<h2>Chosen continent does not exist</h2>";
    }
}
function outputCountries($dbAdapter)
{
    $gate = new CountryTableGateway($dbAdapter);
    $result = $gate->findCountriesWithImages();
    foreach ($result as $row) {
        echo '<li class="list-group-item">
			<a href="single-country.php?iso=' . $row->ISO . '">' . $row->CountryName . '</a></li>';
    }
}
function filterCountry($dbAdapter)
{
    $gate = new CountryTableGateway($dbAdapter);
    $result = $gate->findCountriesWithImages();
    foreach ($result as $row) {
        echo '<option value="' . $row->ISO . '">';
        echo $row->CountryName;
        echo '</option>';
    }
}
function outputContent($dbAdapter)
{
    $gate = new CountryTableGateway($dbAdapter);
    $result = $gate->findById($_GET['iso']);
    echo utf8_encode('<ol class="breadcrumb">
			<li><a href="index.php">Home</a></li>
			<li><a href="browse.php">Browse</a></li>
			<li><a href="browse-countries.php">Countries</a></li>
			<li class="active">' . $result->CountryName . '</li>
			</ol>');
    echo '<div class="panel panel-default">
			<div class="panel-body">';
    echo utf8_encode('<h2>' . $result->CountryName . '</h2>
			<p>Capital: <b>' . $result->Capital . '</b></p>
			<p>Area: <b>' . number_format($result->Area) . '</b> sq km.</p>
			<p>Population: <b>' . number_format($result->Population) . '</b></p>
			<p>Currency Name: <b>' . $result->CurrencyName . '</b></p>
			<p>' . $result->CountryDescription . '</p>');
    echo '</div>
			</div>';
    ImagesFrom($result->CountryName, $dbAdapter);
}
示例#5
0
function ImageDetailsPanel($cityCode, $countryCode, $dbAdapter)
{
    $gateCountry = new CountryTableGateway($dbAdapter);
    $gateCity = new CityTableGateway($dbAdapter);
    $cityName = $gateCity->findById($cityCode)->AsciiName;
    $countryName = $gateCountry->findById($countryCode)->CountryName;
    $countryCodeISO = $gateCountry->findById($countryCode)->CountryCodeISO;
    echo '<div class="panel panel-info">
		<div class="panel-heading">Image Details</div>
		<div class="panel-body">';
    echo utf8_encode('<p>' . $cityName . ', <a href="single-country.php?iso=' . $countryCode . '">' . $countryName . '</a></p>');
    echo '</div>
		</div>';
}
function outputCountriesByContinent($dbAdapter)
{
    $userContinent = $_GET["continentCode"];
    $countryGate = new CountryTableGateway($dbAdapter);
    $result = $countryGate->findCountriesWithCountsById($userContinent);
    $countryInfoArray = [];
    foreach ($result as $row) {
        $countryInfo = new stdClass();
        $countryInfo->name = $row->CountryName;
        $countryInfo->visitCount = $row->VisitsFromCountry;
        array_push($countryInfoArray, $countryInfo);
    }
    echo json_encode($countryInfoArray);
}