Home
Videos uploaded by user “Phil Adams”
1. Python intro - shell vs IDLE
 
01:31
Quick intro into using Python, explaining the difference between Shell and IDLE.
Views: 3708 Phil Adams
Intro - what a dynamic one-page site will look like
 
04:26
A quick overview of the finished product of what we will be creating in this series of videos. The website is a dynamic site created using PHP and mySQL, and has one shell page with smaller pages being loaded dynamically into the main content area, effectively making it a one-page site. This makes it easy to maintain and update.
Views: 89698 Phil Adams
Using CSS to put a background image into a div tag in Dreamweaver CS3
 
02:41
Tutorial on putting images into the background of a div tag, using CSS in Dreamweaver CS3.
Views: 21864 Phil Adams
20. Creating a menu-based program using functions in Python
 
07:43
Quick example of how to create a menu system using functions in Python
Views: 22298 Phil Adams
6. Creating dynamic links
 
05:14
In this video we convert our list of categories in our navigation bar into dynamic links, sending the ID of the category selected through to another page using the GET method. Files can be found at: https://www.dropbox.com/sh/jbe5ai9wkn0pofq/AAAYA4SGHfDYCWHjZhggLaj1a?dl=0
Views: 18249 Phil Adams
Using normal maps to texture terrain in Unity
 
05:02
In this video we use Crazy Bump to generate a normal map for our terrain texture, and then use a custom material to create a realistic texture effect.
Views: 10111 Phil Adams
3. Using php include for common content
 
06:50
In this series of tutorials I will show how to create a dynamic, database-driven website with a secure admin section for maintaining content. In this video we place content that will be appearing on all pages in the website into separate files, then use the php command 'include' to display the content in our template. Files can be found at: https://www.dropbox.com/sh/jbe5ai9wkn0pofq/AAAYA4SGHfDYCWHjZhggLaj1a?dl=0
Views: 22478 Phil Adams
Adding audio to your Unity scene
 
03:12
In this video we add an audio source to a scene in Unity.
Views: 2555 Phil Adams
Importing Blender objects into Unity
 
03:55
In this video we export our textured Blender object as an fbx file, then import it into Unity, applying textures to each material.
Views: 19170 Phil Adams
Creating a box and whisker graph in Excel 2013
 
06:03
How to create a box and whisker graph in Excel 2013, using a stacked bar chart and error bars.
Views: 6856 Phil Adams
15. Password protecting a php page using SESSION
 
05:13
In this video we look at how to password protect all admin pages using the in-built $_SESSION array in php. Files can be found at: https://www.dropbox.com/sh/jbe5ai9wkn0pofq/AAAYA4SGHfDYCWHjZhggLaj1a?dl=0
Views: 7077 Phil Adams
4. Connecting a php page to a MySQL database
 
05:22
In this series of tutorials I will show how to create a dynamic, database-driven website with a secure admin section for maintaining content. In this tutorial we connect our php template to our MySQL database. Files can be found at: https://www.dropbox.com/sh/jbe5ai9wkn0pofq/AAAYA4SGHfDYCWHjZhggLaj1a?dl=0
Views: 17780 Phil Adams
11. Setting up a database to support an encrypted admin section
 
07:14
In this video we look at basic password encryption and set up a table in a mySQL database to support a password-protected admin section. Files can be found at: https://www.dropbox.com/sh/jbe5ai9wkn0pofq/AAAYA4SGHfDYCWHjZhggLaj1a?dl=0
Views: 6824 Phil Adams
5. Creating our navigation bar - displaying multiple results from a database query
 
08:38
In this video we run a query on our MySQL database, selecting all of the categories in the category table, and display them in our navigation bar using a do while loop. Files can be found at: https://www.dropbox.com/sh/jbe5ai9wkn0pofq/AAAYA4SGHfDYCWHjZhggLaj1a?dl=0
Views: 18969 Phil Adams
8. Displaying multiple records from an SQL query on a PHP page
 
04:55
Tutorial on how to query a mySQL database from PHP, then using do while loop to display multiple results.
Views: 22004 Phil Adams
Tkinter labels with textvariables
 
04:57
Introduction on how to set the value of a label using Python's Tkinter, and how to change that value by using buttons and functions.
Views: 4179 Phil Adams
Adding a background gradient to a webpage using CSS
 
