PHP while loop dynamic rowspan

Question

Consider a table for example

using these table I just wanted to print a table like these by adding rowspan to item id 1002.

Here is my PHP code

$temp_val = '';
$counter = 1;
$sql_sel = mysqli_query($con,"select * from item_table");
while($res_sel = mysqli_fetch_array($sql_sel)){

    if($temp_val == $res_sel['item_id']){
        $counter++;
        echo "<tr></tr>";
    }
    else{
       echo "<tr><td rowspan='".$counter."'>".$res_sel['item_id']."</td></tr>"; 
    }

    $temp_val = $res_sel['item_id'];

}
echo "</table>";

it's not correct, it's adding rowspan to item id 1003

You already asked this question here stackoverflow.com/questions/38816416/…. — trajchevska
– trajchevska, Commented Aug 8, 2016 at 7:29
maybe interesting? An answer I did - stackoverflow.com/questions/24028866/…. — Ryan Vincent
– Ryan Vincent, Commented Aug 8, 2016 at 11:08

Aman Rawat · Accepted Answer · 2016-08-08 07:39:36Z

You can't do like this because when you create the first row then you have to decide how much will this column can span so you have to get the count of the similar ids first to achieve it. I am just giving you and idea how it can work with and array like you database provides.

<?php

// Array comming from database
$databaseValues = [
    [
        'item_id'=>'1001',
        'item_color'=>'black',
    ],
    [
        'item_id'=>'1002',
        'item_color'=>'blue',
    ],
    [
        'item_id'=>'1002',
        'item_color'=>'green',
    ],
    [
        'item_id'=>'1003',
        'item_color'=>'red',
    ]
];

// Creating an array as per the need for the table
$arrayForTable = [];
foreach ($databaseValues as $databaseValue) {
    $temp = [];
    $temp['item_color'] = $databaseValue['item_color'];
    if(!isset($arrayForTable[$databaseValue['item_id']])){
        $arrayForTable[$databaseValue['item_id']] = [];
    }
    $arrayForTable[$databaseValue['item_id']][] = $temp;
}

?>

<!doctype html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>Document</title>
</head>
<body>

<table border="1">
    <?php foreach ($arrayForTable as $id=>$values) :
        foreach ($values as $key=>$value) :?>
    <tr>
        <?php if($key == 0) :?>
        <td rowspan="<?= count($values)?>"><?= $id?></td>
        <?php endif;?>
        <td><?= $value['item_color']?></td>
    </tr>
    <?php endforeach;
    endforeach; ?>
</table>

</body>
</html>

Hope this will be helpfull for you

Jason · Accepted Answer · 2016-08-08 07:29:25Z

0

You should switch the code inside else and if statement

answered Aug 8, 2016 at 7:29

Jason

3362 silver badges13 bronze badges

1 Comment

Jason Over a year ago

Try placing the code <td><td rowspan=... inside the if statement

Collectives™ on Stack Overflow

PHP while loop dynamic rowspan

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related