WebSite X5Help Center

 
Graeme G.
Graeme G.
User

PhpMyAdmin database - how to get images sent to it?  en

Author: Graeme G.
Visited 874, Followers 2, Shared 0  

Hi - I am trying to collect data via this link https://www.topek.co.uk/projects.html

Everything is successfully making its way into the database except the images, the image file names appear but not the actual images, how can I get the database to store the actual images and them be available to download?
Thanks!

Posted on the
3 ANSWERS
Axel  
Axel  
User

Hello,

In your DB you need to define the field with "Blob" to stock file directly into your DB and to get it after

https://www.tutorialspoint.com/What-is-BLOB-data-type-in-MySQL

But it's not the best because your DB will grow quickly.

The best is to have the file name into you DB, the put the file on your disk and to get the file by path\DB_filename. Like that your DB will not be populate by files.

Hope this helps

https://wsx5.afsoftware.fr

Read more
Posted on the from Axel  
Graeme G.
Graeme G.
User
Author

Thanks for the reply - do you have a step by step instruction for how to do this? Please see attached there is a BLOB data appearing in the field at the top, but I need step by step instructions on how to program this. Thanks!

Read more
Posted on the from Graeme G.
Axel  
Axel  
User

check you DB structure to see if the type is blob for your field

Use google to check on how to. I have nothing ready 

https://wsx5.afsoftware.fr

Read more
Posted on the from Axel