SQL with PHP
From SQLZoo
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