Automatically adding files to a database

[droms]

Hi, I'm not even entirely sure if this can be done, it's the place to ask just incase though, i'm currently creating a downloads system for a hobby website I have setup (A public domain gaming site) - I have created a script that simply reads the folder and displays the downloads in an a-z listing, however.

I have all the folders in the following format

/GAMES/SYSTEM/files

I.E

/GAMES/Super Nintendo/Pinball_PD.zip

What I was hoping to do was have a php script that I could run to create a database of all files listed in each directory.

I.E read the entire games folder, inserting all the roms under category/file name and link

SO if it was reading the Super Nintendo game file Pinball_PD.zip it would insert it into the database in the following format

MySQL Table:
ID=1
SYSCATEGORY=Super Nintendo
Filename=Pinball PD
Filelink =/GAMES/Super Nintendo/Pinball_PD.zip

which I could then read from the database and output to the website?

Sorry if this appears like a long winded description, it's effectively a script that will read a directory and add it's contents to a database.

Hope you can help!
Regards.
Andy.

[devinemke]

you say you already have a script that parses thru the directory and reads all the files. so then just add the db insertion code to each iteration of the loop.

[droms]

Hi there, many thanks for your response. I'm a little iffy when it comes to adding database queries, not quite that advanced!! Here is the code I currently use to list each folder -

<?

function listroms($system, $letter) {

if ($handle = opendir("roms/$system")) {

    while (false !== ($rom = readdir($handle))) {



        if ($rom != "." && $rom != ".." && $rom[0] == $letter) {

        $isfile = "TRUE";

        $rom2 = str_replace("_", " ", $rom);
        $rom2 = str_replace(".zip", "", $rom2);
$rom2 = str_replace(".7z", "", $rom2);

            echo "<div align=\"center\"><center><table border=\"0\" cellpadding=\"2\" cellspacing=\"2\" style=\"border-collapse: collapse\" bordercolor=\"#111111\" width=\"100%\" id=\"AutoNumber1\"><tr><td width=\"100%\"><a href=\"romsget.php?&system=$system&rom=$rom\">$rom2</a><BR></td></tr></table></center></div>";

        }

    }

    closedir($handle);

}

if ($isfile != "TRUE") {

    echo "Sorry we have no roms for $system beginning with the letter $letter.<BR>";

}



}  // end function listroms

?>

<b><? echo $system ?> ROMS for the letter <? echo $letter ?></b><BR><BR>

<? listroms($system, $letter); ?> 

To call the A-Z of each games page I call the following URL
romsshow.php?&system=Atari 2600&letter=A

Where would I insert the database code so it would insert $system under category, the game file name under gamename and the URL under gamelink ?

Hope you can help, I'm tearing my hair out!!!

Many thanks & regards,
Andy 🆒