<?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();
