COAP:COAP-3110/week5

Part one

• Guest lecture on trust and reputation

Short mid term exam

Exam topics:

(1) SQL

• Creation of simple tables with integer and string fields
• Inserting data into a single table with INSERT
• Retrieving data with a WHERE CLOSE
• Killing a table
• Defining a new user with all privileges for a database

(2) PHP

• Assignments
• Function definitions and calls
• Super global variables
• if-then-else clauses
• Foreach loops
• String concatenation that includes variables
• Finding information obtained with phpinfo();
• Finding a definition in the manual
• Creating instances and using methods

(3) Web servers

• Configuration files for Apache and PHP
• Log files (where are they ?)