<?php
include_once "header.php";
?>
<!-- Main -->
<div id="main-wrapper">
    <div class="container">
        <div class="row 200%">
            <div class="4u 12u(medium)">
                <?php
                include_once "sidebar.php";
                ?>
            </div>
            <div class="8u 12u(medium) important(medium)">
                <div id="content">

                    <!-- Content -->
                    <article>

                        <h2>Countries</h2>

                        <p>We have published our portal for our clients couple of weeks ago. 
                            We are hardly working to full-fill all the countries and destinations, 
                            to which we arrange your travels.
                            We are sorry, if the country, you are looking for, is not listed. 
                            For all available destinations, select country from the list below.</p>
                        <h3>List of all countries:</h3>
                        <?php
                        $db = new Db();
                        $rows = $db->select("SELECT `Id`,`Name` FROM `countries` ORDER BY name ASC");
                        ?>
                       
                            <?php
                            foreach ($rows as $row) {
                                
                                echo "<a href='country/".filter_var($row['Id'], FILTER_SANITIZE_NUMBER_INT)."' title='Country - ".filter_var($row['Name'], FILTER_SANITIZE_STRING)."'>".filter_var($row['Name'], FILTER_SANITIZE_STRING).'</a><br>';
                            }
                            ?>
                        
                    </article>

                </div>
            </div>
        </div>
    </div>
</div>
<?php
include_once "footer.php";
?>