Reading a directory of files

[rulkster2]

I am trying to read all the files in a directory, then dump the data into the database. It reads it fine but I can't get the $data[] to store anything. Can anyone tell me what is wrong here:

$directory = "./temp";
$dir = opendir($directory);
 while($curfile = readdir($dir)) { //Loops through all the files in the directory;
   
    if ($curfile!="." && $curfile != "..") { // don't need any directories, just files
      echo "$curfile<br>"; // Checker - each file name does print to the screen
      
       // problem somewhere here when trying to read the data
            $nowfile = $_FILES[csv][tmp_name];
            $handle = fopen($nowfile,"r");
                do {

                    echo "$data[0]"; // do anything with the data

                    } while ($data = fgetcsv($handle,1000,",",'"')); // do
    } // end if             
      } // end while

Thanks!!!

[EvilDevDog]

It appears that you're using the super-global $_FILES for no particular reason. That line should probably read like this:

$nowfile = $directory . "/" . $curfile; 

Then your handle will actually point to a file.

[rulkster2]

That was it! Thanks!!!!!

[bradgrafelman]

Also note that unless you have some extensive processing to do on the data in the files before it gets inserted into your database, you might be able to let the database do all of the reading/importing itself. For example, MySQL has a LOAD DATA INFILE query for this purpose.

[dalecosp]

For example, MySQL has a LOAD DATA INFILE query for this purpose.

And our vBulletin installation has a "Resolve Thread" link (under thread tools) for another purpose.

Thanks!