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]

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.