3 // vim: expandtab sw=4 ts=4 sts=4:
7 * Gets some core libraries
9 require('./libraries/grab_globals.lib.php3');
10 require('./libraries/common.lib.php3');
11 require('./libraries/relation.lib.php3'); // foreign keys
15 * Defines arrays of functions (should possibly be in config.inc.php3
16 * so it can also be used in tbl_qbe.php3)
18 $numfunctions = array('=', '>', '>=', '<', '<=', '!=');
19 $textfunctions = array('LIKE', '=', '!=');
23 * Not selection yet required -> displays the selection form
25 if (!isset($param) ||
$param[0] == '') {
26 // Gets some core libraries
27 include('./tbl_properties_common.php3');
28 $err_url = 'tbl_select.php3' . $err_url;
29 $url_query .= '&goto=tbl_select.php3&back=tbl_select.php3';
30 include('./tbl_properties_table_info.php3');
32 // Defines the url to return to in case of error in the next sql statement
35 . '&convcharset=' . $convcharset
36 . '&server=' . $server
37 . '&db=' . urlencode($db)
38 . '&table=' . urlencode($table);
40 // Gets the list and number of fields
41 $local_query = 'SHOW FIELDS FROM ' . PMA_backquote($table) . ' FROM ' . PMA_backquote($db);
42 $result = @PMA_mysql_query
($local_query);
44 PMA_mysqlDie('', $local_query, '', $err_url);
47 $fields_cnt = mysql_num_rows($result);
48 while ($row = PMA_mysql_fetch_array($result)) {
49 $fields_list[] = $row['Field'];
51 // reformat mysql query output - staybyte - 9. June 2001
52 $shorttype = substr($type, 0, 3);
53 if ($shorttype == 'set' ||
$shorttype == 'enu') {
54 $type = eregi_replace(',', ', ', $type);
55 // Removes automatic MySQL escape format
56 $type = str_replace('\'\'', '\\\'', $type);
58 $type = eregi_replace('BINARY', '', $type);
59 $type = eregi_replace('ZEROFILL', '', $type);
60 $type = eregi_replace('UNSIGNED', '', $type);
64 $fields_type[] = $type;
66 mysql_free_result($result);
69 // retrieve keys into foreign fields, if any
70 $cfgRelation = PMA_getRelationsParam();
71 $foreigners = ($cfgRelation['relwork'] ?
PMA_getForeigners($db, $table) : FALSE);
73 <form method
="post" action
="tbl_select.php3">
74 <input type
="hidden" name
="server" value
="<?php echo $server; ?>" />
75 <input type
="hidden" name
="lang" value
="<?php echo $lang; ?>" />
76 <input type
="hidden" name
="convcharset" value
="<?php echo $convcharset; ?>" />
77 <input type
="hidden" name
="db" value
="<?php echo $db; ?>" />
78 <input type
="hidden" name
="table" value
="<?php echo $table; ?>" />
79 <input type
="hidden" name
="goto" value
="<?php echo $goto; ?>" />
80 <input type
="hidden" name
="back" value
="tbl_select.php3" />
81  
; 
; 
; 
; 
;
82 <?php
echo $strSelectFields; ?
> 
;:<br
/>
83  
; 
; 
; 
; 
;
84 <select name
="param[]" size
="<?php echo ($fields_cnt < 10) ? $fields_cnt : 10; ?>" multiple
="multiple">
87 // Displays the list of the fields
88 for ($i = 0 ; $i < $fields_cnt; $i++
) {
89 echo ' <option value="' . urlencode($fields_list[$i]) . '" selected="selected">' . htmlspecialchars($fields_list[$i]) . '</option>' . "\n";
95 <div style
="margin-bottom: 10px">
96 <?php
echo $strLimitNumRows . "\n"; ?
>
97 <input type
="text" size
="4" name
="session_max_rows" value
="<?php echo $cfg['MaxRows']; ?>" class="textfield" />
101 <?php
echo $strAddSearchConditions; ?
><br
/>
102 <input type
="text" name
="where" class="textfield" /> 
;
103 <?php
echo PMA_showMySQLDocu('Reference', 'Functions') . "\n"; ?
>
105 <?php
echo '<i>' . $strOr . '</i> ' . $strDoAQuery; ?
><br
/>
106 <table border
="<?php echo $cfg['Border']; ?>">
108 <th
><?php
echo $strField; ?
></th
>
109 <th
><?php
echo $strType; ?
></th
>
110 <th
><?php
echo $strFunction; ?
></th
>
111 <th
><?php
echo $strValue; ?
></th
>
114 for ($i = 0; $i < $fields_cnt; $i++
) {
116 $bgcolor = ($i %
2) ?
$cfg['BgcolorOne'] : $cfg['BgcolorTwo'];
119 <td bgcolor
="<?php echo $bgcolor; ?>"><?php
echo htmlspecialchars($fields_list[$i]); ?
></td
>
120 <td bgcolor
="<?php echo $bgcolor; ?>"><?php
echo $fields_type[$i]; ?
></td
>
121 <td bgcolor
="<?php echo $bgcolor; ?>">
122 <select name
="func[]">
124 reset($numfunctions);
125 reset($textfunctions);
126 if (eregi('char|blob|text|set|enum', $fields_type[$i])) {
127 while (list($k, $fc) = each($textfunctions)) {
129 . '<option value="' . htmlspecialchars($fc) . '">' . htmlspecialchars($fc) . '</option>';
132 while (list($k, $fc) = each($numfunctions)) {
134 . '<option value="' . htmlspecialchars($fc) . '">' . htmlspecialchars($fc) . '</option>';
136 } // end if... else...
141 <td bgcolor
="<?php echo $bgcolor; ?>">
144 $field = $fields_list[$i];
146 include('./libraries/get_foreign.lib.php3');
149 if ($foreigners && isset($foreigners[$field]) && isset($disp) && $disp) {
150 echo ' <select name="fields[]">' . "\n";
151 echo ' <option value=""></option>' . "\n";
152 while ($relrow = @PMA_mysql_fetch_array
($disp)) {
153 $key = $relrow[$foreign_field];
154 $value = (($foreign_display != FALSE) ?
'-' . htmlspecialchars($relrow[$foreign_display]) : '');
155 echo ' <option value="' . urlencode($key) . '">'
156 . htmlspecialchars($key) . $value . '</option>' . "\n";
158 echo ' </select>' . "\n";
160 echo ' <input type="text" name="fields[]" size="40" class="textfield" />' . "\n";
163 <input type
="hidden" name
="names[]" value
="<?php echo urlencode($fields_list[$i]); ?>" />
164 <input type
="hidden" name
="types[]" value
="<?php echo $fields_type[$i]; ?>" />
174 <?php
echo $strDisplayOrder; ?
><br
/>
175 <select name
="orderField" style
="vertical-align: middle">
176 <option value
="--nil--"></option
>
179 for ($i = 0; $i < $fields_cnt; $i++
) {
181 echo '<option value="' . urlencode($fields_list[$i]) . '">' . htmlspecialchars($fields_list[$i]) . '</option>' . "\n";
185 <input type
="radio" name
="order" value
="ASC" checked
="checked" />
186 <?php
echo $strAscending; ?
> 
;
187 <input type
="radio" name
="order" value
="DESC" />
188 <?php
echo $strDescending; ?
><br
/><br
/>
192  
; 
; 
; 
;
193 <input type
="submit" name
="submit" value
="<?php echo $strGo; ?>" />
198 include('./footer.inc.php3');
203 * Selection criteria have been submitted -> do the work
207 $sql_query = 'SELECT ' . PMA_backquote(urldecode($param[0]));
212 $sql_query .= ',' . PMA_backquote(urldecode($param[$i]));
216 $sql_query .= ' FROM ' . PMA_backquote($table);
219 $sql_query .= ' WHERE ' . ((get_magic_quotes_gpc()) ?
stripslashes($where) : $where);
222 $sql_query .= ' WHERE 1';
223 for ($i = 0; $i < count($fields); $i++
) {
224 if (!empty($fields) && $fields[$i] != '') {
225 if (eregi('char|blob|text|set|enum|date|time|year', $types[$i])) {
230 if (strtoupper($fields[$i]) == 'NULL' ||
strtoupper($fields[$i]) == 'NOT NULL') {
234 $sql_query .= ' AND ' . PMA_backquote(urldecode($names[$i])) . " $func[$i] $quot$fields[$i]$quot";
239 if ($orderField != '--nil--') {
240 $sql_query .= ' ORDER BY ' . PMA_backquote(urldecode($orderField)) . ' ' . $order;
243 // The query will be stripslashed in sql.php3 if "magic_quotes_gpc" is on
244 if (get_magic_quotes_gpc()) {
245 $sql_query = addslashes($sql_query);
247 include('./sql.php3');