Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $render_sanitasi = array();
- for ($i=$Tahun1;$i<=$Tahun2;$i++) {
- if ($Sumber <> 'all') {
- $query = $this->db->query("SELECT * FROM sird_sanitasi WHERE sanitasi_tahun='$i' AND sanitasi_sumber='$Sumber'");
- } else {
- $query = $this->db->query("SELECT * FROM sird_sanitasi WHERE sanitasi_tahun='$i'");
- }
- $row = $query->row();
- if (isset($row)) {
- $komunal = $row->sanitasi_komunal;
- $leherangsa = $row->sanitasi_leherangsa;
- $plengsengan= $row->sanitasi_plengsengan;
- $cemplung = $row->sanitasi_cemplung;
- }
- $a = array();
- array_push($a, $komunal, $leherangsa, $plengsengan, $cemplung);
- $render_sanitasi[] = array(
- 'label' => $i.' - '.$Sumber,
- 'data' => $a,
- 'backgroundColor' => 'rgba(0, 188, 212, 0.8)'
- );
- }
- $render = json_encode($render_sanitasi);
- echo "<pre>";
- print_r($render);
- echo "</pre>";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement