File manager - Edit - /home/autoph/public_html/ahglegal/includes/chart/agesexanalysis.php
Back
<?php $MaleLessTwenty = mysql_result(mysql_query("SELECT COUNT('patient_id') FROM `patient_list` WHERE `patient_age` < 20 AND `patient_sex`='Male' AND `branch_code`='$compCode' AND `nephro_status`!='Expired'"),0); $MaleTwentyOne_LessFifty = mysql_result(mysql_query("SELECT COUNT('patient_id') FROM `patient_list` WHERE `patient_age` > 20 AND `patient_age` < 51 AND `patient_sex`='Male' AND `branch_code`='$compCode' AND `nephro_status`!='Expired'"),0); $MaleFiftyOneAbove =mysql_result(mysql_query("SELECT COUNT('patient_id') FROM `patient_list` WHERE `patient_age` > 50 AND `patient_sex`='Male' AND `branch_code`='$compCode' AND `nephro_status`!='Expired'"),0); $FeMaleLessTwenty = mysql_result(mysql_query("SELECT COUNT('patient_id') FROM `patient_list` WHERE `patient_age` < 20 AND `patient_sex`='Female' AND `branch_code`='$compCode' AND `nephro_status`!='Expired'"),0); $FeMaleTwentyOne_LessFifty = mysql_result(mysql_query("SELECT COUNT('patient_id') FROM `patient_list` WHERE `patient_age` > 20 AND `patient_age` < 51 AND `patient_sex`='Female' AND `branch_code`='$compCode' AND `nephro_status`!='Expired'"),0); $FeMaleFiftyOneAbove =mysql_result(mysql_query("SELECT COUNT('patient_id') FROM `patient_list` WHERE `patient_age` > 50 AND `patient_sex`='Female' AND `branch_code`='$compCode' AND `nephro_status`!='Expired'"),0); ?> <html> <head> <script type="text/javascript" src="http://localhost/nephro/script/chartScript/loader.js"></script> <script type="text/javascript"> google.charts.load('current', {'packages':['corechart']}); google.charts.setOnLoadCallback(drawVisualization); function drawVisualization() { // Some raw data (not necessarily accurate) var data = google.visualization.arrayToDataTable([ ['Gender', 'Male', 'Female'], ['M/F Less 20', <?php echo $MaleLessTwenty; ?>,<?php echo $FeMaleLessTwenty; ?>], ['M/F 20 - 50', <?php echo $MaleTwentyOne_LessFifty; ?>,<?php echo $FeMaleTwentyOne_LessFifty; ?>], ['M/F 51 Above', <?php echo $MaleFiftyOneAbove; ?>,<?php echo $FeMaleFiftyOneAbove; ?>], ]); var options = { title : 'PATIENT AGE/SEX ANALYSIS', vAxis: {title: 'Cencus'}, hAxis: {title: 'Age Range by Sex'}, seriesType: 'bars', series: {5: {type: 'line'}} }; var chart = new google.visualization.ComboChart(document.getElementById('chart_div')); chart.draw(data, options); } </script> </head> <body> <div id="chart_div" style="width: 700px; height: 430px;background:white"></div> </body> </html>
| ver. 1.4 |
.
| PHP 8.1.32 | Generation time: 0.01 |
proxy
|
phpinfo
|
Settings