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?
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
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.