Reply to thread

Message

<blockquote data-quote="විල්සන් මාමා" data-source="post: 16715679" data-attributes="member: 397789">මචන්ලා මට php වලින් charts generate කරන්න&nbsp; ඕනේ highcharts හොදයි නේද&amp;#133;මේක පවිච්චි කරන කවුරුහරි ඉන්නවද&amp;#133;මට පොඩ්ඩක් කියල දෙන්න පුලුවන්ද&amp;#133;mysql database එකකින් ගන්න data set එකක් highcharts වලට දෙන්නෙ කොහමඩ කියලා[CODE]//file name is data.php&lt;?phprequire_once '../includes/database.php';require_once '../includes/customer.php';$customers=&nbsp; Customer::find_by_sql(&quot;SELECT firstname,monthly_income FROM customer&quot;);$rows=array();foreach ($customers as $customer) {&nbsp; &nbsp; $row[0]=$customer-&gt;firstname;&nbsp; &nbsp; $row[1]=$customer-&gt;monthly_income;&nbsp; &nbsp; array_push($rows,$row);}&nbsp;&nbsp; print json_encode($rows, JSON_NUMERIC_CHECK);?&gt;[/CODE]උඩ code එකෙන් මෙන්න මේ වගේ output එකක් දෙනවා [[&quot;Michael&quot;,55000],[&quot;Praveen&quot;,50000],[&quot;Nuwan&quot;,120000],[&quot;Thilan&quot;,100000]]ඊට පස්සේ මේක මෙන්න මේ වගේ html එකක paste කලාම මුකුත් පෙන්නන්නේ නැහැ නේ මේ යට තියෙන code මම එහෙන් පිටින්ම වෙන තැනකින් ගත්තේ මට මේක වැඩිය තේරෙන්නේ නැහැ කාට හරි කියන්න පුලුවන්ද මොකක්ද කරන්න ඕනේ මේකෙන් chart එක පෙන්න ගන්න මේකේ එහෙම වෙනස් කරන්න ඕන තැන් මොනාද [CODE]&lt;!DOCTYPE HTML&gt;&lt;html&gt;&nbsp; &nbsp; &lt;head&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;meta http-equiv=&quot;Content-Type&quot; content=&quot;text/html; charset=utf-8&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;title&gt;Highcharts Pie Chart&lt;/title&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;script type=&quot;text/javascript&quot; src=&quot;http://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js&quot;&gt;&lt;/script&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;script type=&quot;text/javascript&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; $(document).ready(function() {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var options = {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; chart: {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; renderTo: 'container',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; plotBackgroundColor: null,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; plotBorderWidth: null,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; plotShadow: false&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; },&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; title: {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; text: 'Customer Vs Income'&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; },&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; tooltip: {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; formatter: function() {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return '&lt;b&gt;'+ this.point.name +'&lt;/b&gt;: '+ this.percentage +' %';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; },&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; plotOptions: {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; pie: {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; allowPointSelect: true,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; cursor: 'pointer',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; dataLabels: {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; enabled: true,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; color: '#000000',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; connectorColor: '#000000',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; formatter: function() {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; return '&lt;b&gt;'+ this.point.name +'&lt;/b&gt;: '+ this.percentage +' %';&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; },&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; series: [{&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; type: 'pie',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; name: 'Browser share',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; data: []&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $.getJSON(&quot;data.php&quot;, function(json) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; options.series[0].data = json;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; chart = new Highcharts.Chart(options);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; });&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; });&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/script&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;script src=&quot;http://code.highcharts.com/highcharts.js&quot;&gt;&lt;/script&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;script src=&quot;http://code.highcharts.com/modules/exporting.js&quot;&gt;&lt;/script&gt;&nbsp; &nbsp; &lt;/head&gt;&nbsp; &nbsp; &lt;body&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;div id=&quot;container&quot; style=&quot;min-width: 400px; height: 400px; margin: 0 auto&quot;&gt;&lt;/div&gt;&nbsp; &nbsp; &lt;/body&gt;&lt;/html&gt;[/CODE]එහෙම නැත්තම්&nbsp; සාමාන්යෙන් මොනාද පාවිච්චි කරන්නේ php වලින් charts generate කරන්න පොඩි උදව්වක් දෙන්න බම්ප් හරි කරන්න &amp;#133;</blockquote>

[QUOTE="විල්සන් මාමා, post: 16715679, member: 397789"] [SIZE=4]මචන්ලා මට php වලින් charts generate කරන්න ඕනේ highcharts හොදයි නේද මේක පවිච්චි කරන කවුරුහරි ඉන්නවද මට පොඩ්ඩක් කියල දෙන්න පුලුවන්ද mysql database එකකින් ගන්න data set එකක් highcharts වලට දෙන්නෙ කොහමඩ කියලා [/SIZE] [CODE] //file name is data.php <?php require_once '../includes/database.php'; require_once '../includes/customer.php'; $customers= Customer::find_by_sql("SELECT firstname,monthly_income FROM customer"); $rows=array(); foreach ($customers as $customer) { $row[0]=$customer->firstname; $row[1]=$customer->monthly_income; array_push($rows,$row); } print json_encode($rows, JSON_NUMERIC_CHECK); ?>[/CODE] උඩ code එකෙන් මෙන්න මේ වගේ output එකක් දෙනවා [["Michael",55000],["Praveen",50000],["Nuwan",120000],["Thilan",100000]] [SIZE=4] ඊට පස්සේ මේක මෙන්න මේ වගේ html එකක paste කලාම මුකුත් පෙන්නන්නේ නැහැ නේ මේ යට තියෙන code මම එහෙන් පිටින්ම වෙන තැනකින් ගත්තේ මට මේක වැඩිය තේරෙන්නේ නැහැ කාට හරි කියන්න පුලුවන්ද මොකක්ද කරන්න ඕනේ මේකෙන් chart එක පෙන්න ගන්න මේකේ එහෙම වෙනස් කරන්න ඕන තැන් මොනාද [/SIZE] [CODE]<!DOCTYPE HTML> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <title>Highcharts Pie Chart</title> <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script> <script type="text/javascript"> $(document).ready(function() { var options = { chart: { renderTo: 'container', plotBackgroundColor: null, plotBorderWidth: null, plotShadow: false }, title: { text: 'Customer Vs Income' }, tooltip: { formatter: function() { return ''+ this.point.name +': '+ this.percentage +' %'; } }, plotOptions: { pie: { allowPointSelect: true, cursor: 'pointer', dataLabels: { enabled: true, color: '#000000', connectorColor: '#000000', formatter: function() { return ''+ this.point.name +': '+ this.percentage +' %'; } } } }, series: [{ type: 'pie', name: 'Browser share', data: [] }] } $.getJSON("data.php", function(json) { options.series[0].data = json; chart = new Highcharts.Chart(options); }); }); </script> <script src="http://code.highcharts.com/highcharts.js"></script> <script src="http://code.highcharts.com/modules/exporting.js"></script> </head> <body> <div id="container" style="min-width: 400px; height: 400px; margin: 0 auto"></div> </body> </html> [/CODE] [SIZE=4] එහෙම නැත්තම් සාමාන්යෙන් මොනාද පාවිච්චි කරන්නේ php වලින් charts generate කරන්න පොඩි උදව්වක් දෙන්න බම්ප් හරි කරන්න [/SIZE] [/QUOTE]

Verification

Hata thunen beduwama keeyada? (60 bedeema thuna)

Search

Latest ads

Reply to thread