/** * Function to create new task, validate and save it to DB * @param $new_task - user input - task */ public function createNewTask($new_task) { $new_task = Validate::cleanInput($new_task); if ($new_task != "") { //not to allow to add empty task $conn = Model\Db::getConnection(); $query_to_create_new_task = 'INSERT INTO `task`(`date`, `name`, `is_done`, `is_deleted`, `time`) VALUES (?, ?, ?, ?, ?)'; $stmt = $conn->prepare($query_to_create_new_task); $stmt->bindParam(1, $date); $stmt->bindParam(2, $name); $stmt->bindParam(3, $is_done); $stmt->bindParam(4, $is_deleted); $stmt->bindParam(5, $time); $stmt->execute(); $date = date("Y-m-d"); $name = $new_task; $is_done = 0; $is_deleted = 0; $time = date("H:i:s"); $stmt->execute(); } }