Web, SQL: display random images despite file name, load images from folder

I want a web page to display several random images on load. I've th开发者_运维技巧ought of several solutions but I would really like to be able to dump images into a folder without renaming them, and the web page will choose from those images in the folder and display them

I can imagine a PHP solution that will display random images from a folder, but it will need to look for certain names.

So my next step was to have an SQL database where every image got a key, and 10 keys would be chosen random by a query - the images associated with them would then be passed into an array that the document will load the elements of.

But now I guess I need to know how to automatically populate an SQL database by having it read a folder?

Insight appreciated, if I don't have to reinvent the wheel the better

Glob works like on the filesystem, e.g. supports wildcards

$files = glob('/path/to/files/*.jpg');
$yourRandomFile = array_rand($files);

This will return a random JPG file, based on it's extension.

This should do it :

function your_dir ($directory) 

{

$results = array();

$handler = opendir($directory);

while ($file = readdir($handler)) {

  if ($file != "." && $file != "..") {

    $results[] = $file;

    //or sql query for each file

    $sql = mysql_query("SELECT * FROM your_table WHERE your_file = '".$file."'");
    if(mysql_num_rows !== 0){

    //your query...

    }

    //

  }


}

closedir($handler);

return $results;

}


$directory = '/path/to/your/directory';

your_dir($directory);

Would probably be better to select existing files from db first put them into an array and exclude them rather than checking for each one.

You can do as below.
1. read complete dir from where you want the page to load the image
2. store the image names in array
3. now generate a number using random function from 1 to size of the array
4. consider the generated number as key for the array and use that image name to put the image.