PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!
When i display the image, it knows the dimensions of the image, because itll push content down, and when you save the image from the site as JPG and view it, the majority of it is just white
I have attached an image uploaded using this script.
The dimensions of a jpg file are stored in the meta information (I believe), so all the data about the picture is downloaded first - that's why the size is accurate. BLOB types do have limitations - that's why there are MEDIUMBLOB and LONGBLOB types as well.
BLOB columns can only hold 65,536 bytes (65 KB). Half your image is 47KB, so it looks like the full thing wouldn't have fit. Additionally, there is a maximum on the amount of data that can be transmitted through an SQL query, so that might be restricting the data being retrieved.
Well I changed to a longblob and it worked. What gets me is that I was using this SAME database table for this application when I started it in RoR and it worked just fine.. then when I started writing to that same exact table using PHP its too small.. odd