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
- AJAX Introduction
- 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
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
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
- Review the Installing WordPress guide. This will give you a brief rundown of the steps necessary to install WordPress.
- Download Wordpress from http://wordpress.org/download/
- Setup the MySQL Database
- Decide what URL you want to assign the site. i.e. http://website.com/blog, http://website.com/wordpress, http://website.com/
- Extract the downloaded zip file to your local computer.
- Rename wp-config.sample to wp-config.php
- Open wp-config.php and change database values. Also change the authentication keys section. Use the online generator for this part.
- Upload files to your server.
- Run WordPress Installation.
In this tutorial I introduce jQuery. jQuery is an open source JavaScript Framework which simplifies writing JavaScript code.
Source files used in the video can be found here.
Watch video | Download video| View Live Demo
Loading ...