CODEWITHSUNDEEP
phpsqlmysqlselectlimit
mouthpiec
mouthpiec

Reputation: 4033

Displaying SQL results using PHP

I have an SQL query that returns an amount of tuples (about 50). Now I need to display the results, 15 tuples at a time, then I will have a "view more" button to view the next 15 results.

Can you please help me how I can make this? The issue is that I cannot use the 'limits' because each time I run the query the results will be different, hence when pressing view more, I may get the same results of the same page.

thanks

Upvotes: 1

Views: 219

Answers (3)

Matt S
Matt S

Reputation: 15374

If you can only run the query once, you only have two options:

  • Send the entire resultset to the browser, hiding all but 15 rows. "View more" would simply unhide more rows.

  • Run the query once and cache the results, but only send back the rows requested to the browser. When more rows are requested from the browser, send back another set of cached rows. This is useful for progressively loading large or complex data sets.

Upvotes: 0

o0'.
o0'.

Reputation: 11863

Instead of reloading, you should put each "page" into a display:hidden div and using JS you show one div after another.

Upvotes: 1

Konerak
Konerak

Reputation: 39763

If you can't use LIMIT, this means your script will have to fetch and load the 50 tuples. If you only want to display 15, you should look for a Javascript solution to hide the others and only show the active ones.

The JQuery Datatables is an EXCELLENT piece of work. You just load all the tuples in a table, and call the Datatable - that's it! You can later customize it to show more or less than 15 at a time.

Upvotes: 1

Related Questions