MEDICAL PROBLEM DESCRIPTION REGISTERED BETWEEN AND
PROBLEM DESCRIPTION
AGE GORUP
GENDER
SCHOOLING
10 - 14
15 - 19
20 - 24
Above 24
TOTAL
FEMALE
MALE
TOTAL
IS-SCH
OUT-SCH
TOTAL
prepare("SELECT DATECREATED,MEDICALPROBLEM,
sum( if( SEX = 'FEMALE', RECORDCOUNTER, 0 ) ) AS FEMALE,
sum( if( SEX = 'MALE', RECORDCOUNTER, 0 ) ) AS MALE,
sum( if( AGE_GROUP = '10-14', RECORDCOUNTER, 0 ) ) AS gpone,
sum( if( AGE_GROUP = '15-19', RECORDCOUNTER, 0 ) ) AS gptwo,
sum( if( AGE_GROUP = '20-24', RECORDCOUNTER, 0 ) ) AS gpthree,
sum( if( AGE_GROUP = '20-24', RECORDCOUNTER, 0 ) ) AS gpfour,
sum( if( SCHOOLING = 'IS', RECORDCOUNTER, 0 ) ) AS insc,
sum( if( SCHOOLING = 'OS', RECORDCOUNTER, 0 ) ) AS ossc
FROM clientsexamination
WHERE DATECREATED BETWEEN :a AND :b GROUP BY MEDICALPROBLEM ASC ");
$result->bindParam(':a', $d1);
$result->bindParam(':b', $d2);
$result->execute();
for($i=0; $row = $result->fetch(); $i++){
?>
TOTAL:
prepare("SELECT sum(RECORDCOUNTER) FROM clientsexamination WHERE SEX = 'FEMALE' AND DATECREATED BETWEEN :a AND :b");
$results->bindParam(':a', $d1);
$results->bindParam(':b', $d2);
$results->execute();
for($i=0; $rows = $results->fetch(); $i++){
$dsdsd=$rows['sum(RECORDCOUNTER)'];
echo formatMoney($dsdsd, true);
}
?>
prepare("SELECT sum(RECORDCOUNTER) FROM clientsexamination WHERE SEX = 'MALE' AND DATECREATED BETWEEN :c AND :d");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(RECORDCOUNTER)'];
echo formatMoney($zxc, true);
}
?>
prepare("SELECT sum(RECORDCOUNTER) FROM clientsexamination WHERE DATECREATED BETWEEN :c AND :d");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(RECORDCOUNTER)'];
echo formatMoney($zxc, true);
}
?>
prepare("SELECT sum(RECORDCOUNTER) FROM clientsexamination WHERE AGE_GROUP = '10-14' AND DATECREATED BETWEEN :c AND :d");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(RECORDCOUNTER)'];
echo formatMoney($zxc, true);
}
?>
prepare("SELECT sum(RECORDCOUNTER) FROM clientsexamination WHERE AGE_GROUP = '15-19' AND DATECREATED BETWEEN :c AND :d");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(RECORDCOUNTER)'];
echo formatMoney($zxc, true);
}
?>
prepare("SELECT sum(RECORDCOUNTER) FROM clientsexamination WHERE AGE_GROUP = '20-24' AND DATECREATED BETWEEN :c AND :d");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(RECORDCOUNTER)'];
echo formatMoney($zxc, true);
}
?>
prepare("SELECT sum(RECORDCOUNTER) FROM clientsexamination WHERE AGE_GROUP = '24' AND DATECREATED BETWEEN :c AND :d");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(RECORDCOUNTER)'];
echo formatMoney($zxc, true);
}
?>
prepare("SELECT sum(RECORDCOUNTER) FROM clientsexamination WHERE DATECREATED BETWEEN :c AND :d");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(RECORDCOUNTER)'];
echo formatMoney($zxc, true);
}
?>
prepare("SELECT sum(RECORDCOUNTER) FROM clientsexamination WHERE SCHOOLING = 'IS' AND DATECREATED BETWEEN :c AND :d");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(RECORDCOUNTER)'];
echo formatMoney($zxc, true);
}
?>
prepare("SELECT sum(RECORDCOUNTER) FROM clientsexamination WHERE SCHOOLING = 'OS' AND DATECREATED BETWEEN :c AND :d");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(RECORDCOUNTER)'];
echo formatMoney($zxc, true);
}
?>
prepare("SELECT sum(RECORDCOUNTER) FROM clientsexamination WHERE DATECREATED BETWEEN :c AND :d");
$resultia->bindParam(':c', $d1);
$resultia->bindParam(':d', $d2);
$resultia->execute();
for($i=0; $cxz = $resultia->fetch(); $i++){
$zxc=$cxz['sum(RECORDCOUNTER)'];
echo formatMoney($zxc, true);
}
?>
connect_error) {
exit("There was an error with your connection: ".$dbhandle->connect_error);
}
?>
= '" . $from_date . "' AND DATECREATED <= '" . $to_date . "'
GROUP BY MEDICALPROBLEM ASC";
// Execute the query, or else return the error message.
$result = $dbhandle->query($strQuery) or exit("Error code ({$dbhandle->errno}): {$dbhandle->error}");
// If the query returns a valid response, prepare the JSON string
if ($result) {
// The `$arrData` array holds the chart attributes and data
$arrData = array(
"chart" => array(
"caption" => "Medical Problem Patterns among Youth",
"paletteColors" => "#3c8dbc",
"bgColor" => "#ffffff",
"borderAlpha"=> "20",
"canvasBorderAlpha"=> "0",
"usePlotGradientColor"=> "0",
"plotBorderAlpha"=> "10",
"showXAxisLine"=> "1",
"xAxisLineColor" => "#000",
"showValues" => "0",
"divlineColor" => "#999999",
"divLineIsDashed" => "1",
"showAlternateHGridColor" => "0"
)
);
$arrData["data"] = array();
// Push the data into the array
while($row = mysqli_fetch_array($result)) {
array_push($arrData["data"], array(
"label" => $row["MEDICALPROBLEM"],
"value" => $row["SUM(RECORDCOUNTER)"]
)
);
}
/*JSON Encode the data to retrieve the string containing the JSON representation of the data in the array. */
$jsonEncodedData = json_encode($arrData);
$columnChart = new FusionCharts("column2D", "myFirstChart" , 1060, 290, "chart-1", "json", $jsonEncodedData);
// Render the chart
$columnChart->render();
// Close the database connection
$dbhandle->close();
}
?>
MEDICAL PROBLEM DESCRIPTION REGISTERED BETWEEN AND