Making Database backed Websites

A short course on how to build websites, create databases, and then put the two together to run a website from a database.

Part One - Building a simple website by hand

Part Two - The SQL... Where do we put the data?

Resources

• MySQL
• Screenshot of a database browser

Part Three - The Return of the HyperText... Putting it all together

Examples

• Slide 3.4 - A PHP page (Source)
• Slide 3.6 - A simple PHP program (Source)
• Slide 3.7 - Another simple PHP program (Source)
• Slide 3.11 - if else elseif (Source)
• Slide 3.12 - while (Source)
• Slide 3.13 - for (Source)
• Slide 3.16 - Arrays (Source)
• Slide 3.18 - Getting data from a Form (Source)
  • Target script (Source)
• Slides 3.19-3.22 - Getting data from the Actors table (Source)
• Slide 3.32 - Adding data to the Actors table (Source)
  • Target script (Source)

Resources

• PHP
• PHP Documentation

© Peter Bagnall