data entry!!!!!! argh!

Anon

I have about 700 files (filenames) to enter in the database (mySQL), is there a quicker way to enter them into the database? I do not want to waste over 1 hour typing all of that in! lol

Any help would be greatly appreciated!
Thanks

brandonschnell

if they're in the same format you could create a php script to read the docs in and process them.

rrijnders

If all the files are in a directory on disk, use opendir() and readdir() to get the list of them and use sql to add them to your db.

-- Rich Rijnders
-- Irvine, CA US

Anon

Thank you very much, I will try this

Anon

yes, they are all .jpg files
Such as opendir() and readdir() like the other guy replied?

Thanks!

Anon

sorry about msg you twice!

so I read the filename, insert into table ...

but do I use a while loop to check if there are any more files left in the directory?

I viewed the xamples ...

<pre>
$path = "/home/web_site/www/my_dir";
chdir($path);
$main = opendir($path);

while($file = readdir($main)) {
... statements ...
}

closedir($main);
</pre>

does that seem to work?

Thanks again!

rrijnders

That should do it. You might also have to use is_file() on each $file to make sure that you don't accidently process ".", ".." or subdirectories into your table.

-- Rich Rijnders
-- Irvine, CA US

Anon

Thank you very much!