if (isset($_SESSION['task']) && $_SESSION['task'] != '') { switch ($_SESSION['task']) { case 'edit': $message = 'Successfully saved the changes of tasks: ' . $_SESSION['title']; break; case 'add': $message = 'Successfully saved the tasks: ' . $_SESSION['title']; break; case 'delete': $message = 'Successfully delete the task(s) '; break; } unset($_SESSION['task']); } $db = new database(); $created = simpledate(time()); $sql = "select * from tasks order by created_t desc"; if (!($result = $db->query($sql))) { die('Error:' . $db->error()); } $tasks = array(); while ($tasks[] = $db->fetcharray()) { } $totalrows = count($tasks); $limit = 10; $paging = ceil($totalrows / $limit); $scroll = 0; $scrollnumber = 5; if (isset($_GET['page'])) { $page = $_GET['page']; } else {
if (isset($_SESSION['task']) && $_SESSION['task'] != '') { switch ($_SESSION['task']) { case 'edit': $message = 'Successfully saved the changes of tasks: ' . $_SESSION['title']; break; case 'add': $message = 'Successfully saved the tasks: ' . $_SESSION['title']; break; } unset($_SESSION['task']); } //print_r($_POST); $priority = $_POST['priority']; $_SESSION['priority'] = $priority; $db = new database(); $currentdate = simpledate(time()); //echo $currentdate; $sql = "select * from tasks where assignedto = '{$userID}' "; $sql .= " and status != 'completed' "; $sql .= " and created = '{$currentdate}'"; if ($priority) { $sql .= " and priority = '{$priority}' "; } $sql .= " order by created desc "; //echo $sql; if (!($result = $db->query($sql))) { die('Error:' . $db->error()); } $tasks = array(); while ($tasks[] = $db->fetcharray()) { }