We are an e learning developer using Macromedia Authorware as an authoring tool. We have developed an Access database that has stored query procedures in it to update/delete/append learner activities such as responses to questions.
We would like to migrate from Access to MySQL/PHP using similar stored procedures. Is it possible to have such procedures using MySQL/PHP and if so how?
Here are some SQL examples of our current stored procedures in MS Access:
Retrieve a Question By a specific label (select query)
SELECT [Question].[Question_ID], [Question].[Stem_txt], [Distractors].[Distractor_Id], [DistractorType].[DistractorTypeDescr], [Distractors].[Feedback], [Distractors].[Distractor_Text], [Distractors].[IsCorrect]
FROM DistractorType RIGHT JOIN (Question INNER JOIN Distractors ON [Question].[Question_ID]=[Distractors].[Question_ID]) ON [DistractorType].[DistractorTypeID]=[Distractors].[DistractorType_ID]
WHERE ((([Question].[Question_label])=[Enter the label]))
ORDER BY [Question].[Question_ID];
Insert a new distractor value or new response to a question(append query);
INSERT INTO Question_Response ( Participant_ID, Session_ID, Distractor_ID, Response_Text, Response_Time )
VALUES ([Enter a participant ID], [Enter a Session ID], [Enter a Distractor ID], [Enter the user's response], Now());
Change a user's response to a distractor to match his most recent entry (update query);
UPDATE Question_response SET Question_response.Session_ID = [Enter a Session ID], Question_response.Response_text = [Enter the user's response"]
WHERE (((Question_response.Response_Id)=[Enter a Response id]));
Thankyou in advance
