How can you please encode multiple lines?
2012. június 13., szerda 13:12:37 UTC+2 időpontban Wesley Chin a következőt írta: > > Thank you, I have solved it, the format of the JSON was incorrect! > > On Wed, Jun 13, 2012 at 10:19 AM, John M <[email protected] <javascript:> > > wrote: > >> Do you get any javascript error? ( You can check it with firebug in >> Firefox or ctrl+shift+i in Chrome ) >> Try to check the json with an online json validator. >> >> Τη Δευτέρα, 11 Ιουνίου 2012 10:09:59 π.μ. UTC+3, ο χρήστης Wesley Chin >> έγραψε: >> >>> Hi everyone, >>> >>> I was wondering if you could please help me out, I am trying to pull >>> data (status and value) from a table in php, save it to an array (and >>> encode it to JSON??) and then use the encoded JSON array to add the >>> rows in the Pie Chart I am trying to create. Can anyone please guide >>> me on how to successfully do this? >>> >>> My code below: >>> >>> <? >>> // Connection to the database >>> $db = mysql_connect("localhost", "root", "elves") or die("Could not >>> connect"); >>> mysql_select_db("wlp_FIX001"); >>> >>> // Selecting the data >>> $s = "SELECT * FROM `lu_opportunity_status`"; >>> $m = mysql_query($s) or die("$s dies - " . mysql_error()); >>> >>> while ($row = mysql_fetch_array($m)) { >>> >>> $oppStatusName = $row['status']; >>> >>> $s1 = "SELECT `lu_opportunity_status`.`status`, >>> SUM(`opportunities`.`value`) AS `totalvalue` FROM `opportunities` LEFT >>> JOIN `lu_opportunity_status` ON `opportunities`.`status` = >>> `lu_opportunity_status`.`id` WHERE `lu_opportunity_status`.`status` = >>> '$oppStatusName'"; >>> $m1 = mysql_query($s1) or die("$s1 dies - " . mysql_error()); >>> >>> while ($row1 = mysql_fetch_array($m1)) { >>> >>> $oppStatus = $row1['status']; >>> $oppValue = $row1['totalvalue']; >>> $oppStageTotals = array("status" => $oppStatus, "oppValue" => >>> $oppValue); >>> // I need some code here to encode the array??? >>> } >>> } >>> ?> >>> <html> >>> <head> >>> <TITLE>Form Scaff Charts</TITLE> >>> <!--<link rel="stylesheet" media="print" title="Printer- >>> Friendly Style" >>> type="text/css" href="print.css">--> >>> <!--Load the AJAX API--> >>> <script type="text/javascript" src="https://www.google.com/ >>> jsapi"></script> >>> >>> <script type="text/javascript"> >>> >>> // Load the Visualization API and the piechart package. >>> google.load("visualization", "1", {packages: >>> ["corechart"]}); >>> google.load('visualization', '1.0', {'packages': >>> ['corechart']}); >>> google.load('visualization', '1', {packages:['table']}); >>> >>> // Set a callback to run when the Google Visualization API >>> is loaded. >>> google.setOnLoadCallback(drawChart); >>> >>> // Callback that creates and populates a data table, >>> // instantiates the pie chart, passes in the data and >>> // draws it. >>> function drawChart() { >>> // Create the data table. >>> var data = new google.visualization.DataTable(); >>> data.addColumn('string', 'Status'); >>> data.addColumn('number', 'Value'); >>> data.addRows([ >>> // I need the code here to insert the rows??? >>> ]); >>> >>> // Set chart options >>> var options = {'title':'Opportunities', >>> 'width':300, >>> 'height':300}; >>> >>> // Instantiate and draw our chart, passing in some >>> options. >>> var chart = new >>> google.visualization.PieChart(document.getElementById('chart_div')); >>> >>> function selectHandler() { >>> var selectedItem = chart.getSelection()[0]; >>> var selectedItem2 = chart.getSelection()[1]; >>> if (selectedItem) { >>> var topping = data.getValue(selectedItem.row, >>> 0); >>> var amount = data.getValue(selectedItem.row, >>> 1); >>> } >>> } >>> >>> google.visualization.events.addListener(chart, >>> 'select', selectHandler); >>> chart.draw(data, options); >>> } >>> </script> >>> <style> >>> body { >>> margin:0px; >>> padding:0px; >>> } >>> >>> .container { >>> width: 210mm; >>> height: 297mm; >>> margin-left: auto; >>> margin-right: auto; >>> } >>> >>> @media print >>> { >>> .container { >>> position: absolute; >>> top: 0px; >>> bottom: 0px; >>> left: 0px; >>> right: 0px; >>> } >>> >>> iframe { >>> /* float:left; >>> display: block;*/ >>> } >>> >>> } >>> </style> >>> </head> >>> <body> >>> <div class="container"> >>> <div id="chart_div" class=span4></div> >>> </div> >>> </body> >>> </html> >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Google Visualization API" group. >> To view this discussion on the web visit >> https://groups.google.com/d/msg/google-visualization-api/-/UFhMmxvx24QJ. >> >> To post to this group, send email to [email protected] >> <javascript:>. >> To unsubscribe from this group, send email to >> [email protected] <javascript:>. >> For more options, visit this group at >> http://groups.google.com/group/google-visualization-api?hl=en. >> > > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
