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?
解决方案
You can mix your result from PHP into HTML code:
foreach ($results as result){
echo '
'.$result->field.'';}
?>