コード例 #1
0
 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;
 }
コード例 #2
0
 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;
 }