Discussion Forums  >  Plugins, Customizing, Source Code

Replies: 7    Views: 430

satit
I hate code!
Profile
Posts: 89
Reg: Feb 16, 2012
bangkok
6,640
04/19/13 11:38 PM (12 years ago)

Interactive Quiz, How send score to mysql ?

Hi, I want my student to make the Quiz. Then after they finished, the result will sent to mysql server to make the report. So , Anyone know how to using interactive Quiz send the score with separated deviceid:score to MySQL. I need a sample of php scripts also. I Thank you in Advance Satit P.
 
MacApple
Apple Fan
Profile
Posts: 4675
Reg: Oct 25, 2010
USA
61,150
like
04/20/13 06:44 AM (12 years ago)
Good morning. Out at #BuzzCon13 with a bunch of folks, good times. There was a simple php script kicking around that you could customize for this if you get a hold of it, will have a look on my laptop when I get back to hotel, out taking in the St Louis morning air. The script does exactly as you need but it posts to a page rather than a DB, change that and you'll be good.
 
satit
I hate code!
Profile
Posts: 89
Reg: Feb 16, 2012
bangkok
6,640
like
04/20/13 06:49 AM (12 years ago)
I look forward to see your scripts. Thank you very much.
 
Niraj
buzztouch Evangelist
Profile
Posts: 2943
Reg: Jul 11, 2012
Cerritos
37,930
like
04/21/13 09:16 PM (12 years ago)
Alternatively, perhaps there is a way to post it to a Google Form via an API? That way, the need for PHP and MySQL infrastructure is eliminated. -- Niraj
 
satit
I hate code!
Profile
Posts: 89
Reg: Feb 16, 2012
bangkok
6,640
like
04/21/13 09:18 PM (12 years ago)
@Niraj, How? is there some places to get more info?
 
Niraj
buzztouch Evangelist
Profile
Posts: 2943
Reg: Jul 11, 2012
Cerritos
37,930
like
04/22/13 07:40 AM (12 years ago)
Try this and see if you can carry onwards from the tip: http://blog.dfarooq.com/2012/10/using-google-spreadsheets-as-database.html I forget, does the Quiz plugin allow one to email the results? If so, perhaps one can email the results to a Google Form living on Google Drive. http://www.google.com/drive/start/apps.html#forms -- Niraj
 
satit
I hate code!
Profile
Posts: 89
Reg: Feb 16, 2012
bangkok
6,640
like
04/22/13 10:11 PM (12 years ago)
actually i need only a sample of url with scripts follow by plugins document said: -------------------------- Enter a URL that is prepared to accept the results of the quiz. When the quiz completes, it will request the URL with some important key/value pairs appended to the end of it. Configure your backend to save these results using the most appropriate method (database, file system, email the app owner, etc). Key / Values appended to the results URL totalPoints=[number of points earned on the quiz] totalSeconds=[number of seconds it took to complete the quiz] numberOfQuestions=[the number of questions in the quiz] numberCorrect=[the number of questions in the quiz] numberIncorrect=[the number of questions in the quiz] Additional Merge Fields: You can also include additional data in the URL to save values such as [deviceId], [deviceLatitude], [deviceLongitide] in your backend systems. Look at the "About sending device data" to see the list of available merge fields (expand the Screen Data URL property). Displaying Quiz Results: There are a number of ways to display quiz results. One way is to setup a screen in your control panel (a web view, a map, any plugin type) then connect it to the right side navigation bar button. Tapping the right side navigation bar button could then display quiz results pulled from your backend systems. ------------------------------ I's also tried by following the link => http://blog.dfarooq.com/2012/10/using-google-spreadsheets-as-database.html Yes, that the good idea to use with custom HTML plugin to open the live form then it will insert data into speedsheet. it' amazing. but i'd no idea to use with my Quiz. ------- Satit P.
 
Niraj
buzztouch Evangelist
Profile
Posts: 2943
Reg: Jul 11, 2012
Cerritos
37,930
like
04/22/13 10:33 PM (12 years ago)
Ok. Those instructions are helpful. Lets see is we can get the data to be collected within Google Forms. I will try in the next 24-36 hours. -- Niraj
 

Login + Screen Name Required to Post

pointerLogin to participate so you can start earning points. Once you're logged in (and have a screen name entered in your profile), you can subscribe to topics, follow users, and start learning how to make apps like the pros.