Topics Covered

(1) How PHP files are written.

(2) Comments in PHP.

(3) Running PHP from the command line.

(4) Running PHP in an interactive mode.

(5) HTML and PHP, HTML in PHP code, multiple PHP codes, <BR> vs. \n.

(6) Using the backslash to print characters in output statements.

(7) Single vs. double quotes (problem with whitespace characters when using single quotes).

(8) Echo vs. print (unlike echo, print can’t be used for multiple prints separated by commas) vs. print_r.

(9) Text blocks and the HERE docs (<<< operator).

(10) Variables and named constants in PHP.

(11) One-dimensional arrays, processing them (including accessing the keys), foreach, range, count, etc.

(12) Associative (string indices/keys) and indexed (integral indices) arrays.

(13) Sorting one-dimensional arrays, sort, assort, ksort, rsort, arsort, krsort.

(14) Multi-dimensional arrays and processing them (including accessing the keys).

(15) The _SERVER array.

(16) Math functions: trig functions, fmod, rand, mt_rand, getrandmax, lcg_value, pow, log, etc.

(17) Multiple files: include and require.

(18) Forms (action, get vs. post methods, etc) and processing them.

(19) The _REQUEST, _GET, and _POST arrays, magic quotes, validating forms, functions isset, empty, strlen, is_numeric, stipslashes, addslashes.

(20) Sticky forms.

(21) Functions: non-value returning functions, value-returning function, value parameters, reference parameters, reference returning functions, array arguments, value default arguments, reference default arguments, recursive functions, dynamic function calls, using list for functions returning arrays, global, local and static variables, global named constants, using global and _GLOBALS, etc.

(22) Sending e-mail and HTML email (file uploads, sending emails with attachments, building email lists, forwarding email, etc, will be covered later).

Friday, Mar 2, 07: Continue with sending email, begin files (reading).

Monday, Mar 5, 07: Continue with files (reading; writing).

Wednesday, Mar 7, 07: Continue; Uploading files.

Friday, Mar 9, 07: Part 2 of Quiz 1. Continue with uploading files.

Monday, Mar 12, 07: Q1 of Assignment 5.

Wednesday, Mar 14, 07: ?

Friday, Mar 16, 07: Exam I.

Monday, Mar 26, 07: ?

Wednesday, Mar 28, 07: The date, time, gmdate, getdate, etc functions, Dir and file processing, operations and functions on files and directories.

Friday, Mar 30, 07: Continued; begin databases.

Mon, April 2, 07: Database continued; SQL and MySQL; logging in, changing the password, databases: creating, deleting, showing all databases, showing tables in the database; tables: creating, describing, inserting/updating/deleting records (rows) or fields, adding new columns at chosen locations, renaming columns or changing their types, renaming tables, dropping a column, dropping a table, dealing with null (setting a field to null, deleting null fields, updating them, queries involving null or not null), queries (selection records, whole table, fields, etc), ordered queries, using like, using relational operators (<, <=, >, >=, =), using logical operators (not !, and &&, or ||), MySQL continued: queries joining two tables, copying tables, creating table from another (i.e. some/all of the columns of the new table are from an old one), using MySQL to perform calculations, data types; math, string, and date functions; other functions.

Wednesday, April 4, 07: Continued.

Friday, April 6, 07: Continued.

Wednesday, April 11, 07:  Continued.

Friday, April 13, 07:  PHP and MySQL: connecting to MySQL from PHP, selecting a database, performing queries, processing queries (e.g. printing them), determining the number of rows (records) and the number of fields (columns), determining the fields (e.g. names), closing the MySQL connection.

Monday, April 16, 07:  Continued; counter  example (# of users, # of distinct users, # visitors this hour, # visitors today).

Wednesday, April 18, 07:  Continued; other topics.

Friday, April 20, 07:  Continued; other topics.

Remaining two weeks of classes: cookies. Then (not necessarily in order) Exam II, security, SSI commands, htaccess, sessions.