A6: PHP Connections

On This Page Overview Specifications Extra Credit Grading Criteria (20) What to Turn In Overview During this assignment, you will: Create an HTML page Connect to your project database using PHP Make simple queries using PHP Display the results of your query in your Web page Document your code Preparation If your HTML is rusty, you may want to review basic tags and tables before completing this assignment. Check the Links page for suggested tutorials on HTML. ^ top Specifications This assignment has several parts: Write an HTML page and include the following in your page: Opening and closing HTML tags Opening and closing header tags Opening and closing title tags with your project's name enclosed Opening and closing body tags At least one opening and closing heading tags (h1-6) with your projects name enclosed A brief description of your projects purpose using appropriate tags Create a PHP comment at the top of your page formatted like the following: /** * CIS-165PH Asn 6 * about.php * Purpose: Displays information about my project and * displays queries from my project database. * * @author Ed Parrish * @version 1.0 10/09/03 */ Remember that PHP comments must be enclosed within PHP tags. You will get no credit for this part if you use HTML comments. Query your project database using PHP and display the query data in an HTML table on your web page. You do not need to use loops or conditional statements for this assignment, but may if you want to work ahead. The name of the page must be about.php. Using the specified name makes grading easier. After you turn in the assignment, you can change the name of the page for your final project. Export your database design as SQL statements to a dbname.sql file. Name the file after your database and add the extension .sql to the name. Note that this is the default behavior for phpMyAdmin. Make sure of the following about your dbname.sql file: Does not contain a SQL 'USE' or 'CREATE DATABASE' statement Includes DROP TABLE IF EXISTS statements for all tables Is compatiable with MySQL version 4.0.X Note that phpMyAdmin supports all these behaviors if you check the correct checkboxes. Use the include file includes/dbconvars.php for all database connection arguments in your code. Even though you do not need to submit your dbconvars.php file, the instructor will use one to test your work. Failure to use a dbconvars.php file will result in a poor grade. Sample Operation For an example page, click here. ^ top Extra Credit The following are worth extra credit points: Add images or other artistic touches to your web page. (0 to 2 points) Make certain that your README.txt file lists any extra credit attempted. ^ top Grading Criteria The instructor will evaluate your assignment using the following criteria. Each criteria represents a specific achievement of your assignment and has a scoring guide. The scoring guide explains the possible scores you can receive. Some scoring guides have a list of indicators. These indicators are a sign of meeting, or a symptom of not meeting, the specific criterion. Note that a single indicator may not always be reliable or appropriate in a given context. However, as a group, they show the condition of meeting the criterion. For information on grading policies, including interpretation of scores, see the course Syllabus. Database Export 4: Database loads from dbname.sql file with no errors or warnings 2: Database loads from dbname.sql file but has errors or warnings, or 'drop table' code is missing 0: Does not load or dbname.sql file not submitted HTML Code 8: Demonstrates mastery of HTML Has extra features or demonstrates techniques beyond the assignment Meets all specifications (see above) with particularly elegant solutions No errors in the HTML code (both opening and closing tags used) 6: Has most of the functionality expected of the assignment Demonstrates many techniques from the lesson Meets many of the specifications (see above) May have 1-2 minor HTML errors. 4: Has some of the functionality expected of the assignment Demonstrates some techniques from the lesson Meets some of the specifications (see above) May have 3-5 minor errors 2: Serious problems but shows some effort and understanding Demonstrates few techniques from the lesson Meets few of the of the specifications (see above) Has many errors 0: No HTML file submitted or page does not display anything PHP Functionality 4: Demonstrates mastery of the assignment Has extra features or demonstrates techniques beyond the assignment Applies concepts from the lessons appropriately Meets all specifications (see above) with particularly elegant solutions 3: Has all the functionality expected of the assignment Demonstrates many techniques from the lesson Meets all specifications (see above) Implementation seems more complicated than necessary. May have one minor error 2: Has much of the functionality expected of the assignment Demonstrates some techniques from the lesson Meets all but one of the specifications (see above) Implementation seems excessively complicated. May have 2-3 minor errors 1: Serious functional problems but shows some effort and understanding Demonstrates few techniques from the lesson Meets few of the of the specifications (see above) Implementation seems very convoluted Has a major error or many minor errors 0: Does not execute PHP Documentation 2: Code is well-documented Name, date, and page description in page comment block Follows format for page comment block Proper use of whitespace and indenting 1: Code has minor documentation errors Has 1-2 documentation error 0: No apparent attempt at documentation README.txt File 2: README.txt file submitted with specified information included 1: README.txt submitted but some information was not included 0: No README.txt submitted Maximum Score: 20, plus extra credit ^ top What to Turn In Submit your assignment following the instructions for homework. Include the following items for grading: README.txt file about.php file dbname.sql file Any other file needed to make your page work properly Note: if you turn in a file with the wrong file name, you may receive no credit. You must submit all the files needed to make your assignment function properly. Do not assume that the instructors has any files unless explicitly stated by the instructor. Your assignment must work as submitted. Also, your dbname.sql file must create your database tables as submitted. Make sure your tables are in a loadable order. You may need to arrange your table order manually, so test your dbname.sql file before submitting it. In addition, do NOT have a USE statement or CREATE DATABASE statement in your dbname.sql file. ^ top Home | WebCT | Announcements | Course info | Expectations | Schedule Project | Help | FAQ's | HowTo's | Links Last Updated: March 29 2006 @16:08:30