php - Google chart: I cant label my each (3 column) bar -

-

right code retrieved data 3 columns of database , display them row in column chart (haxis) , means:-

  1. there 3 bar ( called 3 columns of database)
  2. but want label each of bar (criteria1, criteria 2, criteria3..)

  3. clear example table below..i want retrieve percentage database stored in 3 columns.. criteria labeled manually..

     ________________________ |criteria   |percentage | |-----------------------| |criteria 1 | 64.1      | |-----------------------| |criteria 2 | 11.1      | |-----------------------| |criteria 3 | 21.1      | |-----------------------|

    thank u much..

edited :getdata.php:

    $table = array();     $table['cols'] = array    (     array('label' => 'criteria', 'type' => 'string'),     array('label' => 'criteria 1', 'type' => 'number'),     array('label' => 'criteria 2', 'type' => 'number'),     array('label' => 'criteria 3', 'type' => 'number')     );     $rows = array();    while($r = mysql_fetch_assoc($sql_query))     {           $temp = array();           $temp[] = array('v' =>"");           $temp[] = array('v' => (float)$r['resultsd']);           $temp[] = array('v' => (float)$r['resultwe']);            $temp[] = array('v' => (float)$r['resulttre']);             $rows[] = array('c' => $temp);     }      $table['rows'] = $rows;     $jsontable = json_encode($table);     echo $jsontable;

this google visualization code called getdata.php.:

  google.load("visualization", "1", {packages:["corechart"]});    function drawvisualization()    {     var jsondata=null;     var json = $.ajax     ({        url:"getdata.php?id=<?php echo $_get['id'];?>",        datatype: "json",       async: false,        success: (       function(data)        {          jsondata = data;             var data = new google.visualization.datatable(jsondata);                       var options =           {             title: 'sam histogram results',             haxis: {title: " criteria type", titletextstyle: {italic: false,bold: true}},               vaxis: {title: "percentage (%)", titletextstyle: {italic: false, bold: true}},             titletextstyle: {color: 'black', bold:'true'},           }     var chart = new google.visualization.columnchart(document.getelementbyid('visualization')).     draw(data,options);        })     }).responsetext;   }   google.setonloadcallback(drawvisualization);


Comments

Post a Comment

Popular posts from this blog

java - WrongTypeOfReturnValue exception thrown when unit testing using mockito -

-
my test list<person> mylist; @test public void testisvalidperson() { mylist = new arraylist<person>(); mylist.add(new person("tom")); when(persondao.get(person)).thenreturn(mylist); when((persondao.get(person)).isempty()).thenreturn(false);//------exception thrown boolean result = service.isvalid("tom"); assertfalse(result); } method tested: public boolean isvalid(string person){ persondao = new persondao(); person personobj = new person(person); return (persondao.get(person).isempty())?false : true; } exception thrown: org.mockito.exceptions.misusing.wrongtypeofreturnvalue: boolean cannot returned get() get() should return list *** if you're unsure why you're getting above error read on. due nature of syntax above problem might occur because: 1. exception *might* occur in wrongly written multi-threaded tests. please refer mockito faq on limitations of concurrency testing. 2. sp
Read more

php - Magento - Deleted Base url key -

-
i working on cleaning url: http://mydomain.com/shop/shop/deals i going through settings in configuration tab in admin panel on magento , change secure , unsecure base urls remove first base url "shop" web page read: http://mydomain.com/shop/deals so changed unsecure base urls mydomain.com/shop mydomain.com , secure 12.345.67.89/shop 12.345.67.89. wrong thing do. i cannot reload page or admin console. how access these files through ftp , change correctly there?? when make changes in admin panel changes made in database not in file. have make changes in database. 1.go database , select core_config_data table under table find web/unsecure/base_url , web/secure/base_url . make changes here. don't forget clear cache in var/cache folder
Read more

android - How to disable Button if EditText is empty ? -

-
i have edittext , button in application. when button clicked,the text entered in edittext added listview. i want disable button if edittext empty.how ? this code button click imagebutton imb=(imagebutton)findviewbyid(r.id.btn_send); imb.setonclicklistener(new onclicklistener() { @override public void onclick(view arg0) { edittext et = (edittext)findviewbyid(r.id.edittext1); string str = et.gettext().tostring(); web1.add(str); toast.maketext(shoutsingleprogram.this, "you entered...."+str, toast.length_short).show(); adapter1.notifydatasetchanged(); et.settext(""); } }); } how can ? edittext1.addtextchangedlistener(new textwatcher() { @override public void ontextchanged(charsequence s, int start, int before, in
Read more