[Resolved] dynamic gallery with only directories in the database

[fr8]

Im looking at building a dynamic gallery but without having to store all of the image file names in the database. just the directory where the images are located. that way i only have to add one row to my table. Any ideas of the best way to do this? opendir() ect.??

[fr8]

Hmm. No ideas. Figure I would at least get "goto hotscripts" or something of that nature. Which is not what im looking for.

This is the idea of the code. just not coded.

$_GET rowid directory name
quruery mysql for name

use opendir() for the listing of the directory.
while the list into a table.

The above looks sound and should work. My problem is some of my directorys have a few thousand items in it and i would like to add prev next links. ive done this pulling from the database and got the links to work but im not sure how to use that idea with the opendir() and to get me page numbers. anyone have an idea of how to do that?

[Weedpacket]

Well, I'm hoping you're not expecting someone to just write it for you 🙂

You can use opendir()/readdir() (or, better yet, scandir()) to get a listing of the files in a directory, and then count the number of entries in that list (don't forget to discount the special . and .. files). You could have two variables supplied by the prev/next links. One to say whether to move backwards or forwards, and the other one gives the position in the list for the first item on the current page. Between those two you have enough to know where in the directory listing to start displaying records from on the page that's being requested.

[fr8]

No not looking for anyone to write it for me. Just want to make sure that im on the right track.

I'll have some working code up here in a few days. Im sure ill get more replies once i get it going.

[fr8]

Ok this is a simplified version of what i have going on as of now:

$fullpath = 'galleries/';
$dir = 'holidays/elves/'; // pull from mysql
$newpath = $fullpath.$dir;
    if ($dh = opendir($newpath)) {
        while (($file = readdir($dh)) !== false) {
          // Block files from being displayed
          if ($file != "." && $file != ".." && $file != "thumbnails") {

        // Display
        echo 'This is the file: '.$file.' and this is the location of it: '.$dir.'<BR>';

    }
   }
    closedir($dh);
}

Now what im wondering is how i can add the thumbnail images into the loop. those are located in the $newpath. its just a sub directory which i exlude in the ifelse. when i do the "echo" i would like to be able to echo the matching thumbnails with it. The thumbnails have a different name that what the image is. any ideas?

[fr8]

FYI: i dont seem to have scandir() on my server. php4.

[fr8]

Since i exlcude the thumbnail directory. would it be best to make an array that has the thumbnails in it? that way when i go to display it i can have the thumbs have a different name?