online scouting database + picture question

[Robert Hafner]

Just so you all know, there are currently 27 teams registered on the team 96 scouting database, so if any of you are looking to do some scouting I would suggest you check it out there (www.team96.org).


Now, for my question-
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?

[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

[steven114]

Take the JPEG file, read it into a blob, and when you want to recreate it I believe PHP has some functions for doing so. If not, you could always create a temporary file and write the data back.