WebSite X5Help Center

 
James Becker
James Becker
User

Database input  en

Autor: James Becker
Visited 1079, Followers 1, Udostępniony 0  

Is it possible to populate a MySQL database from within X5 11Pro via user input. For example, say you have a private club and you want an admin to be able to enter member data, and also to let a member print a member list?

Posted on the
3 ODPOWIEDZI - 1 PRAWIDłOWA ODPOWIEDź
Paul M.
Paul M.
Moderator

Hello James, it is certainly possible to enter member data, but for the time being only if you use custom code in the HTML Object, etc.

Unfortunately the code involved would be unique to your own project, and certainly more than could easily be explained in a few lines here.

At present WebSite X5's native MySQL functionality is read-only, using the Database Viewer Object:

https://answers.websitex5.com/objects/livepreview/371262fa-27c5-421a-9127-852da219d4

However, you should be able to use this Object to format a member list which can then be printed (although I have not tried to do so!)

You could use an Email Form Object to post data to a database, but it is rudimentary at best, for example it does not permit you to edit/update any saved data (including data entered in error!)  -  not ideal for a members list.

Kind regards,

Paul

Czytaj więcej
Posted on the from Paul M.
James Becker
James Becker
User
Autor

HiYa Paul,

I understand that I would need to use an HTML Object to do this. I'm just wonder where I would find such a script that would allow it.

Czytaj więcej
Posted on the from James Becker