Database Access with MySQL

and Dynamic Content

For medium to large businesses, they will likely have a treasure trove of goods or services that need stored on a file of some sort. Depending on the type of data and the need to retrieve or store that information will drive how is best to maintain that data on a server. For inventories and such, a relational data model typically works best. One such relational model is MySQL. This example illustrates retrieveing data that is stored on a MySQL database. It is a form of a wedding reception seating database. All of the guests have been assigned to a specific table. This piece of the overall system is used for a guest to inquire what table they are at. The visitor is prompted to enter their last name and if on the database, their table assignment will be displayed. For purposes of this example, use some of the following names: Smith, Thompson, Marsh, Johnson, Stropes, or Ocasio-Cortez. Any other name will return that guest is not found. Entry of the name is case sensitive.