<?php
//query kelurahan
$query_depan2="SELECT SUM(IF(status_keluarga='pakis',1,0)) AS jml_pakis, 
SUM(IF(status_keluarga='Sobo',1,0)) AS jml_sobo,
SUM(IF(status_keluarga='kebalenan',1,0,)) AS jml_kebalenan,
SUM(IF(status_keluarga='sumberrejo',1,0)) AS jml_sumberrejo,
SUM(IF(status_keluarga='tamanbaru',1,0)) AS jml_tamanbaru,
SUM(IF(status_keluarga='tukangkayu',1,0)) AS jml_tukangkayu,
SUM(IF(status_keluarga='kertosari',1,0)) AS jml_kertosari,
SUM(IF(status_keluarga='penganjuran',1,0)) AS jml_penganjuran,
SUM(IF(status_keluarga='panderejo',1,0)) AS jml_panderejo,
SUM(IF(status_keluarga='temenggungan',1,0)) AS jml_temenggungan,
SUM(IF(status_keluarga='kepatihan',1,0)) AS jml_kepatihan,
SUM(IF(status_keluarga='kampung melayu',1,0)) AS jml_kmpmelayu,
SUM(IF(status_keluarga='kampung mandar',1,0)) AS jml_kmpmandar,
SUM(IF(status_keluarga='singonegaran',1,0)) AS jml_singonegaran,
SUM(IF(status_keluarga='singotrunan',1,0)) AS jml_singotrunan,
SUM(IF(status_keluarga='pengantigan',1,0)) AS jml_pengantigan,
SUM(IF(status_keluarga='lateng',1,0)) AS jml_lateng,
SUM(IF(status_keluarga='karangrejo',1,0)) AS jml_karangrejo,


SUM(IF(status_pendaftaran='Belum Diverifikasi',1,0)) AS jml_verifikasi, SUM(IF(status_pendaftaran='Tidak Diterima',1,0)) AS jml_ditolak  from ro_formulir";
$perintah=mysqli_query($koneksi,$query_depan2);
$data2=mysqli_fetch_array($perintah);
//query tamu

?>