?  search:
summary | log | graphiclog1 | graphiclog2 | commit | commitdiff | tree | refs | edit | fork
blame | history | raw | HEAD
Conditional Ajax for db Structure and Tracking
[phpmyadmin-themes.git] / libraries / display_tbl.lib.php
blobc2c8518f5794081a7d9d53a47aff38c6a6caacb6
1 <?php
2 /* vim: set expandtab sw=4 ts=4 sts=4: */
3 /**
4 * library for displaying table with results from all sort of select queries
5 *
6 * @package phpMyAdmin
7 */
8
9 /**
10 *
11 */
12 require_once './libraries/Index.class.php';
13
14 /**
15 * Defines the display mode to use for the results of a SQL query
16 *
17 * It uses a synthetic string that contains all the required informations.
18 * In this string:
19 * - the first two characters stand for the action to do while
20 * clicking on the "edit" link (e.g. 'ur' for update a row, 'nn' for no
21 * edit link...);
22 * - the next two characters stand for the action to do while
23 * clicking on the "delete" link (e.g. 'kp' for kill a process, 'nn' for
24 * no delete link...);
25 * - the next characters are boolean values (1/0) and respectively stand
26 * for sorting links, navigation bar, "insert a new row" link, the
27 * bookmark feature, the expand/collapse text/blob fields button and
28 * the "display printable view" option.
29 * Of course '0'/'1' means the feature won't/will be enabled.
30 *
31 * @param string the synthetic value for display_mode (see a few
32 * lines above for explanations)
33 * @param integer the total number of rows returned by the SQL query
34 * without any programmatically appended "LIMIT" clause
35 * (just a copy of $unlim_num_rows if it exists, else
36 * computed inside this function)
37 *
38 * @return array an array with explicit indexes for all the display
39 * elements
40 *
41 * @global string the database name
42 * @global string the table name
43 * @global integer the total number of rows returned by the SQL query
44 * without any programmatically appended "LIMIT" clause
45 * @global array the properties of the fields returned by the query
46 * @global string the URL to return to in case of error in a SQL
47 * statement
48 *
49 * @access private
50 *
51 * @see PMA_displayTable()
52 */
53 function PMA_setDisplayMode(&$the_disp_mode, &$the_total)
54 {
55 global $db, $table;
56 global $unlim_num_rows, $fields_meta;
57 global $err_url;
58
59 // 1. Initializes the $do_display array
60 $do_display = array();
61 $do_display['edit_lnk'] = $the_disp_mode[0] . $the_disp_mode[1];
62 $do_display['del_lnk'] = $the_disp_mode[2] . $the_disp_mode[3];
63 $do_display['sort_lnk'] = (string) $the_disp_mode[4];
64 $do_display['nav_bar'] = (string) $the_disp_mode[5];
65 $do_display['ins_row'] = (string) $the_disp_mode[6];
66 $do_display['bkm_form'] = (string) $the_disp_mode[7];
67 $do_display['text_btn'] = (string) $the_disp_mode[8];
68 $do_display['pview_lnk'] = (string) $the_disp_mode[9];
69
70 // 2. Display mode is not "false for all elements" -> updates the
71 // display mode
72 if ($the_disp_mode != 'nnnn000000') {
73 // 2.0 Print view -> set all elements to false!
74 if (isset($GLOBALS['printview']) && $GLOBALS['printview'] == '1') {
75 $do_display['edit_lnk'] = 'nn'; // no edit link
76 $do_display['del_lnk'] = 'nn'; // no delete link
77 $do_display['sort_lnk'] = (string) '0';
78 $do_display['nav_bar'] = (string) '0';
79 $do_display['ins_row'] = (string) '0';
80 $do_display['bkm_form'] = (string) '0';
81 $do_display['text_btn'] = (string) '0';
82 $do_display['pview_lnk'] = (string) '0';
83 }
84 // 2.1 Statement is a "SELECT COUNT", a
85 // "CHECK/ANALYZE/REPAIR/OPTIMIZE", an "EXPLAIN" one or
86 // contains a "PROC ANALYSE" part
87 elseif ($GLOBALS['is_count'] || $GLOBALS['is_analyse'] || $GLOBALS['is_maint'] || $GLOBALS['is_explain']) {
88 $do_display['edit_lnk'] = 'nn'; // no edit link
89 $do_display['del_lnk'] = 'nn'; // no delete link
90 $do_display['sort_lnk'] = (string) '0';
91 $do_display['nav_bar'] = (string) '0';
92 $do_display['ins_row'] = (string) '0';
93 $do_display['bkm_form'] = (string) '1';
94 if ($GLOBALS['is_maint']) {
95 $do_display['text_btn'] = (string) '1';
96 } else {
97 $do_display['text_btn'] = (string) '0';
98 }
99 $do_display['pview_lnk'] = (string) '1';
100 }
101 // 2.2 Statement is a "SHOW..."
102 elseif ($GLOBALS['is_show']) {
103 /**
104 * 2.2.1
105 * @todo defines edit/delete links depending on show statement
106 */
107 $tmp = preg_match('@^SHOW[[:space:]]+(VARIABLES|(FULL[[:space:]]+)?PROCESSLIST|STATUS|TABLE|GRANTS|CREATE|LOGS|DATABASES|FIELDS)@i', $GLOBALS['sql_query'], $which);
108 if (isset($which[1]) && strpos(' ' . strtoupper($which[1]), 'PROCESSLIST') > 0) {
109 $do_display['edit_lnk'] = 'nn'; // no edit link
110 $do_display['del_lnk'] = 'kp'; // "kill process" type edit link
111 } else {
112 // Default case -> no links
113 $do_display['edit_lnk'] = 'nn'; // no edit link
114 $do_display['del_lnk'] = 'nn'; // no delete link
115 }
116 // 2.2.2 Other settings
117 $do_display['sort_lnk'] = (string) '0';
118 $do_display['nav_bar'] = (string) '0';
119 $do_display['ins_row'] = (string) '0';
120 $do_display['bkm_form'] = (string) '1';
121 $do_display['text_btn'] = (string) '1';
122 $do_display['pview_lnk'] = (string) '1';
123 }
124 // 2.3 Other statements (ie "SELECT" ones) -> updates
125 // $do_display['edit_lnk'], $do_display['del_lnk'] and
126 // $do_display['text_btn'] (keeps other default values)
127 else {
128 $prev_table = $fields_meta[0]->table;
129 $do_display['text_btn'] = (string) '1';
130 for ($i = 0; $i < $GLOBALS['fields_cnt']; $i++) {
131 $is_link = ($do_display['edit_lnk'] != 'nn'
132 || $do_display['del_lnk'] != 'nn'
133 || $do_display['sort_lnk'] != '0'
134 || $do_display['ins_row'] != '0');
135 // 2.3.2 Displays edit/delete/sort/insert links?
136 if ($is_link
137 && ($fields_meta[$i]->table == '' || $fields_meta[$i]->table != $prev_table)) {
138 $do_display['edit_lnk'] = 'nn'; // don't display links
139 $do_display['del_lnk'] = 'nn';
140 /**
141 * @todo May be problematic with same fields names in two joined table.
142 */
143 // $do_display['sort_lnk'] = (string) '0';
144 $do_display['ins_row'] = (string) '0';
145 if ($do_display['text_btn'] == '1') {
146 break;
147 }
148 } // end if (2.3.2)
149 // 2.3.3 Always display print view link
150 $do_display['pview_lnk'] = (string) '1';
151 $prev_table = $fields_meta[$i]->table;
152 } // end for
153 } // end if..elseif...else (2.1 -> 2.3)
154 } // end if (2)
155
156 // 3. Gets the total number of rows if it is unknown
157 if (isset($unlim_num_rows) && $unlim_num_rows != '') {
158 $the_total = $unlim_num_rows;
159 } elseif (($do_display['nav_bar'] == '1' || $do_display['sort_lnk'] == '1')
160 && (strlen($db) && !empty($table))) {
161 $the_total = PMA_Table::countRecords($db, $table);
162 }
163
164 // 4. If navigation bar or sorting fields names URLs should be
165 // displayed but there is only one row, change these settings to
166 // false
167 if ($do_display['nav_bar'] == '1' || $do_display['sort_lnk'] == '1') {
168
169 // - Do not display sort links if less than 2 rows.
170 // - For a VIEW we (probably) did not count the number of rows
171 // so don't test this number here, it would remove the possibility
172 // of sorting VIEW results.
173 if (isset($unlim_num_rows) && $unlim_num_rows < 2 && ! PMA_Table::isView($db, $table)) {
174 // force display of navbar for vertical/horizontal display-choice.
175 // $do_display['nav_bar'] = (string) '0';
176 $do_display['sort_lnk'] = (string) '0';
177 }
178 } // end if (3)
179
180 // 5. Updates the synthetic var
181 $the_disp_mode = join('', $do_display);
182
183 return $do_display;
184 } // end of the 'PMA_setDisplayMode()' function
185
186
187 /**
188 * Displays a navigation button
189 *
190 * @uses $GLOBALS['cfg']['NavigationBarIconic']
191 * @uses PMA_generate_common_hidden_inputs()
192 *
193 * @param string iconic caption for button
194 * @param string text for button
195 * @param integer position for next query
196 * @param string query ready for display
197 * @param string optional onsubmit clause
198 * @param string optional hidden field for special treatment
199 * @param string optional onclick clause
200 *
201 * @global string $db the database name
202 * @global string $table the table name
203 * @global string $goto the URL to go back in case of errors
204 *
205 * @access private
206 *
207 * @see PMA_displayTableNavigation()
208 */
209 function PMA_displayTableNavigationOneButton($caption, $title, $pos, $html_sql_query, $onsubmit = '', $input_for_real_end = '', $onclick = '') {
210
211 global $db, $table, $goto;
212
213 $caption_output = '';
214 // for true or 'both'
215 if ($GLOBALS['cfg']['NavigationBarIconic']) {
216 $caption_output .= $caption;
217 }
218 // for false or 'both'
219 if (false === $GLOBALS['cfg']['NavigationBarIconic'] || 'both' === $GLOBALS['cfg']['NavigationBarIconic']) {
220 $caption_output .= '&nbsp;' . $title;
221 }
222 $title_output = ' title="' . $title . '"';
223 ?>
224 <td>
225 <form action="sql.php" method="post" <?php echo $onsubmit; ?>>
226 <?php echo PMA_generate_common_hidden_inputs($db, $table); ?>
227 <input type="hidden" name="sql_query" value="<?php echo $html_sql_query; ?>" />
228 <input type="hidden" name="pos" value="<?php echo $pos; ?>" />
229 <input type="hidden" name="goto" value="<?php echo $goto; ?>" />
230 <?php echo $input_for_real_end; ?>
231 <input type="submit" name="navig" <?php echo ($GLOBALS['cfg']['AjaxEnable'] ? ' class="ajax" ' : '' ); ?> value="<?php echo $caption_output; ?>"<?php echo $title_output . $onclick; ?> />
232 </form>
233 </td>
234 <?php
235 } // end function PMA_displayTableNavigationOneButton()
236
237 /**
238 * Displays a navigation bar to browse among the results of a SQL query
239 *
240 * @uses $_SESSION['tmp_user_values']['disp_direction']
241 * @uses $_SESSION['tmp_user_values']['repeat_cells']
242 * @uses $_SESSION['tmp_user_values']['max_rows']
243 * @uses $_SESSION['tmp_user_values']['pos']
244 * @param integer the offset for the "next" page
245 * @param integer the offset for the "previous" page
246 * @param string the URL-encoded query
247 * @param string the id for the direction dropdown
248 *
249 * @global string $db the database name
250 * @global string $table the table name
251 * @global string $goto the URL to go back in case of errors
252 * @global integer $num_rows the total number of rows returned by the
253 * SQL query
254 * @global integer $unlim_num_rows the total number of rows returned by the
255 * SQL any programmatically appended "LIMIT" clause
256 * @global boolean $is_innodb whether its InnoDB or not
257 * @global array $showtable table definitions
258 *
259 * @access private
260 *
261 * @see PMA_displayTable()
262 */
263 function PMA_displayTableNavigation($pos_next, $pos_prev, $sql_query, $id_for_direction_dropdown)
264 {
265 global $db, $table, $goto;
266 global $num_rows, $unlim_num_rows;
267 global $is_innodb;
268 global $showtable;
269
270 // here, using htmlentities() would cause problems if the query
271 // contains accented characters
272 $html_sql_query = htmlspecialchars($sql_query);
273
274 /**
275 * @todo move this to a central place
276 * @todo for other future table types
277 */
278 $is_innodb = (isset($showtable['Type']) && $showtable['Type'] == 'InnoDB');
279
280 ?>
281
282 <!-- Navigation bar -->
283 <table border="0" cellpadding="2" cellspacing="0">
284 <tr>
285 <?php
286 // Move to the beginning or to the previous page
287 if ($_SESSION['tmp_user_values']['pos'] && $_SESSION['tmp_user_values']['max_rows'] != 'all') {
288 PMA_displayTableNavigationOneButton('&lt;&lt;', __('Begin'), 0, $html_sql_query);
289 PMA_displayTableNavigationOneButton('&lt;', __('Previous'), $pos_prev, $html_sql_query);
290
291 } // end move back
292 ?>
293 <td>
294 &nbsp;&nbsp;&nbsp;
295 </td>
296 <td align="center">
297 <?php // if displaying a VIEW, $unlim_num_rows could be zero because
298 // of $cfg['MaxExactCountViews']; in this case, avoid passing
299 // the 5th parameter to checkFormElementInRange()
300 // (this means we can't validate the upper limit ?>
301 <form action="sql.php" method="post"
302 onsubmit="return (checkFormElementInRange(this, 'session_max_rows', '<?php echo str_replace('\'', '\\\'', __('%d is not valid row number.')); ?>', 1) &amp;&amp; checkFormElementInRange(this, 'pos', '<?php echo str_replace('\'', '\\\'', __('%d is not valid row number.')); ?>', 0<?php echo $unlim_num_rows > 0 ? ',' . $unlim_num_rows - 1 : ''; ?>))">
303 <?php echo PMA_generate_common_hidden_inputs($db, $table); ?>
304 <input type="hidden" name="sql_query" value="<?php echo $html_sql_query; ?>" />
305 <input type="hidden" name="goto" value="<?php echo $goto; ?>" />
306 <input type="submit" name="navig" <?php echo ($GLOBALS['cfg']['AjaxEnable'] ? ' class="ajax"' : ''); ?> value="<?php echo __('Show'); ?> :" />
307 <input type="text" name="session_max_rows" size="3" value="<?php echo (($_SESSION['tmp_user_values']['max_rows'] != 'all') ? $_SESSION['tmp_user_values']['max_rows'] : $GLOBALS['cfg']['MaxRows']); ?>" class="textfield" onfocus="this.select()" />
308 <?php echo __('row(s) starting from row #') . "\n"; ?>
309 <input type="text" name="pos" size="6" value="<?php echo (($pos_next >= $unlim_num_rows) ? 0 : $pos_next); ?>" class="textfield" onfocus="this.select()" />
310 <br />
311 <?php
312 // Display mode (horizontal/vertical and repeat headers)
313 $choices = array(
314 'horizontal' => __('horizontal'),
315 'horizontalflipped' => __('horizontal (rotated headers)'),
316 'vertical' => __('vertical'));
317 $param1 = PMA_generate_html_dropdown('disp_direction', $choices, $_SESSION['tmp_user_values']['disp_direction'], $id_for_direction_dropdown);
318 unset($choices);
319
320 $param2 = ' <input type="text" size="3" name="repeat_cells" value="' . $_SESSION['tmp_user_values']['repeat_cells'] . '" class="textfield" />' . "\n"
321 . ' ';
322 echo ' ' . sprintf(__('in %s mode and repeat headers after %s cells'), "\n" . $param1, "\n" . $param2) . "\n";
323 ?>
324 </form>
325 </td>
326 <td>
327 &nbsp;&nbsp;&nbsp;
328 </td>
329 <?php
330 // Move to the next page or to the last one
331 if (($_SESSION['tmp_user_values']['pos'] + $_SESSION['tmp_user_values']['max_rows'] < $unlim_num_rows) && $num_rows >= $_SESSION['tmp_user_values']['max_rows']
332 && $_SESSION['tmp_user_values']['max_rows'] != 'all') {
333
334 // display the Next button
335 PMA_displayTableNavigationOneButton('&gt;',
336 __('Next'),
337 $pos_next,
338 $html_sql_query);
339
340 // prepare some options for the End button
341 if ($is_innodb && $unlim_num_rows > $GLOBALS['cfg']['MaxExactCount']) {
342 $input_for_real_end = '<input id="real_end_input" type="hidden" name="find_real_end" value="1" />';
343 // no backquote around this message
344 $onclick = '';
345 } else {
346 $input_for_real_end = $onclick = '';
347 }
348
349 // display the End button
350 PMA_displayTableNavigationOneButton('&gt;&gt;',
351 __('End'),
352 @((ceil($unlim_num_rows / $_SESSION['tmp_user_values']['max_rows'])- 1) * $_SESSION['tmp_user_values']['max_rows']),
353 $html_sql_query,
354 'onsubmit="return ' . (($_SESSION['tmp_user_values']['pos'] + $_SESSION['tmp_user_values']['max_rows'] < $unlim_num_rows && $num_rows >= $_SESSION['tmp_user_values']['max_rows']) ? 'true' : 'false') . '"',
355 $input_for_real_end,
356 $onclick
357 );
358 } // end move toward
359
360
361 //page redirection
362 // (unless we are showing all records)
363 if ('all' != $_SESSION['tmp_user_values']['max_rows']) { //if1
364 $pageNow = @floor($_SESSION['tmp_user_values']['pos'] / $_SESSION['tmp_user_values']['max_rows']) + 1;
365 $nbTotalPage = @ceil($unlim_num_rows / $_SESSION['tmp_user_values']['max_rows']);
366
367 if ($nbTotalPage > 1){ //if2
368 ?>
369 <td>
370 &nbsp;&nbsp;&nbsp;
371 </td>
372 <td>
373 <?php
374 $_url_params = array(
375 'db' => $db,
376 'table' => $table,
377 'sql_query' => $sql_query,
378 'goto' => $goto,
379 );
380 //<form> to keep the form alignment of button < and <<
381 // and also to know what to execute when the selector changes
382 echo '<form action="sql.php' . PMA_generate_common_url($_url_params). '" method="post">';
383 echo PMA_pageselector(
384 $_SESSION['tmp_user_values']['max_rows'],
385 $pageNow,
386 $nbTotalPage,
387 200,
388 5,
389 5,
390 20,
391 10,
392 __('Page number:')
393 );
394 ?>
395 </form>
396 </td>
397 <?php
398 } //_if2
399 } //_if1
400
401 // Display the "Show all" button if allowed
402 if ($GLOBALS['cfg']['ShowAll'] && ($num_rows < $unlim_num_rows)) {
403 echo "\n";
404 ?>
405 <td>
406 &nbsp;&nbsp;&nbsp;
407 </td>
408 <td>
409 <form action="sql.php" method="post">
410 <?php echo PMA_generate_common_hidden_inputs($db, $table); ?>
411 <input type="hidden" name="sql_query" value="<?php echo $html_sql_query; ?>" />
412 <input type="hidden" name="pos" value="0" />
413 <input type="hidden" name="session_max_rows" value="all" />
414 <input type="hidden" name="goto" value="<?php echo $goto; ?>" />
415 <input type="submit" name="navig" value="<?php echo __('Show all'); ?>" />
416 </form>
417 </td>
418 <?php
419 } // end show all
420 echo "\n";
421 ?>
422 </tr>
423 </table>
424
425 <?php
426 } // end of the 'PMA_displayTableNavigation()' function
427
428
429 /**
430 * Displays the headers of the results table
431 *
432 * @uses $_SESSION['tmp_user_values']['disp_direction']
433 * @uses $_SESSION['tmp_user_values']['repeat_cells']
434 * @uses $_SESSION['tmp_user_values']['max_rows']
435 * @uses $_SESSION['tmp_user_values']['display_text']
436 * @uses $_SESSION['tmp_user_values']['display_binary']
437 * @uses $_SESSION['tmp_user_values']['display_binary_as_hex']
438 * @param array which elements to display
439 * @param array the list of fields properties
440 * @param integer the total number of fields returned by the SQL query
441 * @param array the analyzed query
442 *
443 * @return boolean $clause_is_unique
444 *
445 * @global string $db the database name
446 * @global string $table the table name
447 * @global string $goto the URL to go back in case of errors
448 * @global string $sql_query the SQL query
449 * @global integer $num_rows the total number of rows returned by the
450 * SQL query
451 * @global array $vertical_display informations used with vertical display
452 * mode
453 *
454 * @access private
455 *
456 * @see PMA_displayTable()
457 */
458 function PMA_displayTableHeaders(&$is_display, &$fields_meta, $fields_cnt = 0, $analyzed_sql = '', $sort_expression, $sort_expression_nodirection, $sort_direction)
459 {
460 global $db, $table, $goto;
461 global $sql_query, $num_rows;
462 global $vertical_display, $highlight_columns;
463
464 if ($analyzed_sql == '') {
465 $analyzed_sql = array();
466 }
467
468 // can the result be sorted?
469 if ($is_display['sort_lnk'] == '1') {
470
471 // Just as fallback
472 $unsorted_sql_query = $sql_query;
473 if (isset($analyzed_sql[0]['unsorted_query'])) {
474 $unsorted_sql_query = $analyzed_sql[0]['unsorted_query'];
475 }
476 // Handles the case of multiple clicks on a column's header
477 // which would add many spaces before "ORDER BY" in the
478 // generated query.
479 $unsorted_sql_query = trim($unsorted_sql_query);
480
481 // sorting by indexes, only if it makes sense (only one table ref)
482 if (isset($analyzed_sql) && isset($analyzed_sql[0]) &&
483 isset($analyzed_sql[0]['querytype']) && $analyzed_sql[0]['querytype'] == 'SELECT' &&
484 isset($analyzed_sql[0]['table_ref']) && count($analyzed_sql[0]['table_ref']) == 1) {
485
486 // grab indexes data:
487 $indexes = PMA_Index::getFromTable($table, $db);
488
489 // do we have any index?
490 if ($indexes) {
491
492 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
493 || $_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
494 $span = $fields_cnt;
495 if ($is_display['edit_lnk'] != 'nn') {
496 $span++;
497 }
498 if ($is_display['del_lnk'] != 'nn') {
499 $span++;
500 }
501 if ($is_display['del_lnk'] != 'kp' && $is_display['del_lnk'] != 'nn') {
502 $span++;
503 }
504 } else {
505 $span = $num_rows + floor($num_rows/$_SESSION['tmp_user_values']['repeat_cells']) + 1;
506 }
507
508 echo '<form action="sql.php" method="post">' . "\n";
509 echo PMA_generate_common_hidden_inputs($db, $table);
510 echo __('Sort by key') . ': <select name="sql_query" onchange="this.form.submit();">' . "\n";
511 $used_index = false;
512 $local_order = (isset($sort_expression) ? $sort_expression : '');
513 foreach ($indexes as $index) {
514 $asc_sort = '`' . implode('` ASC, `', array_keys($index->getColumns())) . '` ASC';
515 $desc_sort = '`' . implode('` DESC, `', array_keys($index->getColumns())) . '` DESC';
516 $used_index = $used_index || $local_order == $asc_sort || $local_order == $desc_sort;
517 echo '<option value="'
518 . htmlspecialchars($unsorted_sql_query . ' ORDER BY ' . $asc_sort)
519 . '"' . ($local_order == $asc_sort ? ' selected="selected"' : '')
520 . '>' . htmlspecialchars($index->getName()) . ' ('
521 . __('Ascending') . ')</option>';
522 echo '<option value="'
523 . htmlspecialchars($unsorted_sql_query . ' ORDER BY ' . $desc_sort)
524 . '"' . ($local_order == $desc_sort ? ' selected="selected"' : '')
525 . '>' . htmlspecialchars($index->getName()) . ' ('
526 . __('Descending') . ')</option>';
527 }
528 echo '<option value="' . htmlspecialchars($unsorted_sql_query) . '"' . ($used_index ? '' : ' selected="selected"') . '>' . __('None') . '</option>';
529 echo '</select>' . "\n";
530 echo '<noscript><input type="submit" value="' . __('Go') . '" /></noscript>';
531 echo '</form>' . "\n";
532 }
533 }
534 }
535
536
537 $vertical_display['emptypre'] = 0;
538 $vertical_display['emptyafter'] = 0;
539 $vertical_display['textbtn'] = '';
540
541 // Display options (if we are not in print view)
542 if (! (isset($GLOBALS['printview']) && $GLOBALS['printview'] == '1')) {
543 echo '<form method="post" action="sql.php" name="displayOptionsForm" id="displayOptionsForm">';
544 $url_params = array(
545 'db' => $db,
546 'table' => $table,
547 'sql_query' => $sql_query,
548 'goto' => $goto,
549 'display_options_form' => 1
550 );
551 echo PMA_generate_common_hidden_inputs($url_params);
552 echo '<br />';
553 PMA_generate_slider_effect('displayoptions',__('Options'));
554 echo '<fieldset>';
555
556 echo '<div class="formelement">';
557 $choices = array(
558 'P' => __('Partial texts'),
559 'F' => __('Full texts')
560 );
561 PMA_display_html_radio('display_text', $choices, $_SESSION['tmp_user_values']['display_text']);
562 echo '</div>';
563
564 // prepare full/partial text button or link
565 if ($_SESSION['tmp_user_values']['display_text']=='F') {
566 // currently in fulltext mode so show the opposite link
567 $tmp_image_file = $GLOBALS['pmaThemeImage'] . 's_partialtext.png';
568 $tmp_txt = __('Partial texts');
569 $url_params['display_text'] = 'P';
570 } else {
571 $tmp_image_file = $GLOBALS['pmaThemeImage'] . 's_fulltext.png';
572 $tmp_txt = __('Full texts');
573 $url_params['display_text'] = 'F';
574 }
575
576 $tmp_image = '<img class="fulltext" width="50" height="20" src="' . $tmp_image_file . '" alt="' . $tmp_txt . '" title="' . $tmp_txt . '" />';
577 $tmp_url = 'sql.php' . PMA_generate_common_url($url_params);
578 $full_or_partial_text_link = PMA_linkOrButton($tmp_url, $tmp_image, array(), false);
579 unset($tmp_image_file, $tmp_txt, $tmp_url, $tmp_image);
580
581
582 if ($GLOBALS['cfgRelation']['relwork'] && $GLOBALS['cfgRelation']['displaywork']) {
583 echo '<div class="formelement">';
584 $choices = array(
585 'K' => __('Relational key'),
586 'D' => __('Relational display column')
587 );
588 PMA_display_html_radio('relational_display', $choices, $_SESSION['tmp_user_values']['relational_display']);
589 echo '</div>';
590 }
591
592 echo '<div class="formelement">';
593 PMA_display_html_checkbox('display_binary', __('Show binary contents'), ! empty($_SESSION['tmp_user_values']['display_binary']), false);
594 echo '<br />';
595 PMA_display_html_checkbox('display_blob', __('Show BLOB contents'), ! empty($_SESSION['tmp_user_values']['display_blob']), false);
596 echo '<br />';
597 PMA_display_html_checkbox('display_binary_as_hex', __('Show binary contents as HEX'), ! empty($_SESSION['tmp_user_values']['display_binary_as_hex']), false);
598 echo '</div>';
599
600 // I would have preferred to name this "display_transformation".
601 // This is the only way I found to be able to keep this setting sticky
602 // per SQL query, and at the same time have a default that displays
603 // the transformations.
604 echo '<div class="formelement">';
605 PMA_display_html_checkbox('hide_transformation', __('Hide') . ' ' . __('Browser transformation'), ! empty($_SESSION['tmp_user_values']['hide_transformation']), false);
606 echo '</div>';
607
608 echo '<div class="clearfloat"></div>';
609 echo '</fieldset>';
610
611 echo '<fieldset class="tblFooters">';
612 echo '<input type="submit" value="' . __('Go') . '" />';
613 echo '</fieldset>';
614 echo '</div>';
615 echo '</form>';
616 }
617
618 // Start of form for multi-rows edit/delete/export
619
620 if ($is_display['del_lnk'] == 'dr' || $is_display['del_lnk'] == 'kp') {
621 echo '<form method="post" action="tbl_row_action.php" name="rowsDeleteForm" id="rowsDeleteForm">' . "\n";
622 echo PMA_generate_common_hidden_inputs($db, $table, 1);
623 echo '<input type="hidden" name="goto" value="sql.php" />' . "\n";
624 }
625
626 echo '<table id="table_results" class="data">' . "\n";
627 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
628 || $_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
629 echo '<thead><tr>' . "\n";
630 }
631
632 // 1. Displays the full/partial text button (part 1)...
633 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
634 || $_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
635 $colspan = ($is_display['edit_lnk'] != 'nn' && $is_display['del_lnk'] != 'nn')
636 ? ' colspan="3"'
637 : '';
638 } else {
639 $rowspan = ($is_display['edit_lnk'] != 'nn' && $is_display['del_lnk'] != 'nn')
640 ? ' rowspan="3"'
641 : '';
642 }
643
644 // ... before the result table
645 if (($is_display['edit_lnk'] == 'nn' && $is_display['del_lnk'] == 'nn')
646 && $is_display['text_btn'] == '1') {
647 $vertical_display['emptypre'] = ($is_display['edit_lnk'] != 'nn' && $is_display['del_lnk'] != 'nn') ? 3 : 0;
648 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
649 || $_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
650 ?>
651 <th colspan="<?php echo $fields_cnt; ?>"></th>
652 </tr>
653 <tr>
654 <?php
655 } // end horizontal/horizontalflipped mode
656 else {
657 ?>
658 <tr>
659 <th colspan="<?php echo $num_rows + floor($num_rows/$_SESSION['tmp_user_values']['repeat_cells']) + 1; ?>"></th>
660 </tr>
661 <?php
662 } // end vertical mode
663 }
664
665 // ... at the left column of the result table header if possible
666 // and required
667 elseif ($GLOBALS['cfg']['ModifyDeleteAtLeft'] && $is_display['text_btn'] == '1') {
668 $vertical_display['emptypre'] = ($is_display['edit_lnk'] != 'nn' && $is_display['del_lnk'] != 'nn') ? 3 : 0;
669 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
670 || $_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
671 ?>
672 <th <?php echo $colspan; ?>><?php echo $full_or_partial_text_link;?></th>
673 <?php
674 } // end horizontal/horizontalflipped mode
675 else {
676 $vertical_display['textbtn'] = ' <th ' . $rowspan . ' valign="middle">' . "\n"
677 . ' ' . "\n"
678 . ' </th>' . "\n";
679 } // end vertical mode
680 }
681
682 // ... elseif no button, displays empty(ies) col(s) if required
683 elseif ($GLOBALS['cfg']['ModifyDeleteAtLeft']
684 && ($is_display['edit_lnk'] != 'nn' || $is_display['del_lnk'] != 'nn')) {
685 $vertical_display['emptypre'] = ($is_display['edit_lnk'] != 'nn' && $is_display['del_lnk'] != 'nn') ? 3 : 0;
686 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
687 || $_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
688 ?>
689 <td<?php echo $colspan; ?>></td>
690 <?php
691 } // end horizontal/horizontalfipped mode
692 else {
693 $vertical_display['textbtn'] = ' <td' . $rowspan . '></td>' . "\n";
694 } // end vertical mode
695 }
696
697 // 2. Displays the fields' name
698 // 2.0 If sorting links should be used, checks if the query is a "JOIN"
699 // statement (see 2.1.3)
700
701 // 2.0.1 Prepare Display column comments if enabled ($GLOBALS['cfg']['ShowBrowseComments']).
702 // Do not show comments, if using horizontalflipped mode, because of space usage
703 if ($GLOBALS['cfg']['ShowBrowseComments']
704 && $_SESSION['tmp_user_values']['disp_direction'] != 'horizontalflipped') {
705 $comments_map = array();
706 if (isset($analyzed_sql[0]) && is_array($analyzed_sql[0])) {
707 foreach ($analyzed_sql[0]['table_ref'] as $tbl) {
708 $tb = $tbl['table_true_name'];
709 $comments_map[$tb] = PMA_getComments($db, $tb);
710 unset($tb);
711 }
712 }
713 }
714
715 if ($GLOBALS['cfgRelation']['commwork'] && $GLOBALS['cfgRelation']['mimework'] && $GLOBALS['cfg']['BrowseMIME'] && ! $_SESSION['tmp_user_values']['hide_transformation']) {
716 require_once './libraries/transformations.lib.php';
717 $GLOBALS['mime_map'] = PMA_getMIME($db, $table);
718 }
719
720 // See if we have to highlight any header fields of a WHERE query.
721 // Uses SQL-Parser results.
722 $highlight_columns = array();
723 if (isset($analyzed_sql) && isset($analyzed_sql[0]) &&
724 isset($analyzed_sql[0]['where_clause_identifiers'])) {
725
726 $wi = 0;
727 if (isset($analyzed_sql[0]['where_clause_identifiers']) && is_array($analyzed_sql[0]['where_clause_identifiers'])) {
728 foreach ($analyzed_sql[0]['where_clause_identifiers'] AS $wci_nr => $wci) {
729 $highlight_columns[$wci] = 'true';
730 }
731 }
732 }
733
734 for ($i = 0; $i < $fields_cnt; $i++) {
735 // See if this column should get highlight because it's used in the
736 // where-query.
737 if (isset($highlight_columns[$fields_meta[$i]->name]) || isset($highlight_columns[PMA_backquote($fields_meta[$i]->name)])) {
738 $condition_field = true;
739 } else {
740 $condition_field = false;
741 }
742
743 // 2.0 Prepare comment-HTML-wrappers for each row, if defined/enabled.
744 if (isset($comments_map) &&
745 isset($comments_map[$fields_meta[$i]->table]) &&
746 isset($comments_map[$fields_meta[$i]->table][$fields_meta[$i]->name])) {
747 $comments = '<span class="tblcomment">' . htmlspecialchars($comments_map[$fields_meta[$i]->table][$fields_meta[$i]->name]) . '</span>';
748 } else {
749 $comments = '';
750 }
751
752 // 2.1 Results can be sorted
753 if ($is_display['sort_lnk'] == '1') {
754
755 // 2.1.1 Checks if the table name is required; it's the case
756 // for a query with a "JOIN" statement and if the column
757 // isn't aliased, or in queries like
758 // SELECT `1`.`master_field` , `2`.`master_field`
759 // FROM `PMA_relation` AS `1` , `PMA_relation` AS `2`
760
761 if (isset($fields_meta[$i]->table) && strlen($fields_meta[$i]->table)) {
762 $sort_tbl = PMA_backquote($fields_meta[$i]->table) . '.';
763 } else {
764 $sort_tbl = '';
765 }
766
767 // 2.1.2 Checks if the current column is used to sort the
768 // results
769 // the orgname member does not exist for all MySQL versions
770 // but if found, it's the one on which to sort
771 $name_to_use_in_sort = $fields_meta[$i]->name;
772 if (isset($fields_meta[$i]->orgname) && strlen($fields_meta[$i]->orgname)) {
773 $name_to_use_in_sort = $fields_meta[$i]->orgname;
774 }
775 // $name_to_use_in_sort might contain a space due to
776 // formatting of function expressions like "COUNT(name )"
777 // so we remove the space in this situation
778 $name_to_use_in_sort = str_replace(' )', ')', $name_to_use_in_sort);
779
780 if (empty($sort_expression)) {
781 $is_in_sort = false;
782 } else {
783 // Field name may be preceded by a space, or any number
784 // of characters followed by a dot (tablename.fieldname)
785 // so do a direct comparison for the sort expression;
786 // this avoids problems with queries like
787 // "SELECT id, count(id)..." and clicking to sort
788 // on id or on count(id).
789 // Another query to test this:
790 // SELECT p.*, FROM_UNIXTIME(p.temps) FROM mytable AS p
791 // (and try clicking on each column's header twice)
792 if (! empty($sort_tbl) && strpos($sort_expression_nodirection, $sort_tbl) === false && strpos($sort_expression_nodirection, '(') === false) {
793 $sort_expression_nodirection = $sort_tbl . $sort_expression_nodirection;
794 }
795 $is_in_sort = (str_replace('`', '', $sort_tbl) . $name_to_use_in_sort == str_replace('`', '', $sort_expression_nodirection) ? true : false);
796 }
797 // 2.1.3 Check the field name for a bracket.
798 // If it contains one, it's probably a function column
799 // like 'COUNT(`field`)'
800 if (strpos($name_to_use_in_sort, '(') !== false) {
801 $sort_order = ' ORDER BY ' . $name_to_use_in_sort . ' ';
802 } else {
803 $sort_order = ' ORDER BY ' . $sort_tbl . PMA_backquote($name_to_use_in_sort) . ' ';
804 }
805 unset($name_to_use_in_sort);
806
807 // 2.1.4 Do define the sorting URL
808 if (! $is_in_sort) {
809 // patch #455484 ("Smart" order)
810 $GLOBALS['cfg']['Order'] = strtoupper($GLOBALS['cfg']['Order']);
811 if ($GLOBALS['cfg']['Order'] === 'SMART') {
812 $sort_order .= (preg_match('@time|date@i', $fields_meta[$i]->type)) ? 'DESC' : 'ASC';
813 } else {
814 $sort_order .= $GLOBALS['cfg']['Order'];
815 }
816 $order_img = '';
817 } elseif ('DESC' == $sort_direction) {
818 $sort_order .= ' ASC';
819 $order_img = ' <img class="icon" src="' . $GLOBALS['pmaThemeImage'] . 's_desc.png" width="11" height="9" alt="'. __('Descending') . '" title="'. __('Descending') . '" id="soimg' . $i . '" />';
820 } else {
821 $sort_order .= ' DESC';
822 $order_img = ' <img class="icon" src="' . $GLOBALS['pmaThemeImage'] . 's_asc.png" width="11" height="9" alt="'. __('Ascending') . '" title="'. __('Ascending') . '" id="soimg' . $i . '" />';
823 }
824
825 if (preg_match('@(.*)([[:space:]](LIMIT (.*)|PROCEDURE (.*)|FOR UPDATE|LOCK IN SHARE MODE))@i', $unsorted_sql_query, $regs3)) {
826 $sorted_sql_query = $regs3[1] . $sort_order . $regs3[2];
827 } else {
828 $sorted_sql_query = $unsorted_sql_query . $sort_order;
829 }
830 $_url_params = array(
831 'db' => $db,
832 'table' => $table,
833 'sql_query' => $sorted_sql_query,
834 );
835 $order_url = 'sql.php' . PMA_generate_common_url($_url_params);
836
837 // 2.1.5 Displays the sorting URL
838 // enable sort order swapping for image
839 $order_link_params = array();
840 if (isset($order_img) && $order_img!='') {
841 if (strstr($order_img, 'asc')) {
842 $order_link_params['onmouseover'] = 'if(document.getElementById(\'soimg' . $i . '\')){ document.getElementById(\'soimg' . $i . '\').src=\'' . $GLOBALS['pmaThemeImage'] . 's_desc.png\'; }';
843 $order_link_params['onmouseout'] = 'if(document.getElementById(\'soimg' . $i . '\')){ document.getElementById(\'soimg' . $i . '\').src=\'' . $GLOBALS['pmaThemeImage'] . 's_asc.png\'; }';
844 } elseif (strstr($order_img, 'desc')) {
845 $order_link_params['onmouseover'] = 'if(document.getElementById(\'soimg' . $i . '\')){ document.getElementById(\'soimg' . $i . '\').src=\'' . $GLOBALS['pmaThemeImage'] . 's_asc.png\'; }';
846 $order_link_params['onmouseout'] = 'if(document.getElementById(\'soimg' . $i . '\')){ document.getElementById(\'soimg' . $i . '\').src=\'' . $GLOBALS['pmaThemeImage'] . 's_desc.png\'; }';
847 }
848 }
849 if ($GLOBALS['cfg']['HeaderFlipType'] == 'auto') {
850 if (PMA_USR_BROWSER_AGENT == 'IE') {
851 $GLOBALS['cfg']['HeaderFlipType'] = 'css';
852 } else {
853 $GLOBALS['cfg']['HeaderFlipType'] = 'fake';
854 }
855 }
856 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped'
857 && $GLOBALS['cfg']['HeaderFlipType'] == 'css') {
858 $order_link_params['style'] = 'direction: ltr; writing-mode: tb-rl;';
859 }
860 $order_link_params['title'] = __('Sort');
861 $order_link_content = ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped' && $GLOBALS['cfg']['HeaderFlipType'] == 'fake' ? PMA_flipstring(htmlspecialchars($fields_meta[$i]->name), "<br />\n") : htmlspecialchars($fields_meta[$i]->name));
862 $order_link = PMA_linkOrButton($order_url, $order_link_content . $order_img, $order_link_params, false, true);
863
864 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
865 || $_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
866 echo '<th';
867 $th_class = array();
868 if ($condition_field) {
869 $th_class[] = 'condition';
870 }
871 $th_class[] = 'column_heading';
872 echo ' class="' . implode(' ', $th_class) . '"';
873
874 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
875 echo ' valign="bottom"';
876 }
877 echo '>' . $order_link . $comments . '</th>';
878 }
879 $vertical_display['desc'][] = ' <th '
880 . ($condition_field ? ' class="condition"' : '') . '>' . "\n"
881 . $order_link . $comments . ' </th>' . "\n";
882 } // end if (2.1)
883
884 // 2.2 Results can't be sorted
885 else {
886 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
887 || $_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
888 echo '<th';
889 if ($condition_field) {
890 echo ' class="condition"';
891 }
892 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
893 echo ' valign="bottom"';
894 }
895 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped'
896 && $GLOBALS['cfg']['HeaderFlipType'] == 'css') {
897 echo ' style="direction: ltr; writing-mode: tb-rl;"';
898 }
899 echo '>';
900 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped'
901 && $GLOBALS['cfg']['HeaderFlipType'] == 'fake') {
902 echo PMA_flipstring(htmlspecialchars($fields_meta[$i]->name), '<br />');
903 } else {
904 echo htmlspecialchars($fields_meta[$i]->name);
905 }
906 echo "\n" . $comments . '</th>';
907 }
908 $vertical_display['desc'][] = ' <th '
909 . ($condition_field ? ' class="condition"' : '') . '>' . "\n"
910 . ' ' . htmlspecialchars($fields_meta[$i]->name) . "\n"
911 . $comments . ' </th>';
912 } // end else (2.2)
913 } // end for
914
915 // 3. Displays the needed checkboxes at the right
916 // column of the result table header if possible and required...
917 if ($GLOBALS['cfg']['ModifyDeleteAtRight']
918 && ($is_display['edit_lnk'] != 'nn' || $is_display['del_lnk'] != 'nn')
919 && $is_display['text_btn'] == '1') {
920 $vertical_display['emptyafter'] = ($is_display['edit_lnk'] != 'nn' && $is_display['del_lnk'] != 'nn') ? 3 : 1;
921 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
922 || $_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
923 echo "\n";
924 ?>
925 <th <?php echo $colspan; ?>><?php echo $full_or_partial_text_link;?>
926 </th>
927 <?php
928 } // end horizontal/horizontalflipped mode
929 else {
930 $vertical_display['textbtn'] = ' <th ' . $rowspan . ' valign="middle">' . "\n"
931 . ' ' . "\n"
932 . ' </th>' . "\n";
933 } // end vertical mode
934 }
935
936 // ... elseif no button, displays empty columns if required
937 // (unless coming from Browse mode print view)
938 elseif ($GLOBALS['cfg']['ModifyDeleteAtRight']
939 && ($is_display['edit_lnk'] == 'nn' && $is_display['del_lnk'] == 'nn')
940 && (!$GLOBALS['is_header_sent'])) {
941 $vertical_display['emptyafter'] = ($is_display['edit_lnk'] != 'nn' && $is_display['del_lnk'] != 'nn') ? 3 : 1;
942 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
943 || $_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
944 echo "\n";
945 ?>
946 <td<?php echo $colspan; ?>></td>
947 <?php
948 } // end horizontal/horizontalflipped mode
949 else {
950 $vertical_display['textbtn'] = ' <td' . $rowspan . '></td>' . "\n";
951 } // end vertical mode
952 }
953
954 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
955 || $_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
956 ?>
957 </tr>
958 </thead>
959 <?php
960 }
961
962 return true;
963 } // end of the 'PMA_displayTableHeaders()' function
964
965
966 /**
967 * Prepares the display for a value
968 *
969 * @param string $class
970 * @param string $condition_field
971 * @param string $value
972 *
973 * @return string the td
974 */
975 function PMA_buildValueDisplay($class, $condition_field, $value) {
976 return '<td align="left"' . ' class="' . $class . ($condition_field ? ' condition' : '') . '">' . $value . '</td>';
977 }
978
979 /**
980 * Prepares the display for a null value
981 *
982 * @param string $class
983 * @param string $condition_field
984 *
985 * @return string the td
986 */
987 function PMA_buildNullDisplay($class, $condition_field) {
988 // the null class is needed for inline editing
989 return '<td align="right"' . ' class="' . $class . ($condition_field ? ' condition' : '') . ' null"><i>NULL</i></td>';
990 }
991
992 /**
993 * Prepares the display for an empty value
994 *
995 * @param string $class
996 * @param string $condition_field
997 * @param string $align
998 *
999 * @return string the td
1000 */
1001 function PMA_buildEmptyDisplay($class, $condition_field, $align = '') {
1002 return '<td ' . $align . ' class="' . $class . ' nowrap' . ($condition_field ? ' condition' : '') . '">&nbsp;</td>';
1003 }
1004
1005 /**
1006 * Displays the body of the results table
1007 *
1008 * @uses $_SESSION['tmp_user_values']['disp_direction']
1009 * @uses $_SESSION['tmp_user_values']['repeat_cells']
1010 * @uses $_SESSION['tmp_user_values']['max_rows']
1011 * @uses $_SESSION['tmp_user_values']['display_text']
1012 * @uses $_SESSION['tmp_user_values']['display_binary']
1013 * @uses $_SESSION['tmp_user_values']['display_binary_as_hex']
1014 * @uses $_SESSION['tmp_user_values']['display_blob']
1015 * @param integer the link id associated to the query which results have
1016 * to be displayed
1017 * @param array which elements to display
1018 * @param array the list of relations
1019 * @param array the analyzed query
1020 *
1021 * @return boolean always true
1022 *
1023 * @global string $db the database name
1024 * @global string $table the table name
1025 * @global string $goto the URL to go back in case of errors
1026 * @global string $sql_query the SQL query
1027 * @global array $fields_meta the list of fields properties
1028 * @global integer $fields_cnt the total number of fields returned by
1029 * the SQL query
1030 * @global array $vertical_display informations used with vertical display
1031 * mode
1032 * @global array $highlight_columns column names to highlight
1033 * @global array $row current row data
1034 *
1035 * @access private
1036 *
1037 * @see PMA_displayTable()
1038 */
1039 function PMA_displayTableBody(&$dt_result, &$is_display, $map, $analyzed_sql) {
1040 global $db, $table, $goto;
1041 global $sql_query, $fields_meta, $fields_cnt;
1042 global $vertical_display, $highlight_columns;
1043 global $row; // mostly because of browser transformations, to make the row-data accessible in a plugin
1044
1045 $url_sql_query = $sql_query;
1046
1047 // query without conditions to shorten URLs when needed, 200 is just
1048 // guess, it should depend on remaining URL length
1049
1050 if (isset($analyzed_sql) && isset($analyzed_sql[0]) &&
1051 isset($analyzed_sql[0]['querytype']) && $analyzed_sql[0]['querytype'] == 'SELECT' &&
1052 strlen($sql_query) > 200) {
1053
1054 $url_sql_query = 'SELECT ';
1055 if (isset($analyzed_sql[0]['queryflags']['distinct'])) {
1056 $url_sql_query .= ' DISTINCT ';
1057 }
1058 $url_sql_query .= $analyzed_sql[0]['select_expr_clause'];
1059 if (!empty($analyzed_sql[0]['from_clause'])) {
1060 $url_sql_query .= ' FROM ' . $analyzed_sql[0]['from_clause'];
1061 }
1062 }
1063
1064 if (!is_array($map)) {
1065 $map = array();
1066 }
1067 $row_no = 0;
1068 $vertical_display['edit'] = array();
1069 $vertical_display['delete'] = array();
1070 $vertical_display['data'] = array();
1071 $vertical_display['row_delete'] = array();
1072 // name of the class added to all inline editable elements
1073 $inline_edit_class = 'inline_edit';
1074
1075 // Correction University of Virginia 19991216 in the while below
1076 // Previous code assumed that all tables have keys, specifically that
1077 // the phpMyAdmin GUI should support row delete/edit only for such
1078 // tables.
1079 // Although always using keys is arguably the prescribed way of
1080 // defining a relational table, it is not required. This will in
1081 // particular be violated by the novice.
1082 // We want to encourage phpMyAdmin usage by such novices. So the code
1083 // below has been changed to conditionally work as before when the
1084 // table being displayed has one or more keys; but to display
1085 // delete/edit options correctly for tables without keys.
1086
1087 $odd_row = true;
1088 while ($row = PMA_DBI_fetch_row($dt_result)) {
1089 // "vertical display" mode stuff
1090 if ($row_no != 0 && $_SESSION['tmp_user_values']['repeat_cells'] != 0 && !($row_no % $_SESSION['tmp_user_values']['repeat_cells'])
1091 && ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
1092 || $_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped'))
1093 {
1094 echo '<tr>' . "\n";
1095 if ($vertical_display['emptypre'] > 0) {
1096 echo ' <th colspan="' . $vertical_display['emptypre'] . '">' . "\n"
1097 .' &nbsp;</th>' . "\n";
1098 }
1099
1100 foreach ($vertical_display['desc'] as $val) {
1101 echo $val;
1102 }
1103
1104 if ($vertical_display['emptyafter'] > 0) {
1105 echo ' <th colspan="' . $vertical_display['emptyafter'] . '">' . "\n"
1106 .' &nbsp;</th>' . "\n";
1107 }
1108 echo '</tr>' . "\n";
1109 } // end if
1110
1111 $alternating_color_class = ($odd_row ? 'odd' : 'even');
1112 $odd_row = ! $odd_row;
1113
1114 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
1115 || $_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
1116 // pointer code part
1117 echo '<tr class="' . $alternating_color_class . '">';
1118 }
1119
1120
1121 // 1. Prepares the row
1122 // 1.1 Results from a "SELECT" statement -> builds the
1123 // WHERE clause to use in links (a unique key if possible)
1124 /**
1125 * @todo $where_clause could be empty, for example a table
1126 * with only one field and it's a BLOB; in this case,
1127 * avoid to display the delete and edit links
1128 */
1129 list($where_clause, $clause_is_unique) = PMA_getUniqueCondition($dt_result, $fields_cnt, $fields_meta, $row);
1130 $where_clause_html = urlencode($where_clause);
1131
1132 // 1.2 Defines the URLs for the modify/delete link(s)
1133
1134 if ($is_display['edit_lnk'] != 'nn' || $is_display['del_lnk'] != 'nn') {
1135 // We need to copy the value or else the == 'both' check will always return true
1136
1137 if ($GLOBALS['cfg']['PropertiesIconic'] === 'both') {
1138 $iconic_spacer = '<div class="nowrap">';
1139 } else {
1140 $iconic_spacer = '';
1141 }
1142
1143 // 1.2.1 Modify link(s)
1144 if ($is_display['edit_lnk'] == 'ur') { // update row case
1145 $_url_params = array(
1146 'db' => $db,
1147 'table' => $table,
1148 'where_clause' => $where_clause,
1149 'clause_is_unique' => $clause_is_unique,
1150 'sql_query' => $url_sql_query,
1151 'goto' => 'sql.php',
1152 );
1153 $edit_url = 'tbl_change.php' . PMA_generate_common_url($_url_params);
1154
1155 $edit_str = PMA_getIcon('b_edit.png', __('Edit'), true);
1156
1157 // Class definitions required for inline editing jQuery scripts
1158 $edit_anchor_class = "edit_row_anchor";
1159 if( $clause_is_unique == 0) {
1160 $edit_anchor_class .= ' nonunique';
1161 }
1162 } // end if (1.2.1)
1163
1164 // 1.2.2 Delete/Kill link(s)
1165 if ($is_display['del_lnk'] == 'dr') { // delete row case
1166 $_url_params = array(
1167 'db' => $db,
1168 'table' => $table,
1169 'sql_query' => $url_sql_query,
1170 'message_to_show' => __('The row has been deleted'),
1171 'goto' => (empty($goto) ? 'tbl_sql.php' : $goto),
1172 );
1173 $lnk_goto = 'sql.php' . PMA_generate_common_url($_url_params, 'text');
1174
1175 $del_query = 'DELETE FROM ' . PMA_backquote($db) . '.' . PMA_backquote($table)
1176 . ' WHERE ' . $where_clause . ($clause_is_unique ? '' : ' LIMIT 1');
1177
1178 $_url_params = array(
1179 'db' => $db,
1180 'table' => $table,
1181 'sql_query' => $del_query,
1182 'message_to_show' => __('The row has been deleted'),
1183 'goto' => $lnk_goto,
1184 );
1185 $del_url = 'sql.php' . PMA_generate_common_url($_url_params);
1186
1187 $js_conf = 'DELETE FROM ' . PMA_jsFormat($db) . '.' . PMA_jsFormat($table)
1188 . ' WHERE ' . PMA_jsFormat($where_clause, false)
1189 . ($clause_is_unique ? '' : ' LIMIT 1');
1190 $del_str = PMA_getIcon('b_drop.png', __('Delete'), true);
1191 } elseif ($is_display['del_lnk'] == 'kp') { // kill process case
1192
1193 $_url_params = array(
1194 'db' => $db,
1195 'table' => $table,
1196 'sql_query' => $url_sql_query,
1197 'goto' => 'main.php',
1198 );
1199 $lnk_goto = 'sql.php' . PMA_generate_common_url($_url_params, 'text');
1200
1201 $_url_params = array(
1202 'db' => 'mysql',
1203 'sql_query' => 'KILL ' . $row[0],
1204 'goto' => $lnk_goto,
1205 );
1206 $del_url = 'sql.php' . PMA_generate_common_url($_url_params);
1207 $del_query = 'KILL ' . $row[0];
1208 $js_conf = 'KILL ' . $row[0];
1209 $del_str = PMA_getIcon('b_drop.png', __('Kill'), true);
1210 } // end if (1.2.2)
1211
1212 // 1.3 Displays the links at left if required
1213 if ($GLOBALS['cfg']['ModifyDeleteAtLeft']
1214 && ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
1215 || $_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped')) {
1216 if (! isset($js_conf)) {
1217 $js_conf = '';
1218 }
1219 echo PMA_generateCheckboxAndLinks('left', $del_url, $is_display, $row_no, $where_clause, $where_clause_html, $del_query, 'l', $edit_url, $edit_anchor_class, $edit_str, $del_str, $js_conf);
1220 } // end if (1.3)
1221 } // end if (1)
1222
1223 // 2. Displays the rows' values
1224 for ($i = 0; $i < $fields_cnt; ++$i) {
1225 $meta = $fields_meta[$i];
1226 $pointer = $i;
1227 $is_field_truncated = false;
1228 //If the previous column had blob data, we need to reset the class
1229 // to $inline_edit_class
1230 $class = 'data ' . $inline_edit_class . ' ' . $alternating_color_class;
1231
1232 // See if this column should get highlight because it's used in the
1233 // where-query.
1234 if (isset($highlight_columns) && (isset($highlight_columns[$meta->name]) || isset($highlight_columns[PMA_backquote($meta->name)]))) {
1235 $condition_field = true;
1236 } else {
1237 $condition_field = false;
1238 }
1239
1240 if ($_SESSION['tmp_user_values']['disp_direction'] == 'vertical' && (!isset($GLOBALS['printview']) || ($GLOBALS['printview'] != '1'))) {
1241 // the row number corresponds to a data row, not HTML table row
1242 $class .= ' row_' . $row_no;
1243 if ($GLOBALS['cfg']['BrowsePointerEnable'] == true) {
1244 $class .= ' vpointer';
1245 }
1246 if ($GLOBALS['cfg']['BrowseMarkerEnable'] == true) {
1247 $class .= ' vmarker';
1248 }
1249 }// end if
1250
1251 // Wrap MIME-transformations. [MIME]
1252 $default_function = 'default_function'; // default_function
1253 $transform_function = $default_function;
1254 $transform_options = array();
1255
1256 if ($GLOBALS['cfgRelation']['mimework'] && $GLOBALS['cfg']['BrowseMIME']) {
1257
1258 if (isset($GLOBALS['mime_map'][$meta->name]['mimetype']) && isset($GLOBALS['mime_map'][$meta->name]['transformation']) && !empty($GLOBALS['mime_map'][$meta->name]['transformation'])) {
1259 $include_file = $GLOBALS['mime_map'][$meta->name]['transformation'];
1260
1261 if (file_exists('./libraries/transformations/' . $include_file)) {
1262 $transformfunction_name = str_replace('.inc.php', '', $GLOBALS['mime_map'][$meta->name]['transformation']);
1263
1264 require_once './libraries/transformations/' . $include_file;
1265
1266 if (function_exists('PMA_transformation_' . $transformfunction_name)) {
1267 $transform_function = 'PMA_transformation_' . $transformfunction_name;
1268 $transform_options = PMA_transformation_getOptions((isset($GLOBALS['mime_map'][$meta->name]['transformation_options']) ? $GLOBALS['mime_map'][$meta->name]['transformation_options'] : ''));
1269 $meta->mimetype = str_replace('_', '/', $GLOBALS['mime_map'][$meta->name]['mimetype']);
1270 }
1271 } // end if file_exists
1272 } // end if transformation is set
1273 } // end if mime/transformation works.
1274
1275 $_url_params = array(
1276 'db' => $db,
1277 'table' => $table,
1278 'where_clause' => $where_clause,
1279 'transform_key' => $meta->name,
1280 );
1281
1282 if (! empty($sql_query)) {
1283 $_url_params['sql_query'] = $url_sql_query;
1284 }
1285
1286 $transform_options['wrapper_link'] = PMA_generate_common_url($_url_params);
1287
1288 // n u m e r i c
1289 if ($meta->numeric == 1) {
1290
1291 // if two fields have the same name (this is possible
1292 // with self-join queries, for example), using $meta->name
1293 // will show both fields NULL even if only one is NULL,
1294 // so use the $pointer
1295
1296 if (!isset($row[$i]) || is_null($row[$i])) {
1297 $vertical_display['data'][$row_no][$i] = PMA_buildNullDisplay($class, $condition_field);
1298 } elseif ($row[$i] != '') {
1299
1300 $nowrap = ' nowrap';
1301 $where_comparison = ' = ' . $row[$i];
1302
1303 $vertical_display['data'][$row_no][$i] = '<td align="right"' . PMA_prepare_row_data($class, $condition_field, $analyzed_sql, $meta, $map, $row[$i], $transform_function, $default_function, $nowrap, $where_comparison, $transform_options, $is_field_truncated);
1304 } else {
1305 $vertical_display['data'][$row_no][$i] = PMA_buildEmptyDisplay($class, $condition_field, 'align="right"');
1306 }
1307
1308 // b l o b
1309
1310 } elseif (stristr($meta->type, 'BLOB')) {
1311 // PMA_mysql_fetch_fields returns BLOB in place of
1312 // TEXT fields type so we have to ensure it's really a BLOB
1313 $field_flags = PMA_DBI_field_flags($dt_result, $i);
1314
1315 // reset $class from $inline_edit_class to just 'data'
1316 // as we can't edit binary data
1317 $class = 'data';
1318
1319 if (stristr($field_flags, 'BINARY')) {
1320 if (!isset($row[$i]) || is_null($row[$i])) {
1321 $vertical_display['data'][$row_no][$i] = PMA_buildNullDisplay($class, $condition_field);
1322 } else {
1323 // for blobstreaming
1324 // if valid BS reference exists
1325 if (PMA_BS_IsPBMSReference($row[$i], $db)) {
1326 $blobtext = PMA_BS_CreateReferenceLink($row[$i], $db);
1327 } else {
1328 $blobtext = PMA_handle_non_printable_contents('BLOB', (isset($row[$i]) ? $row[$i] : ''), $transform_function, $transform_options, $default_function, $meta, $_url_params);
1329 }
1330
1331 $vertical_display['data'][$row_no][$i] = PMA_buildValueDisplay($class, $condition_field, $blobtext);
1332 unset($blobtext);
1333 }
1334 // not binary:
1335 } else {
1336 if (!isset($row[$i]) || is_null($row[$i])) {
1337 $vertical_display['data'][$row_no][$i] = PMA_buildNullDisplay($class, $condition_field);
1338 } elseif ($row[$i] != '') {
1339 // if a transform function for blob is set, none of these replacements will be made
1340 if (PMA_strlen($row[$i]) > $GLOBALS['cfg']['LimitChars'] && $_SESSION['tmp_user_values']['display_text'] == 'P') {
1341 $row[$i] = PMA_substr($row[$i], 0, $GLOBALS['cfg']['LimitChars']) . '...';
1342 $is_field_truncated = true;
1343 }
1344 // displays all space characters, 4 space
1345 // characters for tabulations and <cr>/<lf>
1346 $row[$i] = ($default_function != $transform_function ? $transform_function($row[$i], $transform_options, $meta) : $default_function($row[$i], array(), $meta));
1347
1348 $vertical_display['data'][$row_no][$i] = PMA_buildValueDisplay($class, $condition_field, $row[$i]);
1349 } else {
1350 $vertical_display['data'][$row_no][$i] = PMA_buildEmptyDisplay($class, $condition_field);
1351 }
1352 }
1353 // g e o m e t r y
1354 } elseif ($meta->type == 'geometry') {
1355 $geometry_text = PMA_handle_non_printable_contents('GEOMETRY', (isset($row[$i]) ? $row[$i] : ''), $transform_function, $transform_options, $default_function, $meta);
1356 // reset $class from $inline_edit_class to 'data'
1357 // as we can't edit geometry data
1358 $class = 'data';
1359 $vertical_display['data'][$row_no][$i] = PMA_buildValueDisplay($class, $condition_field, $geometry_text);
1360 unset($geometry_text);
1361
1362 // n o t n u m e r i c a n d n o t B L O B
1363 } else {
1364 if (!isset($row[$i]) || is_null($row[$i])) {
1365 $vertical_display['data'][$row_no][$i] = PMA_buildNullDisplay($class, $condition_field);
1366 } elseif ($row[$i] != '') {
1367 // support blanks in the key
1368 $relation_id = $row[$i];
1369
1370 // Cut all fields to $GLOBALS['cfg']['LimitChars']
1371 // (unless it's a link-type transformation)
1372 if (PMA_strlen($row[$i]) > $GLOBALS['cfg']['LimitChars'] && $_SESSION['tmp_user_values']['display_text'] == 'P' && !strpos($transform_function, 'link') === true) {
1373 $row[$i] = PMA_substr($row[$i], 0, $GLOBALS['cfg']['LimitChars']) . '...';
1374 $is_field_truncated = true;
1375 }
1376
1377 // displays special characters from binaries
1378 $field_flags = PMA_DBI_field_flags($dt_result, $i);
1379 if (isset($meta->_type) && $meta->_type === MYSQLI_TYPE_BIT) {
1380 $row[$i] = PMA_printable_bit_value($row[$i], $meta->length);
1381 // some results of PROCEDURE ANALYSE() are reported as
1382 // being BINARY but they are quite readable,
1383 // so don't treat them as BINARY
1384 } elseif (stristr($field_flags, 'BINARY') && $meta->type == 'string' && !(isset($GLOBALS['is_analyse']) && $GLOBALS['is_analyse'])) {
1385 if ($_SESSION['tmp_user_values']['display_binary']) {
1386 // user asked to see the real contents of BINARY
1387 // fields
1388 if ($_SESSION['tmp_user_values']['display_binary_as_hex'] && PMA_contains_nonprintable_ascii($row[$i])) {
1389 $row[$i] = bin2hex($row[$i]);
1390 } else {
1391 $row[$i] = htmlspecialchars(PMA_replace_binary_contents($row[$i]));
1392 }
1393 } else {
1394 // we show the BINARY message and field's size
1395 // (or maybe use a transformation)
1396 $row[$i] = PMA_handle_non_printable_contents('BINARY', $row[$i], $transform_function, $transform_options, $default_function, $meta, $_url_params);
1397 }
1398 }
1399
1400 // transform functions may enable no-wrapping:
1401 $function_nowrap = $transform_function . '_nowrap';
1402 $bool_nowrap = (($default_function != $transform_function && function_exists($function_nowrap)) ? $function_nowrap($transform_options) : false);
1403
1404 // do not wrap if date field type
1405 $nowrap = ((preg_match('@DATE|TIME@i', $meta->type) || $bool_nowrap) ? ' nowrap' : '');
1406 $where_comparison = ' = \'' . PMA_sqlAddslashes($row[$i]) . '\'';
1407 $vertical_display['data'][$row_no][$i] = '<td ' . PMA_prepare_row_data($class, $condition_field, $analyzed_sql, $meta, $map, $row[$i], $transform_function, $default_function, $nowrap, $where_comparison, $transform_options, $is_field_truncated);
1408
1409 } else {
1410 $vertical_display['data'][$row_no][$i] = PMA_buildEmptyDisplay($class, $condition_field);
1411 }
1412 }
1413
1414 // output stored cell
1415 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
1416 || $_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
1417 echo $vertical_display['data'][$row_no][$i];
1418 }
1419
1420 if (isset($vertical_display['rowdata'][$i][$row_no])) {
1421 $vertical_display['rowdata'][$i][$row_no] .= $vertical_display['data'][$row_no][$i];
1422 } else {
1423 $vertical_display['rowdata'][$i][$row_no] = $vertical_display['data'][$row_no][$i];
1424 }
1425 } // end for (2)
1426
1427 // 3. Displays the modify/delete links on the right if required
1428 if ($GLOBALS['cfg']['ModifyDeleteAtRight']
1429 && ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
1430 || $_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped')) {
1431 if (! isset($js_conf)) {
1432 $js_conf = '';
1433 }
1434 echo PMA_generateCheckboxAndLinks('right', $del_url, $is_display, $row_no, $where_clause, $where_clause_html, $del_query, 'r', $edit_url, $edit_anchor_class, $edit_str, $del_str, $js_conf);
1435 } // end if (3)
1436
1437 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
1438 || $_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
1439 ?>
1440 </tr>
1441 <?php
1442 } // end if
1443
1444 // 4. Gather links of del_urls and edit_urls in an array for later
1445 // output
1446 if (!isset($vertical_display['edit'][$row_no])) {
1447 $vertical_display['edit'][$row_no] = '';
1448 $vertical_display['delete'][$row_no] = '';
1449 $vertical_display['row_delete'][$row_no] = '';
1450 }
1451 $vertical_class = ' row_' . $row_no;
1452 if ($GLOBALS['cfg']['BrowsePointerEnable'] == true) {
1453 $vertical_class .= ' vpointer';
1454 }
1455 if ($GLOBALS['cfg']['BrowseMarkerEnable'] == true) {
1456 $vertical_class .= ' vmarker';
1457 }
1458
1459 if (!empty($del_url) && $is_display['del_lnk'] != 'kp') {
1460 $vertical_display['row_delete'][$row_no] .= PMA_generateCheckboxForMulti($del_url, $is_display, $row_no, $where_clause_html, $del_query, '[%_PMA_CHECKBOX_DIR_%]', $alternating_color_class . $vertical_class);
1461 } else {
1462 unset($vertical_display['row_delete'][$row_no]);
1463 }
1464
1465 if (isset($edit_url)) {
1466 $vertical_display['edit'][$row_no] .= PMA_generateEditLink($edit_url, $alternating_color_class . ' ' . $edit_anchor_class . $vertical_class, $edit_str, $where_clause, $where_clause_html);
1467 } else {
1468 unset($vertical_display['edit'][$row_no]);
1469 }
1470
1471 if (isset($del_url)) {
1472 if (! isset($js_conf)) {
1473 $js_conf = '';
1474 }
1475 $vertical_display['delete'][$row_no] .= PMA_generateDeleteLink($del_url, $del_str, $js_conf, $alternating_color_class . $vertical_class);
1476 } else {
1477 unset($vertical_display['delete'][$row_no]);
1478 }
1479
1480 echo (($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal' || $_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') ? "\n" : '');
1481 $row_no++;
1482 } // end while
1483
1484 // this is needed by PMA_displayTable() to generate the proper param
1485 // in the multi-edit and multi-delete form
1486 return $clause_is_unique;
1487 } // end of the 'PMA_displayTableBody()' function
1488
1489
1490 /**
1491 * Do display the result table with the vertical direction mode.
1492 *
1493 * @return boolean always true
1494 *
1495 * @uses $_SESSION['tmp_user_values']['repeat_cells']
1496 * @global array $vertical_display the information to display
1497 *
1498 * @access private
1499 *
1500 * @see PMA_displayTable()
1501 */
1502 function PMA_displayVerticalTable()
1503 {
1504 global $vertical_display;
1505
1506 // Displays "multi row delete" link at top if required
1507 if ($GLOBALS['cfg']['ModifyDeleteAtLeft'] && is_array($vertical_display['row_delete']) && (count($vertical_display['row_delete']) > 0 || !empty($vertical_display['textbtn']))) {
1508 echo '<tr>' . "\n";
1509 echo $vertical_display['textbtn'];
1510 $foo_counter = 0;
1511 foreach ($vertical_display['row_delete'] as $val) {
1512 if (($foo_counter != 0) && ($_SESSION['tmp_user_values']['repeat_cells'] != 0) && !($foo_counter % $_SESSION['tmp_user_values']['repeat_cells'])) {
1513 echo '<th></th>' . "\n";
1514 }
1515
1516 echo str_replace('[%_PMA_CHECKBOX_DIR_%]', '_left', $val);
1517 $foo_counter++;
1518 } // end while
1519 echo '</tr>' . "\n";
1520 } // end if
1521
1522 // Displays "edit" link at top if required
1523 if ($GLOBALS['cfg']['ModifyDeleteAtLeft'] && is_array($vertical_display['edit']) && (count($vertical_display['edit']) > 0 || !empty($vertical_display['textbtn']))) {
1524 echo '<tr>' . "\n";
1525 if (!is_array($vertical_display['row_delete'])) {
1526 echo $vertical_display['textbtn'];
1527 }
1528 $foo_counter = 0;
1529 foreach ($vertical_display['edit'] as $val) {
1530 if (($foo_counter != 0) && ($_SESSION['tmp_user_values']['repeat_cells'] != 0) && !($foo_counter % $_SESSION['tmp_user_values']['repeat_cells'])) {
1531 echo ' <th></th>' . "\n";
1532 }
1533
1534 echo $val;
1535 $foo_counter++;
1536 } // end while
1537 echo '</tr>' . "\n";
1538 } // end if
1539
1540 // Displays "delete" link at top if required
1541 if ($GLOBALS['cfg']['ModifyDeleteAtLeft'] && is_array($vertical_display['delete']) && (count($vertical_display['delete']) > 0 || !empty($vertical_display['textbtn']))) {
1542 echo '<tr>' . "\n";
1543 if (!is_array($vertical_display['edit']) && !is_array($vertical_display['row_delete'])) {
1544 echo $vertical_display['textbtn'];
1545 }
1546 $foo_counter = 0;
1547 foreach ($vertical_display['delete'] as $val) {
1548 if (($foo_counter != 0) && ($_SESSION['tmp_user_values']['repeat_cells'] != 0) && !($foo_counter % $_SESSION['tmp_user_values']['repeat_cells'])) {
1549 echo '<th></th>' . "\n";
1550 }
1551
1552 echo $val;
1553 $foo_counter++;
1554 } // end while
1555 echo '</tr>' . "\n";
1556 } // end if
1557
1558 // Displays data
1559 foreach ($vertical_display['desc'] AS $key => $val) {
1560
1561 echo '<tr>' . "\n";
1562 echo $val;
1563
1564 $foo_counter = 0;
1565 foreach ($vertical_display['rowdata'][$key] as $subval) {
1566 if (($foo_counter != 0) && ($_SESSION['tmp_user_values']['repeat_cells'] != 0) and !($foo_counter % $_SESSION['tmp_user_values']['repeat_cells'])) {
1567 echo $val;
1568 }
1569
1570 echo $subval;
1571 $foo_counter++;
1572 } // end while
1573
1574 echo '</tr>' . "\n";
1575 } // end while
1576
1577 // Displays "multi row delete" link at bottom if required
1578 if ($GLOBALS['cfg']['ModifyDeleteAtRight'] && is_array($vertical_display['row_delete']) && (count($vertical_display['row_delete']) > 0 || !empty($vertical_display['textbtn']))) {
1579 echo '<tr>' . "\n";
1580 echo $vertical_display['textbtn'];
1581 $foo_counter = 0;
1582 foreach ($vertical_display['row_delete'] as $val) {
1583 if (($foo_counter != 0) && ($_SESSION['tmp_user_values']['repeat_cells'] != 0) && !($foo_counter % $_SESSION['tmp_user_values']['repeat_cells'])) {
1584 echo '<th></th>' . "\n";
1585 }
1586
1587 echo str_replace('[%_PMA_CHECKBOX_DIR_%]', '_right', $val);
1588 $foo_counter++;
1589 } // end while
1590 echo '</tr>' . "\n";
1591 } // end if
1592
1593 // Displays "edit" link at bottom if required
1594 if ($GLOBALS['cfg']['ModifyDeleteAtRight'] && is_array($vertical_display['edit']) && (count($vertical_display['edit']) > 0 || !empty($vertical_display['textbtn']))) {
1595 echo '<tr>' . "\n";
1596 if (!is_array($vertical_display['row_delete'])) {
1597 echo $vertical_display['textbtn'];
1598 }
1599 $foo_counter = 0;
1600 foreach ($vertical_display['edit'] as $val) {
1601 if (($foo_counter != 0) && ($_SESSION['tmp_user_values']['repeat_cells'] != 0) && !($foo_counter % $_SESSION['tmp_user_values']['repeat_cells'])) {
1602 echo '<th></th>' . "\n";
1603 }
1604
1605 echo $val;
1606 $foo_counter++;
1607 } // end while
1608 echo '</tr>' . "\n";
1609 } // end if
1610
1611 // Displays "delete" link at bottom if required
1612 if ($GLOBALS['cfg']['ModifyDeleteAtRight'] && is_array($vertical_display['delete']) && (count($vertical_display['delete']) > 0 || !empty($vertical_display['textbtn']))) {
1613 echo '<tr>' . "\n";
1614 if (!is_array($vertical_display['edit']) && !is_array($vertical_display['row_delete'])) {
1615 echo $vertical_display['textbtn'];
1616 }
1617 $foo_counter = 0;
1618 foreach ($vertical_display['delete'] as $val) {
1619 if (($foo_counter != 0) && ($_SESSION['tmp_user_values']['repeat_cells'] != 0) && !($foo_counter % $_SESSION['tmp_user_values']['repeat_cells'])) {
1620 echo '<th></th>' . "\n";
1621 }
1622
1623 echo $val;
1624 $foo_counter++;
1625 } // end while
1626 echo '</tr>' . "\n";
1627 }
1628
1629 return true;
1630 } // end of the 'PMA_displayVerticalTable' function
1631
1632 /**
1633 *
1634 * @uses $_SESSION['tmp_user_values']['disp_direction']
1635 * @uses $_REQUEST['disp_direction']
1636 * @uses $GLOBALS['cfg']['DefaultDisplay']
1637 * @uses $_SESSION['tmp_user_values']['repeat_cells']
1638 * @uses $_REQUEST['repeat_cells']
1639 * @uses $GLOBALS['cfg']['RepeatCells']
1640 * @uses $_SESSION['tmp_user_values']['max_rows']
1641 * @uses $_REQUEST['session_max_rows']
1642 * @uses $GLOBALS['cfg']['MaxRows']
1643 * @uses $_SESSION['tmp_user_values']['pos']
1644 * @uses $_REQUEST['pos']
1645 * @uses $_SESSION['tmp_user_values']['display_text']
1646 * @uses $_REQUEST['display_text']
1647 * @uses $_SESSION['tmp_user_values']['relational_display']
1648 * @uses $_REQUEST['relational_display']
1649 * @uses $_SESSION['tmp_user_values']['display_binary']
1650 * @uses $_REQUEST['display_binary']
1651 * @uses $_SESSION['tmp_user_values']['display_binary_as_hex']
1652 * @uses $_REQUEST['display_binary_as_hex']
1653 * @uses $_SESSION['tmp_user_values']['display_blob']
1654 * @uses $_REQUEST['display_blob']
1655 * @uses PMA_isValid()
1656 * @uses $GLOBALS['sql_query']
1657 * @todo make maximum remembered queries configurable
1658 * @todo move/split into SQL class!?
1659 * @todo currently this is called twice unnecessary
1660 * @todo ignore LIMIT and ORDER in query!?
1661 */
1662 function PMA_displayTable_checkConfigParams()
1663 {
1664 $sql_md5 = md5($GLOBALS['sql_query']);
1665
1666 $_SESSION['tmp_user_values']['query'][$sql_md5]['sql'] = $GLOBALS['sql_query'];
1667
1668 if (PMA_isValid($_REQUEST['disp_direction'], array('horizontal', 'vertical', 'horizontalflipped'))) {
1669 $_SESSION['tmp_user_values']['query'][$sql_md5]['disp_direction'] = $_REQUEST['disp_direction'];
1670 unset($_REQUEST['disp_direction']);
1671 } elseif (empty($_SESSION['tmp_user_values']['query'][$sql_md5]['disp_direction'])) {
1672 $_SESSION['tmp_user_values']['query'][$sql_md5]['disp_direction'] = $GLOBALS['cfg']['DefaultDisplay'];
1673 }
1674
1675 if (PMA_isValid($_REQUEST['repeat_cells'], 'numeric')) {
1676 $_SESSION['tmp_user_values']['query'][$sql_md5]['repeat_cells'] = $_REQUEST['repeat_cells'];
1677 unset($_REQUEST['repeat_cells']);
1678 } elseif (empty($_SESSION['tmp_user_values']['query'][$sql_md5]['repeat_cells'])) {
1679 $_SESSION['tmp_user_values']['query'][$sql_md5]['repeat_cells'] = $GLOBALS['cfg']['RepeatCells'];
1680 }
1681
1682 // as this is a form value, the type is always string so we cannot
1683 // use PMA_isValid($_REQUEST['session_max_rows'], 'integer')
1684 if ((PMA_isValid($_REQUEST['session_max_rows'], 'numeric')
1685 && (int) $_REQUEST['session_max_rows'] == $_REQUEST['session_max_rows'])
1686 || $_REQUEST['session_max_rows'] == 'all') {
1687 $_SESSION['tmp_user_values']['query'][$sql_md5]['max_rows'] = $_REQUEST['session_max_rows'];
1688 unset($_REQUEST['session_max_rows']);
1689 } elseif (empty($_SESSION['tmp_user_values']['query'][$sql_md5]['max_rows'])) {
1690 $_SESSION['tmp_user_values']['query'][$sql_md5]['max_rows'] = $GLOBALS['cfg']['MaxRows'];
1691 }
1692
1693 if (PMA_isValid($_REQUEST['pos'], 'numeric')) {
1694 $_SESSION['tmp_user_values']['query'][$sql_md5]['pos'] = $_REQUEST['pos'];
1695 unset($_REQUEST['pos']);
1696 } elseif (empty($_SESSION['tmp_user_values']['query'][$sql_md5]['pos'])) {
1697 $_SESSION['tmp_user_values']['query'][$sql_md5]['pos'] = 0;
1698 }
1699
1700 if (PMA_isValid($_REQUEST['display_text'], array('P', 'F'))) {
1701 $_SESSION['tmp_user_values']['query'][$sql_md5]['display_text'] = $_REQUEST['display_text'];
1702 unset($_REQUEST['display_text']);
1703 } elseif (empty($_SESSION['tmp_user_values']['query'][$sql_md5]['display_text'])) {
1704 $_SESSION['tmp_user_values']['query'][$sql_md5]['display_text'] = 'P';
1705 }
1706
1707 if (PMA_isValid($_REQUEST['relational_display'], array('K', 'D'))) {
1708 $_SESSION['tmp_user_values']['query'][$sql_md5]['relational_display'] = $_REQUEST['relational_display'];
1709 unset($_REQUEST['relational_display']);
1710 } elseif (empty($_SESSION['tmp_user_values']['query'][$sql_md5]['relational_display'])) {
1711 $_SESSION['tmp_user_values']['query'][$sql_md5]['relational_display'] = 'K';
1712 }
1713
1714 if (isset($_REQUEST['display_binary'])) {
1715 $_SESSION['tmp_user_values']['query'][$sql_md5]['display_binary'] = true;
1716 unset($_REQUEST['display_binary']);
1717 } elseif (isset($_REQUEST['display_options_form'])) {
1718 // we know that the checkbox was unchecked
1719 unset($_SESSION['tmp_user_values']['query'][$sql_md5]['display_binary']);
1720 } else {
1721 // selected by default because some operations like OPTIMIZE TABLE
1722 // and all queries involving functions return "binary" contents,
1723 // according to low-level field flags
1724 $_SESSION['tmp_user_values']['query'][$sql_md5]['display_binary'] = true;
1725 }
1726
1727 if (isset($_REQUEST['display_binary_as_hex'])) {
1728 $_SESSION['tmp_user_values']['query'][$sql_md5]['display_binary_as_hex'] = true;
1729 unset($_REQUEST['display_binary_as_hex']);
1730 } elseif (isset($_REQUEST['display_options_form'])) {
1731 // we know that the checkbox was unchecked
1732 unset($_SESSION['tmp_user_values']['query'][$sql_md5]['display_binary_as_hex']);
1733 } else {
1734 // display_binary_as_hex config option
1735 if (isset($GLOBALS['cfg']['DisplayBinaryAsHex']) && true === $GLOBALS['cfg']['DisplayBinaryAsHex']) {
1736 $_SESSION['tmp_user_values']['query'][$sql_md5]['display_binary_as_hex'] = true;
1737 }
1738 }
1739
1740 if (isset($_REQUEST['display_blob'])) {
1741 $_SESSION['tmp_user_values']['query'][$sql_md5]['display_blob'] = true;
1742 unset($_REQUEST['display_blob']);
1743 } elseif (isset($_REQUEST['display_options_form'])) {
1744 // we know that the checkbox was unchecked
1745 unset($_SESSION['tmp_user_values']['query'][$sql_md5]['display_blob']);
1746 }
1747
1748 if (isset($_REQUEST['hide_transformation'])) {
1749 $_SESSION['tmp_user_values']['query'][$sql_md5]['hide_transformation'] = true;
1750 unset($_REQUEST['hide_transformation']);
1751 } elseif (isset($_REQUEST['display_options_form'])) {
1752 // we know that the checkbox was unchecked
1753 unset($_SESSION['tmp_user_values']['query'][$sql_md5]['hide_transformation']);
1754 }
1755
1756 // move current query to the last position, to be removed last
1757 // so only least executed query will be removed if maximum remembered queries
1758 // limit is reached
1759 $tmp = $_SESSION['tmp_user_values']['query'][$sql_md5];
1760 unset($_SESSION['tmp_user_values']['query'][$sql_md5]);
1761 $_SESSION['tmp_user_values']['query'][$sql_md5] = $tmp;
1762
1763 // do not exceed a maximum number of queries to remember
1764 if (count($_SESSION['tmp_user_values']['query']) > 10) {
1765 array_shift($_SESSION['tmp_user_values']['query']);
1766 //echo 'deleting one element ...';
1767 }
1768
1769 // populate query configuration
1770 $_SESSION['tmp_user_values']['display_text'] = $_SESSION['tmp_user_values']['query'][$sql_md5]['display_text'];
1771 $_SESSION['tmp_user_values']['relational_display'] = $_SESSION['tmp_user_values']['query'][$sql_md5]['relational_display'];
1772 $_SESSION['tmp_user_values']['display_binary'] = isset($_SESSION['tmp_user_values']['query'][$sql_md5]['display_binary']) ? true : false;
1773 $_SESSION['tmp_user_values']['display_binary_as_hex'] = isset($_SESSION['tmp_user_values']['query'][$sql_md5]['display_binary_as_hex']) ? true : false;
1774 $_SESSION['tmp_user_values']['display_blob'] = isset($_SESSION['tmp_user_values']['query'][$sql_md5]['display_blob']) ? true : false;
1775 $_SESSION['tmp_user_values']['hide_transformation'] = isset($_SESSION['tmp_user_values']['query'][$sql_md5]['hide_transformation']) ? true : false;
1776 $_SESSION['tmp_user_values']['pos'] = $_SESSION['tmp_user_values']['query'][$sql_md5]['pos'];
1777 $_SESSION['tmp_user_values']['max_rows'] = $_SESSION['tmp_user_values']['query'][$sql_md5]['max_rows'];
1778 $_SESSION['tmp_user_values']['repeat_cells'] = $_SESSION['tmp_user_values']['query'][$sql_md5]['repeat_cells'];
1779 $_SESSION['tmp_user_values']['disp_direction'] = $_SESSION['tmp_user_values']['query'][$sql_md5]['disp_direction'];
1780
1781 /*
1782 * debugging
1783 echo '<pre>';
1784 var_dump($_SESSION['tmp_user_values']);
1785 echo '</pre>';
1786 */
1787 }
1788
1789 /**
1790 * Displays a table of results returned by a SQL query.
1791 * This function is called by the "sql.php" script.
1792 *
1793 * @param integer the link id associated to the query which results have
1794 * to be displayed
1795 * @param array the display mode
1796 * @param array the analyzed query
1797 *
1798 * @uses $_SESSION['tmp_user_values']['pos']
1799 * @global string $db the database name
1800 * @global string $table the table name
1801 * @global string $goto the URL to go back in case of errors
1802 * @global string $sql_query the current SQL query
1803 * @global integer $num_rows the total number of rows returned by the
1804 * SQL query
1805 * @global integer $unlim_num_rows the total number of rows returned by the
1806 * SQL query without any programmatically
1807 * appended "LIMIT" clause
1808 * @global array $fields_meta the list of fields properties
1809 * @global integer $fields_cnt the total number of fields returned by
1810 * the SQL query
1811 * @global array $vertical_display informations used with vertical display
1812 * mode
1813 * @global array $highlight_columns column names to highlight
1814 * @global array $cfgRelation the relation settings
1815 *
1816 * @access private
1817 *
1818 * @see PMA_showMessage(), PMA_setDisplayMode(),
1819 * PMA_displayTableNavigation(), PMA_displayTableHeaders(),
1820 * PMA_displayTableBody(), PMA_displayResultsOperations()
1821 */
1822 function PMA_displayTable(&$dt_result, &$the_disp_mode, $analyzed_sql)
1823 {
1824 global $db, $table, $goto;
1825 global $sql_query, $num_rows, $unlim_num_rows, $fields_meta, $fields_cnt;
1826 global $vertical_display, $highlight_columns;
1827 global $cfgRelation;
1828 global $showtable;
1829
1830 // why was this called here? (already called from sql.php)
1831 //PMA_displayTable_checkConfigParams();
1832
1833 /**
1834 * @todo move this to a central place
1835 * @todo for other future table types
1836 */
1837 $is_innodb = (isset($showtable['Type']) && $showtable['Type'] == 'InnoDB');
1838
1839 if ($is_innodb
1840 && ! isset($analyzed_sql[0]['queryflags']['union'])
1841 && ! isset($analyzed_sql[0]['table_ref'][1]['table_name'])
1842 && (empty($analyzed_sql[0]['where_clause'])
1843 || $analyzed_sql[0]['where_clause'] == '1 ')) {
1844 // "j u s t b r o w s i n g"
1845 $pre_count = '~';
1846 $after_count = PMA_showHint(PMA_sanitize(__('May be approximate. See [a@./Documentation.html#faq3_11@Documentation]FAQ 3.11[/a]')), true);
1847 } else {
1848 $pre_count = '';
1849 $after_count = '';
1850 }
1851
1852 // 1. ----- Prepares the work -----
1853
1854 // 1.1 Gets the informations about which functionalities should be
1855 // displayed
1856 $total = '';
1857 $is_display = PMA_setDisplayMode($the_disp_mode, $total);
1858
1859 // 1.2 Defines offsets for the next and previous pages
1860 if ($is_display['nav_bar'] == '1') {
1861 if ($_SESSION['tmp_user_values']['max_rows'] == 'all') {
1862 $pos_next = 0;
1863 $pos_prev = 0;
1864 } else {
1865 $pos_next = $_SESSION['tmp_user_values']['pos'] + $_SESSION['tmp_user_values']['max_rows'];
1866 $pos_prev = $_SESSION['tmp_user_values']['pos'] - $_SESSION['tmp_user_values']['max_rows'];
1867 if ($pos_prev < 0) {
1868 $pos_prev = 0;
1869 }
1870 }
1871 } // end if
1872
1873 // 1.3 Find the sort expression
1874
1875 // we need $sort_expression and $sort_expression_nodirection
1876 // even if there are many table references
1877 if (! empty($analyzed_sql[0]['order_by_clause'])) {
1878 $sort_expression = trim(str_replace(' ', ' ', $analyzed_sql[0]['order_by_clause']));
1879 /**
1880 * Get rid of ASC|DESC
1881 */
1882 preg_match('@(.*)([[:space:]]*(ASC|DESC))@si', $sort_expression, $matches);
1883 $sort_expression_nodirection = isset($matches[1]) ? trim($matches[1]) : $sort_expression;
1884 $sort_direction = isset($matches[2]) ? trim($matches[2]) : '';
1885 unset($matches);
1886 } else {
1887 $sort_expression = $sort_expression_nodirection = $sort_direction = '';
1888 }
1889
1890 // 1.4 Prepares display of first and last value of the sorted column
1891
1892 if (! empty($sort_expression_nodirection)) {
1893 if (strpos($sort_expression_nodirection, '.') === false) {
1894 $sort_table = $table;
1895 $sort_column = $sort_expression_nodirection;
1896 } else {
1897 list($sort_table, $sort_column) = explode('.', $sort_expression_nodirection);
1898 }
1899 $sort_table = PMA_unQuote($sort_table);
1900 $sort_column = PMA_unQuote($sort_column);
1901 // find the sorted column index in row result
1902 // (this might be a multi-table query)
1903 $sorted_column_index = false;
1904 foreach($fields_meta as $key => $meta) {
1905 if ($meta->table == $sort_table && $meta->name == $sort_column) {
1906 $sorted_column_index = $key;
1907 break;
1908 }
1909 }
1910 if ($sorted_column_index !== false) {
1911 // fetch first row of the result set
1912 $row = PMA_DBI_fetch_row($dt_result);
1913 $column_for_first_row = substr($row[$sorted_column_index], 0, $GLOBALS['cfg']['LimitChars']);
1914 // fetch last row of the result set
1915 PMA_DBI_data_seek($dt_result, $num_rows - 1);
1916 $row = PMA_DBI_fetch_row($dt_result);
1917 $column_for_last_row = substr($row[$sorted_column_index], 0, $GLOBALS['cfg']['LimitChars']);
1918 // reset to first row for the loop in PMA_displayTableBody()
1919 PMA_DBI_data_seek($dt_result, 0);
1920 // we could also use here $sort_expression_nodirection
1921 $sorted_column_message = ' [' . htmlspecialchars($sort_column) . ': <strong>' . htmlspecialchars($column_for_first_row) . ' - ' . htmlspecialchars($column_for_last_row) . '</strong>]';
1922 unset($row, $column_for_first_row, $column_for_last_row);
1923 }
1924 unset($sorted_column_index, $sort_table, $sort_column);
1925 }
1926
1927 // 2. ----- Displays the top of the page -----
1928
1929 // 2.1 Displays a messages with position informations
1930 if ($is_display['nav_bar'] == '1' && isset($pos_next)) {
1931 if (isset($unlim_num_rows) && $unlim_num_rows != $total) {
1932 $selectstring = ', ' . $unlim_num_rows . ' ' . __('in query');
1933 } else {
1934 $selectstring = '';
1935 }
1936 $last_shown_rec = ($_SESSION['tmp_user_values']['max_rows'] == 'all' || $pos_next > $total)
1937 ? $total - 1
1938 : $pos_next - 1;
1939
1940 if (PMA_Table::isView($db, $table)
1941 && $total == $GLOBALS['cfg']['MaxExactCountViews']) {
1942 $message = PMA_Message::notice(__('This view has at least this number of rows. Please refer to %sdocumentation%s.'));
1943 $message->addParam('[a@./Documentation.html#cfg_MaxExactCount@_blank]');
1944 $message->addParam('[/a]');
1945 $message_view_warning = PMA_showHint($message);
1946 } else {
1947 $message_view_warning = false;
1948 }
1949
1950 $message = PMA_Message::success(__('Showing rows'));
1951 $message->addMessage($_SESSION['tmp_user_values']['pos']);
1952 if ($message_view_warning) {
1953 $message->addMessage('...', ' - ');
1954 $message->addMessage($message_view_warning);
1955 $message->addMessage('(');
1956 } else {
1957 $message->addMessage($last_shown_rec, ' - ');
1958 $message->addMessage(' (');
1959 $message->addMessage($pre_count . PMA_formatNumber($total, 0));
1960 $message->addString(__('total'));
1961 if (!empty($after_count)) {
1962 $message->addMessage($after_count);
1963 }
1964 $message->addMessage($selectstring, '');
1965 $message->addMessage(', ', '');
1966 }
1967
1968 $messagge_qt = PMA_Message::notice(__('Query took %01.4f sec'));
1969 $messagge_qt->addParam($GLOBALS['querytime']);
1970
1971 $message->addMessage($messagge_qt, '');
1972 $message->addMessage(')', '');
1973
1974 $message->addMessage(isset($sorted_column_message) ? $sorted_column_message : '', '');
1975
1976 PMA_showMessage($message, $sql_query, 'success');
1977
1978 } elseif (!isset($GLOBALS['printview']) || $GLOBALS['printview'] != '1') {
1979 PMA_showMessage(__('Your SQL query has been executed successfully'), $sql_query, 'success');
1980 }
1981
1982 // 2.3 Displays the navigation bars
1983 if (! strlen($table)) {
1984 if (isset($analyzed_sql[0]['query_type'])
1985 && $analyzed_sql[0]['query_type'] == 'SELECT') {
1986 // table does not always contain a real table name,
1987 // for example in MySQL 5.0.x, the query SHOW STATUS
1988 // returns STATUS as a table name
1989 $table = $fields_meta[0]->table;
1990 } else {
1991 $table = '';
1992 }
1993 }
1994
1995 if ($is_display['nav_bar'] == '1') {
1996 PMA_displayTableNavigation($pos_next, $pos_prev, $sql_query, 'top_direction_dropdown');
1997 echo "\n";
1998 } elseif (!isset($GLOBALS['printview']) || $GLOBALS['printview'] != '1') {
1999 echo "\n" . '<br /><br />' . "\n";
2000 }
2001
2002 // 2b ----- Get field references from Database -----
2003 // (see the 'relation' configuration variable)
2004
2005 // initialize map
2006 $map = array();
2007
2008 // find tables
2009 $target=array();
2010 if (isset($analyzed_sql[0]['table_ref']) && is_array($analyzed_sql[0]['table_ref'])) {
2011 foreach ($analyzed_sql[0]['table_ref'] AS $table_ref_position => $table_ref) {
2012 $target[] = $analyzed_sql[0]['table_ref'][$table_ref_position]['table_true_name'];
2013 }
2014 }
2015 $tabs = '(\'' . join('\',\'', $target) . '\')';
2016
2017 if (! strlen($table)) {
2018 $exist_rel = false;
2019 } else {
2020 // To be able to later display a link to the related table,
2021 // we verify both types of relations: either those that are
2022 // native foreign keys or those defined in the phpMyAdmin
2023 // configuration storage. If no PMA storage, we won't be able
2024 // to use the "column to display" notion (for example show
2025 // the name related to a numeric id).
2026 $exist_rel = PMA_getForeigners($db, $table, '', 'both');
2027 if ($exist_rel) {
2028 foreach ($exist_rel AS $master_field => $rel) {
2029 $display_field = PMA_getDisplayField($rel['foreign_db'], $rel['foreign_table']);
2030 $map[$master_field] = array($rel['foreign_table'],
2031 $rel['foreign_field'],
2032 $display_field,
2033 $rel['foreign_db']);
2034 } // end while
2035 } // end if
2036 } // end if
2037 // end 2b
2038
2039 // 3. ----- Displays the results table -----
2040 PMA_displayTableHeaders($is_display, $fields_meta, $fields_cnt, $analyzed_sql, $sort_expression, $sort_expression_nodirection, $sort_direction);
2041 $url_query = '';
2042 echo '<tbody>' . "\n";
2043 $clause_is_unique = PMA_displayTableBody($dt_result, $is_display, $map, $analyzed_sql);
2044 // vertical output case
2045 if ($_SESSION['tmp_user_values']['disp_direction'] == 'vertical') {
2046 PMA_displayVerticalTable();
2047 } // end if
2048 unset($vertical_display);
2049 echo '</tbody>' . "\n";
2050 ?>
2051 </table>
2052
2053 <?php
2054 // 4. ----- Displays the link for multi-fields edit and delete
2055
2056 if ($is_display['del_lnk'] == 'dr' && $is_display['del_lnk'] != 'kp') {
2057
2058 $delete_text = $is_display['del_lnk'] == 'dr' ? __('Delete') : __('Kill');
2059
2060 $_url_params = array(
2061 'db' => $db,
2062 'table' => $table,
2063 'sql_query' => $sql_query,
2064 'goto' => $goto,
2065 );
2066 $uncheckall_url = 'sql.php' . PMA_generate_common_url($_url_params);
2067
2068 $_url_params['checkall'] = '1';
2069 $checkall_url = 'sql.php' . PMA_generate_common_url($_url_params);
2070
2071 if ($_SESSION['tmp_user_values']['disp_direction'] == 'vertical') {
2072 $checkall_params['onclick'] = 'if (setCheckboxes(\'rowsDeleteForm\', true)) return false;';
2073 $uncheckall_params['onclick'] = 'if (setCheckboxes(\'rowsDeleteForm\', false)) return false;';
2074 } else {
2075 $checkall_params['onclick'] = 'if (markAllRows(\'rowsDeleteForm\')) return false;';
2076 $uncheckall_params['onclick'] = 'if (unMarkAllRows(\'rowsDeleteForm\')) return false;';
2077 }
2078 $checkall_link = PMA_linkOrButton($checkall_url, __('Check All'), $checkall_params, false);
2079 $uncheckall_link = PMA_linkOrButton($uncheckall_url, __('Uncheck All'), $uncheckall_params, false);
2080 if ($_SESSION['tmp_user_values']['disp_direction'] != 'vertical') {
2081 echo '<img class="selectallarrow" width="38" height="22"'
2082 .' src="' . $GLOBALS['pmaThemeImage'] . 'arrow_' . $GLOBALS['text_dir'] . '.png' . '"'
2083 .' alt="' . __('With selected:') . '" />';
2084 }
2085 echo $checkall_link . "\n"
2086 .' / ' . "\n"
2087 .$uncheckall_link . "\n"
2088 .'<i>' . __('With selected:') . '</i>' . "\n";
2089
2090 PMA_buttonOrImage('submit_mult', 'mult_submit',
2091 'submit_mult_change', __('Change'), 'b_edit.png');
2092 PMA_buttonOrImage('submit_mult', 'mult_submit',
2093 'submit_mult_delete', $delete_text, 'b_drop.png');
2094 if (isset($analyzed_sql[0]) && $analyzed_sql[0]['querytype'] == 'SELECT') {
2095 PMA_buttonOrImage('submit_mult', 'mult_submit',
2096 'submit_mult_export', __('Export'),
2097 'b_tblexport.png');
2098 }
2099 echo "\n";
2100
2101 echo '<input type="hidden" name="sql_query"'
2102 .' value="' . htmlspecialchars($sql_query) . '" />' . "\n";
2103
2104 if (! empty($GLOBALS['url_query'])) {
2105 echo '<input type="hidden" name="url_query"'
2106 .' value="' . $GLOBALS['url_query'] . '" />' . "\n";
2107 }
2108
2109 echo '<input type="hidden" name="clause_is_unique"'
2110 .' value="' . $clause_is_unique . '" />' . "\n";
2111
2112 echo '</form>' . "\n";
2113 }
2114
2115 // 5. ----- Displays the navigation bar at the bottom if required -----
2116
2117 if ($is_display['nav_bar'] == '1') {
2118 echo '<br />' . "\n";
2119 PMA_displayTableNavigation($pos_next, $pos_prev, $sql_query, 'bottom_direction_dropdown');
2120 } elseif (!isset($GLOBALS['printview']) || $GLOBALS['printview'] != '1') {
2121 echo "\n" . '<br /><br />' . "\n";
2122 }
2123
2124 // 6. ----- Displays "Query results operations"
2125 if (!isset($GLOBALS['printview']) || $GLOBALS['printview'] != '1') {
2126 PMA_displayResultsOperations($the_disp_mode, $analyzed_sql);
2127 }
2128 } // end of the 'PMA_displayTable()' function
2129
2130 function default_function($buffer) {
2131 $buffer = htmlspecialchars($buffer);
2132 $buffer = str_replace("\011", ' &nbsp;&nbsp;&nbsp;',
2133 str_replace(' ', ' &nbsp;', $buffer));
2134 $buffer = preg_replace("@((\015\012)|(\015)|(\012))@", '<br />', $buffer);
2135
2136 return $buffer;
2137 }
2138
2139 /**
2140 * Displays operations that are available on results.
2141 *
2142 * @param array the display mode
2143 * @param array the analyzed query
2144 *
2145 * @uses $_SESSION['tmp_user_values']['pos']
2146 * @uses $_SESSION['tmp_user_values']['display_text']
2147 * @global string $db the database name
2148 * @global string $table the table name
2149 * @global string $sql_query the current SQL query
2150 * @global integer $unlim_num_rows the total number of rows returned by the
2151 * SQL query without any programmatically
2152 * appended "LIMIT" clause
2153 *
2154 * @access private
2155 *
2156 * @see PMA_showMessage(), PMA_setDisplayMode(),
2157 * PMA_displayTableNavigation(), PMA_displayTableHeaders(),
2158 * PMA_displayTableBody(), PMA_displayResultsOperations()
2159 */
2160 function PMA_displayResultsOperations($the_disp_mode, $analyzed_sql) {
2161 global $db, $table, $sql_query, $unlim_num_rows;
2162
2163 $header_shown = FALSE;
2164 $header = '<fieldset><legend>' . __('Query results operations') . '</legend>';
2165
2166 if ($the_disp_mode[6] == '1' || $the_disp_mode[9] == '1') {
2167 // Displays "printable view" link if required
2168 if ($the_disp_mode[9] == '1') {
2169
2170 if (!$header_shown) {
2171 echo $header;
2172 $header_shown = TRUE;
2173 }
2174
2175 $_url_params = array(
2176 'db' => $db,
2177 'table' => $table,
2178 'printview' => '1',
2179 'sql_query' => $sql_query,
2180 );
2181 $url_query = PMA_generate_common_url($_url_params);
2182
2183 echo PMA_linkOrButton(
2184 'sql.php' . $url_query,
2185 PMA_getIcon('b_print.png', __('Print view'), false, true),
2186 '', true, true, 'print_view') . "\n";
2187
2188 if ($_SESSION['tmp_user_values']['display_text']) {
2189 $_url_params['display_text'] = 'F';
2190 echo PMA_linkOrButton(
2191 'sql.php' . PMA_generate_common_url($_url_params),
2192 PMA_getIcon('b_print.png', __('Print view (with full texts)'), false, true),
2193 '', true, true, 'print_view') . "\n";
2194 unset($_url_params['display_text']);
2195 }
2196 } // end displays "printable view"
2197 }
2198
2199 // Export link
2200 // (the url_query has extra parameters that won't be used to export)
2201 // (the single_table parameter is used in display_export.lib.php
2202 // to hide the SQL and the structure export dialogs)
2203 // If the parser found a PROCEDURE clause
2204 // (most probably PROCEDURE ANALYSE()) it makes no sense to
2205 // display the Export link).
2206 if (isset($analyzed_sql[0]) && $analyzed_sql[0]['querytype'] == 'SELECT' && !isset($printview) && ! isset($analyzed_sql[0]['queryflags']['procedure'])) {
2207 if (isset($analyzed_sql[0]['table_ref'][0]['table_true_name']) && !isset($analyzed_sql[0]['table_ref'][1]['table_true_name'])) {
2208 $_url_params['single_table'] = 'true';
2209 }
2210 if (!$header_shown) {
2211 echo $header;
2212 $header_shown = TRUE;
2213 }
2214 $_url_params['unlim_num_rows'] = $unlim_num_rows;
2215
2216 /**
2217 * At this point we don't know the table name; this can happen
2218 * for example with a query like
2219 * SELECT bike_code FROM (SELECT bike_code FROM bikes) tmp
2220 * As a workaround we set in the table parameter the name of the
2221 * first table of this database, so that tbl_export.php and
2222 * the script it calls do not fail
2223 */
2224 if (empty($_url_params['table'])) {
2225 $_url_params['table'] = PMA_DBI_fetch_value("SHOW TABLES");
2226 }
2227
2228 echo PMA_linkOrButton(
2229 'tbl_export.php' . PMA_generate_common_url($_url_params),
2230 PMA_getIcon('b_tblexport.png', __('Export'), false, true),
2231 '', true, true, '') . "\n";
2232
2233 // show chart
2234 echo PMA_linkOrButton(
2235 'tbl_chart.php' . PMA_generate_common_url($_url_params),
2236 PMA_getIcon('b_chart.png', __('Display chart'), false, true),
2237 '', true, true, '') . "\n";
2238 }
2239
2240 // CREATE VIEW
2241 /**
2242 *
2243 * @todo detect privileges to create a view
2244 * (but see 2006-01-19 note in display_create_table.lib.php,
2245 * I think we cannot detect db-specific privileges reliably)
2246 * Note: we don't display a Create view link if we found a PROCEDURE clause
2247 */
2248 if (!$header_shown) {
2249 echo $header;
2250 $header_shown = TRUE;
2251 }
2252 if (! isset($analyzed_sql[0]['queryflags']['procedure'])) {
2253 echo PMA_linkOrButton(
2254 'view_create.php' . $url_query,
2255 PMA_getIcon('b_views.png', 'CREATE VIEW', false, true),
2256 '', true, true, '') . "\n";
2257 }
2258 if ($header_shown) {
2259 echo '</fieldset><br />';
2260 }
2261 }
2262
2263 /**
2264 * Verifies what to do with non-printable contents (binary or BLOB)
2265 * in Browse mode.
2266 *
2267 * @uses is_null()
2268 * @uses isset()
2269 * @uses strlen()
2270 * @uses PMA_formatByteDown()
2271 * @uses strpos()
2272 * @uses str_replace()
2273 * @param string $category BLOB|BINARY|GEOMETRY
2274 * @param string $content the binary content
2275 * @param string $transform_function
2276 * @param string $transform_options
2277 * @param string $default_function
2278 * @param object $meta the meta-information about this field
2279 * @return mixed string or float
2280 */
2281 function PMA_handle_non_printable_contents($category, $content, $transform_function, $transform_options, $default_function, $meta, $url_params = array()) {
2282 $result = '[' . $category;
2283 if (is_null($content)) {
2284 $result .= ' - NULL';
2285 $size = 0;
2286 } elseif (isset($content)) {
2287 $size = strlen($content);
2288 $display_size = PMA_formatByteDown($size, 3, 1);
2289 $result .= ' - '. $display_size[0] . $display_size[1];
2290 }
2291 $result .= ']';
2292
2293 if (strpos($transform_function, 'octetstream')) {
2294 $result = $content;
2295 }
2296 if ($size > 0) {
2297 if ($default_function != $transform_function) {
2298 $result = $transform_function($result, $transform_options, $meta);
2299 } else {
2300 $result = $default_function($result, array(), $meta);
2301 if (stristr($meta->type, 'BLOB') && $_SESSION['tmp_user_values']['display_blob']) {
2302 // in this case, restart from the original $content
2303 $result = htmlspecialchars(PMA_replace_binary_contents($content));
2304 }
2305 /* Create link to download */
2306 if (count($url_params) > 0) {
2307 $result = '<a href="tbl_get_field.php' . PMA_generate_common_url($url_params) . '">' . $result . '</a>';
2308 }
2309 }
2310 }
2311 return($result);
2312 }
2313
2314 /**
2315 * Prepares the displayable content of a data cell in Browse mode,
2316 * taking into account foreign key description field and transformations
2317 *
2318 * @uses is_array()
2319 * @uses PMA_backquote()
2320 * @uses PMA_DBI_try_query()
2321 * @uses PMA_DBI_num_rows()
2322 * @uses PMA_DBI_fetch_row()
2323 * @uses PMA_DBI_free_result()
2324 * @uses $GLOBALS['printview']
2325 * @uses htmlspecialchars()
2326 * @uses PMA_generate_common_url()
2327 * @param string $class
2328 * @param string $condition_field
2329 * @param string $analyzed_sql
2330 * @param object $meta the meta-information about this field
2331 * @param string $map
2332 * @param string $data
2333 * @param string $transform_function
2334 * @param string $default_function
2335 * @param string $nowrap
2336 * @param string $where_comparison
2337 * @param bool $is_field_truncated
2338 * @return string formatted data
2339 */
2340 function PMA_prepare_row_data($class, $condition_field, $analyzed_sql, $meta, $map, $data, $transform_function, $default_function, $nowrap, $where_comparison, $transform_options, $is_field_truncated ) {
2341
2342 // Define classes to be added to this data field based on the type of data
2343 $enum_class = '';
2344 if(strpos($meta->flags, 'enum') !== false) {
2345 $enum_class = ' enum';
2346 }
2347
2348 $mime_type_class = '';
2349 if(isset($meta->mimetype)) {
2350 $mime_type_class = ' ' . preg_replace('/\//', '_', $meta->mimetype);
2351 }
2352
2353 // continue the <td> tag started before calling this function:
2354 $result = ' class="' . $class . ($condition_field ? ' condition' : '') . $nowrap
2355 . ' ' . ($is_field_truncated ? ' truncated' : '')
2356 . ($transform_function != $default_function ? ' transformed' : '')
2357 . (isset($map[$meta->name]) ? ' relation' : '')
2358 . $enum_class . $mime_type_class . '">';
2359
2360 if (isset($analyzed_sql[0]['select_expr']) && is_array($analyzed_sql[0]['select_expr'])) {
2361 foreach ($analyzed_sql[0]['select_expr'] AS $select_expr_position => $select_expr) {
2362 $alias = $analyzed_sql[0]['select_expr'][$select_expr_position]['alias'];
2363 if (isset($alias) && strlen($alias)) {
2364 $true_column = $analyzed_sql[0]['select_expr'][$select_expr_position]['column'];
2365 if ($alias == $meta->name) {
2366 // this change in the parameter does not matter
2367 // outside of the function
2368 $meta->name = $true_column;
2369 } // end if
2370 } // end if
2371 } // end foreach
2372 } // end if
2373
2374 if (isset($map[$meta->name])) {
2375 // Field to display from the foreign table?
2376 if (isset($map[$meta->name][2]) && strlen($map[$meta->name][2])) {
2377 $dispsql = 'SELECT ' . PMA_backquote($map[$meta->name][2])
2378 . ' FROM ' . PMA_backquote($map[$meta->name][3])
2379 . '.' . PMA_backquote($map[$meta->name][0])
2380 . ' WHERE ' . PMA_backquote($map[$meta->name][1])
2381 . $where_comparison;
2382 $dispresult = PMA_DBI_try_query($dispsql, null, PMA_DBI_QUERY_STORE);
2383 if ($dispresult && PMA_DBI_num_rows($dispresult) > 0) {
2384 list($dispval) = PMA_DBI_fetch_row($dispresult, 0);
2385 } else {
2386 $dispval = __('Link not found');
2387 }
2388 @PMA_DBI_free_result($dispresult);
2389 } else {
2390 $dispval = '';
2391 } // end if... else...
2392
2393 if (isset($GLOBALS['printview']) && $GLOBALS['printview'] == '1') {
2394 $result .= ($transform_function != $default_function ? $transform_function($data, $transform_options, $meta) : $transform_function($data, array(), $meta)) . ' <code>[-&gt;' . $dispval . ']</code>';
2395 } else {
2396
2397 if ('K' == $_SESSION['tmp_user_values']['relational_display']) {
2398 // user chose "relational key" in the display options, so
2399 // the title contains the display field
2400 $title = (! empty($dispval))? ' title="' . htmlspecialchars($dispval) . '"' : '';
2401 } else {
2402 $title = ' title="' . htmlspecialchars($data) . '"';
2403 }
2404
2405 $_url_params = array(
2406 'db' => $map[$meta->name][3],
2407 'table' => $map[$meta->name][0],
2408 'pos' => '0',
2409 'sql_query' => 'SELECT * FROM '
2410 . PMA_backquote($map[$meta->name][3]) . '.' . PMA_backquote($map[$meta->name][0])
2411 . ' WHERE ' . PMA_backquote($map[$meta->name][1])
2412 . $where_comparison,
2413 );
2414 $result .= '<a href="sql.php' . PMA_generate_common_url($_url_params)
2415 . '"' . $title . '>';
2416
2417 if ($transform_function != $default_function) {
2418 // always apply a transformation on the real data,
2419 // not on the display field
2420 $result .= $transform_function($data, $transform_options, $meta);
2421 } else {
2422 if ('D' == $_SESSION['tmp_user_values']['relational_display']) {
2423 // user chose "relational display field" in the
2424 // display options, so show display field in the cell
2425 $result .= $transform_function($dispval, array(), $meta);
2426 } else {
2427 // otherwise display data in the cell
2428 $result .= $transform_function($data, array(), $meta);
2429 }
2430 }
2431 $result .= '</a>';
2432 }
2433 } else {
2434 $result .= ($transform_function != $default_function ? $transform_function($data, $transform_options, $meta) : $transform_function($data, array(), $meta));
2435 }
2436 $result .= '</td>' . "\n";
2437
2438 return $result;
2439 }
2440
2441 /**
2442 * Generates a checkbox for multi-row submits
2443 *
2444 * @uses htmlspecialchars
2445 * @param string $del_url
2446 * @param array $is_display
2447 * @param string $row_no
2448 * @param string $where_clause_html
2449 * @param string $del_query
2450 * @param string $id_suffix
2451 * @param string $class
2452 * @return string the generated HTML
2453 */
2454
2455 function PMA_generateCheckboxForMulti($del_url, $is_display, $row_no, $where_clause_html, $del_query, $id_suffix, $class) {
2456 $ret = '';
2457 if (! empty($del_url) && $is_display['del_lnk'] != 'kp') {
2458 $ret .= '<td ';
2459 if (! empty($class)) {
2460 $ret .= 'class="' . $class . '"';
2461 }
2462 $ret .= ' align="center">'
2463 . '<input type="checkbox" id="id_rows_to_delete' . $row_no . $id_suffix . '" name="rows_to_delete[' . $where_clause_html . ']"'
2464 . ' class="multi_checkbox"'
2465 . ' value="' . htmlspecialchars($del_query) . '" ' . (isset($GLOBALS['checkall']) ? 'checked="checked"' : '') . ' />'
2466 . ' </td>';
2467 }
2468 return $ret;
2469 }
2470
2471 /**
2472 * Generates an Edit link
2473 *
2474 * @uses PMA_linkOrButton()
2475 * @param string $edit_url
2476 * @param string $class
2477 * @param string $edit_str
2478 * @param string $where_clause
2479 * @param string $where_clause_html
2480 * @return string the generated HTML
2481 */
2482 function PMA_generateEditLink($edit_url, $class, $edit_str, $where_clause, $where_clause_html) {
2483 $ret = '';
2484 if (! empty($edit_url)) {
2485 $ret .= '<td class="' . $class . '" align="center" ' . ' >'
2486 . PMA_linkOrButton($edit_url, $edit_str, array(), FALSE);
2487 /*
2488 * Where clause for selecting this row uniquely is provided as
2489 * a hidden input. Used by jQuery scripts for handling inline editing
2490 */
2491 if(! empty($where_clause)) {
2492 $ret .= '<input type="hidden" class="where_clause" value ="' . $where_clause_html . '" />';
2493 }
2494 $ret .= '</td>';
2495 }
2496 return $ret;
2497 }
2498
2499 /**
2500 * Generates a Delete link
2501 *
2502 * @uses PMA_linkOrButton()
2503 * @param string $del_url
2504 * @param string $del_str
2505 * @param string $js_conf
2506 * @param string $class
2507 * @return string the generated HTML
2508 */
2509 function PMA_generateDeleteLink($del_url, $del_str, $js_conf, $class) {
2510 $ret = '';
2511 if (! empty($del_url)) {
2512 $ret .= '<td ';
2513 if (! empty($class)) {
2514 $ret .= 'class="' . $class . '" ';
2515 }
2516 $ret .= 'align="center" ' . ' >'
2517 . PMA_linkOrButton($del_url, $del_str, $js_conf, FALSE)
2518 . '</td>';
2519 }
2520 return $ret;
2521 }
2522
2523 /**
2524 * Generates checkbox and links at some position (left or right)
2525 *
2526 * @uses PMA_generateCheckboxForMulti()
2527 * @uses PMA_generateEditLink()
2528 * @uses PMA_generateDeleteLink()
2529 * @param string $position
2530 * @param string $del_url
2531 * @param array $is_display
2532 * @param string $row_no
2533 * @param string $where_clause
2534 * @param string $where_clause_html
2535 * @param string $del_query
2536 * @param string $id_suffix
2537 * @param string $edit_url
2538 * @param string $class
2539 * @param string $edit_str
2540 * @param string $del_str
2541 * @param string $js_conf
2542 * @return string the generated HTML
2543 */
2544 function PMA_generateCheckboxAndLinks($position, $del_url, $is_display, $row_no, $where_clause, $where_clause_html, $del_query, $id_suffix, $edit_url, $class, $edit_str, $del_str, $js_conf) {
2545 $ret = '';
2546
2547 if ($position == 'left') {
2548 $ret .= PMA_generateCheckboxForMulti($del_url, $is_display, $row_no, $where_clause_html, $del_query, $id_suffix='_left', '', '', '');
2549
2550 $ret .= PMA_generateEditLink($edit_url, $class, $edit_str, $where_clause, $where_clause_html, '');
2551
2552 $ret .= PMA_generateDeleteLink($del_url, $del_str, $js_conf, '', '');
2553
2554 } elseif ($position == 'right') {
2555 $ret .= PMA_generateDeleteLink($del_url, $del_str, $js_conf, '', '');
2556
2557 $ret .= PMA_generateEditLink($edit_url, $class, $edit_str, $where_clause, $where_clause_html, '');
2558
2559 $ret .= PMA_generateCheckboxForMulti($del_url, $is_display, $row_no, $where_clause_html, $del_query, $id_suffix='_right', '', '', '');
2560 }
2561 return $ret;
2562 }
2563 ?>
phpMyAdmin