/** * @Route("/testdb",name="database") */ public function test() { $member = new Entity\Member(); $member->setMobile("07129832"); $member->setRegisterDate("12/12/2012"); $member->setEmail("*****@*****.**"); $member->setFirstName("Nuwan"); $member->setLastName("Rathnayaka"); $member->setStudentId("123456F"); $member->setDeptName("noone"); $r = new Entity\Resource(); $r->setResourceId("1"); $r->setDescription("this description"); $r->setOfficerId("1234"); $r->setValue("sdsds"); $ra = new Entity\ResourceAllocation(); $ra->setResourceId("1"); $ra->setMemberId("123456F"); $ra->setComments("Use enjoy it"); $ra->setDueDate("2016-01-07"); $ra->setIssuedDate("2015-12-34"); $nStudent = new Entity\Member(); $nStudent->setStudentId("123456"); $db = new Modal\DBAccess($nStudent); $n = $db->getDetail(); echo $n->getFirstName(); return new Response(); }
private function getUser($username) { $db = new DBConnection(); $link = $db->connect(); $query = "SELECT * FROM app_user WHERE email ='{$username}'"; $result = $link->query($query); $user = null; $member_id = 0; while ($row = mysqli_fetch_assoc($result)) { $user = new User($row['email'], $row['password'], "", unserialize($row['role'])); $member_id = $row['id']; } $db->closeConnection(); $member = new Member(); $member->setStudentId($member_id); $da = new DBAccess($member); $user->setMember($da->getDetail()); return $user; }