Database input
Autor: James Becker
Visitado 1201,
Followers 1,
Compartido 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?
Publicado en
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
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.
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/