<?php
class DataBase
{
    private $user = 'root';
    private $pass = '';
    private $dsn = "mysql:host=localhost;dbname=students_bd";
    private $opt = array(
        PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
        PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC
    );
 
    private function makeConnect()
    {
        $pdo = new PDO($this->dsn, $this->user, $this->pass, $this->opt);
        return $pdo;
    }
 
    public function getData()
    {
        $pdo = $this->makeConnect();
        $sql = 'SELECT * FROM students ORDER BY name';
        echo "<table border=1 bordercolor=black>";
        echo "<tr><td>Имя</td><td>Фамилия</td><td>Пол</td><td>Группа</td>
               <td>Email</td><td>Средний Бал</td><td>Местный/Приезжий</td><td>Год Рождения</td>
</tr>";
        foreach ($pdo->query($sql) as $students) {
           echo "<tr><td>".$students['Name']."&nbsp;</td><td>".$students['Surname']."&nbsp;</td>
        <td>".$students['Sex']."&nbsp;</td><td>".$students['GroupNumber']."&nbsp;</td>
        <td>".$students['Email']."&nbsp;</td><td>".$students['Mark']."&nbsp;</td>
        <td>".$students['Local']."&nbsp;</td><td>".$students['Birth Date']."&nbsp;</td></tr>";
        }
        echo "</table>";
 
}
 
 
 
}
$page = new DataBase;
$page->getData();
 

PD9waHAKY2xhc3MgRGF0YUJhc2UKewogICAgcHJpdmF0ZSAkdXNlciA9ICdyb290JzsKICAgIHByaXZhdGUgJHBhc3MgPSAnJzsKICAgIHByaXZhdGUgJGRzbiA9ICJteXNxbDpob3N0PWxvY2FsaG9zdDtkYm5hbWU9c3R1ZGVudHNfYmQiOwogICAgcHJpdmF0ZSAkb3B0ID0gYXJyYXkoCiAgICAgICAgUERPOjpBVFRSX0VSUk1PREUgPT4gUERPOjpFUlJNT0RFX0VYQ0VQVElPTiwKICAgICAgICBQRE86OkFUVFJfREVGQVVMVF9GRVRDSF9NT0RFID0+IFBETzo6RkVUQ0hfQVNTT0MKICAgICk7CgogICAgcHJpdmF0ZSBmdW5jdGlvbiBtYWtlQ29ubmVjdCgpCiAgICB7CiAgICAgICAgJHBkbyA9IG5ldyBQRE8oJHRoaXMtPmRzbiwgJHRoaXMtPnVzZXIsICR0aGlzLT5wYXNzLCAkdGhpcy0+b3B0KTsKICAgICAgICByZXR1cm4gJHBkbzsKICAgIH0KCiAgICBwdWJsaWMgZnVuY3Rpb24gZ2V0RGF0YSgpCiAgICB7CiAgICAgICAgJHBkbyA9ICR0aGlzLT5tYWtlQ29ubmVjdCgpOwogICAgICAgICRzcWwgPSAnU0VMRUNUICogRlJPTSBzdHVkZW50cyBPUkRFUiBCWSBuYW1lJzsKICAgICAgICBlY2hvICI8dGFibGUgYm9yZGVyPTEgYm9yZGVyY29sb3I9YmxhY2s+IjsKICAgICAgICBlY2hvICI8dHI+PHRkPtCY0LzRjzwvdGQ+PHRkPtCk0LDQvNC40LvQuNGPPC90ZD48dGQ+0J/QvtC7PC90ZD48dGQ+0JPRgNGD0L/Qv9CwPC90ZD4KICAgICAgICAgICAgICAgPHRkPkVtYWlsPC90ZD48dGQ+0KHRgNC10LTQvdC40Lkg0JHQsNC7PC90ZD48dGQ+0JzQtdGB0YLQvdGL0Lkv0J/RgNC40LXQt9C20LjQuTwvdGQ+PHRkPtCT0L7QtCDQoNC+0LbQtNC10L3QuNGPPC90ZD4KPC90cj4iOwogICAgICAgIGZvcmVhY2ggKCRwZG8tPnF1ZXJ5KCRzcWwpIGFzICRzdHVkZW50cykgewogICAgICAgICAgIGVjaG8gIjx0cj48dGQ+Ii4kc3R1ZGVudHNbJ05hbWUnXS4iJm5ic3A7PC90ZD48dGQ+Ii4kc3R1ZGVudHNbJ1N1cm5hbWUnXS4iJm5ic3A7PC90ZD4KICAgICAgICA8dGQ+Ii4kc3R1ZGVudHNbJ1NleCddLiImbmJzcDs8L3RkPjx0ZD4iLiRzdHVkZW50c1snR3JvdXBOdW1iZXInXS4iJm5ic3A7PC90ZD4KICAgICAgICA8dGQ+Ii4kc3R1ZGVudHNbJ0VtYWlsJ10uIiZuYnNwOzwvdGQ+PHRkPiIuJHN0dWRlbnRzWydNYXJrJ10uIiZuYnNwOzwvdGQ+CiAgICAgICAgPHRkPiIuJHN0dWRlbnRzWydMb2NhbCddLiImbmJzcDs8L3RkPjx0ZD4iLiRzdHVkZW50c1snQmlydGggRGF0ZSddLiImbmJzcDs8L3RkPjwvdHI+IjsKICAgICAgICB9CiAgICAgICAgZWNobyAiPC90YWJsZT4iOwoKfQoKCgp9CiRwYWdlID0gbmV3IERhdGFCYXNlOwokcGFnZS0+Z2V0RGF0YSgpOwo=