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: 4217 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: 21949 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: 92311 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: 27003 Phil Adams
12. Setting up the admin section of a website
 
06:04
In this video we set up the page structure for a simple admin section in a database-driven website, using PHP and mySQL. Files can be found at: https://www.dropbox.com/sh/jbe5ai9wkn0pofq/AAAYA4SGHfDYCWHjZhggLaj1a?dl=0
Views: 7667 Phil Adams
Texturing objects in Blender
 
04:22
In this video we apply multiple textures to the same object, and prepare the materials for export to Unity.
Views: 2884 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: 19227 Phil Adams
Adding audio to your Unity scene
 
03:12
In this video we add an audio source to a scene in Unity.
Views: 2783 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: 7338 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: 19710 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: 14610 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: 10644 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: 7373 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: 18561 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: 5647 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: 4385 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: 5900 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: 20000 Phil Adams
Using the extrude tool in Blender
 
01:45
Demonstration of how to extrude faces in Blender.
Views: 2499 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: 23052 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: 11588 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: 15573 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: 2658 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: 110115 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: 52264 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: 12701 Phil Adams
12a. Deleting records and using sessions
 
04:27
Part 1 of a 3 part tutorial on how to select a record to delete from a mySQL database table, using PHP. This tutorial uses PHP to display all records, then you can select the one to delete. Part 2 has a confirmation page, so uses sessions to store information. Part 3 runs the actual delete SQL query.
Views: 4761 Phil Adams
3. Basic SQL query on a mySQL table
 
03:14
Short tutorial for my ICT classes about how to do a first, basic, query using SQL. phpMyAdmin is the interface.
Views: 7194 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: 25928 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: 19471 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: 5600 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: 37892 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: 1347 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: 22424 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: 636 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: 1908 Phil Adams
Using option menus in Tkinter
 
03:06
How to populate an option menu from a list in Python's Tkinter library.
Views: 6308 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: 16575 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: 8612 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: 7948 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: 2538 Phil Adams
Stac mixed touch at 2011 Nationals
 
05:31
Video highlights of the St Andrew's mixed touch team that finished second at the 2011 National Secondary Schools Tournament.
Views: 1369 Phil Adams
Blender - scaling an object
 
02:05
Quick intro into how to scale an object in Blender, including how to lock the scaling onto one axis.
Views: 4475 Phil Adams
19. Editing a category - part 1
 
13:47
In this video we add the ability to select and edit a particular category. We run a query that displays all categories from the database, then when one is selected it displays the details in a web form, enabling us to make changes. This is part one of the editing categories section as it is a little more complex than simply adding or deleting. Files can be found at: https://www.dropbox.com/sh/jbe5ai9wkn0pofq/AAAYA4SGHfDYCWHjZhggLaj1a?dl=0
Views: 4466 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: 11921 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: 2445 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: 5698 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: 1514 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: 707 Phil Adams