05:49
This tutorial shows a way of creating a gradient image in Photoshop CS3, then adding it as a tiling background image in a webpage using CSS in Dreamweaver CS3.
Views: 10997 Phil Adams
13. Password protecting a webpage with PHP
 
03:48
In the video we continue to develop our admin section, password-protecting our pages by checking if the admin session has been set, and redirecting the browser to another page if not. Files can be found at: https://www.dropbox.com/sh/jbe5ai9wkn0pofq/AAAYA4SGHfDYCWHjZhggLaj1a?dl=0
Views: 3747 Phil Adams
How to create a basic search bar using PHP and a mySQL database
 
14:08
** Please note that this is quite out of date! A much better video can be found at https://www.youtube.com/watch?v=T_M1ZZKkYlE , which uses phonetic sound matching so is a more thorough search engine than the one here ** Just a quick tutorial on how to create a very basic search bar using PHP to run queries on a mySQL database.
Views: 108112 Phil Adams
MySQL - multiple tables
 
10:08
In this video we look at situations where you will need multiple tables in a MySQL database, how to link them, and what the SQL will look like to select data from them.
Views: 13970 Phil Adams
24. Adding a list to a list in Python
 
03:22
In this video we look at how to take multiple user input, assign it to a list, and then append that list into another list.
Views: 5088 Phil Adams
1. How to create a more advanced search engine for your website
 
03:19
Using php and MySQL, we create a search engine for our own website that searches on what words sound like, not just looking for exact matches. We use the php metaphone function. This video is the first of a series of 4, walking you through how to create the search engine.
Views: 8320 Phil Adams
Seamless, fading photo banner in Flash CS3
 
08:12
An addition to an earlier tutorial on creating an animated Flash banner with images fading in and out. I was asked how to finish it off, and make it seamless, so here's my effort.
Views: 12975 Phil Adams
2. MySQL-Creating tables and adding content in phpmyadmin
 
07:35
In this series of tutorials I will show how to create a dynamic, database-driven website with a secure admin section for maintaining content. In this video we look at how to create tables in a MySQL database using phpmyadmin. We create one and add content manually, and also import another. Files can be found at: https://www.dropbox.com/sh/jbe5ai9wkn0pofq/AAAYA4SGHfDYCWHjZhggLaj1a?dl=0
Views: 36968 Phil Adams
Creating a dynamic, database-driven dropdown menu
 
08:12
Shows how to create a dynamic, database-driven dropdown menu in Dreamweaver CS3 by using a mySQL database and php. Uses a do while loop and is basically an extension of the Spry Menu bar in Dreamweaver.
Views: 51678 Phil Adams
Using the extrude tool in Blender
 
01:45
Demonstration of how to extrude faces in Blender.
Views: 1651 Phil Adams
Applying a terrain texture in Unity
 
02:34
Demonstrates how to apply a texture to your terrain, as well as how to remove the shine that sometimes occurs.
Views: 1929 Phil Adams
Creating a two-column layout using CSS in Dreamweaver CS3
 
06:11
How to use CSS to create a two-column layout in Dreamweaver CS3. Uses floating, and also shows how to clear the floats of each column so a footer would sit neatly beneath the columns.
Views: 5673 Phil Adams
Using option menus in Tkinter
 
03:06
How to populate an option menu from a list in Python's Tkinter library.
Views: 5383 Phil Adams
9. Creating dynamic links using PHP
 
10:14
Tutorial on how to create dynamic links that generate different content on a second page. Uses PHP, SQL and a mySQL database.
Views: 25614 Phil Adams
Using Tkinter's OptionMenu to interact with objects
 
08:49
In this video we use an OptionMenu to display the names of objects. When one is selected, a button will run a function that then finds that object and displays more information about it. This is a simple tutorial covering the interactions between Tkinter's OptionMenu, Button, Label and objects.
Views: 4552 Phil Adams
3. How to create a more advanced search engine using php, mysql and phonic matching
 
13:20
In this video we create a search form, then encode the search criteria phonetically using php's metaphone function. We then query the database for phonic matches. Finally, we enable multi-word searching, looking for whole matches. If there is not a match for the whole string, we explode the string into individual words and search the database for the phonic match for each.
Views: 18694 Phil Adams
8. Creating a dynamic query
 
