Entering images into a database using PHPmyadmin

bajah

Im currently using PHPmyadmin on xampp and im trying to add a photo to a column. This column called photo, has MIME type set to accept image\jpeg, Browser Transformation: image\jpeg:inline, i also have gd support enabled.

It gives me the option to browse for the file but when i press go nothing shows up in the table even when i choose show BLOB data in options.

bradgrafelman

This sounds more like an issue with phpMyAdmin itself (not MySQL or PHP in general), so you'd probably be better off looking for support in phpMyAdmin's Support section.

Out of curiosity, though, is there any particular reason why you're wanting to store the actual image data in the DB in the first place? More often than not, this is a bad idea as compared to simply storing the files in the file system and instead only storing metadata about those files in the DB.

bajah

I have a database of players and i wanted to have a photo of them as well as other info in the same table. I was reading a PHPmyadmin book which showed how to do it but after following the steps provided in the book nothing happen. All other info would be stored in the table except the photos.

bradgrafelman

If you have no other reason to do it other than you've seen it done before, then I would highly recommend you not store the binary information in the DB. In other words, let the file system handle the files themselves and instead just store other relevant information (file name/path, etc.) in the DB.