public function get_by_id($id)
{
//connect
$this->db->connect();
//query
$sql = "SELECT * FROM students WHERE id=?";
//prepare
$stmt = $this->db->initialize($sql);
//bind
$stmt->bind_param("i", $id);
//execute
$stmt->execute();
//bind result
$stmt->bind_result($id, $first_name, $last_name, $email, $contact_no, $course);
while ($row = $stmt->fetch()) {
$student = new Students();
$student->set_id($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;
}
public function get_all()
{
$student_list = array();
//database connect
$this->db->connect();
//query
$sql = "SELECT * FROM students";
//execute and fetch data
$result = $this->db->fetch_query($sql);
while ($row = $result->fetch_assoc()) {
//put in object
$student = new Students();
$student->set_id($row['id']);
$student->set_first_name($row['first_name']);
$student->set_last_name($row['last_name']);
$student->set_email($row['email']);
$student->set_contact_no($row['contact_no']);
$student->set_course($row['course']);
array_push($student_list, $student);
}
return $student_list;
$this->db->close;
}
