can someone provide me an example how to insert image using php mysqli into MySQL longblob field? and display it back using php mysqli?
here is my db table
IMAGE
{
IMAGE_ID int(11)
IMAGE_OWNER varchar(128)
IMAGE_BLOB longblob
IMAGE_NAME varchar(300)
IMAGE_TYPE varchar(50)
IMAGE_SIZE int(11)
}
I know how to upload it using PHP PDO, but I was wondering if I could done it using mysqli.
NOTE:
If you want to say "this is a bad way to store image" or "better use directory for storing image".
Before doing that, please tell me another way to make image only visible to it's uploader.