Making multi-pages for drawing image thumbnails - how?

[jennyp]

I'm looking for some conceptual advice about extending a simple image gallery that I'm writing, which gets its data from a flat-file database. Usual thing: there's a page of thumbnails, and when you click on one you go to the picture on another page.

At the moment the thumbnail page I've written uses a foreach loop to scan the database, and draws thumbnails as it finds them, with the result that all the images that are found are drawn down the page.

What I'd like to do, is to draw only nine images, and then - somehow - have links to further pages (how created I don't know) to display the rest of them, so that there's a maximum of nine drawn per page. And links to the pages under each batch of nine thumbs.

I realise this must be a well-worn scenario but being a PHP newbie I'd be grateful for any advice!!!

Thanks. Jenny.

[Levatio]

This is usually done with relational databases by adding 'LIMIT s, n' to the end of a SELECT query, where n is the amount of results you wish to show and s is which record you would like to start from.

I'd advise using a relational database, their postivies far outweight those of a flatfile system.

[jennyp]

OK - so I've set up the relational database (MySQL) with postivies! So far in the page I have a variable which shows all the records:

$query="SELECT * FROM imagetable";

Then I've put them into an array by:

$result=mysql_query($query);

..and I know the total number by:

$num=mysql_numrows($result);

So if I want to show say 9 images a page, how do I implement your code? And how do I present successive pages?

Thanks!

[HeyRay2]

http://www.phpfreaks.com/tutorial_cat/25/Page-Number--Pagination.php

That will get you started... 😃

[jennyp]

Hey thanks very much for that resource - I'll see if I can get my head around it !! :queasy:

[HeyRay2]

Glad I could help... 😃