Advertisement
jamboljack

Array Chart

Aug 27th, 2017
219
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.87 KB | None | 0 0
  1. $render_sanitasi = array();
  2. for ($i=$Tahun1;$i<=$Tahun2;$i++) {            
  3.     if ($Sumber <> 'all') {
  4.         $query  = $this->db->query("SELECT * FROM sird_sanitasi WHERE sanitasi_tahun='$i' AND sanitasi_sumber='$Sumber'");
  5.     } else {
  6.         $query  = $this->db->query("SELECT * FROM sird_sanitasi WHERE sanitasi_tahun='$i'");
  7.     }
  8.                
  9.     $row        = $query->row();
  10.     if (isset($row)) {
  11.         $komunal    = $row->sanitasi_komunal;
  12.         $leherangsa = $row->sanitasi_leherangsa;
  13.         $plengsengan= $row->sanitasi_plengsengan;
  14.         $cemplung   = $row->sanitasi_cemplung;
  15.     }
  16.  
  17.     $a = array();
  18.     array_push($a, $komunal, $leherangsa, $plengsengan, $cemplung);
  19.     $render_sanitasi[] = array(
  20.         'label'             => $i.' - '.$Sumber,
  21.         'data'              => $a,
  22.         'backgroundColor'   => 'rgba(0, 188, 212, 0.8)'
  23.     );
  24. }
  25.            
  26. $render     = json_encode($render_sanitasi);
  27. echo "<pre>";
  28. print_r($render);
  29. echo "</pre>";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement