COAP:COAP-3110/week5: Difference between revisions

The educational technology and digital learning wiki
Jump to navigation Jump to search
mNo edit summary
Line 24: Line 24:
* Defining a new user with all privileges for a database
* Defining a new user with all privileges for a database


(2) PHP
(2) PHP (understand hw 2 code)


* Assignments
* Assignments (creating a variable)
* Associative arrays (e.g. $_POST)
* Function definitions and calls
* Function definitions and calls
* Super global variables
* Super global variables ($_POST)
* if-then-else clauses
* if-then-else clauses
* Foreach loops
* Foreach loops
* String concatenation that includes variables
* String concatenation that includes variables
* Finding information obtained with phpinfo();
* Finding information obtained with phpinfo();
* Finding a definition in the manual
* Finding a definition in the online manual
* Creating instances and using methods
* Creating instances and using methods


(3) Web servers
(3) Web servers


* Configuration files for Apache and PHP
* Configuration files for Apache and PHP (including finding "how to")
* Log files (where are they ?)
* Log files (where are they ?)

Revision as of 09:25, 12 September 2016

Monday part one

  • Guest lecture on security

Monday part two

  • TBA

Wednesday part one

  • Guest lecture on trust and reputation

Wednesday part two - Short mid term exam

The exam will on paper (probably) and last for 40 minutes. You are allowed to use the Internet. The difficulty will be finishing it in time !!

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 (understand hw 2 code)

  • Assignments (creating a variable)
  • Associative arrays (e.g. $_POST)
  • Function definitions and calls
  • Super global variables ($_POST)
  • if-then-else clauses
  • Foreach loops
  • String concatenation that includes variables
  • Finding information obtained with phpinfo();
  • Finding a definition in the online manual
  • Creating instances and using methods

(3) Web servers

  • Configuration files for Apache and PHP (including finding "how to")
  • Log files (where are they ?)