Slim functions

functions.php

Redirect
return $res->withRedirect("/login");

Get GET parameters
 $jobId = $req->getQueryParams()['jobId']; //checks _GET [IS PSR-7 compliant]
Get POST parameters
  $filename = $req->getParsedBody()['filename'];
Sanitize query param
 $jobId = filter_var($jobId, FILTER_SANITIZE_NUMBER_INT);

DB access
 /**@var PDO $db */
  $db   = $this->get("mysql-archiveapp");
  $sql  = "SELECT * FROM job where id = :id";
  $stmt = $db->prepare($sql);
  $stmt->bindValue(":id", $jobId);
  $stmt->execute();

DB Fetch
$stmt->fetch()

Download file
$fp     = $task->getReport()->getReportFilePointer();
        $stream = new \Slim\Http\Stream($fp); // create a stream instance for the response body

        return $res->withHeader('Content-Type', 'application/force-download')
                   ->withHeader('Content-Type', 'application/octet-stream')
                   ->withHeader('Content-Type', 'application/download')
                   ->withHeader('Content-Description', 'File Transfer')
                   ->withHeader('Content-Transfer-Encoding', 'binary')
                   ->withHeader('Content-Disposition', 'attachment; filename="' . basename($task->getReport()->getFilename()) . '.csv"')
                   ->withHeader('Expires', '0')
                   ->withHeader('Cache-Control', 'must-revalidate, post-check=0, pre-check=0')
                   ->withHeader('Pragma', 'public')
                   ->withBody($stream); // all stream contents will be sent to the response

Return body
$res->getBody()->write("file not found");

Render view
$this->view->render($res, "query.phtml",[//args]);