public function getDetail() { $db = new DBConnection(); $link = $db->connect(); if ($link) { if ($this->entity_type == 'Member') { $member = new Member(); $query = "SELECT * FROM member WHERE id = " . $this->entity->getStudentId(); $result = $link->query($query); while ($row = mysqli_fetch_assoc($result)) { $member->setStudentId($row['id']); $member->setFirstName($row['first_name']); $member->setLastName($row['last_name']); $member->setDeptName($row['dept_name']); $member->setRegisterDate($row['register_date']); $member->setEmail($row['email']); $member->setMobile($row['mobile']); $member->setIndexNu($row['index_no']); $member->setBirthday($row['birthday']); $member->setGender($row['gender']); $member->setFacultyname($row['faculty_name']); $member->setNic($row['NIC']); } $db->closeConnection(); return $member; } elseif ($this->entity_type == 'Resource') { $resource = new Resource(); foreach ($this->entity as $property => $value) { $resource->{$property}($value); } $query = "SELECT * FROM resource WHERE r_ID='" . $resource->getResourceId() . "'"; $result = $db->executeQuery($query); while ($row = mysqli_fetch_assoc($result)) { $resource->setResourceId($row[1]); $resource->setCategory($row[2]); $resource->setDescription($row[3]); $resource->setOfficerId($row[4]); } $db->closeConnection(); return $resource; } elseif ($this->entity_type == 'DynamicAllocation') { $resourceAlloc = new ResourceAllocation(); foreach ($this->entity as $property => $value) { $resourceAlloc->{$property}($value); } $query = "SELECT * FROM dynamic_alloc WHERE r_ID ='" . $resourceAlloc->getResourceId() . "' AND s_ID = '" . $resourceAlloc->getMemberId() . "'"; $result = $db->executeQuery($query); while ($row = mysqli_fetch_assoc($result)) { $resourceAlloc->setComments($row[2]); $resourceAlloc->setIssuedDate($row[3]); $resourceAlloc->setDueDate($row[4]); } $db->closeConnection(); return $resourceAlloc; } } else { echo "Cannot connect to database"; } }