javascript - Populating highcharts with php via json_encode -


i have been wrestling highcharts , json_encode via php few days now. believe have data formatted yet chart not updating properly. category data updated , series data chart column , line data formatted should be.

can me rest of way. here php script , highcharts javascript using.

thank help:

<?php           // data feed power dynamic charts include_once('db_conn.php');  // site data , store in array $query = mysql_query("select site, sum(impressions) impressions, sum(clicks)     clicks dfa_data campaign='$campaign' , time='$time' group site order   impressions desc"); $rows = array(); while($r = mysql_fetch_array($query)) {     $rows['categories'][] = $r['site']; }  // impression data , store in array $query = mysql_query("select site, sum(impressions) impressions, sum(clicks) clicks dfa_data campaign='$campaign' , time='$time' group site order    impressions desc"); $rows1 = array(); $rows1['name'] = 'impressions'; $rows1['color'] = '#4572a7'; $rows1['type'] = 'column'; $rows1['yaxis'] = 1; while($rr = mysql_fetch_array($query)) {     $rows1['data'][] = $rr['impressions']; }  // ctr data , store in array $query = mysql_query("select site, sum(impressions) impressions, sum(clicks) clicks dfa_data campaign='$campaign' , time='$time' group site order impressions desc"); $rows2 = array(); $rows2['name'] = 'ctr'; $rows2['color'] = '#89a54e'; $rows2['type'] = 'spline'; while($rrr = mysql_fetch_array($query)) {  $ctr = number_format(($rrr['clicks']/$rrr['impressions'])*(100),2,'.',',');  $impressions = number_format($rrr['impressions'],0,'.',',');  $clicks = number_format($rrr['clicks'],0,'.',',');     $rows2['data'][] = $ctr; }  $result = array(); $result1 = array(); array_push($result,$rows); array_push($result1,$rows1); array_push($result1,$rows2);   ?>  <script> $(function () {      $('#container').highcharts({         chart: {             zoomtype: 'xy'         },         title: {             text: 'performance site'         },         subtitle: {             text: ''         },         xaxis:          <?php echo json_encode($result); ?>         ,         yaxis: [{ // primary yaxis             labels: {                 format: '{value}%',                 style: {                     color: '#89a54e'                 }             },             title: {                 text: 'ctr',                 style: {                     color: '#89a54e'                 }             }         }, { // secondary yaxis             title: {                 text: 'impressions',                 style: {                     color: '#4572a7'                 }             },             labels: {                 format: '{value}',                 style: {                     color: '#4572a7'                 }             },             opposite: true         }],         tooltip: {             shared: true         },         series: <?php echo json_encode($result1); ?>      });   }); </script>

var_dump($result) outputs following

array(1) { [0]=> array(1) { ["categories"]=> array(5) { [0]=> string(13) "search medica" [1]=> string(10) "medscape 4" [2]=> string(11) "onclive.com" [3]=> string(22) "oncology nurse advisor" [4]=> string(25) "chemotherapyadvisor.com 1" } } }

var_dump($result1) outputs following

string(7) "result1"

here json_encode output both:

json_encode $result

[{"categories":["search medica","medscape 4","onclive.com","oncology nurse advisor","chemotherapyadvisor.com 1"]}]

json_encode $result1

[{"name":"impressions","color":"#4572a7","type":"column","yaxis":1,"data":[140521,71905,69295,68456,49487]},{"name":"ctr","color":"#89a54e","type":"spline","data":[0.11,0.04,0.2,0.09,0.05]}]

as see problem getting data ajax or similar, because when paste json (which looks fine) works http://jsfiddle.net/6fzcz/ advice take @ console, if receive errors. morever php file @ same server script chart? 

$('#container').highcharts({     chart: {         type: 'line',         marginright: 10     },     xaxis: [{         "categories": ["search medica", "medscape 4", "onclive.com", "oncology nurse advisor", "chemotherapyadvisor.com 1"]     }],     series: [{         "name": "impressions",             "color": "#4572a7",             "type": "column",         //"yaxis": 1,         "data": [140521, 71905, 69295, 68456, 49487]     }, {         "name": "ctr",             "color": "#89a54e",             "type": "spline",             "data": [0.11, 0.04, 0.2, 0.09, 0.05]     }] });

Comments

Post a Comment

Popular posts from this blog

python - How to create a legend for 3D bar in matplotlib? -

Image
given ax = plt.subplot() : ax.bar()[0] can passed plt.legend() . however, ax.bar3d() returns none . how create legend displayed bars? update: passing legend="stuff" ax.bar3d() , calling ax.legend() raises /usr/lib/python2.6/site-packages/matplotlib/axes.py:4368: userwarning: no labeled objects found. use label='...' kwarg on individual plots. warnings.warn("no labeled objects found. " you need use proxy artist legends not supported. this code: from mpl_toolkits.mplot3d import axes3d import matplotlib.pyplot plt import numpy np fig = plt.figure() ax = fig.add_subplot(111, projection='3d') x, y = np.random.rand(2, 100) * 4 hist, xedges, yedges = np.histogram2d(x, y, bins=4) elements = (len(xedges) - 1) * (len(yedges) - 1) xpos, ypos = np.meshgrid(xedges[:-1]+0.25, yedges[:-1]+0.25) xpos = xpos.flatten() ypos = ypos.flatten() zpos = np.zeros(elements) dx = 0.5 * np.ones_like(zpos) dy = dx.copy() dz = hist.flatten() ax...
Read more

java - Multi-Label Document Classification -

i have database in store data based upon following 3 fields: id, text, {labels}. note each text has been assigned more 1 label \ tag \ class. want build model (weka \ rapidminer \ mahout) able recommend \ classify bunch of labels \ tags \ classes given text. i have heard svm , naive bayes classifier, not sure whether support multi-label classification or not. guides me right direction more welcome! the basic multilabel classification method one-vs.-the-rest (ovr), called binary relevance (br). basic idea take off-the-shelf binary classifier, such naive bayes or svm, create k instances of solve k independent classification problems. in python-like pseudocode: for each class k: learner = svm(settings) # example labels = [class_of(x) == k x in samples] learner.learn(samples, labels) then @ prediction time, run each of binary classifiers on sample , collect labels predict positive. (both training , prediction can done in parallel, since problems assumed ...
Read more

php - Dynamic url re-writing using htaccess -

how can rewrite http://mydomain.com/test/master.php?catid=2&subcatid=8 http://mydomain.com/test/master.php/catname/subcat using .htaccess file. once rewritten, how can access these parameters in master.php? note: untested, let me know if doesn't work. rewriterule ^master.php/([a-za-z0-9_-]+)/([a-za-z0-9_-]+)$ /master.php?catid$1&subcatid=$2 [l]
Read more