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 a server and fire it up

<iframe width="420" height="315" src="https://www.youtube.com/embed/GwGKUMvZBTM" frameborder="0" allowfullscreen></iframe>

• Connect to your server with putty
  • Convert pem to ppk with puttygen
  • Connect with putty
• Install apache, mysql and php
  • Check each of these is running

Exploring the movie database

• Download and install the database, set up users
• Examine the tables
• Some queries on movie, actor and casting

PHP

• Hello world with php
  • Calculations
  • Debugging
• Connect to a database and run a simple query
• Connect to a database and get a list of results
• Create the actor page
• Create the movie page
• Creating links