Storing Test Results

Hi Brad,

Its already a couple months so hopefully you found your answers. However, if you did not, or if there is someone else with same question, I hope this might help.

There are several ways to do it, but it depends a lot on how you are hosting the content and how much you can get into code.

If you are using SCORM you need an LMS, and you can use Moodle or something similar. Still, if I remember correctly, it doesn't store the answers from users if you need that too.

If you are hosting without an LMS, you can either try some javascript methods like mentioned by Le Dirlo.., or you can publish for Tin Can API (also known as xAPI). Experience API is the next generation of SCORM that doesn't require an LMS. You will need:

1. An LRS that supports MySQL as you need data in MySQL. So far I know of Free ADL LRS, and paid GrassBlade LRS, that stores data in MySQL.

2. Build a Tin Can URL, and load the content in an iframe or create a hyperlink to launch the content. In the link, you basically pass the user's name, user email id (or any other identifier), and the LRS details when you want to send the data to. Exact information is available everywhere on internet and you will be able to use it. If you face problem with that I can help. When user name/email is not available from their login, I either create a simple form in HTML to ask for that information, or I use the IP to keep the data fairly separate.

Now when anyone uses the content, you get the data in the LRS's MySQL tables.

Moderator: spam removed, nothing to do with question.

...

Hello !...

I'm also interested by this subject... And the limited number of learners prevents me from using a LMS...

I found this while ago and maybe it will help you :

Using JavaScript, PHP and MySQL to Log Captivate Variable Data - eLearning

(Didn't try it... )

...

Hi Brad,

I just completed a needs assessment for an LMS and found https://findanlms.com/ to be helpful with narrowing down what I wanted (discussions I needed to have with stakeholders) to give me a starting point on where to go. From there, I went to https://www.capterra.com/learning-management-system-software/ in order to read reviews and find out what functionality was available.

For my own work, I use Wordpress, so I went with LearnDash, which meets my needs. For other organizations, I've used a number of options. The one the company I did the work with has an SQL developer so they needed the data stored there to integrate it with their systems. I don't know any MySQL ones specifically, but I'm sure there are some out there.

The easiest way is using a LMS indeed.