Video Tutorials
- Meeting Request with MS-Outlook
- Making a meeting request with MS-Outlook, a very brief screencast of how to make a meeting request and check availability using Outlook.
- Javascript Debugging
- Firebug Intro. Firebug is an add-in for Firefox that allows you to debug javascript, though it does much more than that, it also allows you to examine the html, css and the DOM tree of any web page. It's a must have tool for a web-developer
- Javascript: getElementById
- Using getElementById. Instead of 'walking' the DOM tree, getElementById allows you to get to any element within a web page but using its id - it's very useful for pulling out an element to then alter or interrogate it. In this short video we use it to do some image rollovers and a view other things.
- Ajax Overview
- Ajax Overview. A brief screencast that tries to give an overview of AJAX, the request/response cycle and how information is included in a web page. This video is intended as a precursor to the workshop material on AJAX
- Ajax Example
- Ajax Example. A 40 minute screencast that works through an example of an html form that asks for a username, and, using ajax, queries a database to see if that username is taken and gives a message if it is.
PHP & Web
- Local Webserver
- Using a local web-server. Instructions on how to use the local Apache server in the labs in CEIS.
- PHPEdit: an introduction
- PHPEdit: an introduction
PHPEdit is a fantastic editor, not only for PHP but for css, javascript and html coding. There are a number of screencasts available at the PHPEdit site showing various aspects of using PHPEdit. - Here is my own contribution, a brief video introduction to using PHPEdit. I hope you find it useful.
- PHPEdit Debugging
- PHPEdit Debugging with a local webserver. PHPEdit is great for PHP coding and the debugging facilities are particularly useful both to solve difficult to spot logic errors but also to really understand how your program is working. This is a basic introction on how to use the debugger.
- SQL file to create the tables that some of the tutorials use.
- student.sql script file. To run this script:
- download to a local drive then:
- ftp the file onto the webserver
- login to the server shell
- from the unix comman prompt type in the command:
mysql youruserid < nameOfFile
eg:
mysql unn_isrd1 < students.sql - then load mysql and do a show tables to see the tables have been created.
I suppose, since the sql file isn't large, you could always click on the link above and just copy and paste the sql into your mysql command interface.
- Connecting to MySQL using PHP
- PHP => MySQL. A short tutorial on how to connect to using PHP to connect and display data from a MySQL database.
- Dynamic xhtml form
- xhtml form with a dynamic select (combo-box) created from data in a table. When the submit button is clicked the value selected in the combo-box is passed to a second script and then used as part of a WHERE clause to display matching data.
- Insert & Update data
- inserting & updating data with data passed from a form to a second script that inserts a new record or updates an existing record as appropriate.
- Display Then Edit Data
- List then edit data;
This tutorial shows how to list records from a table, make a link using a key-field value so that when you click on a record a form is loaded with the details from the record you clicked on. This form, in turn, allows for editing and then saving of the record.
iPod version not tested, so I'm not sure how the move to mp4 and the small screen will affect the quality.