SQL with PHP

PHP and MySQL at the Movies

This tutorial takes you through building a web site to show details of Movies held in a database.

School of computing students at Edinburgh Napier University can complete this tutorial using the server socwebtech1.napier.ac.uk other students will need access to a server set up the database first.

Setting up a server from Amazon

• Choose an image and launch it

{{#ev:youtube|GwGKUMvZBTM}}

• Connect to your server with putty
  • Convert pem to ppk with puttygen
  • Connect with putty

{{#ev:youtube|G_Y-dfATSEs}}

• Install apache, mysql and php
  • Check each of these is running

{{#ev:youtube|vdN8E3q5t0I}}

Exploring the movie database

• Download and install the database http://sqlzoo.net/moviesm.sql and set up a user
• Examine the tables
• Some queries on movie, actor and casting

{{#ev:youtube|ObsGiXJ_7wU}}

PHP

• Hello world with php
  • Calculations
  • Debugging

{{#ev:youtube|EPPBdf0TybM}}

• Connect to a database and run a simple query

{{#ev:youtube|3TVBuE_pp-g}}

• Use a JOIN to get the director, show an image

{{#ev:youtube|9os4TYzWW7w}}

• Parameterise the page

{{#ev:youtube|Fu4hsq3EXXA}}

• Protect from SQL injection

{{#ev:youtube|znzvEBDeyhI}}

• Create the actor page
• Create the movie page
• Creating links