CST463 · S7 CSE

Module 4 — PHP, MySQL and Sessions

Reference material for this module, arranged in teaching order. These are the resources used when this module was taught; the classroom posts for the current cohort go up as we cover it. Every link below is public — follow it directly.

Open the classroom → Back to CST463 hub

Reference material for this module

Advanced PHP form processing, cookies, sessions, MySQL integration, CRUD operations and dynamic content.

Form processing on the server

PHP Form Processing
- 🔗 PHP Form Handling
- 🔗 php_samples/php_form_samples
- 🔗 CST-463-Web-Programming/php_self_submission_concept
- 🔗 PHP Form Validation
Submit button vs normal button, div vs span
- 🔗 CST-463-Web-Programming/input_type_vs_button.md
- 🔗 CST-463-Web-Programming/Inline vs Block-level_div_vs_span.md

Remembering the user — cookies and sessions

PHP Cookie and Session Management
- 🔗 PHP Cookies
- 🔗 PHP time() Function
- 🔗 HTTP headers — cookies | MDN
- 🔗 HTTP headers — redirects | MDN
- 🔗 cookie_sample1.php — worked example
- 🔗 PHP Sessions
- 📄 php_cookie_management.pdf
- 📄 Read on the web — Cookie management lifecycle
Post/Redirect/Get — avoiding the double submit
- 🔗 Post/Redirect/Get (PRG) Design Pattern — GeeksforGeeks

Objects and errors — what PDO is built on

PHP OOP and exceptions
- 🔗 PHP OOP Classes and Objects
- 🔗 PHP OOP Class Constants
- 🔗 PHP Exceptions

Talking to MySQL from PHP

PHP — MySQL
PDO — error modes and the statement class
CRUD — the worked student example