Login

07-23-2008, 03:17 PM

[eluser]johnmiller[/eluser]
Hey…

I have a table called ‘users’ with fields ‘name, address’.

There are 100 records in this table.

I need to display all the 100 records in the ‘view’.

But I am getting only one record(first record).

How to write the view which displays all the 100 records?

Can you please help me?

The below given are the model and controller

Model (blogmodel.php)

Code:
&lt;?php

class Blogmodel extends  Model {

function select_entries()

{

    $this->db->select('name, address');

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

    return $query->row_array();

}

}

?&gt;

Controller (blog.php)

Code:
&lt;?php

class Blog Extends Controller {

function index()

{  

    $this->load->model('blogmodel');

    $data['query'] = $this->blogmodel->select_entries();

    $this->load->view('blogview', $data);

}

}

?&gt;

07-23-2008, 03:39 PM

[eluser]beemr[/eluser]

Code:
$query->result_array();

instead of

Code:
$query->row_array();

Row_array() returns a single row

07-23-2008, 03:56 PM

[eluser]johnmiller[/eluser]
Thanks beemr, but if i use

Code:
result_array();

i get the output as the word 'array'.

The below is the view (blogview.php)

Code:
&lt;html&gt;

&lt;body&gt;

<table border="1">

<thead>

<tr>

<th>Name</th>

<th>Address</th>

</tr>

</thead>

<tbody>

&lt;?php foreach($query as $value):?&gt;

<tr>

<td>

can you please tell me how to write code here? if this is not correct, can you please tell me the correct code?

Code:
</td>

</tr>

&lt;?php endforeach; ?&gt;

</tbody>

</table>

&lt;/body&gt;

&lt;/html&gt;

07-23-2008, 05:58 PM

[eluser]beemr[/eluser]
So then, your results are an array. In the red text above, you would remove the surrounding <td> and insert

Code:
<td>&lt;?=$value['name']?&gt;</td>

<td>&lt;?=$value['address']?&gt;</td>

see the docs

07-23-2008, 05:58 PM

[eluser]elvix[/eluser]
just do a print_r($value) in there and it should print out all the values contained in the $value array. then just place the appropriate value ($value['something']) where you want it.

when it comes to arrays, print_r is your best friend. Smile

07-23-2008, 06:11 PM

[eluser]johnmiller[/eluser]
Thanks a lot everybody...

I tried the below code and it is working now...

Code:
&lt;?php $counter = count($query);?&gt;

<table border="1">

<thead>

<tr>

<th>Name</th>

<th>Address</th>

</tr>

</thead>

<tbody>

&lt;?php 

for($i=0;$i<$counter;$i++)

{

?&gt;  

  <tr>

    <td>&lt;?php echo $query[$i]->name;?&gt;</td>

    <td>&lt;?php echo $query[$i]->address;?&gt;</td>

  </tr>

&lt;?php

}

?&gt;

</tbody>

</table>

Thanks a lot to everybody who helped me...

Someone can use this code in the future...

07-23-2008, 10:33 PM

[eluser]Randy Casburn[/eluser]
You can try this too...

Code:
<table border="1">

<thead>

<tr>

<th>Name</th>

<th>Address</th>

</tr>

</thead>

<tbody>

&lt;?php foreach($query as $row):?&gt;

<tr>

<td>&lt;?php echo $row['name'];?&gt;</td>

<td>&lt;?php echo $row['address'];?&gt;</td>

</tr>

&lt;?php endforeach;?&gt;

</tbody>

</table>

Randy

07-24-2008, 10:50 AM

[eluser]johnmiller[/eluser]
Thanks Randy