public function getListPage($paginaActual = 0, $nrpp = Constant::NRPP)
{
$this->bd->select($this->tabla, "*", "1=1", array(), "url, nombre", "{$paginaActual},{$nrpp}");
$r = array();
while ($fila = $this->bd->getRow()) {
$cuadro = new Cuadro();
$cuadro->set($fila);
$r[] = $cuadro;
}
return $r;
}
private static function addCuadro($gestor, $sesion)
{
$destino = "../contenido/" . $sesion->getUser()->getEmail() . "/";
$subir = new UploadFileMultiple("foto", $destino);
$subir->upload();
if ($subir->getSubida(0)) {
$bd2 = new DB();
$gestorC = new ManagerCuadro($bd2);
$cuadro = new Cuadro();
$cuadro->read();
$cuadro->setUrl($subir->getDestino(0));
$gestorC->insert($cuadro);
$bd2->close();
self::crearCuadro($gestor, $sesion, "<h1>Cuadro creado.</h1>");
} else {
self::crearCuadro($gestor, $sesion, "<h1>Fallo la subida del cuadro. Destino: {$destino}</h1>");
}
}
function getList2($pagina = 1, $nrpp = Constant::NRPF)
{
$registroInicial = ($pagina - 1) * $nrpp;
$this->bd->select($this->tabla, "*", "1=1", array(), "nombreCuadro", "{$registroInicial}, {$nrpp}");
$r = array();
while ($fila = $this->bd->getRow()) {
$cuadro = new Cuadro();
$cuadro->set($fila);
$r[] = $cuadro;
}
return $r;
}
<?php
include 'Classes/medoo.php';
include 'Classes/Cuadro.php';
if ($_REQUEST['action'] == 'delete') {
Cuadro::delete($database, $_REQUEST['id']);
} elseif ($_REQUEST['action'] == 'search') {
echo Cuadro::search($database, $_REQUEST['draw'], $_REQUEST['search'], $_REQUEST['columns'][$_REQUEST['order'][0]['column']]['data'], $_REQUEST['order'][0]['dir'], $_REQUEST['start'], $_REQUEST['length']);
} elseif ($_REQUEST['action'] == 'add') {
Cuadro::add($database, $_REQUEST['name'], $_REQUEST['author'], $_REQUEST['age'], $_REQUEST['description'], $_FILES['img']);
} elseif ($_REQUEST['action'] == 'info') {
echo Cuadro::getModalInfoById($database, $_REQUEST['id']);
} else {
header("Location:index.php");
}
