I want to write a page that will show all records from a database, and it must be limited using the SQL LIMIT syntax .
My question is how do I use PHP to generate auto links? Do I have a variable which will automatically increase in some way, etc. links, hardcodes, etc. Are there any conference or best practice for such things?
It looks as though you would use functionality in MySQL, set the quantity of records per page And track a page number at the end.
You will remove this part of the $ _GET variable named "$". If page 2 is equal to, and # result is 10 per page, then you should start with the 21st record. So your volume becomes LIMIT 21, 10.
Most of the work will be done on linking for work, page 1, page2, page 3, etc. You should know how many records do you have, 100 records per page and 10 records per page limit per record limit? You will have page 1 - Page 10. Each link calls only one page, but with a different $ _GET ["page"] value.
This is a cursory description.
Comments
Post a Comment