function new_entries_by_category($category) { require_once 'dbm.php'; $data = new DataBase(); $data->open(); $query = "SELECT `id_archivo`, `nombre`, `descripcion`, `ruta`, `punteo`\r\n\t\t\t\t\t\tFROM `archivo` WHERE `id_usuario` = {$category} ORDER BY 1 ASC LIMIT 20"; $result = mysqli_query($data->get_connect(), $query); $list_of_files = array(); while ($row = mysqli_fetch_array($result)) { $elemento = new element_book($row[0], $row[1], $row[2], $row[3]); $elemento->setPunteo($row[4]); $elemento->setId($row[0]); $list_of_files[] = $elemento; } $data->close(); return $list_of_files; }
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; }