javascript - modify Xaxis in highcharts -


how can introduce in highcharts code array comes php code?

in next code php generate 4 arrays, 3 data (tmax ($rows), tmin ($rows1) , rain ($rows2) , last 1 days of consulting ($dia).

$sth = mysqli_query($con,"select city,tmax, day(date) dia meteo2 city= '" . $_session["city"] ."' , data between '" . split($_session["date8"]) ."' , '" . split($_session["date9"]) ."'order date");  $rows = array(); $dia = array(); $dia['name'] = 'dia'; $rows['name'] = 'tmax';  $rows['color'] = '#ff0000'; $cont=1; while($r = mysqli_fetch_array($sth)) { $rows['data'][] = $r['tmax']; $dia['categories'][] = $r['dia']; } $sth = mysqli_query($con,"select city,tmin meteo2 city= '" .   $_session["city"] ."' , data between '" . split($_session["date8"]) ."' , '" . split($_session["date9"]) ."'order date");  $rows1 = array(); $rows1['name'] = 'tmin'; $rows1['color'] = '#00ffff'; $rows1['var valuesuffix'] = 'ºc'; while($rr = mysqli_fetch_assoc($sth)) { $rows1['data'][] = $rr['tmin']; }  mysqli_query($con,"select city,rain meteo2 city= '" . $_session["city"] ."' , data between '" . split($_session["date8"]) ."' , '" . split($_session["date9"]) ."'order date");  $rows2 = array(); $rows2['name'] = 'rain'; $rows2['type'] = 'column'; $rows2['color'] = '#4572a7'; $rows2['var valuesuffix'] = 'mm'; $rows2['var yaxis'] = 2; while($rr = mysqli_fetch_assoc($sth)) { $rows2['data'][] = $rr['rain']; }  $result = array(); array_push($result,$rows2); array_push($result,$rows1); array_push($result,$rows); array_push($result,$dia); print json_encode($result, json_numeric_check);   mysqli_close($con); ?>

when plot chart, can see line of rain, tmax, tmin, in xaxis default have 0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15....and need information of $dia inside categories[]

and when check browser see categories empty... xaxis: { categories: [] },

but in highchart code have

xaxis: { categories: ['<?php echo $dia?>'] },

any please????

here show highcharts code

<!doctype html> <html> <head> <meta http-equiv="content-type" content="text/html; charset=utf-8"> <title>www.meteo4u.com/consultanouformat.html</title>  <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script> <script src="http://code.highcharts.com/modules/exporting.js"></script> <script type="text/javascript"> <?php $city = $_post["city"];   session_start(); $_session['city'] = $_post['city']; $_session['date8'] = $_post['date8']; $_session['date9'] = $_post['date9']; ?>   $(function () { var chart;  $(document).ready(function() { $.getjson("mysql-highcharts.php", function(json) {  chart = new highcharts.chart({ chart: { renderto: 'container', type: 'spline', marginright: 130, marginbottom: 25 }, title: { text: 'temperatura maxima, temperatura minima precipitacio <?php echo $city ?>', x: -20 //center }, xaxis: { categories:  [<?php echo $dia?>] }, yaxis: [{ labels: { format: '{value}°c', style: { color: '#ff0000' } }, title: { text: 'temperatura maxima', style: { color: '#ff0000' } } },{title: { text: 'temperatura minima', style: { color: '#00ffff' } } },{labels: { format: '{value} mm', style: { color: '#4572a7' } }, title: { text: 'precipitacio', style: { color: '#4572a7' } },opposite: true }], tooltip: { formatter: function() { return '<b>'+ this.series.name +'</b><br/>'+ this.x +': '+ this.y; } }, legend: { layout: 'vertical', align: 'right', verticalalign: 'top', x: -10, y: 100, borderwidth: 0 }, credits:{ text: 'meteo4u.com', href:'http://meteo4u.com', itemstyle: {     fontsize: '40px' } }, series: json }); }); }); }); </script> </head> <body> <script src="http://code.highcharts.com/highcharts.js"></script> <script src="http://code.highcharts.com/modules/exporting.js"></script> <div id="container" style="min-width: 400px; height: 400px; margin: 0 auto"></div> </body> </html>

it looks $dia array array, containing entry called 'categories'. don't think can somply echo array variable in highcharts code, dia exists in php on server. returning categories inside json object in 3rd entry of array

array_push($result,$dia);

this means have read categories out of returned json in highcharts code. code hard follow, try this:

xaxis: {     categories:  json[3]['categories']; },

however, worried line:

series: json

the returned json not contain series definitions contains categories well. may work, not clean code.


Comments

Post a Comment

Popular posts from this blog

php - Submit Form Data without Reloading page -

i know question has been asked , answered bunch of times life of me can not solution work on code. believe if redo code, work properly, , in retrospect time i've spent on issue should have redone code...but beyond deadline , have working prototype up... can advise how update multiple forms on single page without reloading page? horrible @ php , complete noob js/jquery/ajax @ best. html/php in single file , believe causing me problems/is largest obstacle @ getting ajax form processing work. basically, want users to: select teams multiple dropdowns in form group 1 (league champs) , on update update db newly selected team without reloadding page. edit team scores per match , on score submit/update, update db new scores. for each requirement there multiple forms (1 each leagues, 1 each per match) have set class on each form id. everything works via php, form submission reloads page each time submitted , not ideal. i have tried ajax code here http://scotch.io/tutoria
Read more

linux - Rails running on virtual machine in Windows -

the reason why want switch ubuntu people said gems works better on linux on windows. i don't want macbook pro rails development since love windows , cannot stand lack of apps mac. moreover, people saying ubuntu "better" mac: http://www.reddit.com/r/ubuntu/comments/1bgj1s/are_there_advantages_of_ubuntu_over_os_x_for/ does virtual box work enough doesn't have lag @ all? using i7-3517u cpu 8gb memory. need program in environment lag-free , not sluggish. or there alternatives recommend? i unsure permission settings or complicated stuffs regarding terminal. i'll using terminal develop. i'm still quite new here development in linux. please kind me >< thanks. @holyxiaoxin pretty sure should asking on superuser instead. nevertheless, suggest install ubuntu in partition instead of running virtual machine. here's guide https://help.ubuntu.com/community/windowsdualboot also, yes. developing in virtual machine accurate, @ end experiment w
Read more

php - $params->set Array between square bracket -

i'm using k2 in joomla 3.3. i'm trying set params (items ids ) module k2_content item.php file. result must between brackets, like: ["96","68"] my code is: $query = "select * #__k2_items extra_fields_search = '$myautor' , catid !=1 " ; $db->setquery($query); $losautores = $db->loadobjectlist(); $result = array(); foreach ($losautores $key => $value) { $result[] = '" '.$value->id.' "'; } $string_version = implode(',', $result); $autoresfinal = '['.$string_version.']'; if test using print, looks ok. passing var pramas, 1064 error. $params->set('items', $autoresfinal); to test tried $autoresfinal = ["96","68"]; and works fine. idea why doesn't work? thank you. if assign ["x","y"] assigning an array . here transforming array in st
Read more