Video Tutorial: Adding Images to the Master/Detail pages
August 8th, 2009
In this video I go over how to add images to your master detail pages.
Archive
Archive for the ‘IMD323’ Category
Video Tutorial: MySQL Setup Through OLS
May 7th, 2009
This video shows you how to create a new MySQL database on your OLS server. Then I go into using phpMyAdmin to create the tables in your database. Finally I show a simple PHP page that will pull the information out of the database and display it in a web page. I also have several other videos about MySQL and data access, including using Dreamweaver to write the PHP code for you.
Video Tutorial: Using Microsoft Access to Create SQL Queries
April 20th, 2009
This video tutorial shows you how to use Microsoft Access to create SQL queries. The advantage to using Access is that it has a gui based tool that will help you create the query.
Video Tutorial: Blog Example Search Page
March 28th, 2009
This video expands upon the Blog Example video and shows how to create a simple search page.
The code used in the video can be downloaded here. To see the blog example in use check out http://er5325.aisites.com/blog_example/.
Video Tutorial: Blog Example
March 28th, 2009
This video shows how to create a web page that displays records from your database. In this example, we code all the PHP ourselves, instead of relying on Dreamweaver. It uses a simple blog as an example.
The code used in the video can be downloaded here. The example files expand upon the video. There is a master page (index.php) which lists all the blog postings. There is a details page (blog.php) and a search page (search.php). I also have a video detailing how to create the search page.
To see the blog example in use check out http://er5325.aisites.com/blog_example/.
Video Tutorial: Master Detail Pages
March 27th, 2009
This video shows how to use Dreamweaver to create a master page which displays all the records from your database and then a details page which will show the details of a given record.
For IMD331: Web Site Development II this is for Week 4 Assignment 2.
I skip over how to create the database connection in this video because we did it in a previous one. If you do not remember how to create the connection please watch Using Dreamweaver to display data from MySQL
Screenshot of the master page
Screenshot of the details page
Video Tutorial: Using Dreamweaver to display data from MySQL
March 27th, 2009
This video was done using Dreamweaver CS3. The steps are the same in CS4.
If you are in IMD331: Web Site Development II, this is for Week 4 Assignment 2.
If you are in IMD323: Database Systems, this is for Week 5 Assignment 1
Video Tutorial: MySQL Administrator
March 26th, 2009
This video goes through how to adminster a database using a GUI based tool called MySQL Administrator. I find that using this application is much easier than going through phpMyAdmin.
This video will go through installing the application, creating a new database and then how to connect to your database using MySQL Administrator.
Important Note: Some students have indicated not being able to connect to their database using MySQL Administrator. I believe that some of the OLS database servers are restricting users from connecting using this method. If you are unable to connect using MySQL Administrator first verify that your username/password and database server name are correct. If you are sure they are correct and still cannot connect it is most likely because you are on a server that is unable to use MySQL Administrator.
Polls
Loading ...