COM372
Notes on Readings
Spring 2010
PHP and MySQL Web Development, 4
th
Edition,
by Luke Welling and Laura Thomson,
Addison-Wesley. 2009.
Dr. Logan
|
Course Website
|
Syllabus
Week
Chapter
Pages
Title (Link)
I. Using PHP
1
1
13-57
PHP Crash Course
2
2
59-80
Storing and Retrieving Data
3
81-106
Using Arrays
3
4
107-131
String Manipulation & Regular Expressions
|
Quick Reference
5
133-158
Reusing Code and Writing Functions
4
6
159-191
Object-Oriented PHP
7
193-203
Error and Exception Handling
II. Using MySQL
4
8
207-218
Designing Your Web Database
5
9
219-241
Creating Your Web Database
10
243-265
Working with Your MySQL Database
6
11
267-285
Accessing Your MySQL Database from the Web with PHP
12
287-309
Advanced MySQL Administration
13
311-323
Advanced MySQL Programming
III. E-commerce and Security
7
14
327-339
Running an E-commerce Site
15
341-359
E-commerce Security Issues
16
361-390
Web Application Security
8
17
391-408
Implementing Authentication with PHP and MySQL
18
409-428
Implementing Secure Transactions with PHP and MySQL
IV. Advanced PHP Techniques
8
19
431-450
Interacting with the File System and the Server
20
451-468
Using Network and Protocol Functions
9
21
469-481
Managing the Date and Time
22
483-508
Generating Images
23
509-524
Using Session Control in PHP
24
525-532
Other Useful Features
V. Building Practical PHP and MySQL Projects
10
25
535-549
Using PHP and MySQL for Large Projects
26
551-567
DeBugging
11
27
569-606
Building User Authentication and Personalization
28
607-650
Building a Shopping Cart
*We will cover these chapters selectively, as time permits.
12
29
651-686
*Building a Web-Based Email Service
30
687-740
*Building a Mailing List Manager
31
741-770
*Building Web Forums
13
32
771-805
*Generating Personalized PDF Documents
33
807-854
*Connecting to Web Services with XML and SOAP
34
855-885
*Building Web 2.0 Applications with Ajax