Erikk Ross AIO

Watch video | Download video

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/.

Watch Video | Download Video

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

Watch Video | Download Video

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

Watch Video | Download Video

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.

Watch video | Download video

Learn how to setup Dreamweaver to FTP to your OLS Web site.

Watch video| Download video

This video tutorial show how to use the web based OLS system.

Watch video | Download video