Good day to you all,
I was looking into makeing a database of all my image and I was wondering if there is a way to read a recursive directory and store it into the database.

I don't have a clue on how, even if I have search the web for a while.


Thanks, take care and have a good one !

__________________
That's why we are not alone on earth... let's build !

You would have to do it via PHP. There should be tons of scripts with the ability to list files out there, just use fstream to get the content and store it.

Out of interest, why are you storing files in the database? Databases really are not meant for that sort of thing.

__________________

I red a please that said it was doable so I just assume we add to do this for faster loading.

Should I just put le url of the image in the db ?

How would I do this ?

__________________
That's why we are not alone on earth... let's build !

It's doable, but the filesystem is far faster.

I would just store the URL in the database. That is as simple as an insert statement in a varchar field.

__________________

I've done something similar in the past but my code was lost lost. *sigh* I stored the filename and url in sql. There are plenty of examples online that you can update to your needs.

__________________
I am not a programmer, nor do I play one on tv.

I agree, let the web server do what its good at and let mysql do what its good at.

If you insist on this method, look into the Mysql BLOB type.

__________________
mysql> SELECT * FROM `users` WHERE `users`.`clue` > 0;
Empty set (0.00 sec)