function foreign_key($fldfk, $fldvis, $label = null, $len = 50) { $vfk = isset($this->vals[$fldfk]) ? $this->vals[$fldfk] : ''; $this->hidden($fldfk, $vfk); $fld = "{$fldfk}_label"; $this->label($fld, $label, true); $v = isset($this->vals[$fldvis]) ? htmlspecial($this->vals[$fldvis]) : ''; echo "<input id={$fld} type=text size={$len} name={$fld}\n value='{$v}' readonly>"; echo "<button class=button type=button\n onclick='ChooseSpecialty(\"{$fldfk}\");'>\n Choose...</button>"; echo "<button class=button type=button\n onclick='ClearField(\"{$fldfk}\");'>\n Clear</button>"; }
protected function request() { $stmt = $this->db->query('select * from query order by title'); while ($row = $stmt->fetch()) { if ($this->ac->has_permission($row['permission'])) { echo "<br>"; $this->button('Screen', array('action_run' => 1, 'dest' => 'screen', 'query_id' => $row['query_id'])); $this->button('PDF', array('action_run' => 1, 'dest' => 'pdf', 'query_id' => $row['query_id'])); $this->button('CSV', array('action_run' => 1, 'dest' => 'csv', 'query_id' => $row['query_id'])); echo ' ' . htmlspecial($row['title']); } } }
function xxsClear(&$list) { if (is_array($list)) { foreach ($list['filelist'] as $key => $value) { $list['filelist'][$key]['ext'] = htmlspecial($value['ext']); $list['filelist'][$key]['path'] = htmlspecial($value['path']); $list['filelist'][$key]['name'] = htmlspecial($value['name']); } foreach ($list['folderlist'] as $key => $value) { $list['folderlist'][$key]['path'] = htmlspecial($value['path']); $list['folderlist'][$key]['name'] = htmlspecial($value['name']); } } else { $list = htmlspecial($list); } }
function query_list() { $stmt = $this->db->query('select * from query order by category, title'); $cat = null; while ($row = $stmt->fetch()) { if ($cat != $row['category']) { if (!is_null($cat)) { echo "</table>"; } echo "<h2>{$row['category']}</h2>"; echo "<table class=query-table>"; $cat = $row['category']; } echo "<tr>"; echo "<td nowrap valign=top>"; echo "<button type=button class=button onclick=\n 'RunQuery(\"{$row['query_id']}\")'>Run</button>"; echo "<button type=button class=button onclick=\n 'EditQuery(\"{$row['query_id']}\")'>Edit</button>"; echo "<button type=button class=button onclick=\n 'DeleteQuery(\"{$row['query_id']}\",\n \"{$row['title']}\")'>Delete</button>"; $t = htmlspecial($row['title']); $q = htmlspecial($row['query']); echo "<td width=100% valign=top>\n <p class=name>{$t}<p class=query>{$q}"; } echo "</table>"; }