Hi, can some body help me ?
how do i use mysql blob to store image(jpeg, gif) files and upload /get files from it using php.
which is better putting the files in the blob of mysql or having it as a seperate file. in the server ?
tnx
there is a great article here that talks about that... Is it better to store images on the filesystem vs the db. that is a matter of debate. some like to use the db, others prefer the filesystem. There are load concerns when the images are blobs in the db, and it may be more difficult for a newcomer to manage the code to store/retreive images in from the db... DBs store blobs, not in a column, but in a virtual folder and store a pointer to the virtual folder to access the image. How you decide what the right course is, is up to you. MY personal preference is to use the filesystem, though for work, I use the DB...
