File manager - Edit - /home/autoph/public_html/ahglegal/includes/chart/barchart.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); ?> <html> <head> <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script> <script type="text/javascript"> google.charts.load('current', {'packages':['bar']}); google.charts.setOnLoadCallback(drawStuff); function drawStuff() { var data = new google.visualization.arrayToDataTable([ ['ACCESS CLASSIFICAITON', 'UTILIZATION'], ["INTRAJUGULAR", 44], ["FEMORAL", 31], ["SUBCLAVIAN", 12], ["AVF", 10], ['AVG', 3] ]); var options = { title: 'PATIENT ACCESS SUMMARY', width: 600, legend: { position: 'none' }, chart: { title: 'PATIENT ACCESS', subtitle: 'Based on Patient Records' }, bars: 'horizontal', // Required for Material Bar Charts. axes: { x: { 0: { side: 'top', label: 'ACTUAL COUNT'} // Top x-axis. } }, bar: { groupWidth: "90%" } }; var chart = new google.charts.Bar(document.getElementById('top_x_div')); chart.draw(data, options); }; </script> </head> <body> <div id="top_x_div" style="width: 600px; height:400px;"></div> </body> </html>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings