public function __construct()
{
$this->core = Core::getInstance();
//getting instance from core
$this->db = $this->core->connection;
//setting models $db to connection with database and use NOTORM
}
function __construct()
{
$this->core = Core::getInstance();
//$this->core->dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
function __construct($userdb)
{
$this->core = Core::getInstanceWithUserDB($userdb);
}
function __construct()
{
$this->core = Core::getInstance();
}
}
});
$app->get('/colector/archivos/descargar/:nombre', function ($nombre) use($app) {
$file = MEDIA_DIR . DS . "{$nombre}";
//file location
header('Content-Type: application/octet-stream');
header('Content-Disposition: attachment; filename="' . basename($file) . '"');
header('Content-Length: ' . filesize($file));
readfile($file);
});
$app->get('/colector/test', function () use($app) {
$coredb = Core::getInstance();
$query = "SELECT * from archivos ORDER BY id DESC LIMIT 1";
$r = array();
$stmt = $coredb->dbh->prepare($query);
$r = $stmt->execute() ? $stmt->fetchAll(PDO::FETCH_ASSOC) : 0;
if (count($r) > 0) {
header("Content-Type: text/plain");
echo nl2br(file_get_contents($r[0]['ruta']));
}
});
$app->get('/colector/db', function () use($app) {
$coredb = Core::getInstance();
try {
// DROP TABLE IF EXISTS archivos ;
$query = "\n\t\t\t\t\tCREATE TABLE IF NOT EXISTS archivos(\n\t\t\t\t\t\t\tid INTEGER PRIMARY KEY AUTOINCREMENT,\n\t\t\t\t\t\t\tnombre TEXT,\n\t\t\t\t\t\t\thash TEXT,\n\t\t\t\t\t\t\truta TEXT,\n\t\t\t\t\t\t\tcreated_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n\t\t\t\t\t\t\tupdated_at DATETIME DEFAULT CURRENT_TIMESTAMP\n\t\t\t\t\t);\n\t\t\t";
$stmt = $coredb->dbh->exec($query);
} catch (PDOException $e) {
echo $e->getMessage();
}
});
