Web Scripting (PHP)!!

Identify a scenario (phone guide, student records, inventory etc) and write command prompt codes and script PHP application to do the following:

Create a database

Create a table with at-least 7 fields

Insert at-least 30 records in your tables. Make sure you insert the records through both php program code, through the GUI interface - myPHPAdmin and php script.

Extract reports/data with at-least three different criteria (for example, if you create a phone book application, then extract the report/query by similar last names or similar first names, or similar zip codes etc.

Program Purpose 5 Legible Screen shots (LSS) Creating part of the database and tables and insertion of values through command prompt (include LSS).

Creating part of the database and tables and insertion of values through GUI interface prompt (include LSS).

Creating part of the database and tables and insertion of values through PHP script prompt (include LSS).

Display the queries through PHP script (include LSS).

Display the queries through command prompt (include LSS).