Connection established successfully!
This page is very similar to the multiple presenters view. However this one will pull ONE of the presenters from the presenters table in the database. It will display all of the columns for that presenter as an HTML table.
NOTE: For purposes of this example hard code one of your presenter_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 presenter_if 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. For example: WHERE presenter_city = "Des Moines", or WHERE presenter_st <> IA.
Each presenter has an Update link. The update link will call a form page that uses PHP to fill out the form for the chosen presenter. Notice how the link passes the presenter_id as a GET parameter on the URL in the href attribute of the hyperlink element.
Each presenter 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 presenter_id as a GET parameter on the URL in the href attribute of the hyperlink element.
| First Name | Last Name | City | State | Zip | Email Address | Update | Delete |
|---|