2. PHPRunner General questions
  3. [SOLVED]  Accessing images inserted into MYSQL by phprunner
This topic is locked
[SOLVED]

 Accessing images inserted into MYSQL by phprunner

 		1/21/2015 9:47:33 AM
PHPRunner General questions
T
 text author

Hi there
We have used phprunner(5.3) to create a back end application so that users can upload photos into a mysql database (blobs). We have a developer that is trying to access those photos once they have been uploaded to show on a bespoke website, he says he is having difficulty retrieving them from the database. Does phprunner encode or encrypt them in a particular way on upload?
Thanks
romaldus 1/21/2015



Hi there
We have used phprunner(5.3) to create a back end application so that users can upload photos into a mysql database (blobs). We have a developer that is trying to access those photos once they have been uploaded to show on a bespoke website, he says he is having difficulty retrieving them from the database. Does phprunner encode or encrypt them in a particular way on upload?
Thanks


You need to know how mysql store and retreive blob data type:
http://stackoverflow.com/questions/13435187/what-is-difference-between-storing-data-in-a-blob-vs-storing-a-pointer-to-a-fi
lefty 1/22/2015



You need to know how mysql store and retreive blob data type:
http://stackoverflow.com/questions/13435187/what-is-difference-between-storing-data-in-a-blob-vs-storing-a-pointer-to-a-fi


First suggestion is upgrade to new version of php with multiple file upload , can set it to one file . See new manual for encoding and decoding click here with new upgrade but for warned mobile version if not android can only browse for files not take them. I would change your file structure to mediumtype text for MySQL as Phprunner manual suggests that. Also note blob fields can take a lot of memory allocation .
Sergey Kornilov admin 1/23/2015

Binary data inserted into the database as is, no encryption or modification whatsoever. You need to explain what kind of trouble your developer is having. More specifics is better.