/** * Obtiene los usuarios y los <li> del * submenu de la derecha. * * @return array */ function get_users() { global $db; global $id_users; $q = new Query($db); $q->exec('SELECT users.id_users , users.username , users.name , users.description FROM users'); $data = array(); $submenu = ''; for ($i = 0; $i < $q->numrows; $i++) { $data[$q->data['id_users']] = $q->data; $selected = $id_users == $q->data['id_users'] ? ' class="selected"' : ''; $submenu .= ' <li><a href="?id_users=' . $q->data['id_users'] . '"' . $selected . '>' . $q->data['name'] . '</a></li>'; $q->nxt(); } $q->free(); return array($data, $submenu); }
function DoUpdate($table, $db, $field, $vars) { $this->db = $db; $this->table = $table; $this->vars = $vars; $this->field = $field; $q = new Query($this->db); $q->exec('SHOW COLUMNS FROM ' . $this->table); $q->inic(); for ($i = 0; $i < $q->numrows; $i++) { $row = $q->data; $this->_col[$row['Field']] = $row['Field']; $q->nxt(); } $q->free(); }