WebSite X5Help Center

 
James Becker
James Becker
User

Database input  en

Author: James Becker
Visited 1071, Followers 1, Shared 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 ANSWERS - 1 CORRECT
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

Read more
Posted on the from Paul M.
James Becker
James Becker
User
Author

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.

Read more
Posted on the from James Becker