Database 2 create record ! ! !

[ax3]

any database which will record all files stored in 1 folder & display a list in\on a webpage ?

[victor_rambo]

I don't know which language you need it in, but here is how I would do it using PHP and MySQL:

With PHP and MySQL:

PHP Code:

<?php
$file_list=scandir($dirname);//returns an array containing names of all file and folders.
foreach($file_list as $file)
{
$sql="";//your SQL command
mysql_query($sql);
}
?>

The target folder may contain more folders too. If you want to exclude those folder names from being added to the database, use the is_file() function. It returns false of it is a folder. So put a conditional statement that will insert the file name only if is_file() function returns true.

Doing it without MySQL:

PHP Code:

<?php
$file_list=scandir($dirname);
foreach($file_list as $file)
{
echo "<li>".$file."<li>";
}
?>

Note: scandir() function is available from PHP 5. PHP 4 does not have such a function.

[ax3]

@rohan_shenoy ...... thanx 4 reply .... bt am a noob in programming .......

any softy which would do it easly 4 me ?

[dheeraj_kumar]

Well, you can always use DIR to pipeline results onto a text file, and then you can import it to excel... Is this what you are asking?

[victor_rambo]

Don't know if there is any program!

[ax3]

& how r v gonna import those links from excel file 2 my webpage ?

softy = any freeware like php 1`s .... i dont know how they work bt knew sql long back where i could get all files listed in folders ......