PHP Assignments 9-10
MySQL and PHP

9. Write a PHP script that uses the appropriate PHP-MySQL interface(odbc) commands to connect to the database called movies on the server gwiggins-old.mc.edu. You are to use the login "phpuser" and the password "csc231phpf03" to make the connection. You will have to test your script from on campus scince I will not ask that you be given firewall access due to security reasons.  After successful connection to the databse (movies) you are to list all of the contents in at least two of the tables. You are also  to have your PHP script answer the following queries:

1. List all of the movies reviewed by  the critic "Glenn Wiggins"
2. List all of the movies produced by "Pixarc" company.
3. List the critics that reviewed a "computer animation".

10. Insert yourself as a critic in the critic table and insert a critique of a movie that you reviewed. You can make up real or 'bogus' info to insert, but you must use your real name. This is how I will check to see if it worked for you. You should design your script so that it will prompt(form elements)the user for the fields to be entered  in the tables. The values entered in the form elements will be used to insert into the appropriate movie database tables.  Additional database structure and connection information will be given in class.

Please note the following URLs contain the same information on connection and data source creation:
http://php.weblogs.com/odbc
http://www.briansooyco.com/DynamicLink/DSN_setup/DSN_setup.htm
http://www.mathworks.com/access/helpdesk/help/toolbox/database/install7.shtml