db->fetchObjectList($sql); } public function formatYear($year) { $out = ''; $sql = sprintf("SELECT * FROM sprit_log WHERE EXTRACT(YEAR from date) = %d ORDER BY date ASC", $year);; $total_km = 0; $total_liter = 0; $total_price = 0; foreach ($this->db->fetchObjectList($sql) as $row) { $out .= sprintf('
Datum | Ort | Tankstelle | ' . 'EUR/l | l | EUR | km | gesamt | ' . '
---|---|---|---|---|---|---|---|
Summe | ' . sprintf('%.2f | %.2f | %d | ', $total_liter, $total_price, $total_km). ' |