Server-Side Programming
Test 2 Review: PHP and MySQL
(Chapters 4-6, Appendix E)

There will be 30 Scantron type questions (multiple choice/true-false) worth 2 points each for a total of 60 points. They will be taken from the review questions used for the weekly quiz plus questions regarding debugging (Hint: The questions on the handout "might" prove very informative.) The coding section will be worth 40 points. The total point value for the test is 100 points. 

Notes may be used during the test. The notes may be no larger than one 3”x 5” note card (or sheet of paper of equivalent size).  The notes must be student prepared (hand written or word processed) It may not be a photocopy of class handouts, portions of the text, or similar items. It is hoped that by allowing notes it will help students to organize the material and determine the most important concepts. The notes must be submitted with the test and will not be returned to the student.

There will be a 25 point deduction if the notes used during the test do not meet the above specifications.

Hint: Happy St. Patrick's Day! (Just a wee bit late!) - Gotta' love the GREEN!

Coding Content
Chapter 4
Path and name of current script
Process form data using GET and using POST
Handle ',", and NULL values in user input
addslashes() and stripslashes()
empty( ) and isset ( ) functions
is_*( ) functions for validation
Advanced escaping in XHTML
Redisplay a form including user's input if valid or a blank field if user's input is not valid
Creating an all-in-one form
Text hyperlinks for navigation using GET
Code and utilize URL tokens
Using form image button for navigation
---- Mail will not be included in the coding
Chapter 5
Retrieve and change file permissions
Open, close, change, read, and create an array of directories
Determine if a file exists, can be read, can be written, or can be executed
Determine a file's size, type and the last time it was modified
Upload and download files
Reading and writing entire files
Reading and writing files incrementally
Displaying the contents of a file on a web page
Open and close filestreams
Create an image "button" and accompanying code such that a form will be submitted when the image is clicked.
Move, copy, and delete files and directories
Chapter 6
Array Functions
  • array_shift() and array_unshift()
  • array_push() and array_pop()
  • explode()
  • array_splice() and array_slice()
  • unset()
  • array_values()
  • array_unique()
  • in_array()
  • array_search()
  • array_key_exists()
  • sort() , rsort()
  • natcasesort(), natsort()
  • krsort(), ksort()
  • arsort(), asort()
  • array_merge()
  • array_diff(), array_intersect()
Combining Arrays
Iterating through arrays and retrieving elements
Creating and using arrays including multidimensional arrays (both indexed and associative)
Appendix E
highlight_file(), highlight_string()

Setting error_reporting levels