public function get_by_id($id)
{
$student = null;
//database connect
$this->db->connect();
//query
$sql = "SELECT * FROM students WHERE id=?";
//execute
$stmt = $this->db->initStatement($sql);
$stmt->bind_param("i", $id);
$stmt->execute();
$stmt->bind_result($id, $first_name, $last_name, $email, $contact_no, $course);
while ($stmt->fetch()) {
//put in object
$student = new Students();
$student->set_id($id);
$student->get_id();
$student->set_first_name($first_name);
$student->set_last_name($last_name);
$student->set_email($email);
$student->set_contact_no($contact_no);
$student->set_course($course);
}
$this->db->close();
return $student;
}
