CS2623: Server-Side Programming
SSP09: MySQL PHP

Objective:

• Connect to MySQL from PHP
• Work with MySQL databases using PHP
• Create, modify, and delete MySQL tables with PHP
• Use PHP to manipulate MySQL records
• Use PHP to retrieve database records

Points

• Full Credit: 40 Points
• Late/Resubmit Credit: 36 Points

Situation

Just a quick reminder to make the following adjustments in the PHP code as needed:

ChineseZodiac Database --> user#####a
Host --> localhost
User --> Apollo1 Login
Password --> Apollo1 Password

Need a Visual Reference?
The following are videos (Flash Files) of past student sites. In most of the cases the entire web page is not included in the screen shot, just enough to let you see the functionality of each project assignment.
Disclaimer: If you see something that is contradictory to our class assignments, please ask. Do not assume that since it is on the video that it is 100% correct.

• Discovery Project 8-1 (Note: This is a screenshot not a Flash file.): Feedback Form
  
• Discovery Project 8-2: Process Feedback
• Discover Project 8-3: View Feedback
• Discovery Project 8-4: WebForms - Feedback
• Discovery Project 8- 5: Footer Proverb

Specifications

• Discovery Project 8-1: Use the POST method. Also include a Clear (Reset) button. Although CSS would be preferable for formatting, a table may be used for ease and convenience. Do not include DTD info and save the file as inc_zodiac_feedback.php
  
• Discovery Project 8-2:
  • Again, db=user#####a (where user##### is replaced by your apollo login), host-->localhost, user-->apollo1 login, password-->apollo1 password
  • zodiacfeedback will remain as the name of the table since that did not change
  • message_date must be formatted as 2010-04-03 (year, month, day) and message_time must be formatted as 16:55:02 (hour, minute, seconds). Use the date () function. For additional information on formatting see p. 403 in the text and http://us3.php.net/manual/en/function.date.php
  • Do not include DTD info and save the file as inc_process_zodiac_feedback.php
• Discovery Project 8-3: Just be sure to use an "attractive" table. No ugly tables here!
          Do not include DTD info and save the file as inc_view_zodiac_feedback.php
  
• Discovery Project 8-4:
  • Text for describing the process of Zodiac Feedback (copy or create your own):
         This form allows site visitors to enter feedback about the Chinese Zodiac Web site, and stores the data in a database table.
  • Text for describing the process of retrieving records from the database (copy or write your own):
         This page displays all of the Zodiac Feedback records that are marked as public messages.
    
• Discovery Project 8-5: Consider commenting the code used with the text file as opposed to deleting it. It might be good reference for future web projects.

Recurring Specifications:

• XHTML must validate STRICT on all pages
• CSS must validate for CSS3 Standards
• Code must be easy to read and properly indented.
• Documentation must be appropriate and meaningful.
• Meta Tags including the following must be included on all pages. The content must be revised to information that is meaningful to the page.

  <meta name="author" content="Your Name" />
  <meta name="revised" content="12/18/2015" />
  <meta name="description" content="Description of web page" />
  <meta name="keywords" content="Add appropriate key words" />

• Tables may not be used for general layout and only when specifically indicated in an assignment.
• JavaScript may not be used in assignments unless specifically indicated. One exception is the date late modified at the bottom of the web page.

Assignment Submission

• Follow the Assignment Submission requirements outlined in http://apollo.occc.edu/chyde/CS2623/Handouts/CS2623_CodingStandards.htm.
• Upload the files/folder to your apollo1 account.
• View the web page/s in Firefox, Chrome, Safari, and Internet Explorer.
• Revalidate and double check to make sure all items are visible from all computers.
• Note: The include files will not validate because they do not have complete DTD's and tags. However, index.php when it is displaying ANY and ALL of the dynamic content must validate.
  
• Submit the URL of your web page in the LMS.
• The URL will be
  • http://apollo1.occc.edu/user#####/ChineseZodiac/index.php
• Submission links must open web page in a new window (not inside of MoodleRooms) and display the page (and not a directory)
• XHTML code must validate STRICT and CSS must also validate for CSS3 or earlier. The Web Developer Toolbar in Firefox will be used for grading.
• Assignments not meeting the previous requirements (opening in a new window and XHTML/CSS Validation) cannot be graded. If it is still within the late/resubmit period, they can be re-uploaded and resubmitted (10% penalty). If it is after the final deadline, the work can no longer be submitted.