如何使用新数据重新加载php文件中的某个部分？

Question

I have a php file which retrieves data from a MySql database and display it. But the database have more no of data say 100. But in my php file I have planned to display 6 at a time just by using

LIMIT start_value, 6.

Then at the bottom I have a pan which contains the following code

<a href="index.html?start_value=start_value+6">1</a>
<a href="index.html?start_value=start_value+12">2</a>
<a href="index.html?start_value=start_value+18">3</a>
<a href="index.html?start_value=start_value+24">4</a>
<a href="index.html?start_value=start_value+30">5</a>
<a href="index.html?start_value=start_value+36">6</a>

So now the issue is if anyone clicks the link above the whole index.html will be reloading which will be annoying. Is there any way to display the new data from the database just by reloading that particular DIV after clicking any of the links?

Answer 1

Is there any way to display the new data from the database just by reloading that particular DIV after clicking any of the links?

Yes, there is. You need to use the XMLHttpRequest object and DOM. In one word: AJAX

The best way is to use a framework like jQuery or Prototipe.

Here you can find an example. You should replace the "latest_scores.html" page, in that example, with another page "latest_scores.php". The php script will create the refreshed content that can be placed inside your div.