function loadEmployee($id) { // name $request = "SELECT * FROM employee WHERE id = {$id}"; $result = mysql_query($request); $row = mysql_fetch_object($result); $name = $row->name; $address = $row->address; $salary = $row->salary; $did = $row->did; $departments = array(); $request = "SELECT * FROM department"; $result = mysql_query($request); while ($row = mysql_fetch_object($result)) { $department["id"] = $row->id; $department["name"] = $row->name; if ($row->id == $did) { $department["parent"] = true; } else { $department["parent"] = false; } $departments[] = $department; } // create employee object $employee = new Employee(); $employee->setId($id); $employee->setName($name); $employee->setAddress($address); $employee->setSalary($salary); $employee->setDepartments($departments); // return employee object return $employee; }
public function constructReturnArr($res) { $arr = array(); $i = 0; while ($row = mysql_fetch_assoc($res)) { $emp = new Employee(); $emp->setName($row['name']); $emp->setCode($row['code']); $emp->setSalary($row['salary']); $emp->setGrade($row['grade']); $arr[$i] = $emp; $i++; } $this->getConnection()->releaseRes($res); return $arr; }
function loadEmployee($jsonObject) { $id = $jsonObject->id; // name $request = "SELECT * FROM employee WHERE id = {$id}"; $result = mysql_query($request); $row = mysql_fetch_object($result); $name = $row->name; $address = $row->address; $salary = $row->salary; // create department object $employee = new Employee(); $employee->setName($name); $employee->setAddress($address); $employee->setSalary($salary); // return department object return $employee; }