public function getempleado($id) { $users = array(); $resultado = $this->conex->query("SELECT FirstName, LastName FROM Employees WHERE EmployeeID='{$id}'"); while ($filas = $resultado->fetch_array()) { $employeeDTO = new EmployeeDTO(); $employeeDTO->setFirstName($filas["FirstName"]); $employeeDTO->setLastName($filas["LastName"]); array_push($users, $employeeDTO); } return $users; }
public function getEmployee() { $users = array(); $resultado = $this->conex->query('SELECT EmployeeID, FirstName, LastName FROM employees'); while ($filas = $resultado->fetch_array()) { $EmployeDTO = new EmployeeDTO(); $EmployeDTO->setEmployeeID($filas["EmployeeID"]); $EmployeDTO->setLastName($filas["LastName"]); $EmployeDTO->setFirstName($filas["FirstName"]); array_push($users, $EmployeDTO); } // parent::cerrarConexion(); return $users; }