online scouting database + picture question

[Brandon Martus]

Originally Posted by Robert Hafner

I'm using a MySQL database to run the scouting program, and I was wondering if it was possible to store pictured into the database. I know the blob type is for storing binary data, but how would I go about putting a picture in there, and then how would I have it display?

here's some snippets. nothing complete, but it'll get you on the right track, i think.

grab the file, first.

	  @ob_start();
  	  $output = @readfile("/path/to/file.jpg"); // could be url
  	  $theImage = @ob_get_contents();
  	  @ob_end_clean();

and then run this insert

"INSERT INTO table (id,column) VALUES ('','".addslashes($theImage)."')"'

to display later, assuming its a jpeg:

@header('Content-Type: image/jpeg');
 // echo out contents of that column you just updated