Display data from database with using COLUMN not row in CodeIgniter VIEW

Question

I have problem in my view display in codeigniter

I have a problem with my database display in the 'view' in CodeIgniter, I've been able to do load my database and display data using tables, but the data is performed by using extends vertically downwards by using a row, whereas I want to display it horizontally by using column

[my view display in browser]
[data 1]
[data 2]
[data 3]
[etc...]

my view I wanted!
[data 1] [data 2] [data 3] [etc..]

this is my Controller Code:

function coba(){
    // nyobain nge load td secara multiple
$data['query'] = $this->Latihan_model->coba()->result();
$this->load->view('rubbish/coba',$data);
}

this is my model Code:

function coba(){
$sql = ("
    SELECT soal.ID_soal as soal
    from soal
    where soal.ID_bagian = 1;
    "); return $this->db->query($sql);
}

this is my view code:

<table border=1>
<?php foreach($query as $post): ?>
<tr>
    <td><? echo $post->soal; ?></td>
</tr>
<?php endforeach; ?>

I hope you're understand what I am asked

Move the tr outside foreach?

lighter
– lighter

2014-05-25 16:26:44 +00:00
Commented May 25, 2014 at 16:26 — lighter
– lighter, Commented May 25, 2014 at 16:26
I input my answers. Wish that will help for you.

lighter
– lighter

2014-05-25 16:39:42 +00:00
Commented May 25, 2014 at 16:39 — lighter
– lighter, Commented May 25, 2014 at 16:39

lighter · Accepted Answer · 2014-05-25 16:38:49Z

1

You can try this

<table border=1>
<tr>
<?php foreach($query as $post): ?>
    <td><? echo $post->soal; ?></td>
<?php endforeach; ?>
</tr>

answered May 25, 2014 at 16:38

lighter

2,8243 gold badges43 silver badges61 bronze badges

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

Comments

Parag Tyagi · Accepted Answer · 2014-05-25 16:43:59Z

0

try this:

<?php foreach($query as $key => $value): ?>
<tr>
   <?php foreach($key as $val): ?>
       <td><?php echo $val; ?></td>
   <?php endforeach; ?>
</tr>
<?php endforeach; ?>

edited May 25, 2014 at 16:43

Parag Tyagi

9,0003 gold badges45 silver badges50 bronze badges

answered May 25, 2014 at 16:17

Alessandro Minoccheri

36.1k22 gold badges128 silver badges176 bronze badges

Collectives™ on Stack Overflow

Display data from database with using COLUMN not row in CodeIgniter VIEW

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related