query($sql_trip); $row = $stmh_trip->fetch(PDO::FETCH_ASSOC); $trip = $row['colt']; // 最終給油日取り出し // $sql_date = "SELECT date FROM fuel_colt ORDER BY num DESC"; $stmh_date = $pdo->query($sql_date); $row = $stmh_date->fetch(PDO::FETCH_ASSOC); $date = $row['date']; $date_Y = substr($date,0,4); $date_d = substr($date,5,2); $date_m = substr($date,8,2); $date = $date_Y."年".$date_d."月".$date_m."日"; // 給油累計量算出 // $sql_fuel_sum = "SELECT SUM(gs_fuel) as fuel_sum FROM fuel_colt"; $stmh_fuel_sum = $pdo->query($sql_fuel_sum); $row = $stmh_fuel_sum->fetch(PDO::FETCH_ASSOC); $fuel_sum = $row['fuel_sum']; $fuel_sum = sprintf("%01.2f",$fuel_sum); // 累計額算出 // $sql_cost_sum = "SELECT SUM(gs_money) as cost_sum FROM fuel_colt"; $stmh_cost_sum = $pdo->query($sql_cost_sum); $row = $stmh_cost_sum->fetch(PDO::FETCH_ASSOC); $cost_sum = $row['cost_sum']; // 平均単価算出 // $avg_tanka = $cost_sum / $fuel_sum; $avg_tanka = round($avg_tanka,2); $avg_tanka = sprintf("%01.2f",$avg_tanka); // 燃費計算 // $avg_fuel = $trip / $fuel_sum; $avg_fuel = round($avg_fuel,2); $avg_fuel = sprintf("%01.2f",$avg_fuel); $page_title = '燃料統計 | ランサーエボリューションVIII'; require('/home/infobuild/common/log_script.php'); ?>