query("SELECT COUNT(id_pend) as pend from tb_pdd where status='Ada'");
while ($data= $sql->fetch_assoc()) {
$pend=$data['pend'];
}
$sql = $koneksi->query("SELECT COUNT(id_kk) as kartu from tb_kk");
while ($data= $sql->fetch_assoc()) {
$kartu=$data['kartu'];
}
$sql = $koneksi->query("SELECT COUNT(id_pend) as laki from tb_pdd where jekel='LK' AND status='Ada'");
while ($data= $sql->fetch_assoc()) {
$laki=$data['laki'];
}
$sql = $koneksi->query("SELECT COUNT(id_pend) as prem from tb_pdd where jekel='PR' AND status='Ada'");
while ($data= $sql->fetch_assoc()) {
$prem=$data['prem'];
}
$sql = $koneksi->query("SELECT COUNT(id_lahir) as lahir from tb_lahir");
while ($data= $sql->fetch_assoc()) {
$lahir=$data['lahir'];
}
$sql = $koneksi->query("SELECT COUNT(id_mendu) as mendu from tb_mendu");
while ($data= $sql->fetch_assoc()) {
$mendu=$data['mendu'];
}
$sql = $koneksi->query("SELECT COUNT(id_datang) as datang from tb_datang");
while ($data= $sql->fetch_assoc()) {
$datang=$data['datang'];
}
$sql = $koneksi->query("SELECT COUNT(id_pindah) as pindah from tb_pindah");
while ($data= $sql->fetch_assoc()) {
$pindah=$data['pindah'];
}
// Demografi Umur
$balita = 0; $anak = 0; $remaja = 0; $dewasa = 0; $lansia = 0;
$sql_balita = $koneksi->query("SELECT COUNT(id_pend) as c FROM tb_pdd WHERE TIMESTAMPDIFF(YEAR, tgl_lh, CURDATE()) BETWEEN 0 AND 5 AND status='Ada'");
if($d = $sql_balita->fetch_assoc()) $balita = $d['c'];
$sql_anak = $koneksi->query("SELECT COUNT(id_pend) as c FROM tb_pdd WHERE TIMESTAMPDIFF(YEAR, tgl_lh, CURDATE()) BETWEEN 6 AND 12 AND status='Ada'");
if($d = $sql_anak->fetch_assoc()) $anak = $d['c'];
$sql_remaja = $koneksi->query("SELECT COUNT(id_pend) as c FROM tb_pdd WHERE TIMESTAMPDIFF(YEAR, tgl_lh, CURDATE()) BETWEEN 13 AND 17 AND status='Ada'");
if($d = $sql_remaja->fetch_assoc()) $remaja = $d['c'];
$sql_dewasa = $koneksi->query("SELECT COUNT(id_pend) as c FROM tb_pdd WHERE TIMESTAMPDIFF(YEAR, tgl_lh, CURDATE()) BETWEEN 18 AND 59 AND status='Ada'");
if($d = $sql_dewasa->fetch_assoc()) $dewasa = $d['c'];
$sql_lansia = $koneksi->query("SELECT COUNT(id_pend) as c FROM tb_pdd WHERE TIMESTAMPDIFF(YEAR, tgl_lh, CURDATE()) >= 60 AND status='Ada'");
if($d = $sql_lansia->fetch_assoc()) $lansia = $d['c'];
// Data Profil
$sql_profil = "SELECT * FROM tb_profil WHERE id_profil='1'";
$query_profil = mysqli_query($koneksi, $sql_profil);
$data_profil = mysqli_fetch_array($query_profil,MYSQLI_BOTH);
?>
PEMERINTAH DESA
Kec. , Kab. |