Retrieve BLOB values from MYSql DB - HTML/Image files-HOW?

[amycrystal123]

Hi Everyone!

PLEASE HELP! I have a PHP program that allows me to upload any file (like html or image) from my PC and then I save it in my database (MySql - BLOB type).

I store the file name, file type, file size, file content (that is read from the file uploaded) in my database.

I try to retrieve the file but that does not work out. HTML file comes our un-formatted and image file comes in the form of binary characters..
Please help with an example.

Thanks a ton!
Amy.

[AstroTeg]

Why save it all in a database?

[amycrystal123]

Hi there!

I changed my mind sometime back but have come again to ask a question..

I had read many articles saving huge files as BLOB in DB is not a good idea..instead.. we can save the file path.

I did that.. I copied my file path to a new destination directory.
with the command..
copy ($uploadedFilePath, $destinationPath);

First problem:
It says I do not have permission!?
I have phpDev installed in my computer. What should I check for?

Second Problem:
I manually copied those files to my destination directory and saved the following information in the database:
File name, File type, File size, File path.
When I try to retrieve files, I am getting the html and image files displayed..
BUT.. When a html file has an image in it.. That image within the html file is not displayed.. WHY?

Third Problem:
Right now, I am working in my PC having phpDev installed.. Later, I would move my files to my website.. (say it is www.abc.com). If the files I have to move (destination directory) is in a file named (Files).. how do I specify the destination path of the files?
Is it www.abc.com/files/ ? How do I make that page secure?

I am sorry.. I know these questions are silly.. But, I am a beginner. I'd appreciate if you could help me. Thank you!

Amy.