WebSite X5Help Center

 
Hongyu L.
Hongyu L.
User

URGENT: View image sent from Contact Form in Database  en

Autore: Hongyu L.
Visite 985, Followers 2, Condiviso 0  

Hi, I am using Evo 2020.2.

I created a contact form whereby users can upload images in the format of: 

jpg,png,jpeg,heic

It is then stored in the database as longblob.

However, I am unable to view the images uploaded via X5's contact form using tools like MySQL Workbench and RazorSQL.

The other images stored in the database which are not uploaded using X5's contact form can be viewed normally. 

Please help me with this, thank you and appreciate it.

Postato il
8 RISPOSTE - 3 UTILI - 1 CORRETTO
Paul M.
Paul M.
Moderator

Hello Hongyu,

Did you use WebSite X5's own Contact Form Object?  If so then be aware that WebSite X5 does not store images (attachments) in the database.  You will find the uploaded images in the root folder of your WebSite X5 project on the server.

Kind regards,

Paul

Search the WebSite X5 Help Center

Leggi di più
Postato il da Paul M.
Hongyu L.
Hongyu L.
User
Autore

I passed all my website test (php7..database connection..)

Leggi di più
Postato il da Hongyu L.
Hongyu L.
Hongyu L.
User
Autore

Dear Paul,

Yup, I used X5's own contact form object. I see, so I look for the root folder to retrieve the submitted images? May I know how to access the root folder to retrieve the images?

Thank you a lot!

Leggi di più
Postato il da Hongyu L.
Paul M.
Paul M.
Moderator

You can download the images using any FTP client, such as File Zilla:

https://filezilla-project.org/

Or you can use the built-in FTP engine in WebSite X5 (Step 5 - Website Export to Internet):

First click on the icon highlighted in red, which will allow you to browse the files and folders on your server.

Then, click once on the file you wish to download (to give it focus), then click on the icon highlighted in yellow, to download that particular file from the server.

Leggi di più
Postato il da Paul M.
Hongyu L.
Hongyu L.
User
Autore

Dear Paul,

Thank you for your quick response, much appreciated. 

I managed to download the submitted images. 

However, for another server, I am only able to upload using WinSCP after I have 'expored website to disk' in Step 5.

Can I still use the built-in FTP engine in WebSite X5 to retrieve the file?

If no, how can I retrieve it in this case?

Have a great day.

Leggi di più
Postato il da Hongyu L.
Paul M.
Paul M.
Moderator

Yes, you should still be able to use the built-in FTP engine to do that, Hongyu.

But if you are uploading using WinSCP then there is no reason why you couldn't download using WinSCP also:

https://winscp.net/eng/docs/task_download

Leggi di più
Postato il da Paul M.
Hongyu L.
Hongyu L.
User
Autore

Dear Paul,

I managed to locate the submitted images in the WinSCP as well, thank you!

Can I check if I can automatically store the submitted images in a designated folder (such as admin, analytics, blogs..etc) inside the root folder? It would be easier to keep track and manage the submitted images. 

If not, are there ways in which you recommend to better organize the submitted images?

Thank you!

Leggi di più
Postato il da Hongyu L.
Paul M.
Paul M.
Moderator

It's not possible to 'automatically' move the submitted images to another folder on the server.  It's fine to do this manually, but avoid placing the images in one of WebSite X5's own folders (such as the ones you mentioned).  It would be better to create a new folder (or multiple folders) in which to store the images.

If you have programming skills then you might like to look into creating a cron script which would organise the images for you based on the criteria you specify:

https://en.wikipedia.org/wiki/Cron

This is beyond the scope of WebSite X5 though.

Leggi di più
Postato il da Paul M.