Chart from Database

I am trying to implement a chart from database, but I’m having a few problems…

I have a Database with 2 rows: Date, Pcr

My files .php:


$query = “SELECT * FROM table1 ORDER BY Date LIMIT 0 , 100”;
$result = mysql_query($query) or die("SQL Error 1: " . mysql_error());


while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
    $dates[] = $row['Date'];
    $dates[] = $row['Pcr']; 

echo json_encode($dates);

I get the array:

I would like to get a dynamic chart from this array, but I don’t know how to do that…

I have this static file:




                    var valores = eval(data);
                    var date1 = valores[0];
                    var pcr1 = valores[1];
                    var date2 = valores[2];
                    var pcr2 = valores[3];
                    var date3 = valores[4];
                    var pcr3 = valores[5];
                    var date4 = valores[6];
                    var pcr4 = valores[7];

                    var Datos = {
                            labels : [date1,date2,date3,date4],
                            datasets : [

                                    fillColor : 'rgba(255,0,0,0.1)', 
                                    strokeColor :'rgba(255,0,0,100)',
                                    pointColor : 'rgba(255,0,0,100)',

                                    data : [pcr1,pcr2,pcr3,pcr4]

                    var contexto = document.getElementById('grafico').getContext('2d');
                    window.Barra = new Chart(contexto).Line(Datos, { responsive : true });
            return false;

Could someone help me to find what I have to put in Data:?

Thank you very much

Is there a reason why you want JavaScript to generate the chart rather than simply generating the chart in PHP?

Why not let something like generate the graph in PHP (it’s got a professional license available if needed)?

btw, you’re using the old mysql_* extension which is deprecated in the current version of PHP (5.5), it’s being remove from the next version of PHP (7). You need to migrate over to either the mysqli_* extension or PDO

Not really…but I don’t know how to do that…
The code that I’ve written works fine, takes the arrays from the database with json, but when I want to get the chart (in Chart.php), I don’t know how to get these arrays…
If you could guide me about how to do that…
Thank you

Thank you, I was trying to do it in Chart.js, but I’ll look that you said.

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.