read directory?

realcoder

how to read all files in folder and save their name in databas ..
i want that in a input field i give folder name that that read all files in that folder and return their complete name with extention and that i can save each name separate in database

NogDog

I's probably start with [man]glob/man.

realcoder

what's diifference between readdir and this one

NogDog

I generally find glob() easier to use, as one function call will create an array of file path-names. If all you want are the file names, you can do a chdir to that directory first:

$dir = "path/to/directory";
$curdir = getcwd();
chdir($dir) or die("Invalid directory");
$files = glob('*'); // might want to filter out "." and ".." if applicable
chdir($dir); // back to original directory
$values = array();
foreach($files as $file) {
   $values[] = "('" . mysql_real_escape_string($file) . "')";
}
$sql = "INSERT INTO table_name (file_name) VALUES\n" . implode(",\n", $values);
$result = mysql_query($sql);

(untested, of course 😉 )

realcoder

giving error
Warning: chdir() [function.chdir]: No such file or directory (errno 2) in D:\xampp\htdocs\1.php on line 9
Invalid

NogDog

Well, did you change the value for $dir to something legitimate on your test machine, and is it readable by your PHP user (e.g. the apache user if running that web server)?

PS: I see an unrelated typo: the second call to chdir() should be:

chdir($curdir); // back to original directory