public function update($id) { $conn = $this->db->getConn(); $student = new StudentDTO(); $sql = 'SELECT * FROM students WHERE id="' . $id . '"'; $result = $conn->query($sql)->fetch_assoc(); // echo '<pre>'; print_r($result);die; $student->setId($result['id']); $student->setFirstname($result['firstname']); $student->setLastname($result['lastname']); $student->setAge($result['age']); $student->setBirthday($result['bday']); $student->setEmail($result['email']); $student->setSex($result['sex']); $student->setAbout($result['message']); return $result; }