Ejemplo n.º 1
0
 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;
 }
Ejemplo n.º 2
0
 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;
 }