In this assignment the goal is to first write events into a SQLite3 database and then read these events from a SQLite3 database and display on the calendar the upcoming events.

Your PHP code in the file update_database.php, should process the data a user fills in on the create_event.html page. Then your program calendar2.php should display the events in the correct time slots and for the correct person(your code should call a function called get_events($person, $timestamp)).For example, consider that we set in the create_event.html the person to be Joe and the date to 5-20-2011 and time is set as 15:00. The user writes the event title as: "Soccer practice" and event message: "Bring the ball". Then the calendar2.php should show for 5-20-2011 in the Joe column in the 3:00pm slot: "Soccer practice: Bring the ball". You will also "upgrade" your calendar.php to display at the bottom of the calendar three buttons labeled: "previous", "now" and "next". The button labeled "previous" should move the start hour displayed back by 12 hours. The button labeled "next" should move the start hour forward by 12 hours. Finally the button labeled now should display the calendar with the current date and time

Directions for database

Directions for your database

Your database is called dbyourusername.

Your table should be called event_table

Your table should contain field time which is a timestamp it is going to be an integer with perhaps as many as 12 digits.

Your table should contain a field person which has character data.

Your table should contain fields event_title and event_message. Both contain character data max of perhaps 300 characters.

/p>

"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">

Simple Event

Joe

Joanna

Lil Cub

Date should be in format M-D-Y. For example 11-24-2015. Time is 24 hour time in format H:mm. For example 15:00.

Date		Time
Event title		Event message

(calendar.php)

print ''; ?>

Bruin Family Schedule for

'; else echo '"odd_row">'; echo '

"; echo ""; echo ""; echo ""; echo ""; $timestamp += 60 * 60; } ?>

	Joe	Joanna	Lil Cub
'. get_hour_string($timestamp) . "

(calendar.php picture)

Bruin Family Schedule for Mon, July 30, 2018, 5:01 pm Joanna Joe Lil Cub 5.00pm 6.00pm 7.00pm 8.00pm 9.00pm 10.00pm 11.00pm 12.00am 1.00am 2.00am 3.00am 4.00am 5.00am