public function get_all()
{
$enquiry_list = array();
$this->db->connect();
//Query
$sql = "SELECT * FROM tbl_enquiries";
//run query
$result = $this->db->fetch_query($sql);
while ($row = $result->fetch_assoc()) {
$enquiry = new Enquiry();
$enquiry->set_id($row['id']);
$enquiry->set_company_name($row['company_name']);
$enquiry->set_first_name($row['first_name']);
$enquiry->set_last_name($row['last_name']);
$enquiry->set_email($row['email']);
$enquiry->set_message($row['message']);
$enquiry->set_contact_no($row['contact_no']);
$enquiry->set_subject($row['subject']);
$enquiry->set_enquiry_date($row['enquiry_date']);
$enquiry->set_is_read($row['is_read']);
array_push($enquiry_list, $enquiry);
}
$this->db->close();
return $enquiry_list;
}
public function get_all($order_by = null)
{
$enquiry_list = array();
$this->db->connect();
$sql = "SELECT * from tbl_enquiries";
if (!is_null($order_by)) {
$sql = $sql . " ORDER BY " . $order_by;
}
$result = $this->db->fetchQuery($sql);
while ($row = $result->fetch_assoc()) {
$enquiry = new Enquiry();
$enquiry->set_id($row['id']);
$enquiry->set_company_name($row['company_name']);
$enquiry->set_first_name($row['first_name']);
$enquiry->set_last_name($row['last_name']);
$enquiry->set_email($row['email']);
$enquiry->set_contact_no($row['contact_no']);
$enquiry->set_enquiry_date($row['enquiry_date']);
$enquiry->set_subject($row['subject']);
$enquiry->set_message($row['message']);
$enquiry->set_is_read($row['is_read']);
$enquiry_list[] = $enquiry;
}
$this->db->close();
return $enquiry_list;
}