Reading data from a MySQL database into a HTML Table?

Question

So i am working on a project and need some advice.

I have a MySQL database that stores events, i know how to code this functionality in PHP but im just stuck of a few specifics.

As the project that I am creating is a timetable, the most important attributes are the day of the event, starting time and finishing time.

Once i have read this data from the MYSQL database using my PHP script, how do i go about inserting these events in to a html timetable?

Lets say i have record like below in my events table:

Event ID = 01
Event Day = Monday
Event Start = 12:00
Event End = 14:00

How would I then put that into a html table, bearing in mind that i may have mutiple events for a day?

Does the output format have to look like a regular calendar? Say google's calendar? — MJB
– MJB, Commented Apr 7, 2010 at 20:57
Are You going to use rowspan= or colspan= in HTML table cels? — Michas
– Michas, Commented Apr 7, 2010 at 21:03

ronaldosantana · Accepted Answer · 2010-04-07 21:02:06Z

2

You can mix your result from PHP into HTML code:

<table>
<?php
foreach ($results as result){
  echo '<tr><td>'.$result->field.'</td></tr>';
}
?>
</table>

answered Apr 7, 2010 at 21:02

ronaldosantana

5,2924 gold badges24 silver badges28 bronze badges

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

Comments

webbiedave · Accepted Answer · 2010-04-07 21:00:52Z

1

Are you having trouble determining how the PHP mixes with the HTML in this situation? If so:

<table>
<thead>
    <tr>
        <th>Event ID</th>
        <th>Event Day</th>
        <!-- etc... -->
    </tr>
</thead>
<tbody>
<?php while ($row = mysql_fetch_assoc($resultSet)) { ?>
    <tr>
        <td><!-- Event ID row data --></td>
        <td><!-- Event Day row data --></td>
        <!-- etc... -->
    </tr>    
<? } ?>
</tbody>
</table>

answered Apr 7, 2010 at 21:00

webbiedave

49k8 gold badges92 silver badges104 bronze badges

Comments

objectivesea · Accepted Answer · 2010-04-07 20:58:43Z

0

mysql_fetch_array($result) iterates the rows from your result. Just do something like this:

while ($row = mysql_fetch_array($result)) {
    echo $row['fieldname'];
}

The above code would display every item in the result's column named "fieldname". Use HTML to format the results however you like.

answered Apr 7, 2010 at 20:58

objectivesea

6071 gold badge7 silver badges22 bronze badges

Comments

nik · Accepted Answer · 2010-04-08 10:34:06Z

0

u can do something like this http://monket.net/wiki-v2/Image:MonketCalendarLarge.png

answered Apr 8, 2010 at 10:34

nik

3,6783 gold badges24 silver badges34 bronze badges

Comments

Anil Kumar · Accepted Answer · 2016-04-19 11:31:15Z

0

<table>
<?php while ($row = mysql_fetch_assoc($result)) {?>
   <tr>
      <td>
           Event ID = <?php $row['id'] ?> <br />
           Event Day = <?php $row['day]?> <br/>
           Event Start = <?php $row['start_date']?> <br/>
           Event End = <?php $row['end_date']?> 
      </td>
   </tr>
<?php } ?>

answered Apr 19, 2016 at 11:31

Anil Kumar

445 bronze badges

Collectives™ on Stack Overflow

Reading data from a MySQL database into a HTML Table?

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related