maurobonfietti / api-rest-slimphp

        return $statement->fetchAll();

    }

    public function getAll(int $userId): array

    {

        $query = 'SELECT * FROM `tasks` WHERE `userId` = :userId ORDER BY `id`';

        $statement = $this->getDb()->prepare($query);

        $statement->bindParam('userId', $userId);

        $statement->execute();

        return $statement->fetchAll();

    }

    public function search($tasksName, int $userId, $status): array

    {

        return $this->checkAndGetTask((int) $task->id, (int) $task->userId);

    }

    public function delete(int $taskId, int $userId): string

    {

        $query = 'DELETE FROM `tasks` WHERE `id` = :id AND `userId` = :userId';

        $statement = $this->getDb()->prepare($query);

        $statement->bindParam('id', $taskId);

        $statement->bindParam('userId', $userId);

        $statement->execute();

        return 'The task was deleted.';

    }

}