/** * Tells the database system to let go of its data from the previous * query. * * @access public * */ function free() { parent::free(); if ($this->result) { return @pg_free_result($this->result); } }
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(); }
/** * 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); }
} } else { if (isset($_POST['username'])) { $success = false; $q = new Query($db); $q->exec('SELECT users.* FROM users WHERE users.username = \'' . $_POST['username'] . '\' AND users.password = \'' . md5($_POST['password']) . '\''); if ($q->numrows > 0) { $success = true; $_SESSION['login'] = $q->data; $_SESSION['login']['password'] = ''; // Security } $q->free(); if ($success) { redirect('?rand=' . rand()); } } $page_title = 'Login'; $content = isset($success) && !$success ? 'Not Success. Sorry.' : ''; $content .= ' <form name="frm" id="frm" action="" method="post"> <label for="username">Username</label><input type="text" name="username" id="username" value="' . $_POST['username'] . '" /><br /> <label for="password">Password</label><input type="password" name="password" id="password" /><br /> <div align="center"><a href="javascript:send();">login</a></div> </form>'; } ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">