#!/usr/bin/php -q <?php set_time_limit(30); require 'phpagi.php'; $agi = new AGI(); $mysqli = mysqli_connect('parkingcity.nl', 'citypark', 'KoffieKopje12', 'citypark'); $setting = $mysqli->query("SELECT setting_value FROM citypark_setting WHERE setting_name = 'citypark_parking_space'"); $setting_count = $setting->fetch_object()->setting_value; $parking = $mysqli->query("SELECT COUNT(id) AS aantal FROM parking WHERE start_date IS NOT NULL AND end_date IS NULL"); $parking_count = $parking->fetch_object()->aantal; $free_space = $setting_count - $parking_count; $agi->say_number($free_space);