sql - Create PieChart with google chart api and php -


i'm kinda new google chart api, , still wiping dust out php knowledge, maybe can (imo) basic question...

so have php class wich queries data server , should post page. there working line chart in it, can see @ snippet below:

$rowdata = array();             $i=0;             $_post['from'] = str_replace("/","-",$_post['from']);             $_post['to'] = str_replace("/","-",$_post['to']);              $cur_date = $_post['from'];              $sql =  "select date(entered),                            count(*) totalaccounts,                            sum(case when facebook_username != '' 1 else 0 end) facebook,                            sum(case when facebook_username = '' 1 else 0 end) standard                     account                     entered between '". $_post['from'] ."' , '". $_post['to'] ."'                     group date(entered)";              $result = $dbmain->query($sql);             $rows = tratardadosparagrafico($result);              $return = json_encode(array('cols' => $cols, 'rows' => $rows));              $data = array(                 'cols' => array(                     array('id' => '', 'label' => 'date', 'type' => 'string'),                     array('id' => '', 'label' => 'total accounts', 'type' => 'number'),                     array('id' => '', 'label' => 'total accounts (facebook)', 'type' => 'number'),                     array('id' => '', 'label' => 'total accounts (non facebook)', 'type' => 'number')                 ),                 'rows' => $rows             );               $chart = new chart('linechart');             $options = array('title' => 'accounts');             $chart->load(json_encode($data));             echo $chart->draw('rchart', $options);

what trying use same query result ($data) populate chart, 1 pie chart... pasted last 4 lines of code, changing parameter when creating new instance of chart:

$chart = new chart('piechart');             $options = array('title' => 'accounts');             $chart->load(json_encode($data));             echo $chart->draw('pchart', $options);

after this, close php tag , use 2 divs show charts...

<div id="rchart"></div>         <div id="pchart"></div>

everything here comes index.php class, haven't seen html files @ all... happens can see pie chart right below line chart, it comes no data within, i.e., whole chart grey , labeled "other"

what may i've done wrong? in advance!

[edit] let's want pie chart 2 slices, why code below doesn't works? (i "cannot read property '1' of undefined" error)

$data = array(                 'cols' => array(                     array('label' => 'pie slice labels', 'type' => 'string'),                     array('label' => 'pie slice values', 'type' => 'number')                 ),                 'rows' => array(                     array('v' => intval($facebook_accounts[0]), 'type' => 'int'),                     array('v' => intval($default_accounts[0]), 'type' => 'int')                 )             );             $chart = new chart('piechart');             $options = array('title' => 'accounts');             $chart->load(json_encode($data));             echo $chart->draw('piechart', $options);

[edit] maybe can helping me :) https://groups.google.com/forum/#!topic/google-visualization-api/wi_wovogzg8

creating pie char mysql database using php , google charts

piecharts don't use same data structure linecharts. piecharts expect 2 columns of data: first pie slice labels, , second pie slice values. have reconfigure data pull put data in correct format.

edit:

here's sample php pseudo-code building datatable piechart:

$data = array(     'cols' => array(         array('label': 'pie slice labels', type: 'string'),         array('label': 'pie slice values', type: 'number')     ),     'rows' => array() ); while (/* loop on sql results */) {     $data['rows'][] = array('c' => array(         array('v' => /* pie slice label */),         array('v' => /* pie slice value */) // use (int) or (float) parse appropriately, many databases output numbers strings     )); }

Comments

Post a Comment

Popular posts from this blog

java.util.scanner - How to read and add only numbers to array from a text file -

i'm learning java , have question regarding reading file want read numbers file contains strings well. here example of file: 66.56 "3 java 3-43 5-42 2.1 1 and here coding: public class test { public static void main (string [] args){ if (0 < args.length) { file x = new file(args[0]); try{ scanner in = new scanner( new fileinputstream(x)); arraylist<double> test = new arraylist<>(); while(in.hasnext()){ if(in.hasnextdouble()){ double f=in.nextdouble(); test.add(f);} else {in.next();} } catch(ioexception e) { system.err.println("exception during reading: " + e); } } my problem add 66.56,2.1 , 1 doesn't add 3 after "3 or ignores 3-43 , 5-42 can tell me how skip strings , add doubles here? thanks all said 3 ie; "3, 3-43 , 4-42 strings either u read string , split , check number @ " , - or put in space between characters , integers. jvm after compilation tre...
Read more

rewrite - Trouble with Wordpress multiple custom querystrings -

i'm working on adding multiple querystring , doesn't seem work. i've found codes seems work others might i'm missing something. i want like: http://mydomain.com/board/?getyear=2013&getsometext2=sometext to http://mydomain.com/board/2013/sometext/ i added code below functions.php file. doesn't seem work should though. this works. echoing querystring gets both variable without problem. http://mydomain.com/board/2013/sometext/ but doesn't. tested querystring vis isset() seems nothing being set/get http://mydomain.com/board/2013/ function add_query_vars($vars) { $vars[] = "getyear"; $vars[] = "getsometext2"; return $vars; } add_filter('query_vars', 'add_query_vars'); function add_rewrite_rules($arules) { $anewrules = array('board/([^/]+)/([^/]+)/?$' => 'index.php?pagename=board&getyear=$matches[1]&getsometext2=$matches[2]'); $arules = $a...
Read more