<?php 

include 'mariadb.php';

class Getdata {
    public static function getEmployees() {
        $employees = array();        
        $conn = Mariadb::connectDb();
        $sql = "select name, city, salary from employees";
        if ($res = $conn->query($sql)) {
            while(($record = $res->fetch_assoc()) !== null) {
                $employee = new Employee();
                $employee->name = $record['name'];
                $employee->city = $record['city'];
                $employee->salary = $record['salary'];
                array_push($employees, $employee);
            }
        }else {
            error_log('Hiba! A lekérdezés sikertelen!');
        }
        $conn->close();
        return $employees;
    }
}