Inputing filesys data into mysql

[jeffwhansen]

I have a (at least for me) somewhat difficult task on my hands.

I need to be able to populate a mysql table [files] with the path and filename of each file in a directory, also its size and date.

For example - a directory with many sub dirs and files, 13,000 to be exact - I need to cycle through each file and make an insert into the [file] table with the name of the file with its relative path, ie. $basedir/docs/help/index.html. - also the size and date of the file.

I have browsed on php.net and found a few clues, but am hoping someone has done this and has a better idea than me.

thanks!

[hand]

<?
// $array[x][0]= path
// $array[x][1]= index: 0=directory 1=file
// $array[x][2]= name of dir or file 
// $array[x][4]= size of dir or file in bytes;

function RecurseDir($basedir, $AllDirectories=array())
{ 
    $ThisDir=array(); 
    $AllFiles=array();
    chdir($basedir); 
    $current=getcwd(); 
    $handle=opendir("."); 

while ($file = readdir($handle)) 
{ 
    if (($file!='..') & ($file!='.')) 
    { 
        if (is_dir($file)) 
            array_push($ThisDir,array($current.'/'.$file,0,basename($file),filesize($file))); 
        if (is_file($file))
            array_push($ThisDir,array($current.'/'.$file,1,basename($file),filesize($file))); 
    } 
} 
closedir($handle); 

foreach ($ThisDir as $key=>$var) 
{ 
    if ($var[1]==0)
    {
    array_push($AllDirectories, $var); 
    $AllDirectories=RecurseDir($var[0], $AllDirectories);
    }
    else
    array_push($AllFiles, $var);         
} 

chdir($basedir);
$result = array_merge ($AllDirectories, $AllFiles); 
return $result;
}

$list=RecurseDir("e:/"); // start here <<<<<<<<<<

while(list($k, $v) = each($list)):
    echo "k=$k; v0=$v[0]; v1=$v[1]; v2=$v[2]; v3=$v[3]; <br>";
endwhile;
?>

Source: http://www.php-resource.de/forum/showthread.php?s=&threadid=11203
based on http://www.zend.com/codex.php?id=775&single=1