What does CodeIgniter's row_array() method return? [duplicate]

Question

I want to get a list of email addresses from the database, what I have tried are here:

In my model:

public function get_email_address_by_sector($search_by, $search_field)
{
    $this->db->select('*');
    $this->db->like($search_by, $search_field);
    $query = $this->db->get('tb_company');

    $row = $query->row_array();
    return $row['email'];
}

I want to see the data in the array with this controller:

public function get_email_address($search_by, $search_field)
{
    $recipients = $this->company_model->get_email_address_by_sector($search_by, $search_field);

    print_r($recipients);
}

What does row_array() return in CodeIgniter?

check the doc codeigniter.com/userguide3/database/results.html — Madhawa Priyashantha
– Madhawa Priyashantha, Commented Mar 2, 2019 at 7:24
row_array() returns a flat array representing the first qualifying row of the query. If there were no qualifying rows, then null is returned. For this reason, it is unstable to try to access the email element of a potentially null value. You will need to null coalesce. — mickmackusa
– mickmackusa ♦, Commented Mar 5 at 22:40

Saji · Accepted Answer · 2019-03-02 07:38:35Z

1

The row_array() and row() will return only one row. Use result_array() or result() if you want to fetch multiple rows. See result_array()

Change $row = $query->row_array(); to $row = $query->result_array();

answered Mar 2, 2019 at 7:38

Saji

1,4022 gold badges14 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

What does CodeIgniter's row_array() method return? [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related