Codeigniter result_array() returning one row

Question

In my table I have two rows but when I print_r the $data that this model function is connected to it is only returning the second row in the db why?

Model Function:

function getAllUsers()
{
    $query = $this->db->get('users');

    foreach($query->result_array() as $row)
    {
        $row['id'];
        $row['fName'];
        $row['lName'];
        $row['email'];
        $row['password'];
    }

    return $row;
}

Ayush · Accepted Answer · 2012-06-14 04:03:22Z

4

Because $row is the loop variable, it will only hold the data from the last iteration after the loop has exited.

Do it like this:

function getAllUsers()
{
    $rows = array(); //will hold all results
    $query = $this->db->get('users');

    foreach($query->result_array() as $row)
    {    
        $rows[] = $row; //add the fetched result to the result array;
    }

   return $rows; // returning rows, not row
}

In your controller:

$data['users'] = $this->yourModel->getAllUsers();
$this->load->view('yourView',$data);

In your view

//in your view, $users is an array. Iterate over it

<?php foreach($users as $user) : ?>

<p> Your first name is <?= $user['fName'] ?> </p>

<?php endforeach; ?>

edited Jun 14, 2012 at 4:03

answered Jun 14, 2012 at 3:41

Ayush

42.5k52 gold badges169 silver badges243 bronze badges

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

2 Comments

Jess McKenzie Over a year ago

Thanks, How would I fetch the data from the view? Before I had $data['blah'] = model_function then in the view I had $blah['table_name']

Jess McKenzie Over a year ago

Thanks @xbonez When using it with html whats the correct syntax for when you use <?php foreach($userDetails as $userDetail):?>

Collectives™ on Stack Overflow

Codeigniter result_array() returning one row

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related