O.K., now to the exercise:

1. We need to create a table inside the database. You can access your database, through your browser, using this link to "phpMyAdmin". You will need to use a "user_name" and "password" to access the MySQL database. Your username is the same as your login username ane I will give out your MySQL password in class.

Once you have logged in, click on your database's name, mine is called "efa" - it is the same name as my username. Once you do, the following screen following screen will appear.

Once you have created the table "Movie_table" add the fields as shown in the completed movie table.

2. Now that you have created a movie table, you will need to populate it with data. Here is my first work on creating an php insertion dialog script. "insert1.php". It takes the data but, for now, just outputs the results to the screen.

Here is the script running:

3. Here is the next version of our insert. It is actually updating the "movies" table inside our database. Here is the text of the script: "insert.php".

Here is the "new script" running:

4. Here is a "select" script that shows us everything, currently in the table. "select.php".

Here is the "new script" running:

 
earmstrongumhb.edu