javascript - Highcharts: Updating a Pie with ajax -



javascript - Highcharts: Updating a Pie with ajax -

i want update pie's info when li clicked. if data.php $cid value fixed value works. illustration : user_student.cid = 1 work. if utilize user_student.cid = $cid doesn't work. have idea?

thanks you,pquest.

but there have problems.if utilize fixed value 1 ,the alert value is: [["apple",1],["banana",2],["orange",3]] , pie working. if utilize $cid value(if $cid value 1) , value alert is:[["apple",1],["banana",2],["orange",3]] pie not working.

anyone have idea?

<script type="text/javascript"> $(document).ready(function() { $('table.display').datatable({ "paging": false, "info": false }); $('li').click(function(){ var cid = $(this).attr("id"); $.ajax({ type: "post", url: 'data.php', data:{ cid:cid }, success:function(reponse){ alert(reponse) /*options.series[0].data = reponse; chart = new highcharts.chart(options);*/ } }); var options = { chart: { renderto: 'pie', plotbackgroundcolor: null, plotborderwidth: null, plotshadow: false }, title: { text: 'web sales & marketing efforts' }, tooltip: { pointformat: '{series.name}: <b>{point.percentage}%</b>', percentagedecimals: 1, formatter: function() { homecoming '<b>'+ this.point.name +'</b>: '+ highcharts.numberformat(this.percentage, 1); +' %'; } }, plotoptions: { pie: { allowpointselect: true, cursor: 'pointer', datalabels: { enabled: true, color: '#000000', connectorcolor: '#000000', formatter: function() { homecoming '<b>'+ this.point.name +'</b>: '+ highcharts.numberformat(this.percentage, 1); +' %'; } } } }, series: [{ type: 'pie', datatype: 'json', name: 'browser share', data: [] }] } $.getjson("data.php", function(json) { options.series[0].data = json; chart = new highcharts.chart(options); }); }); }); </script>

data.php

<?php require_once("../connectdb.php"); $cid = isset($_post["cid"]) ? $_post["cid"] : ""; $result = $db->prepare("select stu_info.reference stu_info , user_student stu_info.sid = user_student.sid , user_student.cid = :cid"); $result ->execute(array(':cid' => $cid,)); $one = 0; $two = 0; $three = 0; while($r = $result -> fetch()) { if($r['reference'] === "apple") $one = $one+1; else if($r['reference'] === "banana") $two = $two+1; else if($r['reference'] === "orange") $three = $three+1; } $ra = array($one,$three,$two); $rb = array(apple,banana,orange); $rows = array(); for($i=0 ; $i<=2 ; $i=$i+1) { $row[0] = $rb[$i]; $row[1] = $ra[$i]; array_push($rows,$row); } print json_encode($rows, json_numeric_check); ?>

you cant write $cid in query text. have build string:

"select stu_info.reference stu_info , user_student stu_info.sid = user_student.sid , user_student.cid = " . $cid

edit: looks concatenation operator in php . rather +

javascript php jquery ajax highcharts

Comments

Post a Comment

Popular posts from this blog

java Multi query from Mysql using netbeans -

java Multi query from Mysql using netbeans - i have java code retrieve info mysql appropriate code in netbeans.the code below. want multi query such illustration finding total number of products , on.could help me please. in advance import java.sql.*; public class javamysqlselectexample { public static void main(string[] args) { seek { string mydriver = "com.mysql.jdbc.driver"; string myurl = "jdbc:mysql://localhost/sample"; class.forname(mydriver); connection conn = drivermanager.getconnection(myurl, "root", "mypasscode1"); string query = "select * products"; statement st = conn.createstatement(); resultset rs = st.executequery(query); while (rs.next()==true) { int code = rs.getint("code"); string productname = rs.getstring("product_name"); string producttype = rs.getstring("product_type"); system.out.format(" %d, %s, %s\n", code, pr
Read more

c# - DotNetZip fails with "stream does not support seek operations" -

c# - DotNetZip fails with "stream does not support seek operations" - i using dotnetzip in c# unzip stream follows: public static void unzipfromstream(stream stream, string outdir) { //omit seek grab block using (zipfile zip = zipfile.read(stream)){ foreach (zipentry e in zip){ e.extract(outdir, extractexistingfileaction.overwritesilently); } } } stream obtained using webclient client = new webclient(); stream fs = client.openread(url); however, got next exception exception during extracting zip stream system.notsupportedexception: stream not back upwards seek operations. @ system.net.connectstream.get_position() @ ionic.zip.zipfile.read(stream zipstream, textwriter statusmessagewriter, encoding encoding, eventhandler`1 readprogress) on server side(asp.net mvc 4), returning filepathresult or filestreamresult both caused exception. should obtain stream differently on client side? or how create server homec
Read more

c++ - StartServiceCtrlDispatcher don't can access 1063 error -

c++ - StartServiceCtrlDispatcher don't can access 1063 error - i write on c++ service , have error, , don't can fixed it. my service main function int main (int argc, tchar *argv[]) {dword f; for(int i=0;i<113;i++) f = getlasterror(); servicepath = lptstr(argv[0]); outputdebugstring(_t("my sample service: main: entry")); //installservice(); service_table_entry servicetable[] = { {service_name, (lpservice_main_function) servicemain}, {null, null} }; // startservice(); if(!startservicectrldispatcher(servicetable)) { f = getlasterror(); //addlogmessage("error: startservicectrldispatcher"); } else if( memcmp(argv[argc-1],"install",7)) { installservice(); } else if( memcmp(argv[argc-1],"remove",6)) { removeservice(); } else if( memcmp(argv[argc-1],"start",5)) { startservice(); } else if( memcmp(argv[argc-1],"stop",4))
Read more