Is it possible to load php query after the page loads?

[tenj]

I think I am over-thinking this problem. I am trying to do a simple query with php into mysql and show the results of the data on a page. The problem is that when I try to pull 500 records on the page, it takes a long time to load the page.

I was wondering if it was possible to make the query load after the page has completly loaded, or if there was some way to use a combination of jquery/json to load the data.

[icio]

You could certainly use JQuery to do it. You'd just need to request your 'search.php?query=i+want+this' and replace the contents of the results element `<div id="results">Loading&hellip;</div>` so that they show up.

Have you considered pagination?

[tenj]

I have considered pagination, I just have not found a decent tutorial.

[icio]

Finding one is easy
php pagination

It would be considerably easier to do pagination than use an ajax request to get the results after loading the page.

[Esherido]

MXHR (http://blog.digg.com/?p=621) is also a possible solution. Have another PHP page that just spits out result data over MXHR and your database results will slowly flow into the entire page.

[utsav]

Displaying 500+ records in a page is very big.
Either use the idea that icio said. or create pagination. And i guess pagination would be better.

Find a easy and nice working pagination tutorial here http://rathour.com.np/blog/archives/38

[icio]

I said both. Please read the thread.