13:04
In this video we create a category page that takes the ID sent from the previous page using the GET method and adds it to an SQL query, creating a dynamic query. Files can be found at: https://www.dropbox.com/sh/jbe5ai9wkn0pofq/AAAYA4SGHfDYCWHjZhggLaj1a?dl=0
Views: 12313 Phil Adams
Creating a dropdown menu in Dreamweaver CS3 with spry
 
05:40
Short tutorial covering how to create and modify a basic dropdown menu in Dreamweaver CS3 using spry. Does not go into how to format the appearance using CSS however.
Views: 3398 Phil Adams
Determining the nature of turning points
 
04:41
Here we use the second derivative test to show whether a turning point is a maximum or minimum
Views: 2367 Phil Adams
13. Logging in to our admin section
 
14:33
In this video we run a simple query on our admin table, checking whether the username and password entered in the login form matches that in our database. If so, the control panel will be displayed, if not the user is redirected to another page. When the login is successful a new session will be set, and if the session is set then the control panel will be displayed. Files can be found at: https://www.dropbox.com/sh/jbe5ai9wkn0pofq/AAAYA4SGHfDYCWHjZhggLaj1a?dl=0
Views: 7722 Phil Adams
7. Creating a one-page website
 
14:36
We look at how to create a website based around one page, which acts as a container. Other pages/content are loaded into the main content area dynamically, depending on what links the user selects. Files can be found at https://www.dropbox.com/sh/jbe5ai9wkn0pofq/AAAYA4SGHfDYCWHjZhggLaj1a?dl=0
Views: 16062 Phil Adams
St Andrew's College - 2012 national mixed touch champions
 
03:49
A few highlights of St Andrew's College winning the 2012 Mixed grade at the Secondary school touch nationals, beating St Peter's Cambridge 7-5.
Views: 629 Phil Adams
How to run basic SQL select queries on a MySQL database
 
05:56
We look at select queries, including * to select everything, only selecting some columns, ordering our results, and filtering by using WHERE.
Views: 1694 Phil Adams
8. Nested if statements in Python
 
03:55
Here we look at how we can use nested if statements in Python. This enables us to test multiple conditions and return a variety of output.
Views: 1185 Phil Adams
4. Entering records into a mySQL table using phpMyAdmin
 
03:28
Short tutorial for my ICT classes about how to use phpMyAdmin to add records to a mySQL table.
Views: 14398 Phil Adams
Using buttons to control the timeline in Flash CS3 with Actionscript 3.0
 
08:05
A tutorial answering a student's question about how to jump to the next photo in an animated photo banner. I put a button on it and used actions and frame labels.
Views: 11545 Phil Adams
Finding x and y intercepts of parabolas - 2
 
04:10
Second example of how to find x and y intercepts for a parabola, where the coordinates are not integers.
Views: 1196 Phil Adams
2. How to add content and metaphone equivalent to our database
 
13:48
In this video we set up a web form that will add content to our database, but also will create the phonetic equivalent using php's metaphone function.This sets up our database ready for the search engine.
Views: 2353 Phil Adams
Adding trees with colliders to Unity
 
05:57
In this video we look at how to add colliders to trees and then set them up as prefabs so we can place them easily on our terrain.
Views: 1361 Phil Adams
Creating a web form using Dreamweaver
 
06:14
In this tutorial I cover how to create a basic contact form in Dreamweaver. The follow-up tutorial will show how to then create a php page that dynamically displays the content of the form on the next page and send an email containing that information.
Views: 11899 Phil Adams
6. Connecting a PHP webpage to a mySQL database
 
02:46
Short tutorial on the PHP connection string used to connect to a mySQL database.
Views: 16575 Phil Adams
Applying normal maps to objects in Unity
 
09:12
In this video we look at how to create textures with depth and shading using normal maps. We start with a texture, then create our own greyscale map in Photoshop and use Unity to generate a normal map from it.
Views: 1438 Phil Adams
Formatting links using CSS in Dreamweaver CS3
 
05:01
Tutorial showing how you can use CSS to format links differently within a webpage.
Views: 702 Phil Adams