How to fetch row from array.? mysqli

Question

I am working with codeigniter. I want to fetch a single row with passed index. If I pass 0 then first row should be display if 2 then second. etc

Here is my little code.

$qu['tid'] = mysqli_query($con , "select * from tablename");        
$this->load->view('admin/panel1' , $qu);

view code.

<table>
    <tr>
        <th>ID</th>
        <th>Name</th>
    </tr>

    <tr>
        <td><?php echo $tid['id'];?></td> // given row if 1 or 2
        <td><?php echo $tid['name'];?></td>// given row if 1 or 2
    </tr>
</table>

Hikmat Sijapati · Answer 1 · 2017-03-22T08:09:54.503

0

Try using $this->db->get('table_name')->row_array() returns first row in array format.

To fetch the specific row pass the row number as parameter.Like below

$row = $this->db->get('table_name')->row_array(2);//fetches the third row

Example

Controller:

$qu['tid'] = $this->db->get('table_name')->row_array();        
$this->load->view('admin/panel1' , $qu);

view:

echo $tid['id'];//prints id

edited Mar 22 '17 at 08:09

answered Mar 22 '17 at 08:06

Hikmat Sijapati

6,869
1
9
19

I want to change it latter with variable. – Mahi Mar 22 '17 at 08:07
why downvoted?any explain please – Hikmat Sijapati Mar 22 '17 at 08:10
I want echo one row like this `echo $tid['id'][0]`, second `echo $tid['id'][1]` third `echo $tid['id'][3]`.. ** HOw can fetch specific row from whole array variable.?** – Mahi Mar 22 '17 at 08:12
use result_array() and foreach loop. – Hikmat Sijapati Mar 22 '17 at 08:13

How to fetch row from array.? mysqli

1 Answers1