query("SELECT * FROM user_table WHERE authorizationrights = 'GRANTED' "))
{ while ($row = $result->fetch_assoc() ) { $stss=$stss. ""; }
}
$connect->close();
?>
query($sql1);
return $res->num_rows;
}
function getages($conns,$sql1,$sex){
$age=[0,0,0,0,0,0];
$sql1 = $sql1."AND SEX = '".$sex."'";
$res = $conns->query($sql1);
while($row=$res->fetch_assoc()){
if($row['AGE_GROUP']=='10-14'){ $age[0] = $age[0]+1;}
elseif($row['AGE_GROUP']=='15-19'){ $age[1] = $age[1]+1;}
elseif($row['AGE_GROUP']=='20-24'){ $age[2] = $age[2]+1;}
elseif($row['AGE_GROUP']=='24'){ $age[3] = $age[3]+1;}
elseif($row['AGE_GROUP']=='E'){ $age[4] = $age[4]+1;}
elseif($row['AGE_GROUP']=='X'){ $age[5] = $age[5]+1;}
}
return $age;
}
function getagess_episode($conns,$sql1,$sex){
$age=array();
$age[0] =0; $age[1] =0; $age[2] =0; $age[3] =0; $age[4] =0; $age[5] =0;
$sql1 = $sql1."AND SEX = '".$sex."'";
$res = $conns->query($sql1);
while($row=$res->fetch_assoc()){
if(explode('__',$row['SERVICE_EPISODE'])[1]=='1'){
if($row['AGE_GROUP']=='10-14'){ $age[0] = $age[0]+1;}
elseif($row['AGE_GROUP']=='15-19'){ $age[1] = $age[1]+1;}
elseif($row['AGE_GROUP']=='20-24'){ $age[2] = $age[2]+1;}
elseif($row['AGE_GROUP']=='24'){ $age[3] = $age[3]+1;}
elseif($row['AGE_GROUP']=='E'){ $age[4] = $age[4]+1;}
elseif($row['AGE_GROUP']=='X'){ $age[5] = $age[5]+1;}
}
}
return $age;
}
if(isset($_POST['edate'])){
$d1 = $_POST['sdate'].' 00:00:00';
$d2 = $_POST['edate'].' 23:59:59';
$sql = "SELECT * FROM `hct_counselling_andtesting` GROUP BY NTIHCNO HAVING `TIMESTAMP`>= '$d1' AND `TIMESTAMP`<= '$d2'";
$sql2 = "SELECT * FROM `counsellingservices` GROUP BY NTIHCNO HAVING `TIMESTAMP`>= '$d1' AND `TIMESTAMP`<= '$d2'";
$sql0 = "SELECT * FROM `tollfree` GROUP BY PHONECONTACT HAVING `TIMESTAMP`>= '$d1' AND `TIMESTAMP`<= '$d2'";
$sql3 = "SELECT * FROM `clientsexamination` GROUP BY NTIHCNO HAVING `TIMESTAMP`>= '$d1' AND `TIMESTAMP`<= '$d2'";
$sql4 = "SELECT * FROM `hcg` GROUP BY NTIHCNO HAVING `TIMESTAMP`>= '$d1' AND `TIMESTAMP`<= '$d2'";
$sql5 = "SELECT * FROM `family_planning` GROUP BY NTIHCNO HAVING `TIMESTAMP`>= '$d1' AND `TIMESTAMP`<= '$d2'";
$sql6 = "SELECT * FROM `antenatal` GROUP BY NTIHCNO HAVING `TIMESTAMP`>= '$d1' AND `TIMESTAMP`<= '$d2'";
$sql7 = "SELECT * FROM `postnatal_care` GROUP BY NTIHCNO HAVING `TIMESTAMP`>= '$d1' AND `TIMESTAMP`<= '$d2'";
$sql8 = "SELECT * FROM `abortioncare` GROUP BY NTIHCNO HAVING `TIMESTAMP`>= '$d1' AND `TIMESTAMP`<= '$d2'";
$sql9 = "SELECT * FROM `family_planning` GROUP BY NTIHCNO HAVING `TIMESTAMP`>= '$d1' AND `TIMESTAMP`<= '$d2'";
$sql01 = "SELECT * FROM `cmpatientsregistration` HAVING `TIMESTAMP`>= '$d1' AND `TIMESTAMP`<= '$d2'";
}
?>
Ntihc | imm system
