I have plans for a web site which requires images to be saved onto the database, and I seek information about how this happens.


A web site like that of where a person submits a photo, for that photo to be placed on a web page as required. Like a photo on a love matching web site or etc.

Saving binary data in a db has the potential of being corrupted and/or becomming very large in size very fast. An alternative method is to store the file location in the db, and have the actual file in a protected directory.

u can save data in data base but it can be corrupted and can become large and lead to sever crash so better to store the file location so that the orginal file can be protected

save the image data as longblob in mysql, for how to upload a file through form->PHP
use this as form input

<form method="POST" enctype="multipart/form-data" name="image_upload_form" actio
n="<?$_SERVER["PHP_SELF"];?>">
<p><input type="file" name="image_file" size="20"></p>
<p><input type="submit" value="Upload Image" name="action"></p>
</form>

then use $_FILES array in PHP to retrieve the image file

Originally Posted by liandra

save the image data as longblob in mysql, for how to upload a file through form->PHP
use this as form input

<form method="POST" enctype="multipart/form-data" name="image_upload_form" actio
n="<?$_SERVER["PHP_SELF"];?>">
<p><input type="file" name="image_file" size="20"></p>
<p><input type="submit" value="Upload Image" name="action"></p>
</form>

then use $_FILES array in PHP to retrieve the image file

Thanks, I shall try that over the next few days.

DON'T


for the same reasons as here http://www.webmaster-talk.com/the-da...2-as-blob.html