$page = 1; } $view_option = 'monthly'; $limit = 47; if (!empty($_GET['view'])) { if ($_GET['view'] == 'weekly') { $limit = 7; $view_option = 'weekly'; } } $start = time() + ($page - 1) * $limit * 86400; $offset = strtotime("Monday this week", $start); $dbh = new DBWorker(); $apps = null; $get_apps = 'SELECT * FROM apps WHERE app_date > UNIX_TIMESTAMP(NOW())'; $apps = DBWorker::getRows($get_apps); function search($time) { global $apps; if (!empty($apps)) { foreach ($apps as $app) { if (in_array($time, $app)) { return $app['app_date']; } } } return false; } $stats = array('today' => 0, 'this_week' => 0, 'this_month' => 0, 'this_year' => 0); function countApps() {
<?php /** * Created by JetBrains PhpStorm. * User: Peter * Date: 8/9/15 * Time: 11:13 PM * To change this template use File | Settings | File Templates. */ require_once "auth.inc.php"; require_once "includes/database/DBWorker.php"; $day = !empty($_GET['app']) ? intval($_GET['app']) : 0; $apps = null; $lower_limit = strtotime('midnight today', $day); $upper_limit = $lower_limit + 86400; $app_to_delete = !empty($_GET['h']) ? $_GET['h'] : null; if ($app_to_delete) { DBWorker::lookup('DELETE FROM apps WHERE id = :id', ':id', $app_to_delete); } $get_apps_today = "SELECT * FROM apps WHERE app_date >= {$lower_limit} AND app_date <= {$upper_limit}"; $apps = DBWorker::getRows($get_apps_today); //echo '<pre>', print_r($apps), '</pre>';