如何在codeigniter中处理空数组？

Question

So these are my codes.

model

function read() {
     $sql= "SELECT * from table WHERE name = 'rabin'";
     $query = $this->db->query($sql);
     $res = $query->result_array();
     return $res;
 }

controller

function show() {
    $this->load->model("db");
    $array['data'] = $this->db->read();
    $this->load->view("page", $array);
 }

view

foreach($data as $val) {
   "<p>" . echo $val['name']; . "</p>"
   "<p>" . echo $val['address']; . "</p>"
}

Here, when there are no records in the database satisfying the WHERE clause in the query, the model returns null and I get error saying $data expects parameter 1 to be array, null given. There are several methods to deal with this situation. But, what would be the best possible way to handle this situation ?

Answer 1

In your model try out this

function read() {
    $this->db->select()->from('table')->where('name', 'rabin');
    $sql_stmt = $this->db->get();
    return $sql_stmt->result();
}

and then to check you are getting the result - in your controller,

function show() {
     $this->load->model("db");
     $array= array( 'data' => $this->db->read());
     $this->load->view("page", $array);
 }

To view the result in your view file do print_r($data);

And then let me know what you get / result