File manager - Edit - /home/autoph/public_html/portal/includes/chart/agesexanalysis.php
Back
<?php $male = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `talents_profile` WHERE `gender` ='m' AND `age` < 20 "),0); $female = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `talents_profile` WHERE `gender` ='f' AND `age` < 20 "),0); $maleBAB = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `talents_profile` WHERE `gender` ='m' AND `age` BETWEEN 21 AND 40 "),0); $femaleBAB = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `talents_profile` WHERE `gender` ='f' AND `age` BETWEEN 21 AND 40 "),0); $maleAB = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `talents_profile` WHERE `gender` ='m' AND `age` > 40 "),0); $femaleAB = mysql_result(mysql_query("SELECT COUNT(`id`) FROM `talents_profile` WHERE `gender` ='f' AND `age` > 40 "),0); $tb = 3; $tu = 2; ?> <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 $male; ?>,<?php echo $female; ?>], ['M/F Range: 20-40', <?php echo $maleBAB; ?>,<?php echo $femaleBAB; ?>], ['M/F 41 Above', <?php echo $maleAB; ?>,<?php echo $femaleAB; ?>], ]); var options = { title : 'TALENTS AGE/SEX ANALYSIS', vAxis: {title: 'Cencus'}, hAxis: {title: 'Age Range by Sex'}, seriesType: 'bars', series: {2: {type: 'bar'}} }; var chart = new google.visualization.ComboChart(document.getElementById('chart_div')); chart.draw(data, options); } </script> </head> <body> <div id="chart_div" style="width:500px; height: 200px;border:1px solid white;border-top:1px solid lightgray"></div><br> </body> </html>
| ver. 1.4 |
.
| PHP 7.3.33 | Generation time: 0 |
proxy
|
phpinfo
|
Settings