April 6, 2016 at 4:27 pm #309416
Hello all, I am a newbie. I have been tasked with creating an additional login/register admin area that would display reporting from those who tested but also that interfaces with a MySQL database that is being feed with the testing results. I honestly don’t know where to start. Can I use VBScript or PHP custom code to incorporate that into a current Lectora program? If I can, how can I do this or can you point me into the direction of where I should be posting this?April 6, 2016 at 11:31 pm #309423
Math NotermansMember118 pts@mnotermans5114
Another option is like this sample:
MathApril 7, 2016 at 8:30 am #309506
VBScript wasn’t something I preferred, it was just something I had read in documentation somewhere so I thought I was limited to using it. PHP would be much better and seems like, since I will be incorporating with a MySQL database, it would be the best option. I had never used FireBase so that is good to know. Thank you so much for your response. I am sure I will have more questions about how to initially connect with the software and get it to read my code but at least I know what is possible now.
MelanieApril 7, 2016 at 9:08 am #309508
Sergey SnegirevMember336 pts@ssneg
so essentially you want to create a server application that would store Lectora test results along with learner’s input such as Name or Email, correct? That is quite easy:
– step 1: In Lectora, create a test and all forms for learners to enter their names
– step 2: create a PHP script and a MySQL database. The script should get POST parameters and store them into a database. This is usually chapter 2 of any PHP textbook. See this for example: http://www.tizag.com/phpT/postget.php
– step 3: Enable “submit results to CGI / Include all variable value” in Lectora, enter the URL of your server script (e.g. http://www.example.com/submitresults.php), set it to POST.
Of course, if you want to display the results, you will also need to create a PHP page that reads from the database and displays the results. This is usually Chapter 1 of any PHP textbook.
Please note that this will not authenticate your users against any database, it will simply take whatever they input as their names. If you want authentication, you have to expand the server side with a database containing learner names and passwords as well as a method of authenticating learners against the database, creating new learners, managing lost passwords, securing it etc. etc. In other words, you are building your own small LMS.
And if this is your first venture into the wonderful world of PHP, MySQL, servers and databases, then this might be a little bit too much. The easy way out is to just use Lectora’s ability to submit variables to Google Drive.
SergeyApril 12, 2016 at 5:17 pm #310074
You must be logged in to reply to this topic.