How to save the uploaded image to database in perspective?

[ptchanchal]

I am using a file upload component in perspective to upload multiple images and I want to save those uploaded images to my database. How can I do that that?

Thank You

[wking]

I would,

configure an onFileReceived event script and invoke event.file.getBytes() and send to DB as blob

[ptchanchal]

It worked, thank you and now I am trying to retrieve the saved image from database and show it in image component in perspective. I tried different ways but none of them seems working.

[JordanCClark]

View Images from Database

If you’re asking for how to do this in Perspective: Currently, you would probably have to do it using a webdev script, that could either return the image directly or a correctly formatted base64 string, which would then be able to be used by Perspective’s image component (I’m pretty sure). There are some ways that we could improve this experience, but the hard problem to deal with is the fact that the browser can’t directly access the database - so we need to deliver the images to it from the g…

[ptchanchal]

I am new in ignition, I don’t know how to achieve that using webdev, if you could help me with that then it will be really helpful.

Thank you.

[wking]

What kind of DB are you using?

[ptchanchal]

MySQL

[wking]

If they’re small. You would query them out as base 64. with TO_BASE64(col)

In Jordan’s post, it goes over that.

You could also store them straight to the directory. Something like

	upload_path = 'webserver/webapps/main/'
	event.file.copyTo(upload_path + event.file.name)