public function getBook($id)
{
require_once 'dbm.php';
$data = new DataBase();
$data->open();
$query = "SELECT * FROM `archivo` WHERE `id_archivo` = {$id}";
$result = mysqli_query($data->get_connect(), $query);
$row = mysqli_fetch_array($result);
$this->id = $row[0];
$this->user = $row[1];
$this->title = $row[2];
$this->path = $row[5];
$this->description = $row[3];
$this->punteo = $row[6];
$data->close();
}
function getUserId($usuario, $contrasena)
{
if ($usuario == "" or $contrasena == "") {
return -1;
}
$datab = new DataBase();
$datab->open();
$connect = $datab->get_connect();
echo $query = "SELECT id_usuario, nombre, contrasena FROM usuario WHERE nombre = '" . $usuario . "' AND contrasena = '" . $contrasena . "';";
$result = mysqli_query($connect, $query);
while ($row = mysqli_fetch_array($result)) {
mysqli_close($connect);
return $row[0];
}
mysqli_close($connect);
return -1;
}
function getComentarios($id_archivo)
{
require_once 'dbm.php';
require_once 'user.php';
$data = new DataBase();
$data->open();
$comentarios = array();
$query = "SELECT comentario.id_usuario, comentario.texto FROM comentario WHERE comentario.id_archivo = {$id_archivo} ORDER BY comentario.id_comentario DESC";
$result = mysqli_query($data->get_connect(), $query);
while ($row = mysqli_fetch_array($result)) {
$elemento = new Comment();
$usuario = new User();
$usuario->getUser($row[0]);
$elemento->setComentario($usuario->getNombre(), $row[1]);
$comentarios[] = $elemento;
}
$data->close();
return $comentarios;
}
public function Delete()
{
require_once 'dbm.php';
$data = new DataBase();
$data->open();
$query = "DELETE FROM categoria WHERE id_categoria = {$this->id}";
$result = mysqli_query($data->get_connect(), $query);
$data->close();
if ($result) {
$this->id = null;
$this->nombre = null;
$this->descripcion = null;
return true;
} else {
return false;
}
}
function list_of_files()
{
// Esta funcion devolvera un arreglo de objetos para los archivos
require_once 'dbm.php';
$data = new DataBase();
$userid = $this->userid;
$query = "SELECT * FROM archivo WHERE id_usuario = {$userid}";
$data->open();
$result = mysqli_query($data->get_connect(), $query);
$list_of_files = array();
while ($row = mysqli_fetch_array($result)) {
$elemento = new element_book($row[1], $row[2], $row[3], $row[4]);
$elemento->setId($row[0]);
$list_of_files[] = $elemento;
}
$data->close();
return $list_of_files;
}
