Advertisement

You May Like




Online Service

Web Tools
Escape HTML

Subscribe to RSS through Email:

Enter your email address:



RSS Subscription

Home
Retrieving database information with AJAX, PHP and MySQL Print E-mail
Tag it:
Delicious
Digg
RedDot
Spurl
Reddit
YahooMyWeb
Technorati
Stumble
Furl it!
Mister.Wong

Retrieving database information with AJAX, PHP and MySQL - By somecoders


With the recent popularization of AJAX (Asynchronus Javascript And XML), it is now unnessecary to reload a page with the same basic layout, just to get new content. You can use AJAX to retrieve just the content without reloading the page, then change the value of a content area.

First of all, to use AJAX you must understand how it works. AJAX is JavaScript that can run through the "AJAX Engine" and by doing so, retrieve data from a remote page through HTTP, without having a page reload. It is similar to PHP's file_get_contents(), however it can be done through JavaScript as a client-side script.

The first thing we need, is a php file that we will call with AJAX. It doesn't have to be PHP, but since it is the most popular server-side language, that is what we'll use. If you have decent knowledge of another language you would like to use instead, I'm sure you could translate the code. In this file, we will use a GET variable to determine the MySQL query we need to perform. We are using GET because it is accessible by AJAX. The great thing about it is that the file you are calling can be incredibly simple, and just be straight textual information

Read More...
  

  No Comments.

Discuss...
< Prev   Next >
or browse in 35 languages:

Who's Online

We have 3 guests online

Subscribe To

 Subscribe in RSS

Follow me...

Join MyiBook Network

Top 10 Most Downloaded