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');
33 $goto = $cfg['DefaultTabTable'];
35 // Defines the url to return to in case of error in the next sql statement
38 . '&convcharset=' . $convcharset
39 . '&server=' . $server
40 . '&db=' . urlencode($db)
41 . '&table=' . urlencode($table);
43 // Gets the list and number of fields
44 $local_query = 'SHOW FIELDS FROM ' . PMA_backquote($table) . ' FROM ' . PMA_backquote($db);
45 $result = @PMA_mysql_query
($local_query);
47 PMA_mysqlDie('', $local_query, '', $err_url);
50 $fields_cnt = mysql_num_rows($result);
51 while ($row = PMA_mysql_fetch_array($result)) {
52 $fields_list[] = $row['Field'];
54 // reformat mysql query output - staybyte - 9. June 2001
55 $shorttype = substr($type, 0, 3);
56 if ($shorttype == 'set' ||
$shorttype == 'enu') {
57 $type = eregi_replace(',', ', ', $type);
58 // Removes automatic MySQL escape format
59 $type = str_replace('\'\'', '\\\'', $type);
61 $type = eregi_replace('BINARY', '', $type);
62 $type = eregi_replace('ZEROFILL', '', $type);
63 $type = eregi_replace('UNSIGNED', '', $type);
67 $fields_type[] = $type;
69 mysql_free_result($result);
72 // retrieve keys into foreign fields, if any
73 $cfgRelation = PMA_getRelationsParam();
74 $foreigners = ($cfgRelation['relwork'] ?
PMA_getForeigners($db, $table) : FALSE);
76 <form method
="post" action
="tbl_select.php3">
77 <input type
="hidden" name
="server" value
="<?php echo $server; ?>" />
78 <input type
="hidden" name
="lang" value
="<?php echo $lang; ?>" />
79 <input type
="hidden" name
="convcharset" value
="<?php echo $convcharset; ?>" />
80 <input type
="hidden" name
="db" value
="<?php echo htmlspecialchars($db); ?>" />
81 <input type
="hidden" name
="table" value
="<?php echo htmlspecialchars($table); ?>" />
82 <input type
="hidden" name
="goto" value
="<?php echo $goto; ?>" />
83 <input type
="hidden" name
="back" value
="tbl_select.php3" />
84  
; 
; 
; 
; 
;
85 <?php
echo $strSelectFields; ?
> 
;:<br
/>
86  
; 
; 
; 
; 
;
87 <select name
="param[]" size
="<?php echo ($fields_cnt < 10) ? $fields_cnt : 10; ?>" multiple
="multiple">
90 // Displays the list of the fields
91 for ($i = 0 ; $i < $fields_cnt; $i++
) {
92 echo ' <option value="' . urlencode($fields_list[$i]) . '" selected="selected">' . htmlspecialchars($fields_list[$i]) . '</option>' . "\n";
98 <div style
="margin-bottom: 10px">
99 <?php
echo $strLimitNumRows . "\n"; ?
>
100 <input type
="text" size
="4" name
="session_max_rows" value
="<?php echo $cfg['MaxRows']; ?>" class="textfield" />
104 <?php
echo $strAddSearchConditions; ?
><br
/>
105 <input type
="text" name
="where" class="textfield" /> 
;
106 <?php
echo PMA_showMySQLDocu('Reference', 'Functions') . "\n"; ?
>
108 <?php
echo '<i>' . $strOr . '</i> ' . $strDoAQuery; ?
><br
/>
109 <table border
="<?php echo $cfg['Border']; ?>">
111 <th
><?php
echo $strField; ?
></th
>
112 <th
><?php
echo $strType; ?
></th
>
113 <th
><?php
echo $strFunction; ?
></th
>
114 <th
><?php
echo $strValue; ?
></th
>
117 for ($i = 0; $i < $fields_cnt; $i++
) {
119 $bgcolor = ($i %
2) ?
$cfg['BgcolorOne'] : $cfg['BgcolorTwo'];
122 <td bgcolor
="<?php echo $bgcolor; ?>"><?php
echo htmlspecialchars($fields_list[$i]); ?
></td
>
123 <td bgcolor
="<?php echo $bgcolor; ?>"><?php
echo $fields_type[$i]; ?
></td
>
124 <td bgcolor
="<?php echo $bgcolor; ?>">
125 <select name
="func[]">
127 reset($numfunctions);
128 reset($textfunctions);
129 if (eregi('char|blob|text|set|enum', $fields_type[$i])) {
130 while (list($k, $fc) = each($textfunctions)) {
132 . '<option value="' . htmlspecialchars($fc) . '">' . htmlspecialchars($fc) . '</option>';
135 while (list($k, $fc) = each($numfunctions)) {
137 . '<option value="' . htmlspecialchars($fc) . '">' . htmlspecialchars($fc) . '</option>';
139 } // end if... else...
144 <td bgcolor
="<?php echo $bgcolor; ?>">
147 $field = $fields_list[$i];
149 include('./libraries/get_foreign.lib.php3');
152 // we got a bug report: in some cases, even if $disp is true,
153 // there are no rows, so we add a fetch_array
154 if ($foreigners && isset($foreigners[$field]) && isset($disp) && $disp && @PMA_mysql_fetch_array
($disp)) {
155 echo ' <select name="fields[]">' . "\n";
156 echo ' <option value=""></option>' . "\n";
157 // go back to first row
158 mysql_data_seek($disp,0);
159 while ($relrow = @PMA_mysql_fetch_array
($disp)) {
160 $key = $relrow[$foreign_field];
161 $value = (($foreign_display != FALSE) ?
'-' . htmlspecialchars($relrow[$foreign_display]) : '');
162 echo ' <option value="' . urlencode($key) . '">'
163 . htmlspecialchars($key) . $value . '</option>' . "\n";
165 echo ' </select>' . "\n";
167 echo ' <input type="text" name="fields[]" size="40" class="textfield" />' . "\n";
170 <input type
="hidden" name
="names[]" value
="<?php echo urlencode($fields_list[$i]); ?>" />
171 <input type
="hidden" name
="types[]" value
="<?php echo $fields_type[$i]; ?>" />
181 <?php
echo $strDisplayOrder; ?
><br
/>
182 <select name
="orderField" style
="vertical-align: middle">
183 <option value
="--nil--"></option
>
186 for ($i = 0; $i < $fields_cnt; $i++
) {
188 echo '<option value="' . urlencode($fields_list[$i]) . '">' . htmlspecialchars($fields_list[$i]) . '</option>' . "\n";
192 <input type
="radio" name
="order" value
="ASC" checked
="checked" />
193 <?php
echo $strAscending; ?
> 
;
194 <input type
="radio" name
="order" value
="DESC" />
195 <?php
echo $strDescending; ?
><br
/><br
/>
199  
; 
; 
; 
;
200 <input type
="submit" name
="submit" value
="<?php echo $strGo; ?>" />
205 include('./footer.inc.php3');
210 * Selection criteria have been submitted -> do the work
214 $sql_query = 'SELECT ' . PMA_backquote(urldecode($param[0]));
219 $sql_query .= ',' . PMA_backquote(urldecode($param[$i]));
223 $sql_query .= ' FROM ' . PMA_backquote($table);
226 $sql_query .= ' WHERE ' . ((get_magic_quotes_gpc()) ?
stripslashes($where) : $where);
229 $sql_query .= ' WHERE 1';
230 for ($i = 0; $i < count($fields); $i++
) {
231 if (!empty($fields) && $fields[$i] != '') {
232 if (eregi('char|blob|text|set|enum|date|time|year', $types[$i])) {
237 if (strtoupper($fields[$i]) == 'NULL' ||
strtoupper($fields[$i]) == 'NOT NULL') {
241 $sql_query .= ' AND ' . PMA_backquote(urldecode($names[$i])) . " $func[$i] $quot$fields[$i]$quot";
246 if ($orderField != '--nil--') {
247 $sql_query .= ' ORDER BY ' . PMA_backquote(urldecode($orderField)) . ' ' . $order;
250 // The query will be stripslashed in sql.php3 if "magic_quotes_gpc" is on
251 if (get_magic_quotes_gpc()) {
252 $sql_query = addslashes($sql_query);
254 include('./sql.php3');