Erikk Ross AIO

Watch Video | Download Video

In this video I go over the basics of SQL.

Watch Video

This video shows how to customize the look of a WordPress Web site using themes. This is a very simple process. Themes can be downloaded from the WordPress Theme site.

There is also a site that has a lot of WordPress videos. I would recommend it to everyone if you are interested in learning about how to customize the look of WordPress. Scroll down about halfway down the page, titled “WordPress for Designers Series.”

http://blog.themeforest.net/resources/html-css-php-and-jquery-killer-tutorials/

Watch Video | Download Video

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.

These tutorials show you how to incorporate AJAX into a PHP/MySql Web site. I’ve split this up into two tutorials. The first is an introdution to AJAX, explaining what AJAX is and showing several examples of it in use. The second video shows you how to create a simple AJAX application.

Watch Videos

1. AJAX Introduction
2. Using AJAX with PHP and MySql

View Live Demo | Download Code

Database
The database for this example is very simple. It contains a single table called Users. The Users table has the following columns: id, username, password, email, gender, and age. View the picture below for more details on the database table.

Users Definition

Links

• jQuery Download
• jQuery Load function
• AJAX Image Gallery

I don’t know about you, but I find it nice when I can put a face to a person. Since we have zero face to face interaction I thought it would be nice if we could at least share our pictures with each other. Some of you post pictures in your bio page which I think is great.

I’ve created a web site that will allow you to upload your picture to share with your classmates. This web site will be a single location were we can share pictures of each other.

http://er5325.aisites.com/picshare/

I actually got the idea for this from another instructor who posted everyones picture in the classroom. I thought that was a good idea, but I didn’t want to do all the work of gathering the pictures, cropping them and posting them to the class. I’m a programmer…I’m lazy efficient.

Check it out and upload your picture if you like. Obviously this is completely optional. If you do not want to share your picture with the rest of us that’s cool.

If you run into any errors or bugs, let me know.

The spring session is about to start. I hope everyone had a nice Spring Break! Probably not long enough right?

This is my blogging site that I created with WordPress. I have posted all my video tutorials to this site. I teach several different classes so you will see a lot of video tutorials here. However I have categorized all of the videos by class. Going to the IMD331 category will show you just the IMD331 postings.

Watch video | Download video

In this video I go over some basic SQL Select statements.I use MySQL Administrator to write and test the queries in.

If you are in IMD312 this video covers Week 4 Assignment 3

Watch video | Download video

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

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