PHP - MySQL - Image to blob field and then display.

[00stuff]

Hi guys, I have a problem. I need to create a page that has a web form to upload an image to a mySQL database and place it in a blob field. Then I need to be able to query the database later to display the image on the site. I've looked around but I just haven't found any examples that can help me. Does anyone know of any good example or can anyone please give me an example? I have nothing so far, just the html web form and database.

[00stuff]

Does anyone know?

[mentalist]

Storing it and extra info is a trivial affair...

 

To get it out, say have an img tag in your html which calls a php script, which uses something like the following...

 

function dumip_it($s,$fn="fn.xml"){
   header('Content-Description: File Transfer');
   header('Content-Type: application/octet-stream');
   header('Content-Disposition: attachment; filename='.$fn);
   header('Content-Transfer-Encoding: binary');
   header('Expires: 0');
   header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
   header('Pragma: public');
   header('Content-Length: '.strlen($s));
   ob_clean();
   ob_flush();
   print $s;
   exit;
}

 

Never actually got around to this, but it won't be far off...

[00stuff]

thanks, but I don't understand what the function is doing...

[BlueSkyIS]

i suggest that you do not store images in a database unless there is some good reason to do so. store the path to the image, instead, or an identifier that allows you to build the path to the image.

[00stuff]

The site that I'm making is going to have thousands of items with pictures. Like an online store and they need to be able to be read as fast as possible and i thought that if they are included in the database in a blob field it would be easier to query and display. What do you guys think?

 

[BlueSkyIS]

definitely not. store the images as images on the file system. store the image names, or some kind of name or key that is the image path. after you have more experience, this will be a no-brainer.

 

[semanticnotion]

follow this link it may help you

http://bytes.com/topic/php/insights/740327-uploading-files-into-mysql-database-using-php