2 /* vim: set expandtab sw=4 ts=4 sts=4: */
4 * library for displaying table with results from all sort of select queries
12 require_once './libraries/Index.class.php';
15 * Defines the display mode to use for the results of a SQL query
17 * It uses a synthetic string that contains all the required informations.
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
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
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.
31 * @param string &$the_disp_mode the synthetic value for display_mode (see a few
32 * lines above for explanations)
33 * @param integer &$the_total 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)
38 * @return array an array with explicit indexes for all the display
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
51 * @see PMA_displayTable()
53 function PMA_setDisplayMode(&$the_disp_mode, &$the_total)
56 global $unlim_num_rows, $fields_meta;
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];
70 // 2. Display mode is not "false for all elements" -> updates the
72 if ($the_disp_mode != 'nnnn000000') {
73 if (isset($GLOBALS['printview']) && $GLOBALS['printview'] == '1') {
74 // 2.0 Print view -> set all elements to false!
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 } elseif ($GLOBALS['is_count'] ||
$GLOBALS['is_analyse'] ||
$GLOBALS['is_maint'] ||
$GLOBALS['is_explain']) {
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 $do_display['edit_lnk'] = 'nn'; // no edit link
88 $do_display['del_lnk'] = 'nn'; // no delete link
89 $do_display['sort_lnk'] = (string) '0';
90 $do_display['nav_bar'] = (string) '0';
91 $do_display['ins_row'] = (string) '0';
92 $do_display['bkm_form'] = (string) '1';
93 if ($GLOBALS['is_maint']) {
94 $do_display['text_btn'] = (string) '1';
96 $do_display['text_btn'] = (string) '0';
98 $do_display['pview_lnk'] = (string) '1';
99 } elseif ($GLOBALS['is_show']) {
100 // 2.2 Statement is a "SHOW..."
103 * @todo defines edit/delete links depending on show statement
105 $tmp = preg_match('@^SHOW[[:space:]]+(VARIABLES|(FULL[[:space:]]+)?PROCESSLIST|STATUS|TABLE|GRANTS|CREATE|LOGS|DATABASES|FIELDS)@i', $GLOBALS['sql_query'], $which);
106 if (isset($which[1]) && strpos(' ' . strtoupper($which[1]), 'PROCESSLIST') > 0) {
107 $do_display['edit_lnk'] = 'nn'; // no edit link
108 $do_display['del_lnk'] = 'kp'; // "kill process" type edit link
110 // Default case -> no links
111 $do_display['edit_lnk'] = 'nn'; // no edit link
112 $do_display['del_lnk'] = 'nn'; // no delete link
114 // 2.2.2 Other settings
115 $do_display['sort_lnk'] = (string) '0';
116 $do_display['nav_bar'] = (string) '0';
117 $do_display['ins_row'] = (string) '0';
118 $do_display['bkm_form'] = (string) '1';
119 $do_display['text_btn'] = (string) '1';
120 $do_display['pview_lnk'] = (string) '1';
122 // 2.3 Other statements (ie "SELECT" ones) -> updates
123 // $do_display['edit_lnk'], $do_display['del_lnk'] and
124 // $do_display['text_btn'] (keeps other default values)
125 $prev_table = $fields_meta[0]->table
;
126 $do_display['text_btn'] = (string) '1';
127 for ($i = 0; $i < $GLOBALS['fields_cnt']; $i++
) {
128 $is_link = ($do_display['edit_lnk'] != 'nn'
129 ||
$do_display['del_lnk'] != 'nn'
130 ||
$do_display['sort_lnk'] != '0'
131 ||
$do_display['ins_row'] != '0');
132 // 2.3.2 Displays edit/delete/sort/insert links?
134 && ($fields_meta[$i]->table
== '' ||
$fields_meta[$i]->table
!= $prev_table)) {
135 $do_display['edit_lnk'] = 'nn'; // don't display links
136 $do_display['del_lnk'] = 'nn';
138 * @todo May be problematic with same fields names in two joined table.
140 // $do_display['sort_lnk'] = (string) '0';
141 $do_display['ins_row'] = (string) '0';
142 if ($do_display['text_btn'] == '1') {
146 // 2.3.3 Always display print view link
147 $do_display['pview_lnk'] = (string) '1';
148 $prev_table = $fields_meta[$i]->table
;
150 } // end if..elseif...else (2.1 -> 2.3)
153 // 3. Gets the total number of rows if it is unknown
154 if (isset($unlim_num_rows) && $unlim_num_rows != '') {
155 $the_total = $unlim_num_rows;
156 } elseif (($do_display['nav_bar'] == '1' ||
$do_display['sort_lnk'] == '1')
157 && (strlen($db) && !empty($table))) {
158 $the_total = PMA_Table
::countRecords($db, $table);
161 // 4. If navigation bar or sorting fields names URLs should be
162 // displayed but there is only one row, change these settings to
164 if ($do_display['nav_bar'] == '1' ||
$do_display['sort_lnk'] == '1') {
166 // - Do not display sort links if less than 2 rows.
167 // - For a VIEW we (probably) did not count the number of rows
168 // so don't test this number here, it would remove the possibility
169 // of sorting VIEW results.
170 if (isset($unlim_num_rows) && $unlim_num_rows < 2 && ! PMA_Table
::isView($db, $table)) {
171 // force display of navbar for vertical/horizontal display-choice.
172 // $do_display['nav_bar'] = (string) '0';
173 $do_display['sort_lnk'] = (string) '0';
177 // 5. Updates the synthetic var
178 $the_disp_mode = join('', $do_display);
181 } // end of the 'PMA_setDisplayMode()' function
185 * Return true if we are executing a query in the form of
186 * "SELECT * FROM <a table> ..."
190 function PMA_isSelect()
192 // global variables set from sql.php
193 global $is_count, $is_export, $is_func, $is_analyse;
194 global $analyzed_sql;
196 return ! ($is_count ||
$is_export ||
$is_func ||
$is_analyse)
197 && count($analyzed_sql[0]['select_expr']) == 0
198 && isset($analyzed_sql[0]['queryflags']['select_from'])
199 && count($analyzed_sql[0]['table_ref']) == 1;
204 * Displays a navigation button
207 * @param string $caption iconic caption for button
208 * @param string $title text for button
209 * @param integer $pos position for next query
210 * @param string $html_sql_query query ready for display
211 * @param string $onsubmit optional onsubmit clause
212 * @param string $input_for_real_end optional hidden field for special treatment
213 * @param string $onclick optional onclick clause
215 * @global string $db the database name
216 * @global string $table the table name
217 * @global string $goto the URL to go back in case of errors
221 * @see PMA_displayTableNavigation()
223 function PMA_displayTableNavigationOneButton($caption, $title, $pos, $html_sql_query, $onsubmit = '', $input_for_real_end = '', $onclick = '') {
225 global $db, $table, $goto;
227 $caption_output = '';
228 // for true or 'both'
229 if ($GLOBALS['cfg']['NavigationBarIconic']) {
230 $caption_output .= $caption;
232 // for false or 'both'
233 if (false === $GLOBALS['cfg']['NavigationBarIconic'] ||
'both' === $GLOBALS['cfg']['NavigationBarIconic']) {
234 $caption_output .= ' ' . $title;
236 $title_output = ' title="' . $title . '"';
239 <form action
="sql.php" method
="post" <?php
echo $onsubmit; ?
>>
240 <?php
echo PMA_generate_common_hidden_inputs($db, $table); ?
>
241 <input type
="hidden" name
="sql_query" value
="<?php echo $html_sql_query; ?>" />
242 <input type
="hidden" name
="pos" value
="<?php echo $pos; ?>" />
243 <input type
="hidden" name
="goto" value
="<?php echo $goto; ?>" />
244 <?php
echo $input_for_real_end; ?
>
245 <input type
="submit" name
="navig" <?php
echo ($GLOBALS['cfg']['AjaxEnable'] ?
' class="ajax" ' : '' ); ?
> value
="<?php echo $caption_output; ?>"<?php
echo $title_output . $onclick; ?
> />
249 } // end function PMA_displayTableNavigationOneButton()
252 * Displays a navigation bar to browse among the results of a SQL query
254 * @param integer $pos_next the offset for the "next" page
255 * @param integer $pos_prev the offset for the "previous" page
256 * @param string $sql_query the URL-encoded query
257 * @param string $id_for_direction_dropdown the id for the direction dropdown
259 * @global string $db the database name
260 * @global string $table the table name
261 * @global string $goto the URL to go back in case of errors
262 * @global integer $num_rows the total number of rows returned by the
264 * @global integer $unlim_num_rows the total number of rows returned by the
265 * SQL any programmatically appended "LIMIT" clause
266 * @global boolean $is_innodb whether its InnoDB or not
267 * @global array $showtable table definitions
271 * @see PMA_displayTable()
273 function PMA_displayTableNavigation($pos_next, $pos_prev, $sql_query, $id_for_direction_dropdown)
275 global $db, $table, $goto;
276 global $num_rows, $unlim_num_rows;
280 // here, using htmlentities() would cause problems if the query
281 // contains accented characters
282 $html_sql_query = htmlspecialchars($sql_query);
285 * @todo move this to a central place
286 * @todo for other future table types
288 $is_innodb = (isset($showtable['Type']) && $showtable['Type'] == 'InnoDB');
292 <!-- Navigation bar
-->
293 <table border
="0" cellpadding
="0" cellspacing
="0" class="navigation">
295 <td
class="navigation_separator"></td
>
297 // Move to the beginning or to the previous page
298 if ($_SESSION['tmp_user_values']['pos'] && $_SESSION['tmp_user_values']['max_rows'] != 'all') {
299 PMA_displayTableNavigationOneButton('<<', __('Begin'), 0, $html_sql_query);
300 PMA_displayTableNavigationOneButton('<', __('Previous'), $pos_prev, $html_sql_query);
305 // (unless we are showing all records)
306 if ('all' != $_SESSION['tmp_user_values']['max_rows']) { //if1
307 $pageNow = @floor
($_SESSION['tmp_user_values']['pos'] / $_SESSION['tmp_user_values']['max_rows']) +
1;
308 $nbTotalPage = @ceil
($unlim_num_rows / $_SESSION['tmp_user_values']['max_rows']);
310 if ($nbTotalPage > 1) { //if2
314 $_url_params = array(
317 'sql_query' => $sql_query,
320 //<form> to keep the form alignment of button < and <<
321 // and also to know what to execute when the selector changes
322 echo '<form action="sql.php' . PMA_generate_common_url($_url_params). '" method="post">';
323 echo PMA_pageselector(
324 $_SESSION['tmp_user_values']['max_rows'],
340 // Display the "Show all" button if allowed
341 if ($GLOBALS['cfg']['ShowAll'] && ($num_rows < $unlim_num_rows)) {
345 <form action
="sql.php" method
="post">
346 <?php
echo PMA_generate_common_hidden_inputs($db, $table); ?
>
347 <input type
="hidden" name
="sql_query" value
="<?php echo $html_sql_query; ?>" />
348 <input type
="hidden" name
="pos" value
="0" />
349 <input type
="hidden" name
="session_max_rows" value
="all" />
350 <input type
="hidden" name
="goto" value
="<?php echo $goto; ?>" />
351 <input type
="submit" name
="navig" value
="<?php echo __('Show all'); ?>" />
357 // Move to the next page or to the last one
358 if (($_SESSION['tmp_user_values']['pos'] +
$_SESSION['tmp_user_values']['max_rows'] < $unlim_num_rows) && $num_rows >= $_SESSION['tmp_user_values']['max_rows']
359 && $_SESSION['tmp_user_values']['max_rows'] != 'all') {
361 // display the Next button
362 PMA_displayTableNavigationOneButton('>',
367 // prepare some options for the End button
368 if ($is_innodb && $unlim_num_rows > $GLOBALS['cfg']['MaxExactCount']) {
369 $input_for_real_end = '<input id="real_end_input" type="hidden" name="find_real_end" value="1" />';
370 // no backquote around this message
373 $input_for_real_end = $onclick = '';
376 // display the End button
377 PMA_displayTableNavigationOneButton('>>',
379 @((ceil($unlim_num_rows / $_SESSION['tmp_user_values']['max_rows'])- 1) * $_SESSION['tmp_user_values']['max_rows']),
381 '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') . '"',
387 // show separator if pagination happen
388 if ($nbTotalPage > 1) {
389 echo '<td><div class="navigation_separator">|</div></td>';
393 <div
class="restore_column hide">
394 <input type
="submit" value
="<?php echo __('Restore column order'); ?>" />
395 <div
class="navigation_separator">|
</div
>
398 if (PMA_isSelect()) {
399 // generate the column order, if it is set
400 $pmatable = new PMA_Table($GLOBALS['table'], $GLOBALS['db']);
401 $col_order = $pmatable->getUiProp(PMA_Table
::PROP_COLUMN_ORDER
);
403 echo '<input id="col_order" type="hidden" value="' . implode(',', $col_order) . '" />';
405 $col_visib = $pmatable->getUiProp(PMA_Table
::PROP_COLUMN_VISIB
);
407 echo '<input id="col_visib" type="hidden" value="' . implode(',', $col_visib) . '" />';
409 // generate table create time
410 echo '<input id="table_create_time" type="hidden" value="' .
411 PMA_Table
::sGetStatusInfo($GLOBALS['db'], $GLOBALS['table'], 'Create_time') . '" />';
414 echo '<input id="col_order_hint" type="hidden" value="' . __('Drag to reorder') . '" />';
415 echo '<input id="sort_hint" type="hidden" value="' . __('Click to sort') . '" />';
416 echo '<input id="col_mark_hint" type="hidden" value="' . __('Click to mark/unmark') . '" />';
417 echo '<input id="col_visib_hint" type="hidden" value="' . __('Click the drop-down arrow<br />to toggle column\'s visibility') . '" />';
418 echo '<input id="show_all_col_text" type="hidden" value="' . __('Show all') . '" />';
422 <?php
// if displaying a VIEW, $unlim_num_rows could be zero because
423 // of $cfg['MaxExactCountViews']; in this case, avoid passing
424 // the 5th parameter to checkFormElementInRange()
425 // (this means we can't validate the upper limit ?>
426 <td
class="navigation_goto">
427 <form action
="sql.php" method
="post"
428 onsubmit
="return (checkFormElementInRange(this, 'session_max_rows', '<?php echo str_replace('\'', '\\\'', __('%d is not valid row number.')); ?>', 1) && checkFormElementInRange(this, 'pos', '<?php echo str_replace('\'', '\\\'', __('%d is not valid row number.')); ?>', 0<?php echo $unlim_num_rows > 0 ? ',' . $unlim_num_rows - 1 : ''; ?>))">
429 <?php
echo PMA_generate_common_hidden_inputs($db, $table); ?
>
430 <input type
="hidden" name
="sql_query" value
="<?php echo $html_sql_query; ?>" />
431 <input type
="hidden" name
="goto" value
="<?php echo $goto; ?>" />
432 <input type
="submit" name
="navig" <?php
echo ($GLOBALS['cfg']['AjaxEnable'] ?
' class="ajax"' : ''); ?
> value
="<?php echo __('Show'); ?> :" />
433 <?php
echo __('Start row') . ': ' . "\n"; ?
>
434 <input type
="text" name
="pos" size
="3" value
="<?php echo (($pos_next >= $unlim_num_rows) ? 0 : $pos_next); ?>" class="textfield" onfocus
="this.select()" />
435 <?php
echo __('Number of rows') . ': ' . "\n"; ?
>
436 <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()" />
438 if ($GLOBALS['cfg']['ShowDisplayDirection']) {
439 // Display mode (horizontal/vertical and repeat headers)
440 echo __('Mode') . ': ' . "\n";
442 'horizontal' => __('horizontal'),
443 'horizontalflipped' => __('horizontal (rotated headers)'),
444 'vertical' => __('vertical'));
445 echo PMA_generate_html_dropdown('disp_direction', $choices, $_SESSION['tmp_user_values']['disp_direction'], $id_for_direction_dropdown);
449 printf(__('Headers every %s rows'),
450 '<input type="text" size="3" name="repeat_cells" value="' . $_SESSION['tmp_user_values']['repeat_cells'] . '" class="textfield" />');
455 <td
class="navigation_separator"></td
>
460 } // end of the 'PMA_displayTableNavigation()' function
464 * Displays the headers of the results table
466 * @param array which elements to display
467 * @param array the list of fields properties
468 * @param integer the total number of fields returned by the SQL query
469 * @param array the analyzed query
471 * @return boolean $clause_is_unique
473 * @global string $db the database name
474 * @global string $table the table name
475 * @global string $goto the URL to go back in case of errors
476 * @global string $sql_query the SQL query
477 * @global integer $num_rows the total number of rows returned by the
479 * @global array $vertical_display informations used with vertical display
484 * @see PMA_displayTable()
486 function PMA_displayTableHeaders(&$is_display, &$fields_meta, $fields_cnt = 0, $analyzed_sql = '', $sort_expression, $sort_expression_nodirection, $sort_direction)
488 global $db, $table, $goto;
489 global $sql_query, $num_rows;
490 global $vertical_display, $highlight_columns;
492 // required to generate sort links that will remember whether the
493 // "Show all" button has been clicked
494 $sql_md5 = md5($GLOBALS['sql_query']);
495 $session_max_rows = $_SESSION['tmp_user_values']['query'][$sql_md5]['max_rows'];
497 if ($analyzed_sql == '') {
498 $analyzed_sql = array();
501 // can the result be sorted?
502 if ($is_display['sort_lnk'] == '1') {
505 $unsorted_sql_query = $sql_query;
506 if (isset($analyzed_sql[0]['unsorted_query'])) {
507 $unsorted_sql_query = $analyzed_sql[0]['unsorted_query'];
509 // Handles the case of multiple clicks on a column's header
510 // which would add many spaces before "ORDER BY" in the
512 $unsorted_sql_query = trim($unsorted_sql_query);
514 // sorting by indexes, only if it makes sense (only one table ref)
515 if (isset($analyzed_sql) && isset($analyzed_sql[0]) &&
516 isset($analyzed_sql[0]['querytype']) && $analyzed_sql[0]['querytype'] == 'SELECT' &&
517 isset($analyzed_sql[0]['table_ref']) && count($analyzed_sql[0]['table_ref']) == 1) {
519 // grab indexes data:
520 $indexes = PMA_Index
::getFromTable($table, $db);
522 // do we have any index?
525 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
526 ||
$_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
528 if ($is_display['edit_lnk'] != 'nn') {
531 if ($is_display['del_lnk'] != 'nn') {
534 if ($is_display['del_lnk'] != 'kp' && $is_display['del_lnk'] != 'nn') {
538 $span = $num_rows +
floor($num_rows/$_SESSION['tmp_user_values']['repeat_cells']) +
1;
541 echo '<form action="sql.php" method="post">' . "\n";
542 echo PMA_generate_common_hidden_inputs($db, $table);
543 echo __('Sort by key') . ': <select name="sql_query" onchange="this.form.submit();">' . "\n";
545 $local_order = (isset($sort_expression) ?
$sort_expression : '');
546 foreach ($indexes as $index) {
547 $asc_sort = '`' . implode('` ASC, `', array_keys($index->getColumns())) . '` ASC';
548 $desc_sort = '`' . implode('` DESC, `', array_keys($index->getColumns())) . '` DESC';
549 $used_index = $used_index ||
$local_order == $asc_sort ||
$local_order == $desc_sort;
550 echo '<option value="'
551 . htmlspecialchars($unsorted_sql_query . ' ORDER BY ' . $asc_sort)
552 . '"' . ($local_order == $asc_sort ?
' selected="selected"' : '')
553 . '>' . htmlspecialchars($index->getName()) . ' ('
554 . __('Ascending') . ')</option>';
555 echo '<option value="'
556 . htmlspecialchars($unsorted_sql_query . ' ORDER BY ' . $desc_sort)
557 . '"' . ($local_order == $desc_sort ?
' selected="selected"' : '')
558 . '>' . htmlspecialchars($index->getName()) . ' ('
559 . __('Descending') . ')</option>';
561 echo '<option value="' . htmlspecialchars($unsorted_sql_query) . '"' . ($used_index ?
'' : ' selected="selected"') . '>' . __('None') . '</option>';
562 echo '</select>' . "\n";
563 echo '<noscript><input type="submit" value="' . __('Go') . '" /></noscript>';
564 echo '</form>' . "\n";
570 $vertical_display['emptypre'] = 0;
571 $vertical_display['emptyafter'] = 0;
572 $vertical_display['textbtn'] = '';
574 // Display options (if we are not in print view)
575 if (! (isset($GLOBALS['printview']) && $GLOBALS['printview'] == '1')) {
576 echo '<form method="post" action="sql.php" name="displayOptionsForm" id="displayOptionsForm"';
577 if ($GLOBALS['cfg']['AjaxEnable']) {
578 echo ' class="ajax" ';
584 'sql_query' => $sql_query,
586 'display_options_form' => 1
588 echo PMA_generate_common_hidden_inputs($url_params);
590 PMA_generate_slider_effect('displayoptions',__('Options'));
593 echo '<div class="formelement">';
595 'P' => __('Partial texts'),
596 'F' => __('Full texts')
598 PMA_display_html_radio('display_text', $choices, $_SESSION['tmp_user_values']['display_text']);
601 // prepare full/partial text button or link
602 if ($_SESSION['tmp_user_values']['display_text']=='F') {
603 // currently in fulltext mode so show the opposite link
604 $tmp_image_file = $GLOBALS['pmaThemeImage'] . 's_partialtext.png';
605 $tmp_txt = __('Partial texts');
606 $url_params['display_text'] = 'P';
608 $tmp_image_file = $GLOBALS['pmaThemeImage'] . 's_fulltext.png';
609 $tmp_txt = __('Full texts');
610 $url_params['display_text'] = 'F';
613 $tmp_image = '<img class="fulltext" src="' . $tmp_image_file . '" alt="' . $tmp_txt . '" title="' . $tmp_txt . '" />';
614 $tmp_url = 'sql.php' . PMA_generate_common_url($url_params);
615 $full_or_partial_text_link = PMA_linkOrButton($tmp_url, $tmp_image, array(), false);
616 unset($tmp_image_file, $tmp_txt, $tmp_url, $tmp_image);
619 if ($GLOBALS['cfgRelation']['relwork'] && $GLOBALS['cfgRelation']['displaywork']) {
620 echo '<div class="formelement">';
622 'K' => __('Relational key'),
623 'D' => __('Relational display column')
625 PMA_display_html_radio('relational_display', $choices, $_SESSION['tmp_user_values']['relational_display']);
629 echo '<div class="formelement">';
630 PMA_display_html_checkbox('display_binary', __('Show binary contents'), ! empty($_SESSION['tmp_user_values']['display_binary']), false);
632 PMA_display_html_checkbox('display_blob', __('Show BLOB contents'), ! empty($_SESSION['tmp_user_values']['display_blob']), false);
634 PMA_display_html_checkbox('display_binary_as_hex', __('Show binary contents as HEX'), ! empty($_SESSION['tmp_user_values']['display_binary_as_hex']), false);
637 // I would have preferred to name this "display_transformation".
638 // This is the only way I found to be able to keep this setting sticky
639 // per SQL query, and at the same time have a default that displays
640 // the transformations.
641 echo '<div class="formelement">';
642 PMA_display_html_checkbox('hide_transformation', __('Hide') . ' ' . __('Browser transformation'), ! empty($_SESSION['tmp_user_values']['hide_transformation']), false);
645 echo '<div class="formelement">';
647 'GEOM' => __('Geometry'),
648 'WKT' => __('Well Known Text'),
649 'WKB' => __('Well Known Binary')
651 PMA_display_html_radio('geometry_display', $choices, $_SESSION['tmp_user_values']['geometry_display']);
654 echo '<div class="clearfloat"></div>';
657 echo '<fieldset class="tblFooters">';
658 echo '<input type="submit" value="' . __('Go') . '" />';
664 // Start of form for multi-rows edit/delete/export
666 if ($is_display['del_lnk'] == 'dr' ||
$is_display['del_lnk'] == 'kp') {
667 echo '<form method="post" action="tbl_row_action.php" name="resultsForm" id="resultsForm"';
668 if ($GLOBALS['cfg']['AjaxEnable']) {
669 echo ' class="ajax" ';
672 echo PMA_generate_common_hidden_inputs($db, $table, 1);
673 echo '<input type="hidden" name="goto" value="sql.php" />' . "\n";
676 echo '<table id="table_results" class="data';
677 if ($GLOBALS['cfg']['AjaxEnable']) {
681 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
682 ||
$_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
683 echo '<thead><tr>' . "\n";
686 // 1. Displays the full/partial text button (part 1)...
687 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
688 ||
$_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
689 $colspan = ($is_display['edit_lnk'] != 'nn' && $is_display['del_lnk'] != 'nn')
693 $rowspan = ($is_display['edit_lnk'] != 'nn' && $is_display['del_lnk'] != 'nn')
698 // ... before the result table
699 if (($is_display['edit_lnk'] == 'nn' && $is_display['del_lnk'] == 'nn')
700 && $is_display['text_btn'] == '1') {
701 $vertical_display['emptypre'] = ($is_display['edit_lnk'] != 'nn' && $is_display['del_lnk'] != 'nn') ?
4 : 0;
702 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
703 ||
$_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
705 <th colspan
="<?php echo $fields_cnt; ?>"></th
>
709 } // end horizontal/horizontalflipped mode
713 <th colspan
="<?php echo $num_rows + floor($num_rows/$_SESSION['tmp_user_values']['repeat_cells']) + 1; ?>"></th
>
716 } // end vertical mode
719 // ... at the left column of the result table header if possible
721 elseif (($GLOBALS['cfg']['RowActionLinks'] == 'left' ||
$GLOBALS['cfg']['RowActionLinks'] == 'both')
722 && $is_display['text_btn'] == '1') {
723 $vertical_display['emptypre'] = ($is_display['edit_lnk'] != 'nn' && $is_display['del_lnk'] != 'nn') ?
4 : 0;
724 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
725 ||
$_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
727 <th
<?php
echo $colspan; ?
>><?php
echo $full_or_partial_text_link;?
></th
>
729 } // end horizontal/horizontalflipped mode
731 $vertical_display['textbtn'] = ' <th ' . $rowspan . ' valign="middle">' . "\n"
734 } // end vertical mode
737 // ... elseif no button, displays empty(ies) col(s) if required
738 elseif (($GLOBALS['cfg']['RowActionLinks'] == 'left' ||
$GLOBALS['cfg']['RowActionLinks'] == 'both')
739 && ($is_display['edit_lnk'] != 'nn' ||
$is_display['del_lnk'] != 'nn')) {
740 $vertical_display['emptypre'] = ($is_display['edit_lnk'] != 'nn' && $is_display['del_lnk'] != 'nn') ?
4 : 0;
741 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
742 ||
$_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
744 <td
<?php
echo $colspan; ?
>></td
>
746 } // end horizontal/horizontalfipped mode
748 $vertical_display['textbtn'] = ' <td' . $rowspan . '></td>' . "\n";
749 } // end vertical mode
752 // ... elseif display an empty column if the actions links are disabled to match the rest of the table
753 elseif ($GLOBALS['cfg']['RowActionLinks'] == 'none' && ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
754 ||
$_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped')) {
758 // 2. Displays the fields' name
759 // 2.0 If sorting links should be used, checks if the query is a "JOIN"
760 // statement (see 2.1.3)
762 // 2.0.1 Prepare Display column comments if enabled ($GLOBALS['cfg']['ShowBrowseComments']).
763 // Do not show comments, if using horizontalflipped mode, because of space usage
764 if ($GLOBALS['cfg']['ShowBrowseComments']
765 && $_SESSION['tmp_user_values']['disp_direction'] != 'horizontalflipped') {
766 $comments_map = array();
767 if (isset($analyzed_sql[0]) && is_array($analyzed_sql[0])) {
768 foreach ($analyzed_sql[0]['table_ref'] as $tbl) {
769 $tb = $tbl['table_true_name'];
770 $comments_map[$tb] = PMA_getComments($db, $tb);
776 if ($GLOBALS['cfgRelation']['commwork'] && $GLOBALS['cfgRelation']['mimework'] && $GLOBALS['cfg']['BrowseMIME'] && ! $_SESSION['tmp_user_values']['hide_transformation']) {
777 require_once './libraries/transformations.lib.php';
778 $GLOBALS['mime_map'] = PMA_getMIME($db, $table);
781 // See if we have to highlight any header fields of a WHERE query.
782 // Uses SQL-Parser results.
783 $highlight_columns = array();
784 if (isset($analyzed_sql) && isset($analyzed_sql[0]) &&
785 isset($analyzed_sql[0]['where_clause_identifiers'])) {
788 if (isset($analyzed_sql[0]['where_clause_identifiers']) && is_array($analyzed_sql[0]['where_clause_identifiers'])) {
789 foreach ($analyzed_sql[0]['where_clause_identifiers'] AS $wci_nr => $wci) {
790 $highlight_columns[$wci] = 'true';
795 if (PMA_isSelect()) {
796 // prepare to get the column order, if available
797 $pmatable = new PMA_Table($GLOBALS['table'], $GLOBALS['db']);
798 $col_order = $pmatable->getUiProp(PMA_Table
::PROP_COLUMN_ORDER
);
799 $col_visib = $pmatable->getUiProp(PMA_Table
::PROP_COLUMN_VISIB
);
805 for ($j = 0; $j < $fields_cnt; $j++
) {
806 // assign $i with appropriate column order
807 $i = $col_order ?
$col_order[$j] : $j;
808 // See if this column should get highlight because it's used in the
810 if (isset($highlight_columns[$fields_meta[$i]->name
]) ||
isset($highlight_columns[PMA_backquote($fields_meta[$i]->name
)])) {
811 $condition_field = true;
813 $condition_field = false;
816 // 2.0 Prepare comment-HTML-wrappers for each row, if defined/enabled.
817 if (isset($comments_map) &&
818 isset($comments_map[$fields_meta[$i]->table
]) &&
819 isset($comments_map[$fields_meta[$i]->table
][$fields_meta[$i]->name
])) {
820 $comments = '<span class="tblcomment">' . htmlspecialchars($comments_map[$fields_meta[$i]->table
][$fields_meta[$i]->name
]) . '</span>';
825 // 2.1 Results can be sorted
826 if ($is_display['sort_lnk'] == '1') {
828 // 2.1.1 Checks if the table name is required; it's the case
829 // for a query with a "JOIN" statement and if the column
830 // isn't aliased, or in queries like
831 // SELECT `1`.`master_field` , `2`.`master_field`
832 // FROM `PMA_relation` AS `1` , `PMA_relation` AS `2`
834 if (isset($fields_meta[$i]->table
) && strlen($fields_meta[$i]->table
)) {
835 $sort_tbl = PMA_backquote($fields_meta[$i]->table
) . '.';
840 // 2.1.2 Checks if the current column is used to sort the
842 // the orgname member does not exist for all MySQL versions
843 // but if found, it's the one on which to sort
844 $name_to_use_in_sort = $fields_meta[$i]->name
;
845 if (isset($fields_meta[$i]->orgname
) && strlen($fields_meta[$i]->orgname
)) {
846 $name_to_use_in_sort = $fields_meta[$i]->orgname
;
848 // $name_to_use_in_sort might contain a space due to
849 // formatting of function expressions like "COUNT(name )"
850 // so we remove the space in this situation
851 $name_to_use_in_sort = str_replace(' )', ')', $name_to_use_in_sort);
853 if (empty($sort_expression)) {
856 // Field name may be preceded by a space, or any number
857 // of characters followed by a dot (tablename.fieldname)
858 // so do a direct comparison for the sort expression;
859 // this avoids problems with queries like
860 // "SELECT id, count(id)..." and clicking to sort
861 // on id or on count(id).
862 // Another query to test this:
863 // SELECT p.*, FROM_UNIXTIME(p.temps) FROM mytable AS p
864 // (and try clicking on each column's header twice)
865 if (! empty($sort_tbl) && strpos($sort_expression_nodirection, $sort_tbl) === false && strpos($sort_expression_nodirection, '(') === false) {
866 $sort_expression_nodirection = $sort_tbl . $sort_expression_nodirection;
868 $is_in_sort = (str_replace('`', '', $sort_tbl) . $name_to_use_in_sort == str_replace('`', '', $sort_expression_nodirection) ?
true : false);
870 // 2.1.3 Check the field name for a bracket.
871 // If it contains one, it's probably a function column
872 // like 'COUNT(`field`)'
873 if (strpos($name_to_use_in_sort, '(') !== false) {
874 $sort_order = ' ORDER BY ' . $name_to_use_in_sort . ' ';
876 $sort_order = ' ORDER BY ' . $sort_tbl . PMA_backquote($name_to_use_in_sort) . ' ';
878 unset($name_to_use_in_sort);
880 // 2.1.4 Do define the sorting URL
882 // patch #455484 ("Smart" order)
883 $GLOBALS['cfg']['Order'] = strtoupper($GLOBALS['cfg']['Order']);
884 if ($GLOBALS['cfg']['Order'] === 'SMART') {
885 $sort_order .= (preg_match('@time|date@i', $fields_meta[$i]->type
)) ?
'DESC' : 'ASC';
887 $sort_order .= $GLOBALS['cfg']['Order'];
890 } elseif ('DESC' == $sort_direction) {
891 $sort_order .= ' ASC';
892 $order_img = ' <img class="icon ic_s_desc" src="themes/dot.gif" alt="'. __('Descending') . '" title="'. __('Descending') . '" id="soimg' . $i . '" />';
894 $sort_order .= ' DESC';
895 $order_img = ' <img class="icon ic_s_asc" src="themes/dot.gif" alt="'. __('Ascending') . '" title="'. __('Ascending') . '" id="soimg' . $i . '" />';
898 if (preg_match('@(.*)([[:space:]](LIMIT (.*)|PROCEDURE (.*)|FOR UPDATE|LOCK IN SHARE MODE))@is', $unsorted_sql_query, $regs3)) {
899 $sorted_sql_query = $regs3[1] . $sort_order . $regs3[2];
901 $sorted_sql_query = $unsorted_sql_query . $sort_order;
903 $_url_params = array(
906 'sql_query' => $sorted_sql_query,
907 'session_max_rows' => $session_max_rows
909 $order_url = 'sql.php' . PMA_generate_common_url($_url_params);
911 // 2.1.5 Displays the sorting URL
912 // enable sort order swapping for image
913 $order_link_params = array();
914 if (isset($order_img) && $order_img!='') {
915 if (strstr($order_img, 'asc')) {
916 $order_link_params['onmouseover'] = 'if ($(\'#soimg' . $i . '\').length > 0) { $(\'#soimg' . $i . '\').attr(\'class\', \'icon ic_s_desc\'); }';
917 $order_link_params['onmouseout'] = 'if ($(\'#soimg' . $i . '\').length > 0) { $(\'#soimg' . $i . '\').attr(\'class\', \'icon ic_s_asc\'); }';
918 } elseif (strstr($order_img, 'desc')) {
919 $order_link_params['onmouseover'] = 'if ($(\'#soimg' . $i . '\').length > 0) { $(\'#soimg' . $i . '\').attr(\'class\', \'icon ic_s_asc\'); }';
920 $order_link_params['onmouseout'] = 'if ($(\'#soimg' . $i . '\').length > 0) { $(\'#soimg' . $i . '\').attr(\'class\', \'icon ic_s_desc\'); }';
923 if ($GLOBALS['cfg']['HeaderFlipType'] == 'auto') {
924 if (PMA_USR_BROWSER_AGENT
== 'IE') {
925 $GLOBALS['cfg']['HeaderFlipType'] = 'css';
927 $GLOBALS['cfg']['HeaderFlipType'] = 'fake';
930 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped'
931 && $GLOBALS['cfg']['HeaderFlipType'] == 'css') {
932 $order_link_params['style'] = 'direction: ltr; writing-mode: tb-rl;';
934 $order_link_params['title'] = __('Sort');
935 $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
));
936 $order_link = PMA_linkOrButton($order_url, $order_link_content . $order_img, $order_link_params, false, true);
938 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
939 ||
$_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
942 $th_class[] = 'draggable';
943 if ($col_visib && !$col_visib[$j]) {
944 $th_class[] = 'hide';
946 if ($condition_field) {
947 $th_class[] = 'condition';
949 $th_class[] = 'column_heading';
950 if ($GLOBALS['cfg']['BrowsePointerEnable'] == true) {
951 $th_class[] = 'pointer';
953 if ($GLOBALS['cfg']['BrowseMarkerEnable'] == true) {
954 $th_class[] = 'marker';
956 echo ' class="' . implode(' ', $th_class) . '"';
958 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
959 echo ' valign="bottom"';
961 echo '>' . $order_link . $comments . '</th>';
963 $vertical_display['desc'][] = ' <th '
965 . ($condition_field ?
' condition' : '')
967 . $order_link . $comments . ' </th>' . "\n";
970 // 2.2 Results can't be sorted
972 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
973 ||
$_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
976 $th_class[] = 'draggable';
977 if ($col_visib && !$col_visib[$j]) {
978 $th_class[] = 'hide';
980 if ($condition_field) {
981 $th_class[] = 'condition';
983 echo ' class="' . implode(' ', $th_class) . '"';
984 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
985 echo ' valign="bottom"';
987 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped'
988 && $GLOBALS['cfg']['HeaderFlipType'] == 'css') {
989 echo ' style="direction: ltr; writing-mode: tb-rl;"';
992 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped'
993 && $GLOBALS['cfg']['HeaderFlipType'] == 'fake') {
994 echo PMA_flipstring(htmlspecialchars($fields_meta[$i]->name
), '<br />');
996 echo htmlspecialchars($fields_meta[$i]->name
);
998 echo "\n" . $comments . '</th>';
1000 $vertical_display['desc'][] = ' <th '
1001 . 'class="draggable'
1002 . ($condition_field ?
' condition"' : '')
1004 . ' ' . htmlspecialchars($fields_meta[$i]->name
) . "\n"
1005 . $comments . ' </th>';
1009 // 3. Displays the needed checkboxes at the right
1010 // column of the result table header if possible and required...
1011 if (($GLOBALS['cfg']['RowActionLinks'] == 'right' ||
$GLOBALS['cfg']['RowActionLinks'] == 'both')
1012 && ($is_display['edit_lnk'] != 'nn' ||
$is_display['del_lnk'] != 'nn')
1013 && $is_display['text_btn'] == '1') {
1014 $vertical_display['emptyafter'] = ($is_display['edit_lnk'] != 'nn' && $is_display['del_lnk'] != 'nn') ?
4 : 1;
1015 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
1016 ||
$_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
1019 <th
<?php
echo $colspan; ?
>><?php
echo $full_or_partial_text_link;?
>
1022 } // end horizontal/horizontalflipped mode
1024 $vertical_display['textbtn'] = ' <th ' . $rowspan . ' valign="middle">' . "\n"
1027 } // end vertical mode
1030 // ... elseif no button, displays empty columns if required
1031 // (unless coming from Browse mode print view)
1032 elseif (($GLOBALS['cfg']['RowActionLinks'] == 'left' ||
$GLOBALS['cfg']['RowActionLinks'] == 'both')
1033 && ($is_display['edit_lnk'] == 'nn' && $is_display['del_lnk'] == 'nn')
1034 && (!$GLOBALS['is_header_sent'])) {
1035 $vertical_display['emptyafter'] = ($is_display['edit_lnk'] != 'nn' && $is_display['del_lnk'] != 'nn') ?
4 : 1;
1036 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
1037 ||
$_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
1040 <td
<?php
echo $colspan; ?
>></td
>
1042 } // end horizontal/horizontalflipped mode
1044 $vertical_display['textbtn'] = ' <td' . $rowspan . '></td>' . "\n";
1045 } // end vertical mode
1048 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
1049 ||
$_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
1057 } // end of the 'PMA_displayTableHeaders()' function
1061 * Prepares the display for a value
1063 * @param string $class
1064 * @param string $condition_field
1065 * @param string $value
1067 * @return string the td
1069 function PMA_buildValueDisplay($class, $condition_field, $value) {
1070 return '<td align="left"' . ' class="' . $class . ($condition_field ?
' condition' : '') . '">' . $value . '</td>';
1074 * Prepares the display for a null value
1076 * @param string $class
1077 * @param string $condition_field
1079 * @return string the td
1081 function PMA_buildNullDisplay($class, $condition_field) {
1082 // the null class is needed for inline editing
1083 return '<td align="right"' . ' class="' . $class . ($condition_field ?
' condition' : '') . ' null"><i>NULL</i></td>';
1087 * Prepares the display for an empty value
1089 * @param string $class
1090 * @param string $condition_field
1091 * @param string $align
1093 * @return string the td
1095 function PMA_buildEmptyDisplay($class, $condition_field, $meta, $align = '') {
1096 $nowrap = ' nowrap';
1097 return '<td ' . $align . ' class="' . PMA_addClass($class, $condition_field, $meta, $nowrap) . '"></td>';
1101 * Adds the relavant classes.
1103 * @param string $class
1104 * @param string $condition_field
1105 * @param object $meta the meta-information about this field
1106 * @param string $nowrap
1107 * @param bool $is_field_truncated
1108 * @param string $transform_function
1109 * @param string $default_function
1111 * @return string the list of classes
1113 function PMA_addClass($class, $condition_field, $meta, $nowrap, $is_field_truncated = false, $transform_function = '', $default_function = '') {
1114 // Define classes to be added to this data field based on the type of data
1116 if (strpos($meta->flags
, 'enum') !== false) {
1117 $enum_class = ' enum';
1121 if (strpos($meta->flags
, 'set') !== false) {
1122 $set_class = ' set';
1126 if (strpos($meta->type
, 'bit') !== false) {
1127 $bit_class = ' bit';
1130 $mime_type_class = '';
1131 if (isset($meta->mimetype
)) {
1132 $mime_type_class = ' ' . preg_replace('/\//', '_', $meta->mimetype
);
1135 $result = $class . ($condition_field ?
' condition' : '') . $nowrap
1136 . ' ' . ($is_field_truncated ?
' truncated' : '')
1137 . ($transform_function != $default_function ?
' transformed' : '')
1138 . $enum_class . $set_class . $bit_class . $mime_type_class;
1143 * Displays the body of the results table
1145 * @param integer the link id associated to the query which results have
1147 * @param array which elements to display
1148 * @param array the list of relations
1149 * @param array the analyzed query
1151 * @return boolean always true
1153 * @global string $db the database name
1154 * @global string $table the table name
1155 * @global string $goto the URL to go back in case of errors
1156 * @global string $sql_query the SQL query
1157 * @global array $fields_meta the list of fields properties
1158 * @global integer $fields_cnt the total number of fields returned by
1160 * @global array $vertical_display informations used with vertical display
1162 * @global array $highlight_columns column names to highlight
1163 * @global array $row current row data
1167 * @see PMA_displayTable()
1169 function PMA_displayTableBody(&$dt_result, &$is_display, $map, $analyzed_sql) {
1170 global $db, $table, $goto;
1171 global $sql_query, $fields_meta, $fields_cnt;
1172 global $vertical_display, $highlight_columns;
1173 global $row; // mostly because of browser transformations, to make the row-data accessible in a plugin
1175 $url_sql_query = $sql_query;
1177 // query without conditions to shorten URLs when needed, 200 is just
1178 // guess, it should depend on remaining URL length
1180 if (isset($analyzed_sql) && isset($analyzed_sql[0]) &&
1181 isset($analyzed_sql[0]['querytype']) && $analyzed_sql[0]['querytype'] == 'SELECT' &&
1182 strlen($sql_query) > 200) {
1184 $url_sql_query = 'SELECT ';
1185 if (isset($analyzed_sql[0]['queryflags']['distinct'])) {
1186 $url_sql_query .= ' DISTINCT ';
1188 $url_sql_query .= $analyzed_sql[0]['select_expr_clause'];
1189 if (!empty($analyzed_sql[0]['from_clause'])) {
1190 $url_sql_query .= ' FROM ' . $analyzed_sql[0]['from_clause'];
1194 if (! is_array($map)) {
1198 $vertical_display['edit'] = array();
1199 $vertical_display['copy'] = array();
1200 $vertical_display['delete'] = array();
1201 $vertical_display['data'] = array();
1202 $vertical_display['row_delete'] = array();
1203 // name of the class added to all inline editable elements
1204 $inline_edit_class = 'inline_edit';
1206 // prepare to get the column order, if available
1207 if (PMA_isSelect()) {
1208 $pmatable = new PMA_Table($GLOBALS['table'], $GLOBALS['db']);
1209 $col_order = $pmatable->getUiProp(PMA_Table
::PROP_COLUMN_ORDER
);
1210 $col_visib = $pmatable->getUiProp(PMA_Table
::PROP_COLUMN_VISIB
);
1216 // Correction University of Virginia 19991216 in the while below
1217 // Previous code assumed that all tables have keys, specifically that
1218 // the phpMyAdmin GUI should support row delete/edit only for such
1220 // Although always using keys is arguably the prescribed way of
1221 // defining a relational table, it is not required. This will in
1222 // particular be violated by the novice.
1223 // We want to encourage phpMyAdmin usage by such novices. So the code
1224 // below has been changed to conditionally work as before when the
1225 // table being displayed has one or more keys; but to display
1226 // delete/edit options correctly for tables without keys.
1229 while ($row = PMA_DBI_fetch_row($dt_result)) {
1230 // "vertical display" mode stuff
1231 if ($row_no != 0 && $_SESSION['tmp_user_values']['repeat_cells'] != 0 && !($row_no %
$_SESSION['tmp_user_values']['repeat_cells'])
1232 && ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
1233 ||
$_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped'))
1236 if ($vertical_display['emptypre'] > 0) {
1237 echo ' <th colspan="' . $vertical_display['emptypre'] . '">' . "\n"
1238 .' </th>' . "\n";
1239 } else if ($GLOBALS['cfg']['RowActionLinks'] == 'none') {
1240 echo ' <th></th>' . "\n";
1243 foreach ($vertical_display['desc'] as $val) {
1247 if ($vertical_display['emptyafter'] > 0) {
1248 echo ' <th colspan="' . $vertical_display['emptyafter'] . '">' . "\n"
1249 .' </th>' . "\n";
1251 echo '</tr>' . "\n";
1254 $alternating_color_class = ($odd_row ?
'odd' : 'even');
1255 $odd_row = ! $odd_row;
1257 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
1258 ||
$_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
1259 // pointer code part
1260 echo '<tr class="' . $alternating_color_class . '">';
1264 // 1. Prepares the row
1265 // 1.1 Results from a "SELECT" statement -> builds the
1266 // WHERE clause to use in links (a unique key if possible)
1268 * @todo $where_clause could be empty, for example a table
1269 * with only one field and it's a BLOB; in this case,
1270 * avoid to display the delete and edit links
1272 list($where_clause, $clause_is_unique) = PMA_getUniqueCondition($dt_result, $fields_cnt, $fields_meta, $row);
1273 $where_clause_html = urlencode($where_clause);
1275 // 1.2 Defines the URLs for the modify/delete link(s)
1277 if ($is_display['edit_lnk'] != 'nn' ||
$is_display['del_lnk'] != 'nn') {
1278 // We need to copy the value or else the == 'both' check will always return true
1280 if ($GLOBALS['cfg']['PropertiesIconic'] === 'both') {
1281 $iconic_spacer = '<div class="nowrap">';
1283 $iconic_spacer = '';
1286 // 1.2.1 Modify link(s)
1287 if ($is_display['edit_lnk'] == 'ur') { // update row case
1288 $_url_params = array(
1291 'where_clause' => $where_clause,
1292 'clause_is_unique' => $clause_is_unique,
1293 'sql_query' => $url_sql_query,
1294 'goto' => 'sql.php',
1296 $edit_url = 'tbl_change.php' . PMA_generate_common_url($_url_params +
array('default_action' => 'update'));
1297 $copy_url = 'tbl_change.php' . PMA_generate_common_url($_url_params +
array('default_action' => 'insert'));
1299 $edit_str = PMA_getIcon('b_edit.png', __('Edit'), true);
1300 $copy_str = PMA_getIcon('b_insrow.png', __('Copy'), true);
1302 // Class definitions required for inline editing jQuery scripts
1303 $edit_anchor_class = "edit_row_anchor";
1304 if ( $clause_is_unique == 0) {
1305 $edit_anchor_class .= ' nonunique';
1309 // 1.2.2 Delete/Kill link(s)
1310 if ($is_display['del_lnk'] == 'dr') { // delete row case
1311 $_url_params = array(
1314 'sql_query' => $url_sql_query,
1315 'message_to_show' => __('The row has been deleted'),
1316 'goto' => (empty($goto) ?
'tbl_sql.php' : $goto),
1318 $lnk_goto = 'sql.php' . PMA_generate_common_url($_url_params, 'text');
1320 $del_query = 'DELETE FROM ' . PMA_backquote($db) . '.' . PMA_backquote($table)
1321 . ' WHERE ' . $where_clause . ($clause_is_unique ?
'' : ' LIMIT 1');
1323 $_url_params = array(
1326 'sql_query' => $del_query,
1327 'message_to_show' => __('The row has been deleted'),
1328 'goto' => $lnk_goto,
1330 $del_url = 'sql.php' . PMA_generate_common_url($_url_params);
1332 $js_conf = 'DELETE FROM ' . PMA_jsFormat($db) . '.' . PMA_jsFormat($table)
1333 . ' WHERE ' . PMA_jsFormat($where_clause, false)
1334 . ($clause_is_unique ?
'' : ' LIMIT 1');
1335 $del_str = PMA_getIcon('b_drop.png', __('Delete'), true);
1336 } elseif ($is_display['del_lnk'] == 'kp') { // kill process case
1338 $_url_params = array(
1341 'sql_query' => $url_sql_query,
1342 'goto' => 'main.php',
1344 $lnk_goto = 'sql.php' . PMA_generate_common_url($_url_params, 'text');
1346 $_url_params = array(
1348 'sql_query' => 'KILL ' . $row[0],
1349 'goto' => $lnk_goto,
1351 $del_url = 'sql.php' . PMA_generate_common_url($_url_params);
1352 $del_query = 'KILL ' . $row[0];
1353 $js_conf = 'KILL ' . $row[0];
1354 $del_str = PMA_getIcon('b_drop.png', __('Kill'), true);
1357 // 1.3 Displays the links at left if required
1358 if (($GLOBALS['cfg']['RowActionLinks'] == 'left' ||
$GLOBALS['cfg']['RowActionLinks'] == 'both')
1359 && ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
1360 ||
$_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped')) {
1361 if (! isset($js_conf)) {
1364 echo PMA_generateCheckboxAndLinks('left', $del_url, $is_display, $row_no, $where_clause, $where_clause_html, $del_query, 'l', $edit_url, $copy_url, $edit_anchor_class, $edit_str, $copy_str, $del_str, $js_conf);
1365 } else if (($GLOBALS['cfg']['RowActionLinks'] == 'none')
1366 && ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
1367 ||
$_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped')) {
1368 if (! isset($js_conf)) {
1371 echo PMA_generateCheckboxAndLinks('none', $del_url, $is_display, $row_no, $where_clause, $where_clause_html, $del_query, 'l', $edit_url, $copy_url, $edit_anchor_class, $edit_str, $copy_str, $del_str, $js_conf);
1375 // 2. Displays the rows' values
1377 for ($j = 0; $j < $fields_cnt; ++
$j) {
1378 // assign $i with appropriate column order
1379 $i = $col_order ?
$col_order[$j] : $j;
1381 $meta = $fields_meta[$i];
1382 $not_null_class = $meta->not_null ?
'not_null' : '';
1383 $relation_class = isset($map[$meta->name
]) ?
'relation' : '';
1384 $hide_class = ($col_visib && !$col_visib[$j] &&
1385 // hide per <td> only if the display direction is not vertical
1386 $_SESSION['tmp_user_values']['disp_direction'] != 'vertical') ?
'hide' : '';
1388 $is_field_truncated = false;
1389 //If the previous column had blob data, we need to reset the class
1390 // to $inline_edit_class
1391 $class = 'data ' . $inline_edit_class . ' ' . $not_null_class . ' ' . $relation_class; //' ' . $alternating_color_class .
1393 // See if this column should get highlight because it's used in the
1395 if (isset($highlight_columns) && (isset($highlight_columns[$meta->name
]) ||
isset($highlight_columns[PMA_backquote($meta->name
)]))) {
1396 $condition_field = true;
1398 $condition_field = false;
1401 if ($_SESSION['tmp_user_values']['disp_direction'] == 'vertical' && (! isset($GLOBALS['printview']) ||
($GLOBALS['printview'] != '1'))) {
1402 // the row number corresponds to a data row, not HTML table row
1403 $class .= ' row_' . $row_no;
1404 if ($GLOBALS['cfg']['BrowsePointerEnable'] == true) {
1405 $class .= ' vpointer';
1407 if ($GLOBALS['cfg']['BrowseMarkerEnable'] == true) {
1408 $class .= ' vmarker';
1412 // Wrap MIME-transformations. [MIME]
1413 $default_function = 'default_function'; // default_function
1414 $transform_function = $default_function;
1415 $transform_options = array();
1417 if ($GLOBALS['cfgRelation']['mimework'] && $GLOBALS['cfg']['BrowseMIME']) {
1419 if (isset($GLOBALS['mime_map'][$meta->name
]['mimetype']) && isset($GLOBALS['mime_map'][$meta->name
]['transformation']) && !empty($GLOBALS['mime_map'][$meta->name
]['transformation'])) {
1420 $include_file = PMA_securePath($GLOBALS['mime_map'][$meta->name
]['transformation']);
1422 if (file_exists('./libraries/transformations/' . $include_file)) {
1423 $transformfunction_name = str_replace('.inc.php', '', $GLOBALS['mime_map'][$meta->name
]['transformation']);
1425 require_once './libraries/transformations/' . $include_file;
1427 if (function_exists('PMA_transformation_' . $transformfunction_name)) {
1428 $transform_function = 'PMA_transformation_' . $transformfunction_name;
1429 $transform_options = PMA_transformation_getOptions((isset($GLOBALS['mime_map'][$meta->name
]['transformation_options']) ?
$GLOBALS['mime_map'][$meta->name
]['transformation_options'] : ''));
1430 $meta->mimetype
= str_replace('_', '/', $GLOBALS['mime_map'][$meta->name
]['mimetype']);
1432 } // end if file_exists
1433 } // end if transformation is set
1434 } // end if mime/transformation works.
1436 $_url_params = array(
1439 'where_clause' => $where_clause,
1440 'transform_key' => $meta->name
,
1443 if (! empty($sql_query)) {
1444 $_url_params['sql_query'] = $url_sql_query;
1447 $transform_options['wrapper_link'] = PMA_generate_common_url($_url_params);
1450 if ($meta->numeric == 1) {
1452 // if two fields have the same name (this is possible
1453 // with self-join queries, for example), using $meta->name
1454 // will show both fields NULL even if only one is NULL,
1455 // so use the $pointer
1457 if (! isset($row[$i]) ||
is_null($row[$i])) {
1458 $vertical_display['data'][$row_no][$i] = PMA_buildNullDisplay($class, $condition_field);
1459 } elseif ($row[$i] != '') {
1461 $nowrap = ' nowrap';
1462 $where_comparison = ' = ' . $row[$i];
1464 $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);
1466 $vertical_display['data'][$row_no][$i] = PMA_buildEmptyDisplay($class, $condition_field, $meta, 'align="right"');
1471 } elseif (stristr($meta->type
, 'BLOB')) {
1472 // PMA_mysql_fetch_fields returns BLOB in place of
1473 // TEXT fields type so we have to ensure it's really a BLOB
1474 $field_flags = PMA_DBI_field_flags($dt_result, $i);
1476 // remove 'inline_edit' from $class as we can't edit binary data.
1477 $class = str_replace('inline_edit', '', $class);
1479 if (stristr($field_flags, 'BINARY')) {
1480 if (! isset($row[$i]) ||
is_null($row[$i])) {
1481 $vertical_display['data'][$row_no][$i] = PMA_buildNullDisplay($class, $condition_field);
1483 // for blobstreaming
1484 // if valid BS reference exists
1485 if (PMA_BS_IsPBMSReference($row[$i], $db)) {
1486 $blobtext = PMA_BS_CreateReferenceLink($row[$i], $db);
1488 $blobtext = PMA_handle_non_printable_contents('BLOB', (isset($row[$i]) ?
$row[$i] : ''), $transform_function, $transform_options, $default_function, $meta, $_url_params);
1491 $vertical_display['data'][$row_no][$i] = PMA_buildValueDisplay($class, $condition_field, $blobtext);
1496 if (! isset($row[$i]) ||
is_null($row[$i])) {
1497 $vertical_display['data'][$row_no][$i] = PMA_buildNullDisplay($class, $condition_field);
1498 } elseif ($row[$i] != '') {
1499 // if a transform function for blob is set, none of these replacements will be made
1500 if (PMA_strlen($row[$i]) > $GLOBALS['cfg']['LimitChars'] && $_SESSION['tmp_user_values']['display_text'] == 'P') {
1501 $row[$i] = PMA_substr($row[$i], 0, $GLOBALS['cfg']['LimitChars']) . '...';
1502 $is_field_truncated = true;
1504 // displays all space characters, 4 space
1505 // characters for tabulations and <cr>/<lf>
1506 $row[$i] = ($default_function != $transform_function ?
$transform_function($row[$i], $transform_options, $meta) : $default_function($row[$i], array(), $meta));
1508 $vertical_display['data'][$row_no][$i] = PMA_buildValueDisplay($class, $condition_field, $row[$i]);
1510 $vertical_display['data'][$row_no][$i] = PMA_buildEmptyDisplay($class, $condition_field, $meta);
1514 } elseif ($meta->type
== 'geometry') {
1516 // Remove 'inline_edit' from $class as we do not allow to inline-edit geometry data.
1517 $class = str_replace('inline_edit', '', $class);
1519 if (! isset($row[$i]) ||
is_null($row[$i])) {
1520 $vertical_display['data'][$row_no][$i] = PMA_buildNullDisplay($class, $condition_field);
1521 } elseif ($row[$i] != '') {
1522 // Display as [GEOMETRY - (size)]
1523 if ('GEOM' == $_SESSION['tmp_user_values']['geometry_display']) {
1524 $geometry_text = PMA_handle_non_printable_contents(
1525 'GEOMETRY', (isset($row[$i]) ?
$row[$i] : ''), $transform_function,
1526 $transform_options, $default_function, $meta
1528 $vertical_display['data'][$row_no][$i] = PMA_buildValueDisplay(
1529 $class, $condition_field, $geometry_text
1532 // Display in Well Known Text(WKT) format.
1533 } elseif ('WKT' == $_SESSION['tmp_user_values']['geometry_display']) {
1534 // Convert to WKT format
1535 $wktval = PMA_asWKT($row[$i]);
1537 if (PMA_strlen($wktval) > $GLOBALS['cfg']['LimitChars']
1538 && $_SESSION['tmp_user_values']['display_text'] == 'P'
1540 $wktval = PMA_substr($wktval, 0, $GLOBALS['cfg']['LimitChars']) . '...';
1541 $is_field_truncated = true;
1544 $vertical_display['data'][$row_no][$i] = '<td ' . PMA_prepare_row_data(
1545 $class, $condition_field, $analyzed_sql, $meta, $map, $wktval, $transform_function,
1546 $default_function, $nowrap, $where_comparison, $transform_options, $is_field_truncated
1549 // Display in Well Known Binary(WKB) format.
1551 if ($_SESSION['tmp_user_values']['display_binary']) {
1552 if ($_SESSION['tmp_user_values']['display_binary_as_hex']
1553 && PMA_contains_nonprintable_ascii($row[$i])
1555 $wkbval = PMA_substr(bin2hex($row[$i]), 8);
1557 $wkbval = htmlspecialchars(PMA_replace_binary_contents($row[$i]));
1560 if (PMA_strlen($wkbval) > $GLOBALS['cfg']['LimitChars']
1561 && $_SESSION['tmp_user_values']['display_text'] == 'P'
1563 $wkbval = PMA_substr($wkbval, 0, $GLOBALS['cfg']['LimitChars']) . '...';
1564 $is_field_truncated = true;
1567 $vertical_display['data'][$row_no][$i] = '<td ' . PMA_prepare_row_data(
1568 $class, $condition_field, $analyzed_sql, $meta, $map, $wkbval, $transform_function,
1569 $default_function, $nowrap, $where_comparison, $transform_options, $is_field_truncated
1572 $wkbval = PMA_handle_non_printable_contents(
1573 'BINARY', $row[$i], $transform_function, $transform_options, $default_function, $meta, $_url_params
1575 $vertical_display['data'][$row_no][$i] = PMA_buildValueDisplay($class, $condition_field, $wkbval);
1579 $vertical_display['data'][$row_no][$i] = PMA_buildEmptyDisplay($class, $condition_field, $meta);
1582 // n o t n u m e r i c a n d n o t B L O B
1584 if (! isset($row[$i]) ||
is_null($row[$i])) {
1585 $vertical_display['data'][$row_no][$i] = PMA_buildNullDisplay($class, $condition_field);
1586 } elseif ($row[$i] != '') {
1587 // support blanks in the key
1588 $relation_id = $row[$i];
1590 // Cut all fields to $GLOBALS['cfg']['LimitChars']
1591 // (unless it's a link-type transformation)
1592 if (PMA_strlen($row[$i]) > $GLOBALS['cfg']['LimitChars'] && $_SESSION['tmp_user_values']['display_text'] == 'P' && !strpos($transform_function, 'link') === true) {
1593 $row[$i] = PMA_substr($row[$i], 0, $GLOBALS['cfg']['LimitChars']) . '...';
1594 $is_field_truncated = true;
1597 // displays special characters from binaries
1598 $field_flags = PMA_DBI_field_flags($dt_result, $i);
1599 if (isset($meta->_type
) && $meta->_type
=== MYSQLI_TYPE_BIT
) {
1600 $row[$i] = PMA_printable_bit_value($row[$i], $meta->length
);
1601 // some results of PROCEDURE ANALYSE() are reported as
1602 // being BINARY but they are quite readable,
1603 // so don't treat them as BINARY
1604 } elseif (stristr($field_flags, 'BINARY') && $meta->type
== 'string' && !(isset($GLOBALS['is_analyse']) && $GLOBALS['is_analyse'])) {
1605 if ($_SESSION['tmp_user_values']['display_binary']) {
1606 // user asked to see the real contents of BINARY
1608 if ($_SESSION['tmp_user_values']['display_binary_as_hex'] && PMA_contains_nonprintable_ascii($row[$i])) {
1609 $row[$i] = bin2hex($row[$i]);
1611 $row[$i] = htmlspecialchars(PMA_replace_binary_contents($row[$i]));
1614 // we show the BINARY message and field's size
1615 // (or maybe use a transformation)
1616 $row[$i] = PMA_handle_non_printable_contents('BINARY', $row[$i], $transform_function, $transform_options, $default_function, $meta, $_url_params);
1620 // transform functions may enable no-wrapping:
1621 $function_nowrap = $transform_function . '_nowrap';
1622 $bool_nowrap = (($default_function != $transform_function && function_exists($function_nowrap)) ?
$function_nowrap($transform_options) : false);
1624 // do not wrap if date field type
1625 $nowrap = ((preg_match('@DATE|TIME@i', $meta->type
) ||
$bool_nowrap) ?
' nowrap' : '');
1626 $where_comparison = ' = \'' . PMA_sqlAddSlashes($row[$i]) . '\'';
1627 $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);
1630 $vertical_display['data'][$row_no][$i] = PMA_buildEmptyDisplay($class, $condition_field, $meta);
1634 // output stored cell
1635 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
1636 ||
$_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
1637 echo $vertical_display['data'][$row_no][$i];
1640 if (isset($vertical_display['rowdata'][$i][$row_no])) {
1641 $vertical_display['rowdata'][$i][$row_no] .= $vertical_display['data'][$row_no][$i];
1643 $vertical_display['rowdata'][$i][$row_no] = $vertical_display['data'][$row_no][$i];
1647 // 3. Displays the modify/delete links on the right if required
1648 if (($GLOBALS['cfg']['RowActionLinks'] == 'right' ||
$GLOBALS['cfg']['RowActionLinks'] == 'both')
1649 && ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
1650 ||
$_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped')) {
1651 if (! isset($js_conf)) {
1654 echo PMA_generateCheckboxAndLinks('right', $del_url, $is_display, $row_no, $where_clause, $where_clause_html, $del_query, 'r', $edit_url, $copy_url, $edit_anchor_class, $edit_str, $copy_str, $del_str, $js_conf);
1657 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
1658 ||
$_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
1664 // 4. Gather links of del_urls and edit_urls in an array for later
1666 if (! isset($vertical_display['edit'][$row_no])) {
1667 $vertical_display['edit'][$row_no] = '';
1668 $vertical_display['copy'][$row_no] = '';
1669 $vertical_display['delete'][$row_no] = '';
1670 $vertical_display['row_delete'][$row_no] = '';
1672 $vertical_class = ' row_' . $row_no;
1673 if ($GLOBALS['cfg']['BrowsePointerEnable'] == true) {
1674 $vertical_class .= ' vpointer';
1676 if ($GLOBALS['cfg']['BrowseMarkerEnable'] == true) {
1677 $vertical_class .= ' vmarker';
1680 if (!empty($del_url) && $is_display['del_lnk'] != 'kp') {
1681 $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);
1683 unset($vertical_display['row_delete'][$row_no]);
1686 if (isset($edit_url)) {
1687 $vertical_display['edit'][$row_no] .= PMA_generateEditLink($edit_url, $alternating_color_class . ' ' . $edit_anchor_class . $vertical_class, $edit_str, $where_clause, $where_clause_html);
1689 unset($vertical_display['edit'][$row_no]);
1692 if (isset($copy_url)) {
1693 $vertical_display['copy'][$row_no] .= PMA_generateCopyLink($copy_url, $copy_str, $where_clause, $where_clause_html, $alternating_color_class . $vertical_class);
1695 unset($vertical_display['copy'][$row_no]);
1698 if (isset($del_url)) {
1699 if (! isset($js_conf)) {
1702 $vertical_display['delete'][$row_no] .= PMA_generateDeleteLink($del_url, $del_str, $js_conf, $alternating_color_class . $vertical_class);
1704 unset($vertical_display['delete'][$row_no]);
1707 echo (($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal' ||
$_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') ?
"\n" : '');
1711 // this is needed by PMA_displayTable() to generate the proper param
1712 // in the multi-edit and multi-delete form
1713 return $clause_is_unique;
1714 } // end of the 'PMA_displayTableBody()' function
1718 * Do display the result table with the vertical direction mode.
1720 * @return boolean always true
1722 * @global array $vertical_display the information to display
1726 * @see PMA_displayTable()
1728 function PMA_displayVerticalTable()
1730 global $vertical_display;
1732 // Displays "multi row delete" link at top if required
1733 if (($GLOBALS['cfg']['RowActionLinks'] != 'right')
1734 && is_array($vertical_display['row_delete']) && (count($vertical_display['row_delete']) > 0 ||
!empty($vertical_display['textbtn']))) {
1736 if ($GLOBALS['cfg']['RowActionLinks'] == 'none') {
1737 // if we are not showing the RowActionLinks, then we need to show the Multi-Row-Action checkboxes
1738 echo '<th></th>' . "\n";
1740 echo $vertical_display['textbtn'];
1741 $cell_displayed = 0;
1742 foreach ($vertical_display['row_delete'] as $val) {
1743 if (($cell_displayed != 0) && ($_SESSION['tmp_user_values']['repeat_cells'] != 0) && !($cell_displayed %
$_SESSION['tmp_user_values']['repeat_cells'])) {
1745 (($is_display['edit_lnk'] != 'nn' && $is_display['del_lnk'] != 'nn') ?
' rowspan="4"' : '') .
1748 echo str_replace('[%_PMA_CHECKBOX_DIR_%]', '_left', $val);
1751 echo '</tr>' . "\n";
1754 // Displays "edit" link at top if required
1755 if (($GLOBALS['cfg']['RowActionLinks'] == 'left' ||
$GLOBALS['cfg']['RowActionLinks'] == 'both')
1756 && is_array($vertical_display['edit']) && (count($vertical_display['edit']) > 0 ||
!empty($vertical_display['textbtn']))) {
1758 if (! is_array($vertical_display['row_delete'])) {
1759 echo $vertical_display['textbtn'];
1761 foreach ($vertical_display['edit'] as $val) {
1764 echo '</tr>' . "\n";
1767 // Displays "copy" link at top if required
1768 if (($GLOBALS['cfg']['RowActionLinks'] == 'left' ||
$GLOBALS['cfg']['RowActionLinks'] == 'both')
1769 && is_array($vertical_display['copy']) && (count($vertical_display['copy']) > 0 ||
!empty($vertical_display['textbtn']))) {
1771 if (! is_array($vertical_display['row_delete'])) {
1772 echo $vertical_display['textbtn'];
1774 foreach ($vertical_display['copy'] as $val) {
1777 echo '</tr>' . "\n";
1780 // Displays "delete" link at top if required
1781 if (($GLOBALS['cfg']['RowActionLinks'] == 'left' ||
$GLOBALS['cfg']['RowActionLinks'] == 'both')
1782 && is_array($vertical_display['delete']) && (count($vertical_display['delete']) > 0 ||
!empty($vertical_display['textbtn']))) {
1784 if (! is_array($vertical_display['edit']) && ! is_array($vertical_display['row_delete'])) {
1785 echo $vertical_display['textbtn'];
1787 foreach ($vertical_display['delete'] as $val) {
1790 echo '</tr>' . "\n";
1793 if (PMA_isSelect()) {
1794 // prepare to get the column order, if available
1795 $pmatable = new PMA_Table($GLOBALS['table'], $GLOBALS['db']);
1796 $col_order = $pmatable->getUiProp(PMA_Table
::PROP_COLUMN_ORDER
);
1797 $col_visib = $pmatable->getUiProp(PMA_Table
::PROP_COLUMN_VISIB
);
1804 foreach ($vertical_display['desc'] AS $j => $val) {
1805 // assign appropriate key with current column order
1806 $key = $col_order ?
$col_order[$j] : $j;
1808 echo '<tr' . (($col_visib && !$col_visib[$j]) ?
' class="hide"' : '') . '>' . "\n";
1811 $cell_displayed = 0;
1812 foreach ($vertical_display['rowdata'][$key] as $subval) {
1813 if (($cell_displayed != 0) && ($_SESSION['tmp_user_values']['repeat_cells'] != 0) and !($cell_displayed %
$_SESSION['tmp_user_values']['repeat_cells'])) {
1821 echo '</tr>' . "\n";
1824 // Displays "multi row delete" link at bottom if required
1825 if (($GLOBALS['cfg']['RowActionLinks'] == 'right' ||
$GLOBALS['cfg']['RowActionLinks'] == 'both')
1826 && is_array($vertical_display['row_delete']) && (count($vertical_display['row_delete']) > 0 ||
!empty($vertical_display['textbtn']))) {
1828 echo $vertical_display['textbtn'];
1829 $cell_displayed = 0;
1830 foreach ($vertical_display['row_delete'] as $val) {
1831 if (($cell_displayed != 0) && ($_SESSION['tmp_user_values']['repeat_cells'] != 0) && !($cell_displayed %
$_SESSION['tmp_user_values']['repeat_cells'])) {
1833 (($is_display['edit_lnk'] != 'nn' && $is_display['del_lnk'] != 'nn') ?
' rowspan="4"' : '') .
1837 echo str_replace('[%_PMA_CHECKBOX_DIR_%]', '_right', $val);
1840 echo '</tr>' . "\n";
1843 // Displays "edit" link at bottom if required
1844 if (($GLOBALS['cfg']['RowActionLinks'] == 'right' ||
$GLOBALS['cfg']['RowActionLinks'] == 'both')
1845 && is_array($vertical_display['edit']) && (count($vertical_display['edit']) > 0 ||
!empty($vertical_display['textbtn']))) {
1847 if (! is_array($vertical_display['row_delete'])) {
1848 echo $vertical_display['textbtn'];
1850 foreach ($vertical_display['edit'] as $val) {
1853 echo '</tr>' . "\n";
1856 // Displays "copy" link at bottom if required
1857 if (($GLOBALS['cfg']['RowActionLinks'] == 'right' ||
$GLOBALS['cfg']['RowActionLinks'] == 'both')
1858 && is_array($vertical_display['copy']) && (count($vertical_display['copy']) > 0 ||
!empty($vertical_display['textbtn']))) {
1860 if (! is_array($vertical_display['row_delete'])) {
1861 echo $vertical_display['textbtn'];
1863 foreach ($vertical_display['copy'] as $val) {
1866 echo '</tr>' . "\n";
1869 // Displays "delete" link at bottom if required
1870 if (($GLOBALS['cfg']['RowActionLinks'] == 'right' ||
$GLOBALS['cfg']['RowActionLinks'] == 'both')
1871 && is_array($vertical_display['delete']) && (count($vertical_display['delete']) > 0 ||
!empty($vertical_display['textbtn']))) {
1873 if (! is_array($vertical_display['edit']) && ! is_array($vertical_display['row_delete'])) {
1874 echo $vertical_display['textbtn'];
1876 foreach ($vertical_display['delete'] as $val) {
1879 echo '</tr>' . "\n";
1883 } // end of the 'PMA_displayVerticalTable' function
1887 * @todo make maximum remembered queries configurable
1888 * @todo move/split into SQL class!?
1889 * @todo currently this is called twice unnecessary
1890 * @todo ignore LIMIT and ORDER in query!?
1892 function PMA_displayTable_checkConfigParams()
1894 $sql_md5 = md5($GLOBALS['sql_query']);
1896 $_SESSION['tmp_user_values']['query'][$sql_md5]['sql'] = $GLOBALS['sql_query'];
1898 if (PMA_isValid($_REQUEST['disp_direction'], array('horizontal', 'vertical', 'horizontalflipped'))) {
1899 $_SESSION['tmp_user_values']['query'][$sql_md5]['disp_direction'] = $_REQUEST['disp_direction'];
1900 unset($_REQUEST['disp_direction']);
1901 } elseif (empty($_SESSION['tmp_user_values']['query'][$sql_md5]['disp_direction'])) {
1902 $_SESSION['tmp_user_values']['query'][$sql_md5]['disp_direction'] = $GLOBALS['cfg']['DefaultDisplay'];
1905 if (PMA_isValid($_REQUEST['repeat_cells'], 'numeric')) {
1906 $_SESSION['tmp_user_values']['query'][$sql_md5]['repeat_cells'] = $_REQUEST['repeat_cells'];
1907 unset($_REQUEST['repeat_cells']);
1908 } elseif (empty($_SESSION['tmp_user_values']['query'][$sql_md5]['repeat_cells'])) {
1909 $_SESSION['tmp_user_values']['query'][$sql_md5]['repeat_cells'] = $GLOBALS['cfg']['RepeatCells'];
1912 // as this is a form value, the type is always string so we cannot
1913 // use PMA_isValid($_REQUEST['session_max_rows'], 'integer')
1914 if ((PMA_isValid($_REQUEST['session_max_rows'], 'numeric')
1915 && (int) $_REQUEST['session_max_rows'] == $_REQUEST['session_max_rows'])
1916 ||
$_REQUEST['session_max_rows'] == 'all') {
1917 $_SESSION['tmp_user_values']['query'][$sql_md5]['max_rows'] = $_REQUEST['session_max_rows'];
1918 unset($_REQUEST['session_max_rows']);
1919 } elseif (empty($_SESSION['tmp_user_values']['query'][$sql_md5]['max_rows'])) {
1920 $_SESSION['tmp_user_values']['query'][$sql_md5]['max_rows'] = $GLOBALS['cfg']['MaxRows'];
1923 if (PMA_isValid($_REQUEST['pos'], 'numeric')) {
1924 $_SESSION['tmp_user_values']['query'][$sql_md5]['pos'] = $_REQUEST['pos'];
1925 unset($_REQUEST['pos']);
1926 } elseif (empty($_SESSION['tmp_user_values']['query'][$sql_md5]['pos'])) {
1927 $_SESSION['tmp_user_values']['query'][$sql_md5]['pos'] = 0;
1930 if (PMA_isValid($_REQUEST['display_text'], array('P', 'F'))) {
1931 $_SESSION['tmp_user_values']['query'][$sql_md5]['display_text'] = $_REQUEST['display_text'];
1932 unset($_REQUEST['display_text']);
1933 } elseif (empty($_SESSION['tmp_user_values']['query'][$sql_md5]['display_text'])) {
1934 $_SESSION['tmp_user_values']['query'][$sql_md5]['display_text'] = 'P';
1937 if (PMA_isValid($_REQUEST['relational_display'], array('K', 'D'))) {
1938 $_SESSION['tmp_user_values']['query'][$sql_md5]['relational_display'] = $_REQUEST['relational_display'];
1939 unset($_REQUEST['relational_display']);
1940 } elseif (empty($_SESSION['tmp_user_values']['query'][$sql_md5]['relational_display'])) {
1941 $_SESSION['tmp_user_values']['query'][$sql_md5]['relational_display'] = 'K';
1944 if (PMA_isValid($_REQUEST['geometry_display'], array('WKT', 'WKB', 'GEOM'))) {
1945 $_SESSION['tmp_user_values']['query'][$sql_md5]['geometry_display'] = $_REQUEST['geometry_display'];
1946 unset($_REQUEST['geometry_display']);
1947 } elseif (empty($_SESSION['tmp_user_values']['query'][$sql_md5]['geometry_display'])) {
1948 $_SESSION['tmp_user_values']['query'][$sql_md5]['geometry_display'] = 'GEOM';
1951 if (isset($_REQUEST['display_binary'])) {
1952 $_SESSION['tmp_user_values']['query'][$sql_md5]['display_binary'] = true;
1953 unset($_REQUEST['display_binary']);
1954 } elseif (isset($_REQUEST['display_options_form'])) {
1955 // we know that the checkbox was unchecked
1956 unset($_SESSION['tmp_user_values']['query'][$sql_md5]['display_binary']);
1958 // selected by default because some operations like OPTIMIZE TABLE
1959 // and all queries involving functions return "binary" contents,
1960 // according to low-level field flags
1961 $_SESSION['tmp_user_values']['query'][$sql_md5]['display_binary'] = true;
1964 if (isset($_REQUEST['display_binary_as_hex'])) {
1965 $_SESSION['tmp_user_values']['query'][$sql_md5]['display_binary_as_hex'] = true;
1966 unset($_REQUEST['display_binary_as_hex']);
1967 } elseif (isset($_REQUEST['display_options_form'])) {
1968 // we know that the checkbox was unchecked
1969 unset($_SESSION['tmp_user_values']['query'][$sql_md5]['display_binary_as_hex']);
1971 // display_binary_as_hex config option
1972 if (isset($GLOBALS['cfg']['DisplayBinaryAsHex']) && true === $GLOBALS['cfg']['DisplayBinaryAsHex']) {
1973 $_SESSION['tmp_user_values']['query'][$sql_md5]['display_binary_as_hex'] = true;
1977 if (isset($_REQUEST['display_blob'])) {
1978 $_SESSION['tmp_user_values']['query'][$sql_md5]['display_blob'] = true;
1979 unset($_REQUEST['display_blob']);
1980 } elseif (isset($_REQUEST['display_options_form'])) {
1981 // we know that the checkbox was unchecked
1982 unset($_SESSION['tmp_user_values']['query'][$sql_md5]['display_blob']);
1985 if (isset($_REQUEST['hide_transformation'])) {
1986 $_SESSION['tmp_user_values']['query'][$sql_md5]['hide_transformation'] = true;
1987 unset($_REQUEST['hide_transformation']);
1988 } elseif (isset($_REQUEST['display_options_form'])) {
1989 // we know that the checkbox was unchecked
1990 unset($_SESSION['tmp_user_values']['query'][$sql_md5]['hide_transformation']);
1993 // move current query to the last position, to be removed last
1994 // so only least executed query will be removed if maximum remembered queries
1996 $tmp = $_SESSION['tmp_user_values']['query'][$sql_md5];
1997 unset($_SESSION['tmp_user_values']['query'][$sql_md5]);
1998 $_SESSION['tmp_user_values']['query'][$sql_md5] = $tmp;
2000 // do not exceed a maximum number of queries to remember
2001 if (count($_SESSION['tmp_user_values']['query']) > 10) {
2002 array_shift($_SESSION['tmp_user_values']['query']);
2003 //echo 'deleting one element ...';
2006 // populate query configuration
2007 $_SESSION['tmp_user_values']['display_text'] = $_SESSION['tmp_user_values']['query'][$sql_md5]['display_text'];
2008 $_SESSION['tmp_user_values']['relational_display'] = $_SESSION['tmp_user_values']['query'][$sql_md5]['relational_display'];
2009 $_SESSION['tmp_user_values']['geometry_display'] = $_SESSION['tmp_user_values']['query'][$sql_md5]['geometry_display'];
2010 $_SESSION['tmp_user_values']['display_binary'] = isset($_SESSION['tmp_user_values']['query'][$sql_md5]['display_binary']) ?
true : false;
2011 $_SESSION['tmp_user_values']['display_binary_as_hex'] = isset($_SESSION['tmp_user_values']['query'][$sql_md5]['display_binary_as_hex']) ?
true : false;
2012 $_SESSION['tmp_user_values']['display_blob'] = isset($_SESSION['tmp_user_values']['query'][$sql_md5]['display_blob']) ?
true : false;
2013 $_SESSION['tmp_user_values']['hide_transformation'] = isset($_SESSION['tmp_user_values']['query'][$sql_md5]['hide_transformation']) ?
true : false;
2014 $_SESSION['tmp_user_values']['pos'] = $_SESSION['tmp_user_values']['query'][$sql_md5]['pos'];
2015 $_SESSION['tmp_user_values']['max_rows'] = $_SESSION['tmp_user_values']['query'][$sql_md5]['max_rows'];
2016 $_SESSION['tmp_user_values']['repeat_cells'] = $_SESSION['tmp_user_values']['query'][$sql_md5]['repeat_cells'];
2017 $_SESSION['tmp_user_values']['disp_direction'] = $_SESSION['tmp_user_values']['query'][$sql_md5]['disp_direction'];
2022 var_dump($_SESSION['tmp_user_values']);
2028 * Displays a table of results returned by a SQL query.
2029 * This function is called by the "sql.php" script.
2031 * @param integer the link id associated to the query which results have
2033 * @param array the display mode
2034 * @param array the analyzed query
2036 * @global string $db the database name
2037 * @global string $table the table name
2038 * @global string $goto the URL to go back in case of errors
2039 * @global string $sql_query the current SQL query
2040 * @global integer $num_rows the total number of rows returned by the
2042 * @global integer $unlim_num_rows the total number of rows returned by the
2043 * SQL query without any programmatically
2044 * appended "LIMIT" clause
2045 * @global array $fields_meta the list of fields properties
2046 * @global integer $fields_cnt the total number of fields returned by
2048 * @global array $vertical_display informations used with vertical display
2050 * @global array $highlight_columns column names to highlight
2051 * @global array $cfgRelation the relation settings
2055 * @see PMA_showMessage(), PMA_setDisplayMode(),
2056 * PMA_displayTableNavigation(), PMA_displayTableHeaders(),
2057 * PMA_displayTableBody(), PMA_displayResultsOperations()
2059 function PMA_displayTable(&$dt_result, &$the_disp_mode, $analyzed_sql)
2061 global $db, $table, $goto;
2062 global $sql_query, $num_rows, $unlim_num_rows, $fields_meta, $fields_cnt;
2063 global $vertical_display, $highlight_columns;
2064 global $cfgRelation;
2067 // why was this called here? (already called from sql.php)
2068 //PMA_displayTable_checkConfigParams();
2071 * @todo move this to a central place
2072 * @todo for other future table types
2074 $is_innodb = (isset($showtable['Type']) && $showtable['Type'] == 'InnoDB');
2077 && ! isset($analyzed_sql[0]['queryflags']['union'])
2078 && ! isset($analyzed_sql[0]['table_ref'][1]['table_name'])
2079 && (empty($analyzed_sql[0]['where_clause'])
2080 ||
$analyzed_sql[0]['where_clause'] == '1 ')) {
2081 // "j u s t b r o w s i n g"
2083 $after_count = PMA_showHint(PMA_sanitize(__('May be approximate. See [a@./Documentation.html#faq3_11@Documentation]FAQ 3.11[/a]')));
2089 // 1. ----- Prepares the work -----
2091 // 1.1 Gets the informations about which functionalities should be
2094 $is_display = PMA_setDisplayMode($the_disp_mode, $total);
2096 // 1.2 Defines offsets for the next and previous pages
2097 if ($is_display['nav_bar'] == '1') {
2098 if ($_SESSION['tmp_user_values']['max_rows'] == 'all') {
2102 $pos_next = $_SESSION['tmp_user_values']['pos'] +
$_SESSION['tmp_user_values']['max_rows'];
2103 $pos_prev = $_SESSION['tmp_user_values']['pos'] - $_SESSION['tmp_user_values']['max_rows'];
2104 if ($pos_prev < 0) {
2110 // 1.3 Find the sort expression
2112 // we need $sort_expression and $sort_expression_nodirection
2113 // even if there are many table references
2114 if (! empty($analyzed_sql[0]['order_by_clause'])) {
2115 $sort_expression = trim(str_replace(' ', ' ', $analyzed_sql[0]['order_by_clause']));
2117 * Get rid of ASC|DESC
2119 preg_match('@(.*)([[:space:]]*(ASC|DESC))@si', $sort_expression, $matches);
2120 $sort_expression_nodirection = isset($matches[1]) ?
trim($matches[1]) : $sort_expression;
2121 $sort_direction = isset($matches[2]) ?
trim($matches[2]) : '';
2124 $sort_expression = $sort_expression_nodirection = $sort_direction = '';
2127 // 1.4 Prepares display of first and last value of the sorted column
2129 if (! empty($sort_expression_nodirection)) {
2130 if (strpos($sort_expression_nodirection, '.') === false) {
2131 $sort_table = $table;
2132 $sort_column = $sort_expression_nodirection;
2134 list($sort_table, $sort_column) = explode('.', $sort_expression_nodirection);
2136 $sort_table = PMA_unQuote($sort_table);
2137 $sort_column = PMA_unQuote($sort_column);
2138 // find the sorted column index in row result
2139 // (this might be a multi-table query)
2140 $sorted_column_index = false;
2141 foreach ($fields_meta as $key => $meta) {
2142 if ($meta->table
== $sort_table && $meta->name
== $sort_column) {
2143 $sorted_column_index = $key;
2147 if ($sorted_column_index !== false) {
2148 // fetch first row of the result set
2149 $row = PMA_DBI_fetch_row($dt_result);
2150 // initializing default arguments
2151 $default_function = 'default_function';
2152 $transform_function = $default_function;
2153 $transform_options = array();
2154 // check for non printable sorted row data
2155 $meta = $fields_meta[$sorted_column_index];
2156 if (stristr($meta->type
, 'BLOB') ||
$meta->type
== 'geometry') {
2157 $column_for_first_row = PMA_handle_non_printable_contents($meta->type
, $row[$sorted_column_index], $transform_function, $transform_options, $default_function, $meta, NULL);
2159 $column_for_first_row = $row[$sorted_column_index];
2161 $column_for_first_row = strtoupper(substr($column_for_first_row, 0, $GLOBALS['cfg']['LimitChars']));
2162 // fetch last row of the result set
2163 PMA_DBI_data_seek($dt_result, $num_rows - 1);
2164 $row = PMA_DBI_fetch_row($dt_result);
2165 // check for non printable sorted row data
2166 $meta = $fields_meta[$sorted_column_index];
2167 if (stristr($meta->type
, 'BLOB') ||
$meta->type
== 'geometry') {
2168 $column_for_last_row = PMA_handle_non_printable_contents($meta->type
, $row[$sorted_column_index], $transform_function, $transform_options, $default_function, $meta, NULL);
2170 $column_for_last_row = $row[$sorted_column_index];
2172 $column_for_last_row = strtoupper(substr($column_for_last_row, 0, $GLOBALS['cfg']['LimitChars']));
2173 // reset to first row for the loop in PMA_displayTableBody()
2174 PMA_DBI_data_seek($dt_result, 0);
2175 // we could also use here $sort_expression_nodirection
2176 $sorted_column_message = ' [' . htmlspecialchars($sort_column) . ': <strong>' . htmlspecialchars($column_for_first_row) . ' - ' . htmlspecialchars($column_for_last_row) . '</strong>]';
2177 unset($row, $column_for_first_row, $column_for_last_row, $meta, $default_function, $transform_function, $transform_options);
2179 unset($sorted_column_index, $sort_table, $sort_column);
2182 // 2. ----- Displays the top of the page -----
2184 // 2.1 Displays a messages with position informations
2185 if ($is_display['nav_bar'] == '1' && isset($pos_next)) {
2186 if (isset($unlim_num_rows) && $unlim_num_rows != $total) {
2187 $selectstring = ', ' . $unlim_num_rows . ' ' . __('in query');
2191 $last_shown_rec = ($_SESSION['tmp_user_values']['max_rows'] == 'all' ||
$pos_next > $total)
2195 if (PMA_Table
::isView($db, $table)
2196 && $total == $GLOBALS['cfg']['MaxExactCountViews']) {
2197 $message = PMA_Message
::notice(__('This view has at least this number of rows. Please refer to %sdocumentation%s.'));
2198 $message->addParam('[a@./Documentation.html#cfg_MaxExactCount@_blank]');
2199 $message->addParam('[/a]');
2200 $message_view_warning = PMA_showHint($message);
2202 $message_view_warning = false;
2205 $message = PMA_Message
::success(__('Showing rows'));
2206 $message->addMessage($_SESSION['tmp_user_values']['pos']);
2207 if ($message_view_warning) {
2208 $message->addMessage('...', ' - ');
2209 $message->addMessage($message_view_warning);
2210 $message->addMessage('(');
2212 $message->addMessage($last_shown_rec, ' - ');
2213 $message->addMessage(' (');
2214 $message->addMessage($pre_count . PMA_formatNumber($total, 0));
2215 $message->addString(__('total'));
2216 if (!empty($after_count)) {
2217 $message->addMessage($after_count);
2219 $message->addMessage($selectstring, '');
2220 $message->addMessage(', ', '');
2223 $messagge_qt = PMA_Message
::notice(__('Query took %01.4f sec'));
2224 $messagge_qt->addParam($GLOBALS['querytime']);
2226 $message->addMessage($messagge_qt, '');
2227 $message->addMessage(')', '');
2229 $message->addMessage(isset($sorted_column_message) ?
$sorted_column_message : '', '');
2231 PMA_showMessage($message, $sql_query, 'success');
2233 } elseif (! isset($GLOBALS['printview']) ||
$GLOBALS['printview'] != '1') {
2234 PMA_showMessage(__('Your SQL query has been executed successfully'), $sql_query, 'success');
2237 // 2.3 Displays the navigation bars
2238 if (! strlen($table)) {
2239 if (isset($analyzed_sql[0]['query_type'])
2240 && $analyzed_sql[0]['query_type'] == 'SELECT') {
2241 // table does not always contain a real table name,
2242 // for example in MySQL 5.0.x, the query SHOW STATUS
2243 // returns STATUS as a table name
2244 $table = $fields_meta[0]->table
;
2250 if ($is_display['nav_bar'] == '1') {
2251 PMA_displayTableNavigation($pos_next, $pos_prev, $sql_query, 'top_direction_dropdown');
2253 } elseif (! isset($GLOBALS['printview']) ||
$GLOBALS['printview'] != '1') {
2254 echo "\n" . '<br /><br />' . "\n";
2257 // 2b ----- Get field references from Database -----
2258 // (see the 'relation' configuration variable)
2265 if (isset($analyzed_sql[0]['table_ref']) && is_array($analyzed_sql[0]['table_ref'])) {
2266 foreach ($analyzed_sql[0]['table_ref'] AS $table_ref_position => $table_ref) {
2267 $target[] = $analyzed_sql[0]['table_ref'][$table_ref_position]['table_true_name'];
2270 $tabs = '(\'' . join('\',\'', $target) . '\')';
2272 if (! strlen($table)) {
2275 // To be able to later display a link to the related table,
2276 // we verify both types of relations: either those that are
2277 // native foreign keys or those defined in the phpMyAdmin
2278 // configuration storage. If no PMA storage, we won't be able
2279 // to use the "column to display" notion (for example show
2280 // the name related to a numeric id).
2281 $exist_rel = PMA_getForeigners($db, $table, '', 'both');
2283 foreach ($exist_rel AS $master_field => $rel) {
2284 $display_field = PMA_getDisplayField($rel['foreign_db'], $rel['foreign_table']);
2285 $map[$master_field] = array($rel['foreign_table'],
2286 $rel['foreign_field'],
2288 $rel['foreign_db']);
2294 // 3. ----- Displays the results table -----
2295 PMA_displayTableHeaders($is_display, $fields_meta, $fields_cnt, $analyzed_sql, $sort_expression, $sort_expression_nodirection, $sort_direction);
2297 echo '<tbody>' . "\n";
2298 $clause_is_unique = PMA_displayTableBody($dt_result, $is_display, $map, $analyzed_sql);
2299 // vertical output case
2300 if ($_SESSION['tmp_user_values']['disp_direction'] == 'vertical') {
2301 PMA_displayVerticalTable();
2303 unset($vertical_display);
2304 echo '</tbody>' . "\n";
2309 // 4. ----- Displays the link for multi-fields edit and delete
2311 if ($is_display['del_lnk'] == 'dr' && $is_display['del_lnk'] != 'kp') {
2313 $delete_text = $is_display['del_lnk'] == 'dr' ?
__('Delete') : __('Kill');
2315 $_url_params = array(
2318 'sql_query' => $sql_query,
2321 $uncheckall_url = 'sql.php' . PMA_generate_common_url($_url_params);
2323 $_url_params['checkall'] = '1';
2324 $checkall_url = 'sql.php' . PMA_generate_common_url($_url_params);
2326 if ($_SESSION['tmp_user_values']['disp_direction'] == 'vertical') {
2327 $checkall_params['onclick'] = 'if (setCheckboxes(\'resultsForm\', true)) return false;';
2328 $uncheckall_params['onclick'] = 'if (setCheckboxes(\'resultsForm\', false)) return false;';
2330 $checkall_params['onclick'] = 'if (markAllRows(\'resultsForm\')) return false;';
2331 $uncheckall_params['onclick'] = 'if (unMarkAllRows(\'resultsForm\')) return false;';
2333 $checkall_link = PMA_linkOrButton($checkall_url, __('Check All'), $checkall_params, false);
2334 $uncheckall_link = PMA_linkOrButton($uncheckall_url, __('Uncheck All'), $uncheckall_params, false);
2335 if ($_SESSION['tmp_user_values']['disp_direction'] != 'vertical') {
2336 echo '<img class="selectallarrow" width="38" height="22"'
2337 .' src="' . $GLOBALS['pmaThemeImage'] . 'arrow_' . $GLOBALS['text_dir'] . '.png' . '"'
2338 .' alt="' . __('With selected:') . '" />';
2340 echo $checkall_link . "\n"
2342 .$uncheckall_link . "\n"
2343 .'<i>' . __('With selected:') . '</i>' . "\n";
2345 PMA_buttonOrImage('submit_mult', 'mult_submit',
2346 'submit_mult_change', __('Change'), 'b_edit.png', 'edit');
2347 PMA_buttonOrImage('submit_mult', 'mult_submit',
2348 'submit_mult_delete', $delete_text, 'b_drop.png', 'delete');
2349 if (isset($analyzed_sql[0]) && $analyzed_sql[0]['querytype'] == 'SELECT') {
2350 PMA_buttonOrImage('submit_mult', 'mult_submit',
2351 'submit_mult_export', __('Export'),
2352 'b_tblexport.png', 'export');
2356 echo '<input type="hidden" name="sql_query"'
2357 .' value="' . htmlspecialchars($sql_query) . '" />' . "\n";
2359 if (! empty($GLOBALS['url_query'])) {
2360 echo '<input type="hidden" name="url_query"'
2361 .' value="' . $GLOBALS['url_query'] . '" />' . "\n";
2364 echo '<input type="hidden" name="clause_is_unique"'
2365 .' value="' . $clause_is_unique . '" />' . "\n";
2367 echo '</form>' . "\n";
2370 // 5. ----- Displays the navigation bar at the bottom if required -----
2372 if ($is_display['nav_bar'] == '1') {
2373 echo '<br />' . "\n";
2374 PMA_displayTableNavigation($pos_next, $pos_prev, $sql_query, 'bottom_direction_dropdown');
2375 } elseif (! isset($GLOBALS['printview']) ||
$GLOBALS['printview'] != '1') {
2376 echo "\n" . '<br /><br />' . "\n";
2379 // 6. ----- Displays "Query results operations"
2380 if (! isset($GLOBALS['printview']) ||
$GLOBALS['printview'] != '1') {
2381 PMA_displayResultsOperations($the_disp_mode, $analyzed_sql);
2383 } // end of the 'PMA_displayTable()' function
2385 function default_function($buffer) {
2386 $buffer = htmlspecialchars($buffer);
2387 $buffer = str_replace("\011", ' ',
2388 str_replace(' ', ' ', $buffer));
2389 $buffer = preg_replace("@((\015\012)|(\015)|(\012))@", '<br />', $buffer);
2395 * Displays operations that are available on results.
2397 * @param array the display mode
2398 * @param array the analyzed query
2400 * @global string $db the database name
2401 * @global string $table the table name
2402 * @global string $sql_query the current SQL query
2403 * @global integer $unlim_num_rows the total number of rows returned by the
2404 * SQL query without any programmatically
2405 * appended "LIMIT" clause
2409 * @see PMA_showMessage(), PMA_setDisplayMode(),
2410 * PMA_displayTableNavigation(), PMA_displayTableHeaders(),
2411 * PMA_displayTableBody(), PMA_displayResultsOperations()
2413 function PMA_displayResultsOperations($the_disp_mode, $analyzed_sql) {
2414 global $db, $table, $sql_query, $unlim_num_rows, $fields_meta;
2416 $header_shown = false;
2417 $header = '<fieldset><legend>' . __('Query results operations') . '</legend>';
2419 if ($the_disp_mode[6] == '1' ||
$the_disp_mode[9] == '1') {
2420 // Displays "printable view" link if required
2421 if ($the_disp_mode[9] == '1') {
2423 if (!$header_shown) {
2425 $header_shown = true;
2428 $_url_params = array(
2432 'sql_query' => $sql_query,
2434 $url_query = PMA_generate_common_url($_url_params);
2436 echo PMA_linkOrButton(
2437 'sql.php' . $url_query,
2438 PMA_getIcon('b_print.png', __('Print view'), false, true),
2439 '', true, true, 'print_view') . "\n";
2441 if ($_SESSION['tmp_user_values']['display_text']) {
2442 $_url_params['display_text'] = 'F';
2443 echo PMA_linkOrButton(
2444 'sql.php' . PMA_generate_common_url($_url_params),
2445 PMA_getIcon('b_print.png', __('Print view (with full texts)'), false, true),
2446 '', true, true, 'print_view') . "\n";
2447 unset($_url_params['display_text']);
2449 } // end displays "printable view"
2453 // (the url_query has extra parameters that won't be used to export)
2454 // (the single_table parameter is used in display_export.lib.php
2455 // to hide the SQL and the structure export dialogs)
2456 // If the parser found a PROCEDURE clause
2457 // (most probably PROCEDURE ANALYSE()) it makes no sense to
2458 // display the Export link).
2459 if (isset($analyzed_sql[0]) && $analyzed_sql[0]['querytype'] == 'SELECT' && ! isset($printview) && ! isset($analyzed_sql[0]['queryflags']['procedure'])) {
2460 if (isset($analyzed_sql[0]['table_ref'][0]['table_true_name']) && ! isset($analyzed_sql[0]['table_ref'][1]['table_true_name'])) {
2461 $_url_params['single_table'] = 'true';
2463 if (!$header_shown) {
2465 $header_shown = true;
2467 $_url_params['unlim_num_rows'] = $unlim_num_rows;
2470 * At this point we don't know the table name; this can happen
2471 * for example with a query like
2472 * SELECT bike_code FROM (SELECT bike_code FROM bikes) tmp
2473 * As a workaround we set in the table parameter the name of the
2474 * first table of this database, so that tbl_export.php and
2475 * the script it calls do not fail
2477 if (empty($_url_params['table']) && !empty($_url_params['db'])) {
2478 $_url_params['table'] = PMA_DBI_fetch_value("SHOW TABLES");
2479 /* No result (probably no database selected) */
2480 if ($_url_params['table'] === FALSE) {
2481 unset($_url_params['table']);
2485 echo PMA_linkOrButton(
2486 'tbl_export.php' . PMA_generate_common_url($_url_params),
2487 PMA_getIcon('b_tblexport.png', __('Export'), false, true),
2488 '', true, true, '') . "\n";
2491 echo PMA_linkOrButton(
2492 'tbl_chart.php' . PMA_generate_common_url($_url_params),
2493 PMA_getIcon('b_chart.png', __('Display chart'), false, true),
2494 '', true, true, '') . "\n";
2497 $geometry_found = false;
2498 // If atleast one geometry field is found
2499 foreach ($fields_meta as $meta) {
2500 if ($meta->type
== 'geometry') {
2501 $geometry_found = true;
2505 if ($geometry_found) {
2506 echo PMA_linkOrButton(
2507 'tbl_gis_visualization.php' . PMA_generate_common_url($_url_params),
2508 PMA_getIcon('b_globe.gif', __('Visualize GIS data'), false, true),
2509 '', true, true, '') . "\n";
2516 * @todo detect privileges to create a view
2517 * (but see 2006-01-19 note in display_create_table.lib.php,
2518 * I think we cannot detect db-specific privileges reliably)
2519 * Note: we don't display a Create view link if we found a PROCEDURE clause
2521 if (!$header_shown) {
2523 $header_shown = true;
2525 if (! isset($analyzed_sql[0]['queryflags']['procedure'])) {
2526 echo PMA_linkOrButton(
2527 'view_create.php' . $url_query,
2528 PMA_getIcon('b_views.png', __('Create view'), false, true),
2529 '', true, true, '') . "\n";
2531 if ($header_shown) {
2532 echo '</fieldset><br />';
2537 * Verifies what to do with non-printable contents (binary or BLOB)
2540 * @param string $category BLOB|BINARY|GEOMETRY
2541 * @param string $content the binary content
2542 * @param string $transform_function
2543 * @param string $transform_options
2544 * @param string $default_function
2545 * @param object $meta the meta-information about this field
2546 * @return mixed string or float
2548 function PMA_handle_non_printable_contents($category, $content, $transform_function, $transform_options, $default_function, $meta, $url_params = array()) {
2549 $result = '[' . $category;
2550 if (is_null($content)) {
2551 $result .= ' - NULL';
2553 } elseif (isset($content)) {
2554 $size = strlen($content);
2555 $display_size = PMA_formatByteDown($size, 3, 1);
2556 $result .= ' - '. $display_size[0] . ' ' . $display_size[1];
2560 if (strpos($transform_function, 'octetstream')) {
2564 if ($default_function != $transform_function) {
2565 $result = $transform_function($result, $transform_options, $meta);
2567 $result = $default_function($result, array(), $meta);
2568 if (stristr($meta->type
, 'BLOB') && $_SESSION['tmp_user_values']['display_blob']) {
2569 // in this case, restart from the original $content
2570 $result = htmlspecialchars(PMA_replace_binary_contents($content));
2572 /* Create link to download */
2573 if (count($url_params) > 0) {
2574 $result = '<a href="tbl_get_field.php' . PMA_generate_common_url($url_params) . '">' . $result . '</a>';
2582 * Prepares the displayable content of a data cell in Browse mode,
2583 * taking into account foreign key description field and transformations
2585 * @param string $class
2586 * @param string $condition_field
2587 * @param string $analyzed_sql
2588 * @param object $meta the meta-information about this field
2589 * @param string $map
2590 * @param string $data
2591 * @param string $transform_function
2592 * @param string $default_function
2593 * @param string $nowrap
2594 * @param string $where_comparison
2595 * @param bool $is_field_truncated
2596 * @return string formatted data
2598 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 ) {
2600 $result = ' class="' . PMA_addClass($class, $condition_field, $meta, $nowrap, $is_field_truncated, $transform_function, $default_function) . '">';
2602 if (isset($analyzed_sql[0]['select_expr']) && is_array($analyzed_sql[0]['select_expr'])) {
2603 foreach ($analyzed_sql[0]['select_expr'] AS $select_expr_position => $select_expr) {
2604 $alias = $analyzed_sql[0]['select_expr'][$select_expr_position]['alias'];
2605 if (isset($alias) && strlen($alias)) {
2606 $true_column = $analyzed_sql[0]['select_expr'][$select_expr_position]['column'];
2607 if ($alias == $meta->name
) {
2608 // this change in the parameter does not matter
2609 // outside of the function
2610 $meta->name
= $true_column;
2616 if (isset($map[$meta->name
])) {
2617 // Field to display from the foreign table?
2618 if (isset($map[$meta->name
][2]) && strlen($map[$meta->name
][2])) {
2619 $dispsql = 'SELECT ' . PMA_backquote($map[$meta->name
][2])
2620 . ' FROM ' . PMA_backquote($map[$meta->name
][3])
2621 . '.' . PMA_backquote($map[$meta->name
][0])
2622 . ' WHERE ' . PMA_backquote($map[$meta->name
][1])
2623 . $where_comparison;
2624 $dispresult = PMA_DBI_try_query($dispsql, null, PMA_DBI_QUERY_STORE
);
2625 if ($dispresult && PMA_DBI_num_rows($dispresult) > 0) {
2626 list($dispval) = PMA_DBI_fetch_row($dispresult, 0);
2628 $dispval = __('Link not found');
2630 @PMA_DBI_free_result
($dispresult);
2633 } // end if... else...
2635 if (isset($GLOBALS['printview']) && $GLOBALS['printview'] == '1') {
2636 $result .= ($transform_function != $default_function ?
$transform_function($data, $transform_options, $meta) : $transform_function($data, array(), $meta)) . ' <code>[->' . $dispval . ']</code>';
2639 if ('K' == $_SESSION['tmp_user_values']['relational_display']) {
2640 // user chose "relational key" in the display options, so
2641 // the title contains the display field
2642 $title = (! empty($dispval))?
' title="' . htmlspecialchars($dispval) . '"' : '';
2644 $title = ' title="' . htmlspecialchars($data) . '"';
2647 $_url_params = array(
2648 'db' => $map[$meta->name
][3],
2649 'table' => $map[$meta->name
][0],
2651 'sql_query' => 'SELECT * FROM '
2652 . PMA_backquote($map[$meta->name
][3]) . '.' . PMA_backquote($map[$meta->name
][0])
2653 . ' WHERE ' . PMA_backquote($map[$meta->name
][1])
2654 . $where_comparison,
2656 $result .= '<a href="sql.php' . PMA_generate_common_url($_url_params)
2657 . '"' . $title . '>';
2659 if ($transform_function != $default_function) {
2660 // always apply a transformation on the real data,
2661 // not on the display field
2662 $result .= $transform_function($data, $transform_options, $meta);
2664 if ('D' == $_SESSION['tmp_user_values']['relational_display']) {
2665 // user chose "relational display field" in the
2666 // display options, so show display field in the cell
2667 $result .= $transform_function($dispval, array(), $meta);
2669 // otherwise display data in the cell
2670 $result .= $transform_function($data, array(), $meta);
2676 $result .= ($transform_function != $default_function ?
$transform_function($data, $transform_options, $meta) : $transform_function($data, array(), $meta));
2678 $result .= '</td>' . "\n";
2684 * Generates a checkbox for multi-row submits
2686 * @param string $del_url
2687 * @param array $is_display
2688 * @param string $row_no
2689 * @param string $where_clause_html
2690 * @param string $del_query
2691 * @param string $id_suffix
2692 * @param string $class
2693 * @return string the generated HTML
2696 function PMA_generateCheckboxForMulti($del_url, $is_display, $row_no, $where_clause_html, $del_query, $id_suffix, $class) {
2698 if (! empty($del_url) && $is_display['del_lnk'] != 'kp') {
2700 if (! empty($class)) {
2701 $ret .= 'class="' . $class . '"';
2703 $ret .= ' align="center">'
2704 . '<input type="checkbox" id="id_rows_to_delete' . $row_no . $id_suffix . '" name="rows_to_delete[' . $where_clause_html . ']"'
2705 . ' class="multi_checkbox"'
2706 . ' value="' . htmlspecialchars($del_query) . '" ' . (isset($GLOBALS['checkall']) ?
'checked="checked"' : '') . ' />'
2713 * Generates an Edit link
2715 * @param string $edit_url
2716 * @param string $class
2717 * @param string $edit_str
2718 * @param string $where_clause
2719 * @param string $where_clause_html
2720 * @return string the generated HTML
2722 function PMA_generateEditLink($edit_url, $class, $edit_str, $where_clause, $where_clause_html) {
2724 if (! empty($edit_url)) {
2725 $ret .= '<td class="' . $class . '" align="center" ' . ' ><span class="nowrap">'
2726 . PMA_linkOrButton($edit_url, $edit_str, array(), false);
2728 * Where clause for selecting this row uniquely is provided as
2729 * a hidden input. Used by jQuery scripts for handling inline editing
2731 if (! empty($where_clause)) {
2732 $ret .= '<input type="hidden" class="where_clause" value ="' . $where_clause_html . '" />';
2734 $ret .= '</span></td>';
2740 * Generates an Copy link
2742 * @param string $copy_url
2743 * @param string $copy_str
2744 * @param string $where_clause
2745 * @param string $where_clause_html
2746 * @return string the generated HTML
2748 function PMA_generateCopyLink($copy_url, $copy_str, $where_clause, $where_clause_html, $class) {
2750 if (! empty($copy_url)) {
2752 if (! empty($class)) {
2753 $ret .= 'class="' . $class . '" ';
2755 $ret .= 'align="center" ' . ' ><span class="nowrap">'
2756 . PMA_linkOrButton($copy_url, $copy_str, array(), false);
2758 * Where clause for selecting this row uniquely is provided as
2759 * a hidden input. Used by jQuery scripts for handling inline editing
2761 if (! empty($where_clause)) {
2762 $ret .= '<input type="hidden" class="where_clause" value ="' . $where_clause_html . '" />';
2764 $ret .= '</span></td>';
2770 * Generates a Delete link
2772 * @param string $del_url
2773 * @param string $del_str
2774 * @param string $js_conf
2775 * @param string $class
2776 * @return string the generated HTML
2778 function PMA_generateDeleteLink($del_url, $del_str, $js_conf, $class) {
2780 if (! empty($del_url)) {
2782 if (! empty($class)) {
2783 $ret .= 'class="' . $class . '" ';
2785 $ret .= 'align="center" ' . ' >'
2786 . PMA_linkOrButton($del_url, $del_str, $js_conf, false)
2793 * Generates checkbox and links at some position (left or right)
2794 * (only called for horizontal mode)
2796 * @param string $position
2797 * @param string $del_url
2798 * @param array $is_display
2799 * @param string $row_no
2800 * @param string $where_clause
2801 * @param string $where_clause_html
2802 * @param string $del_query
2803 * @param string $id_suffix
2804 * @param string $edit_url
2805 * @param string $copy_url
2806 * @param string $class
2807 * @param string $edit_str
2808 * @param string $del_str
2809 * @param string $js_conf
2810 * @return string the generated HTML
2812 function PMA_generateCheckboxAndLinks($position, $del_url, $is_display, $row_no, $where_clause, $where_clause_html, $del_query, $id_suffix, $edit_url, $copy_url, $class, $edit_str, $copy_str, $del_str, $js_conf) {
2815 if ($position == 'left') {
2816 $ret .= PMA_generateCheckboxForMulti($del_url, $is_display, $row_no, $where_clause_html, $del_query, $id_suffix='_left', '', '', '');
2818 $ret .= PMA_generateEditLink($edit_url, $class, $edit_str, $where_clause, $where_clause_html, '');
2820 $ret .= PMA_generateCopyLink($copy_url, $copy_str, $where_clause, $where_clause_html, '');
2822 $ret .= PMA_generateDeleteLink($del_url, $del_str, $js_conf, '', '');
2824 } elseif ($position == 'right') {
2825 $ret .= PMA_generateDeleteLink($del_url, $del_str, $js_conf, '', '');
2827 $ret .= PMA_generateCopyLink($copy_url, $copy_str, $where_clause, $where_clause_html, '');
2829 $ret .= PMA_generateEditLink($edit_url, $class, $edit_str, $where_clause, $where_clause_html, '');
2831 $ret .= PMA_generateCheckboxForMulti($del_url, $is_display, $row_no, $where_clause_html, $del_query, $id_suffix='_right', '', '', '');
2832 } else { // $position == 'none'
2833 $ret .= PMA_generateCheckboxForMulti($del_url, $is_display, $row_no, $where_clause_html, $del_query, $id_suffix='_left', '', '', '');