使用PHP将数据库查询结果传递给jQuery Sparkline图表

Question

I've created a PIE chart using jquery-sparline.

Pie Chart :

 $(".sparkline").sparkline([2,1], {
                type: 'pie',
                width: '100',
                height: '100',
                sliceColors: ['#F2441D','#fff'],
                borderWidth: 3,
                borderColor: '#F2441D'});

And I have a PostgreSQL database server.

Suppose I write this query select "Group", COUNT(*) from test group by "Group".

My result will be something like this.

Label   Count
Group1  244
Group2  125

Now I need to replace these with value 2 and 1 in the javascript codes.

I'm using PHP over here.

Someone help me on how to do it.

Answer 1

I'm not sure but i think you will have to print you value in html balise (hidden filed for exemple) and retrieve it using javascript : document.getElementById

exemple :

<input type="hidden" id="valueForJs" value="244-125">
<script>
   var obj = document.getElementById("valueForJs").value;
   var array = obj.split("-");

   alert('value = ' + array[0] + ' ' + array[1]);
   // now you have your 2 value and you can use it in your script below...
</script>

You can also put the value in a span and hide this span for exemple, but i think input will be cleaner.