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