Server-Side Programming
Test 1 Review: PHP and MySQL
(Chapters 1-3, Appendices B and C)

The test will be done in MoodleRooms and will be worth a total of 100 points.

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 maybe a few questions related to the material in the appendices. The theory portion must be completed before the coding section becomes available. (Time Allotted: 60 Minutes).

The coding section will have 10 questions worth a total of 40 points. (Time Allotted: 90 Minutes)

The SCS Assistant will type in the password for the Theory portion of the test. When you have finished and submitted that, then find the SCS Assistant and ask that he/she type in the password for the Coding portion of the test. The Coding test must be begun immediately (within 10 minutes) after the Theory portion is completed.

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 to the SCS Assistant at the end of 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.

Think blue! Might want to pay special attention to these items! Hint!

Coding Content
Chapter 1
p. 69: 1-2
p. 70: 1-3
p. 70: 1-5
p. 70: 1-6
Chapter 2
p. 116: 2-1
p. 117: 2-2
pp. 118-119: 2-4
       (You may be asked to create from scratch not just modify)
pp. 119-120: 2-5
Variables
       Local | global, ByReference | ByValue
Functions
        Creating and calling a function
Flow Control
        Conditional operator, If, if-else, if-elseif, nested if, or switch statement
For Statements
for or foreach statement
Loops
while or do-while loop
Includes
Chapter 3
pp. 175-177: 3-1
pp. 177-178: 3-2
pp.178-179: 3-3
p. 180: 3-4 (String functions MUST be used)

Formatting
sprintf() printf() formatting alignment

Text Strings
concatenation, escape, complex string syntax
String Functions
  • strlen()
  • str_word_count()
  • strtoupper()
  • strtolower()
  • ucfirst()
  • lcfirst()
  • ucwords()
  • trim()
  • ltrim()
  • rtrim()
  • substr()
  • md5()
  • strrev()
  • str_shuffle()
  • strpos()
  • str_replace()
  • strireplace()
  • substrreplace()
  • strtok()
  • str_split()
  • explode()
  • implode()
  • strcmp()
  • strcasecmp()
  • similar_text()
  • levenshtein()
  • metaphone()
  • soundex()
REGEX - Guaranteed there will be a question to create a Regular Expression
  • preg_match()
  • preg_replace()
  • metacharacters
  • anchors
  • quantifiers
  • subexpressions
  • character classes
  • escape sequences