Get data from db and display specific array index in view using codeigniter

Question

I want to view a data in view with different style from each data. Thats why I need an array index when load the data from database.
I'm using CodeIgniter, but I still got error like undefined offset.

I tried to select data in my model and order by datetime (timestamp) limit 5 data

Model :

return $this->db->query("select * from artikel order by datetime ASC LIMIT 5");

Controller :

$data['artikels']=$this->Home_model->getartikel();

View :

<?php foreach ($artikels->result_array() as $artikel) { ?>
<div class="style-one"><?php echo $artikel[0]['title'] ?></div>
<div class="style-two"><?php echo $artikel[1]['title'] ?></div>
<div class="style-three"><?php echo $artikel[2]['title'] ?></div>
<div class="style-four"><?php echo $artikel[3]['title'] ?></div>
<div class="style-five"><?php echo $artikel[4]['title'] ?></div>
<?php } ?>

I want the data display like the picture below:

enter image description here

Sherif Salah · Accepted Answer · 2018-12-25 11:15:56Z

1

You have two options..

First is to change your style with style-# to just match the array indices and use it like this:

<?php foreach ($artikels->result_array() as $key => $artikel) { ?>
    <div class="style-<?= $key ?>"><?= $artike['title'] ?></div>
<?php } ?>

Or to prepare your array in your controller and re-index it using your css styles as its keys.

// That's an array with numbers in words
$numbers = array("zero","one","two","three","four","five");

// That's exactly how result_array() returns your result
$articles = array(
    array('title' => 'Lorem ipsum dolor sit amet.'),
    array('title' => 'Consectetur adipisicing elit. Labore, officia?'),
    array('title' => 'Obcaecati cupiditate, eveniet ducimus est ea sed.'),
    array('title' => 'Iste assumenda, recusandae quasi.'),
    array('title' => 'Voluptas sapiente eos atque, debitis.'),
    array('title' => 'Quod, vel, ipsam.')
);

// That's an empty result array
$result = array();

// Processing in your controller
foreach ($articles as $key => $article)
{
    $result[$numbers[$key]] = $article['title'];
}

The result would be like this:

Array
(
    [zero] => Lorem ipsum dolor sit amet.
    [one] => Consectetur adipisicing elit. Labore, officia?
    [two] => Obcaecati cupiditate, eveniet ducimus est ea sed.
    [three] => Iste assumenda, recusandae quasi.
    [four] => Voluptas sapiente eos atque, debitis.
    [five] => Quod, vel, ipsam.
)

Now in your view you can do this:

<?php foreach ($articles as $key => $title) { ?>
    <div class="style-<?= $key ?>"><?= $title ?></div>
<?php } ?>

edited Dec 25, 2018 at 11:15

answered Dec 25, 2018 at 10:32

Sherif Salah

2,1632 gold badges12 silver badges22 bronze badges

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

6 Comments

muasX Over a year ago

thanks for answer @Sherif but not that what I mean. I need to take data and display it to different style in my css style in each data

Sherif Salah Over a year ago

edit your question and give an example with your output and make it clear and i'll edit my answer after that.

muasX Over a year ago

i was edirt my question. please help

muasX Over a year ago

i tried your code but it give me 5 loops array. i just need 1 loops array and different value

Sherif Salah Over a year ago

What do you mean with a five loop array?, edit your question and add what you tried to do.

|

Collectives™ on Stack Overflow

Get data from db and display specific array index in view using codeigniter

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest