Showing data correctly in html table with php

Question

Hello this table pulls data from a database.

<h2>Weekly appointment list</h2>

      <table class="table table-bordered table-hover">
        <thead>

          <tr>
            <th>Week Day</th>
            <th>Customers</th>
            <th>Selected service</th>
            <th>Time</th>
          </tr>
        </thead>

        <tbody>
          <tr>
            <td>Monday</td>


                <?php 
                    $date = date('Y-m-d', strtotime("this Monday"));
                    $sql = "SELECT * FROM appointment WHERE weekday = '$date'";
                    $query = mysqli_query($db, $sql);
                    $numRows = mysqli_num_rows($query);

                    if ($numRows > 0) {
                    while ($row = mysqli_fetch_array($query)) { ?>

                        <td><?php echo $row['user_name'] ?></td>
                        <td><?php echo $row['service'] ?></td>
                        <td><?php echo $row['time'] ?></td>

                    <?php } 
                        }
                     ?>
            </tr>

        </tbody>

But the problem is when i have two users from echo $row['user_name'] //user x, user y the table rows break and show something like this: image link. See the the table row is broken. I want to show this way:expected table structure. All customers are shown on the particular day row in customers column. How to fix my code or the way of representation. Thanks in advance.

score 2 · Accepted Answer · answered Apr 15 '15 at 16:31

2

change your sql query to group concat username,service and time.

 $sql ="SELECT group_concat(user_name) as user_name,group_concat(service) as service ,group_concat(time) as time FROM appointment WHERE weekday = '$date'";

This query will return one row with all the user and service information in one row.

answered Apr 15 '15 at 16:31

akr

739
4
15

Excellent. This is something i was looking for. Thank you – facebook-1422110434758753 Apr 15 '15 at 16:49

score 0 · Answer 2 · edited May 23 '17 at 11:50

0

you want to combine something like this

With something like this:

$res  = mysql_query(/**/);
$rows = array();
while($row = mysql_fetch_assoc($res)){
  array_push($rows, $row);
}

Let me know if you struggle.

edited May 23 '17 at 11:50

Community

1
1

answered Apr 15 '15 at 16:24

n00bstacker

323
2
6
23

This does not fix/address the OPs issue.All you are doing is saving all the returned rows into a php array. OP wants to group all data in a comma list by day. – Sean Apr 15 '15 at 16:36
@Sean Yes i want the user names in comma separated list. Thanks – facebook-1422110434758753 Apr 15 '15 at 16:44
@Sean Combine that with the link I posted and yes it does. – n00bstacker Apr 15 '15 at 16:53

Showing data correctly in html table with php

2 Answers2