Script that connects to Mysql for analytical purposes?

Portal Home > Knowledgebase > Articles Database > Script that connects to Mysql for analytical purposes?

Posted by bambinou, 06-04-2013, 02:04 PM
Hello, I would like to know if any of you do know a script I could use to connect to different rows in Mysql to get real time graphs please. Thank you! Ben
Posted by activelobby4u, 06-04-2013, 10:11 PM
What kind of graphs ?
Posted by RoseHosting, 06-04-2013, 10:17 PM
mtop (MySQL top) - monitors a MySQL server showing the queries which are taking the most amount of time to complete.
Posted by bambinou, 06-05-2013, 03:42 AM
Hello, My apology, I did not specified which types of analytic I wanted to register. I have a form with multiple questions before the registration ends, this data then goes into mysql as: Date, id , Question 1, question 1, question 3, question 4, name, surname, phone number, email. All the questions are based on drop down menu so the replies will always be in a frame and not all over the place. All I would like to do is take for example all the questions 1 and have all the answers into a pie from [start date] to [end date] based on the [date] column. Is there anything which is open source that can help me with this please? Thank you, Ben
Posted by RRWH, 06-05-2013, 04:34 AM
So, you want an application to analyse your custom data - in this case, you either write it yourself or pay someone to do so for you.
Posted by bambinou, 06-05-2013, 09:26 AM
Hi RRWH, Of course I will need to write it myself, all I need to know is if there are any good modules that helps connecting to MYSQl and projecting it into a graph. Like this: https://developers.google.com/chart/ I totally understand that the communication between mysql and the Graph script will have to be added by me. I cannot fund too many good solutions out there. Thank you, Ben