==== Programming 101 using HTML, PHP and MySQL ====
== Basic HTML ==
* Editing plain text
* Tags, headers, structure
* Lists, headers
* Simple tables
* Syntax highlighters
* Links to other files, graphics, external links
== Basic webhosting ==
* Finding a free webhost with PHP and MySQL
* Creating an account
* Creating a test page
* Uploading to a webhost
== Basic PHP and HTML ==
* "Hello World"
* Time - system variables
* change colour of pages based on time or hit counter - logic and math
* Handling errors
* PHP documentation
== Basic Security ==
* .htaccess
* CAPTCHAs
* Why not to store your email address on a website
* Password management
* Protect your website with a password
* Change your passwords to secure values
== Design ==
* Choose a project
* User-interface mockup
* Imagining use-cases (contributor, editor, visitor)
== Basic HTML and PHP part 2 ==
* Tables
* Forms - create a response form
* mailto: action
* Displaying multiple variables - loops
* Loops and tables
* Introductory online programming communities
== Basic HTML and PHP part 2 ==
* Input validation - functions
* Using forms to populate PHP variables - strings
* write form contents to a file
* read form contents from a file
* hit counter (read, write)
* visitor tracker (read, write)
== Basic MySQL ==
* Terminology cheat sheet (rows, tables, columns, values)
* phpmyadmin
* Create a DB
* Create a table
* Update/create/destroy records
== Basic MySQL + PHP ==
* Connect to your table
* Display the contents of your value in your table
* Have your hit counter log in your database
* Have your form store the information in the database
== Basic Backups ==
* Backing up your program directories
* mysqldump
* downloading
* delete, then restore
== Putting it together ==
* Create an entry
* Display an entry
* Delete an entry
* Edit an entry
---------
Tools
* Web developer toolbar
* notepad++ (Windows)
* gedit (Linux) http://grigio.org/pimp_my_gedit_was_textmate_linux
Other mini applications
* What's your IP?
* Hit counter
* Calculator
Project Applications
* Recipe Database (read, write, access levels)
* Catalog tool (read, write, access levels)
* Exercise log (read, write, access levels)
* Simple forum (read, write, access levels)
More advanced
* 2-player chess (read, write, access levels, session, session lockout)
* Connect 4 (read, write, access levels, session, session lockout)
Additional subjects in HTML
* CSS
* icons (.ico, apple)
* robots.txt