How to display results coming from database in 3 columns using php/mysql/html/css

Question

I am using PHP and MySQL to get data from database. My function is returning me array of objects. I am looping through them, and would like to display them in 3 columns. I have tried with CSS column-count property, but there is a problem that if number of results is even, results will be displayed in 2 columns, only if they are odd, they will be in 3 columns. I am using Bootstrap 3 also.

Here is my output code:

<div class="content">

    <div class="col-lg-12 offer">     
        <ul class="cpv">

        <?php foreach ($model as $data): ?>
            <li>
                <?= Html::img(Yii::getAlias('@web').'/img/170713.jpg', ['class' => 'img-responsive']) ?>
                <br> <?= $data->post->author?> <br>
                <a href="#"><span class="glyphicon glyphicon-chevron-up"></span></a> &nbsp;
                <a href="#"><span class="glyphicon glyphicon-chevron-down"></span> (<?= $count ?>)</a>
            </li>
        <?php endforeach ?>

        </ul>

    </div>

    <div class="clearfix"> </div>

</div>

Technologies that I am using are : PHP, MySQL, Yii2 PHP framework, HTML, CSS, Bootstrap 3.

How would you display data in 3 columns, without this problem that even number of results will be displayed in 2 columns instead of 3?

<table>, <div style="display: table-cell">, <div> with flexbox. Take your pick. — Halcyon
– Halcyon, Commented Feb 23, 2015 at 15:12
erm... what ? what is flexbox ? and where should my dynamic code go ? — black-room-boy
– black-room-boy, Commented Feb 23, 2015 at 19:24

hs19 · Accepted Answer · 2015-02-24 08:13:07Z

1

You can use element with bootstrap 3 class 'col-md-4' or 'col-lg-4'

answered Feb 24, 2015 at 8:13

hs19

1872 silver badges16 bronze badges

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

1 Comment

black-room-boy Over a year ago

Yes this work. I have added class="col-lg-4" to <li>. Thanks!

Collectives™ on Stack Overflow

How to display results coming from database in 3 columns using php/mysql/html/css

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related