Installation Software

Apache

• Home
• Download
• Windows Version

PHP

• Home
• Download
• Windows Version

MySQL

• Home
• Download
• Windows Version
• phpMyAdmin
  • Download phpMyAdmin
  • How to Configure phpMyAdmin
• GUI Tools
• MySQL ODBC Driver
  • Download

Pre-Packaged

• WampServer: Download
• USB Webserver: Download
• XAMPP: Download (78Mb!)
• The Uniform Server: Download

PHP Editors

• Eclipse PDT
  (PHP Development Tools for Eclipse)
  • Eclipse PDT
  • Download
• Komodo
  • Komodo
  • Komodo Edit
  • Download
• Dev PHP
  • Dev-PHP
  • Installer
  • Portable Version
  • Dev PHP Editor
• IDE.PHP
  • IDE.PHP

Course Material

Introductory Course

Course Files

• Friends of Ed
• Book Info
• Download

Advanced Course

Course Files

• Book Info
• Downloads
  • Scripts
  • SQL

References

• PHP Reference
  • String Handling
  • Search Bar
  • Regular Expressions
  • Operator Precedence
  • Magic Quotes
  • SQL Injection
  • Encryption Functions
    • sha1
    • Hash
• MySQL Notes
  • Auto Increment
  • Running MySQL in ANSI Mode
• GotAPI
• Time Zones
• Print vs Echo
• Example with fsockopen()

Books

• Sams Teach Yourself SQL in 10 Minutes
• SQL Pocket Guide
• Beginning PHP and MySQL
• MySQL/PHP Database Applications
• Beginning PHP5, Apache, and MySQL Web Development

PHP Reference: Beginner to Intermediate PHP5 is a useful reference for PHP. It can be purchased, but there is also a free PDF version

Notes

• Summary of XHTML
• Summary of CSS
• Installation of Apache/MySQL/PHP

 

Security Issues

• SQL Injection
  • SQL Injection Walkthrough
  • SQL injection (Wikipedia Article)
  • SQL Injection Attacks by Example
  • SQL Injection Cheat Sheet

• Email Injection
  • How to Prevent Email Injection in Your PHP Form to Mail Scripts
  • PHP Email Injection Step by Step
  • Mail Injection: Protect Yourself
  • Sending emails in PHP & email injection attacks