$current_month = date(m);
$current_year = date(Y);
$start_date = $current_year."-".$current_month."-01";
$end_date = $current_year."-".$current_month."-31";
$query = "SELECT count( * ) as nof FROM flights WHERE FlightDate BETWEEN '$start_date' AND '$end_date'";
$result = $db->query($query);
$num_results = $result->num_rows;
$rowresult = $result->fetch_assoc();
$total_flights2 = $rowresult['nof'];
$total_flights = number_format($total_flights2, 0, ',', '.');
$query = "SELECT SUM(NbrPassengers) FROM flights WHERE FlightDate BETWEEN '$start_date' AND '$end_date'";
$result = $db->query($query);
$num_results = $result->num_rows;
$rowresult = $result->fetch_assoc();
$total_passengers2 = $rowresult['SUM(NbrPassengers)'];
$total_passengers = number_format($total_passengers2, 0, ',', '.');
$query = "SELECT SUM(CargoWeight) FROM flights WHERE FlightDate BETWEEN '$start_date' AND '$end_date'";
$result = $db->query($query);
$num_results = $result->num_rows;
$rowresult = $result->fetch_assoc();
$total_cargo2 = $rowresult['SUM(CargoWeight)'];
$total_cargo = number_format($total_cargo2, 2, ',', '.');
$query = "SELECT Sum(Time_to_Sec(TotalBlockTime)) AS ttime FROM flights WHERE FlightDate BETWEEN '$start_date' AND '$end_date'";
$result = $db->query($query);
$num_results = $result->num_rows;
$rowresult = $result->fetch_assoc();
$total_time = $rowresult['ttime'];
$time_hour = $total_time/3600;
$real_time_hour = floor($time_hour);
$time_minute=((($time_hour - $real_time_hour) *100) *60) /100;
$real_time_minute = floor($time_minute);
if ($real_time_minute < 10) {
$real_time_minute = "0".$real_time_minute ;
}
$real_total_time = $real_time_hour.":". $real_time_minute. ":00";
?>
<table border="0" cellpadding="0" cellspacing="0">
<tr>
<td><img src="/files/month_stats.jpg" width="310" /></td>
</tr>
</table>
<table width="310" border="1" cellspacing="0" cellpadding="0" class="sample2">
<tr>
<td><font color="#882b02" style="font-size:13px" face="Lucida Sans Unicode, Lucida Grande, sans-serif">Total Flights</font></td>
<td align="right"><font color="#882b02" style="font-size:13px" face="Lucida Sans Unicode, Lucida Grande, sans-serif"></font></td>
<tr>
<td><font color="#882b02" style="font-size:13px" face="Lucida Sans Unicode, Lucida Grande, sans-serif">Total Hours</font></td>
<td align="right"><font color="#882b02" style="font-size:13px" face="Lucida Sans Unicode, Lucida Grande, sans-serif"></font></td>
</tr>
<tr>
<td><font color="#882b02" style="font-size:13px" face="Lucida Sans Unicode, Lucida Grande, sans-serif">Passengers Carried</font></td>
<td align="right"><font color="#882b02" style="font-size:13px" face="Lucida Sans Unicode, Lucida Grande, sans-serif"></font></td>
</tr>
<tr>
<td><font color="#882b02" style="font-size:13px" face="Lucida Sans Unicode, Lucida Grande, sans-serif">Cargo Transfered</font></td>
<td align="right"><font color="#882b02" style="font-size:13px" face="Lucida Sans Unicode, Lucida Grande, sans-serif"><?php echo $total_cargo;?></font></td>
</tr>
