Liron Paryente Liron Paryente - 10 months ago 56
MySQL Question

echo PHP array with while loop

I'm using a while loop to echo a PHP array :

$connect = mysqli_connect("localhost", "user", "password", "db");
$sql = "SELECT * FROM table ORDER BY RAND() LIMIT 0,4";
$result = mysqli_query($connect, $sql);

if(mysqli_num_rows($result) > 0)
<div class="container">
<div class="row">
<h2 class="bold">title</h2>
<hr> ';

while($row = mysqli_fetch_array($result))
<div class="col-sm-3 col-md-3 col-md-push-3">
<div class="portfolio-wrapper">
<div class="portfolio-single">
<div class="portfolio-thumb">
<a href="'.$row['link']." target="_blank"> <img src="'.$row['image'].'" class="img-responsive" alt="'.$row['alt']."></a>
<div class="portfolio-info" dir="rtl">
<a href="'.$row['link2']." target="_self"><h2> </h2>



This code works fine for me but the problem is that i need to echo 4 different

for example :

first will be: <div class="col-sm-3 col-md-3 col-md-push-9">
second: <div class="col-sm-3 col-md-3 col-md-push-3">
third: <div class="col-sm-3 col-md-3 col-md-pull-3">
last: <div class="col-sm-3 col-md-3 col-md-pull-9">

any ideas how can i accomplish this structure using a while loop ?

Answer Source

Use a counter, and put your classes into an array like this:

$classes = [
    "col-sm-3 col-md-3 col-md-push-9",
    "col-sm-3 col-md-3 col-md-push-3",
    "col-sm-3 col-md-3 col-md-pull-3",
    "col-sm-3 col-md-3 col-md-pull-9"

$i = 0;
while($row = mysqli_fetch_array($result)) {
    if ($i > 3) {
        $i = 0;
    <div class="<?php echo $classes[$i]; ?>">
        Your content comes here


This is resets the counter, if there is no index like that in the array. Your script assumes, that you will get always 4 rows.