Difference between revisions of "SQL with PHP"
Jump to navigation
Jump to search
| Line 5: | Line 5: | ||
==Setting up a server from Amazon== | ==Setting up a server from Amazon== | ||
| − | *Choose | + | *Choose an image and launch it |
{{#ev:youtube|GwGKUMvZBTM}} | {{#ev:youtube|GwGKUMvZBTM}} | ||
*Connect to your server with putty | *Connect to your server with putty | ||
**Convert pem to ppk with puttygen | **Convert pem to ppk with puttygen | ||
| + | **Connect with putty | ||
{{#ev:youtube|G_Y-dfATSEs}} | {{#ev:youtube|G_Y-dfATSEs}} | ||
| − | |||
*Install apache, mysql and php | *Install apache, mysql and php | ||
**Check each of these is running | **Check each of these is running | ||
| − | {{#ev:youtube|}} | + | {{#ev:youtube|vdN8E3q5t0I}} |
==Exploring the movie database== | ==Exploring the movie database== | ||
Revision as of 17:14, 2 March 2016
Contents
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
- 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
