Connection established successfully!

WDV341 Intro PHP

Event SELECT one Homework

View One Event

This page is very similar to the multiple presenters view. However this one will pull ONE of the events from the events table in the database. It will display all of the columns for that event as an HTML table.

NOTE: For purposes of this example hard code one of your event_ids into the WHERE clause.

The SQL SELECT query will use the WHERE clause to filter the selection to the row that has a specific event_id value. This allows us to select a specific record within the table of the database. The WHERE clause can also be used in variety of comparisons on all the columns in the table.

Each event has an Update link. The update link will call a form page that uses PHP to fill out the form for the chosen event. Notice how the link passes the event_id as a GET parameter on the URL in the href attribute of the hyperlink element.

Each event has a Delete link. The delete link will call a php page that will delete the selected record from the table. Notice how the link passes the event_id as a GET parameter on the URL in the href attribute of the hyperlink element.

0 records were found.

Event Name Event Description Presenter First Name Presenter Last Name Event Date (yyyy-mm-dd) Event Time (24h clock, hh:mm:ss) Update Delete