Database input 
Autore: James Becker
Visite 1202,
Followers 1,
Condiviso 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?
Postato il
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
Autore
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.
Have a look at the information in these links, James:
http://www.w3schools.com/php/php_mysql_intro.asp
https://www.siteground.com/tutorials/php-mysql/
http://www.freewebmasterhelp.com/tutorials/phpmysql
I would also personally recommend anything by the author Larry Ullmann, who has a gift for explaining this sort of stuff:
http://www.larryullman.com/