Hello Everyone,
I want to store the result from js file to mysql database please help.
The javascript code is below:
function EmailResults(strAddress)
{
if (!g_oQuizResults.strTitle)
{
g_oQuizResults.strTitle = "";
}
var g_strSubject = "Quiz Results: " + g_oQuizResults.strTitle;
var strQuizResults = "";
var strMainHeader = " " + g_oQuizResults.strTitle + "\nStatus, Raw Score, Passing Score, Max Score, Min Score, Time\n";
var strLineHeader = "\n\nDate, Time, Score, Interaction ID, Objective Id, Interaction Type, Student Response, Result, Weight, Latency\n";
var strMainData = "\n";
var strLineData = "\n";
strMainData += g_oQuizResults.strResult + ",";
strMainData += g_oQuizResults.strPtScore + ",";
strMainData += Math.round((g_oQuizResults.strPassingScore/100) * g_oQuizResults.strPtMax) + ",";
strMainData += g_oQuizResults.strPtMax + ",";
strMainData += 0 + ",";
strMainData += GetTime(g_oQuizResults.dtmFinished);
for (var i = 0; i < g_arrResults.length; i++)
{
strLineData += GetDate(g_arrResults[i].dtmFinished) + ",";
strLineData += GetTime(g_arrResults[i].dtmFinished) + ",";
strLineData += g_arrResults[i].nPoints + ",";
strLineData += g_arrResults[i].strInteractionId + ",";
strLineData += g_arrResults[i].strObjectiveId + ",";
strLineData += g_arrResults[i].strType + ",";
var strResponse = g_arrResults[i].strStudentResponse;
strResponse = ReplaceAll(strResponse, "'", "%27");
strLineData += strResponse + ",";
strLineData += g_arrResults[i].strResult + ",";
strLineData += "1,";
strLineData += g_arrResults[i].strLatency;
strLineData += "\n";
}
strQuizResults = strMainHeader + strMainData + strLineHeader + strLineData;
var sHTML = "";
sHTML += '<FORM id="formQuiz" method="POST" action="mailto:' + strAddress + '?subject=' + g_strSubject + '" enctype="text/plain">';
sHTML += '<INPUT TYPE="hidden" NAME="Quiz Results" VALUE=\'' + strQuizResults + '\'>';
sHTML += '<br><input type="submit"><br>';
sHTML += '</FORM>';
document.getElementById("divEmail").innerHTML = sHTML;
document.getElementById("formQuiz").submit();
}