Example #1
0
/**
 * 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);
}
Example #2
0
 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();
 }