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 synthetic value for display_mode (see a few
32 * lines above for explanations)
33 * @param integer the total number of rows returned by the SQL query
34 * without any programmatically appended "LIMIT" clause
35 * (just a copy of $unlim_num_rows if it exists, else
36 * computed inside this function)
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 // 2.0 Print view -> set all elements to false!
74 if (isset($GLOBALS['printview']) && $GLOBALS['printview'] == '1') {
75 $do_display['edit_lnk'] = 'nn'; // no edit link
76 $do_display['del_lnk'] = 'nn'; // no delete link
77 $do_display['sort_lnk'] = (string) '0';
78 $do_display['nav_bar'] = (string) '0';
79 $do_display['ins_row'] = (string) '0';
80 $do_display['bkm_form'] = (string) '0';
81 $do_display['text_btn'] = (string) '0';
82 $do_display['pview_lnk'] = (string) '0';
84 // 2.1 Statement is a "SELECT COUNT", a
85 // "CHECK/ANALYZE/REPAIR/OPTIMIZE", an "EXPLAIN" one or
86 // contains a "PROC ANALYSE" part
87 elseif ($GLOBALS['is_count'] ||
$GLOBALS['is_analyse'] ||
$GLOBALS['is_maint'] ||
$GLOBALS['is_explain']) {
88 $do_display['edit_lnk'] = 'nn'; // no edit link
89 $do_display['del_lnk'] = 'nn'; // no delete link
90 $do_display['sort_lnk'] = (string) '0';
91 $do_display['nav_bar'] = (string) '0';
92 $do_display['ins_row'] = (string) '0';
93 $do_display['bkm_form'] = (string) '1';
94 if ($GLOBALS['is_maint']) {
95 $do_display['text_btn'] = (string) '1';
97 $do_display['text_btn'] = (string) '0';
99 $do_display['pview_lnk'] = (string) '1';
101 // 2.2 Statement is a "SHOW..."
102 elseif ($GLOBALS['is_show']) {
105 * @todo defines edit/delete links depending on show statement
107 $tmp = preg_match('@^SHOW[[:space:]]+(VARIABLES|(FULL[[:space:]]+)?PROCESSLIST|STATUS|TABLE|GRANTS|CREATE|LOGS|DATABASES|FIELDS)@i', $GLOBALS['sql_query'], $which);
108 if (isset($which[1]) && strpos(' ' . strtoupper($which[1]), 'PROCESSLIST') > 0) {
109 $do_display['edit_lnk'] = 'nn'; // no edit link
110 $do_display['del_lnk'] = 'kp'; // "kill process" type edit link
112 // Default case -> no links
113 $do_display['edit_lnk'] = 'nn'; // no edit link
114 $do_display['del_lnk'] = 'nn'; // no delete link
116 // 2.2.2 Other settings
117 $do_display['sort_lnk'] = (string) '0';
118 $do_display['nav_bar'] = (string) '0';
119 $do_display['ins_row'] = (string) '0';
120 $do_display['bkm_form'] = (string) '1';
121 $do_display['text_btn'] = (string) '1';
122 $do_display['pview_lnk'] = (string) '1';
124 // 2.3 Other statements (ie "SELECT" ones) -> updates
125 // $do_display['edit_lnk'], $do_display['del_lnk'] and
126 // $do_display['text_btn'] (keeps other default values)
128 $prev_table = $fields_meta[0]->table
;
129 $do_display['text_btn'] = (string) '1';
130 for ($i = 0; $i < $GLOBALS['fields_cnt']; $i++
) {
131 $is_link = ($do_display['edit_lnk'] != 'nn'
132 ||
$do_display['del_lnk'] != 'nn'
133 ||
$do_display['sort_lnk'] != '0'
134 ||
$do_display['ins_row'] != '0');
135 // 2.3.2 Displays edit/delete/sort/insert links?
137 && ($fields_meta[$i]->table
== '' ||
$fields_meta[$i]->table
!= $prev_table)) {
138 $do_display['edit_lnk'] = 'nn'; // don't display links
139 $do_display['del_lnk'] = 'nn';
141 * @todo May be problematic with same fields names in two joined table.
143 // $do_display['sort_lnk'] = (string) '0';
144 $do_display['ins_row'] = (string) '0';
145 if ($do_display['text_btn'] == '1') {
149 // 2.3.3 Always display print view link
150 $do_display['pview_lnk'] = (string) '1';
151 $prev_table = $fields_meta[$i]->table
;
153 } // end if..elseif...else (2.1 -> 2.3)
156 // 3. Gets the total number of rows if it is unknown
157 if (isset($unlim_num_rows) && $unlim_num_rows != '') {
158 $the_total = $unlim_num_rows;
159 } elseif (($do_display['nav_bar'] == '1' ||
$do_display['sort_lnk'] == '1')
160 && (strlen($db) && !empty($table))) {
161 $the_total = PMA_Table
::countRecords($db, $table);
164 // 4. If navigation bar or sorting fields names URLs should be
165 // displayed but there is only one row, change these settings to
167 if ($do_display['nav_bar'] == '1' ||
$do_display['sort_lnk'] == '1') {
169 // - Do not display sort links if less than 2 rows.
170 // - For a VIEW we (probably) did not count the number of rows
171 // so don't test this number here, it would remove the possibility
172 // of sorting VIEW results.
173 if (isset($unlim_num_rows) && $unlim_num_rows < 2 && ! PMA_Table
::isView($db, $table)) {
174 // force display of navbar for vertical/horizontal display-choice.
175 // $do_display['nav_bar'] = (string) '0';
176 $do_display['sort_lnk'] = (string) '0';
180 // 5. Updates the synthetic var
181 $the_disp_mode = join('', $do_display);
184 } // end of the 'PMA_setDisplayMode()' function
188 * Displays a navigation button
190 * @uses $GLOBALS['cfg']['NavigationBarIconic']
191 * @uses PMA_generate_common_hidden_inputs()
193 * @param string iconic caption for button
194 * @param string text for button
195 * @param integer position for next query
196 * @param string query ready for display
197 * @param string optional onsubmit clause
198 * @param string optional hidden field for special treatment
199 * @param string optional onclick clause
201 * @global string $db the database name
202 * @global string $table the table name
203 * @global string $goto the URL to go back in case of errors
207 * @see PMA_displayTableNavigation()
209 function PMA_displayTableNavigationOneButton($caption, $title, $pos, $html_sql_query, $onsubmit = '', $input_for_real_end = '', $onclick = '') {
211 global $db, $table, $goto;
213 $caption_output = '';
214 // for true or 'both'
215 if ($GLOBALS['cfg']['NavigationBarIconic']) {
216 $caption_output .= $caption;
218 // for false or 'both'
219 if (false === $GLOBALS['cfg']['NavigationBarIconic'] ||
'both' === $GLOBALS['cfg']['NavigationBarIconic']) {
220 $caption_output .= ' ' . $title;
222 $title_output = ' title="' . $title . '"';
225 <form action
="sql.php" method
="post" <?php
echo $onsubmit; ?
>>
226 <?php
echo PMA_generate_common_hidden_inputs($db, $table); ?
>
227 <input type
="hidden" name
="sql_query" value
="<?php echo $html_sql_query; ?>" />
228 <input type
="hidden" name
="pos" value
="<?php echo $pos; ?>" />
229 <input type
="hidden" name
="goto" value
="<?php echo $goto; ?>" />
230 <?php
echo $input_for_real_end; ?
>
231 <input type
="submit" name
="navig" value
="<?php echo $caption_output; ?>"<?php
echo $title_output . $onclick; ?
> />
235 } // end function PMA_displayTableNavigationOneButton()
238 * Displays a navigation bar to browse among the results of a SQL query
240 * @uses $_SESSION['tmp_user_values']['disp_direction']
241 * @uses $_SESSION['tmp_user_values']['repeat_cells']
242 * @uses $_SESSION['tmp_user_values']['max_rows']
243 * @uses $_SESSION['tmp_user_values']['pos']
244 * @param integer the offset for the "next" page
245 * @param integer the offset for the "previous" page
246 * @param string the URL-encoded query
247 * @param string the id for the direction dropdown
249 * @global string $db the database name
250 * @global string $table the table name
251 * @global string $goto the URL to go back in case of errors
252 * @global integer $num_rows the total number of rows returned by the
254 * @global integer $unlim_num_rows the total number of rows returned by the
255 * SQL any programmatically appended "LIMIT" clause
256 * @global boolean $is_innodb whether its InnoDB or not
257 * @global array $showtable table definitions
261 * @see PMA_displayTable()
263 function PMA_displayTableNavigation($pos_next, $pos_prev, $sql_query, $id_for_direction_dropdown)
265 global $db, $table, $goto;
266 global $num_rows, $unlim_num_rows;
270 // here, using htmlentities() would cause problems if the query
271 // contains accented characters
272 $html_sql_query = htmlspecialchars($sql_query);
275 * @todo move this to a central place
276 * @todo for other future table types
278 $is_innodb = (isset($showtable['Type']) && $showtable['Type'] == 'InnoDB');
282 <!-- Navigation bar
-->
283 <table border
="0" cellpadding
="2" cellspacing
="0">
286 // Move to the beginning or to the previous page
287 if ($_SESSION['tmp_user_values']['pos'] && $_SESSION['tmp_user_values']['max_rows'] != 'all') {
288 PMA_displayTableNavigationOneButton('<<', __('Begin'), 0, $html_sql_query);
289 PMA_displayTableNavigationOneButton('<', __('Previous'), $pos_prev, $html_sql_query);
297 <?php
// if displaying a VIEW, $unlim_num_rows could be zero because
298 // of $cfg['MaxExactCountViews']; in this case, avoid passing
299 // the 5th parameter to checkFormElementInRange()
300 // (this means we can't validate the upper limit ?>
301 <form action
="sql.php" method
="post"
302 onsubmit
="return (checkFormElementInRange(this, 'session_max_rows', '<?php echo str_replace('\'', '\\\'', __('%d is not valid row number.')); ?>', 1) && checkFormElementInRange(this, 'pos', '<?php echo str_replace('\'', '\\\'', __('%d is not valid row number.')); ?>', 0<?php echo $unlim_num_rows > 0 ? ',' . $unlim_num_rows - 1 : ''; ?>))">
303 <?php
echo PMA_generate_common_hidden_inputs($db, $table); ?
>
304 <input type
="hidden" name
="sql_query" value
="<?php echo $html_sql_query; ?>" />
305 <input type
="hidden" name
="goto" value
="<?php echo $goto; ?>" />
306 <input type
="submit" name
="navig" value
="<?php echo __('Show'); ?> :" />
307 <input type
="text" name
="session_max_rows" size
="3" value
="<?php echo (($_SESSION['tmp_user_values']['max_rows'] != 'all') ? $_SESSION['tmp_user_values']['max_rows'] : $GLOBALS['cfg']['MaxRows']); ?>" class="textfield" onfocus
="this.select()" />
308 <?php
echo __('row(s) starting from row #') . "\n"; ?
>
309 <input type
="text" name
="pos" size
="6" value
="<?php echo (($pos_next >= $unlim_num_rows) ? 0 : $pos_next); ?>" class="textfield" onfocus
="this.select()" />
312 // Display mode (horizontal/vertical and repeat headers)
314 'horizontal' => __('horizontal'),
315 'horizontalflipped' => __('horizontal (rotated headers)'),
316 'vertical' => __('vertical'));
317 $param1 = PMA_generate_html_dropdown('disp_direction', $choices, $_SESSION['tmp_user_values']['disp_direction'], $id_for_direction_dropdown);
320 $param2 = ' <input type="text" size="3" name="repeat_cells" value="' . $_SESSION['tmp_user_values']['repeat_cells'] . '" class="textfield" />' . "\n"
322 echo ' ' . sprintf(__('in %s mode and repeat headers after %s cells'), "\n" . $param1, "\n" . $param2) . "\n";
330 // Move to the next page or to the last one
331 if (($_SESSION['tmp_user_values']['pos'] +
$_SESSION['tmp_user_values']['max_rows'] < $unlim_num_rows) && $num_rows >= $_SESSION['tmp_user_values']['max_rows']
332 && $_SESSION['tmp_user_values']['max_rows'] != 'all') {
334 // display the Next button
335 PMA_displayTableNavigationOneButton('>',
340 // prepare some options for the End button
341 if ($is_innodb && $unlim_num_rows > $GLOBALS['cfg']['MaxExactCount']) {
342 $input_for_real_end = '<input id="real_end_input" type="hidden" name="find_real_end" value="1" />';
343 // no backquote around this message
346 $input_for_real_end = $onclick = '';
349 // display the End button
350 PMA_displayTableNavigationOneButton('>>',
352 @((ceil($unlim_num_rows / $_SESSION['tmp_user_values']['max_rows'])- 1) * $_SESSION['tmp_user_values']['max_rows']),
354 'onsubmit="return ' . (($_SESSION['tmp_user_values']['pos'] +
$_SESSION['tmp_user_values']['max_rows'] < $unlim_num_rows && $num_rows >= $_SESSION['tmp_user_values']['max_rows']) ?
'true' : 'false') . '"',
362 // (unless we are showing all records)
363 if ('all' != $_SESSION['tmp_user_values']['max_rows']) { //if1
364 $pageNow = @floor
($_SESSION['tmp_user_values']['pos'] / $_SESSION['tmp_user_values']['max_rows']) +
1;
365 $nbTotalPage = @ceil
($unlim_num_rows / $_SESSION['tmp_user_values']['max_rows']);
367 if ($nbTotalPage > 1){ //if2
373 <?php
//<form> for keep the form alignment of button < and << ?>
376 $_url_params = array(
379 'sql_query' => $sql_query,
382 echo PMA_pageselector(
383 'sql.php' . PMA_generate_common_url($_url_params) . PMA_get_arg_separator('js'),
384 $_SESSION['tmp_user_values']['max_rows'],
401 // Display the "Show all" button if allowed
402 if ($GLOBALS['cfg']['ShowAll'] && ($num_rows < $unlim_num_rows)) {
409 <form action
="sql.php" method
="post">
410 <?php
echo PMA_generate_common_hidden_inputs($db, $table); ?
>
411 <input type
="hidden" name
="sql_query" value
="<?php echo $html_sql_query; ?>" />
412 <input type
="hidden" name
="pos" value
="0" />
413 <input type
="hidden" name
="session_max_rows" value
="all" />
414 <input type
="hidden" name
="goto" value
="<?php echo $goto; ?>" />
415 <input type
="submit" name
="navig" value
="<?php echo __('Show all'); ?>" />
426 } // end of the 'PMA_displayTableNavigation()' function
430 * Displays the headers of the results table
432 * @uses $_SESSION['tmp_user_values']['disp_direction']
433 * @uses $_SESSION['tmp_user_values']['repeat_cells']
434 * @uses $_SESSION['tmp_user_values']['max_rows']
435 * @uses $_SESSION['tmp_user_values']['display_text']
436 * @uses $_SESSION['tmp_user_values']['display_binary']
437 * @uses $_SESSION['tmp_user_values']['display_binary_as_hex']
438 * @param array which elements to display
439 * @param array the list of fields properties
440 * @param integer the total number of fields returned by the SQL query
441 * @param array the analyzed query
443 * @return boolean $clause_is_unique
445 * @global string $db the database name
446 * @global string $table the table name
447 * @global string $goto the URL to go back in case of errors
448 * @global string $sql_query the SQL query
449 * @global integer $num_rows the total number of rows returned by the
451 * @global array $vertical_display informations used with vertical display
456 * @see PMA_displayTable()
458 function PMA_displayTableHeaders(&$is_display, &$fields_meta, $fields_cnt = 0, $analyzed_sql = '', $sort_expression, $sort_expression_nodirection, $sort_direction)
460 global $db, $table, $goto;
461 global $sql_query, $num_rows;
462 global $vertical_display, $highlight_columns;
464 if ($analyzed_sql == '') {
465 $analyzed_sql = array();
468 // can the result be sorted?
469 if ($is_display['sort_lnk'] == '1') {
472 $unsorted_sql_query = $sql_query;
473 if (isset($analyzed_sql[0]['unsorted_query'])) {
474 $unsorted_sql_query = $analyzed_sql[0]['unsorted_query'];
476 // Handles the case of multiple clicks on a column's header
477 // which would add many spaces before "ORDER BY" in the
479 $unsorted_sql_query = trim($unsorted_sql_query);
481 // sorting by indexes, only if it makes sense (only one table ref)
482 if (isset($analyzed_sql) && isset($analyzed_sql[0]) &&
483 isset($analyzed_sql[0]['querytype']) && $analyzed_sql[0]['querytype'] == 'SELECT' &&
484 isset($analyzed_sql[0]['table_ref']) && count($analyzed_sql[0]['table_ref']) == 1) {
486 // grab indexes data:
487 $indexes = PMA_Index
::getFromTable($table, $db);
489 // do we have any index?
492 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
493 ||
$_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
495 if ($is_display['edit_lnk'] != 'nn') {
498 if ($is_display['del_lnk'] != 'nn') {
501 if ($is_display['del_lnk'] != 'kp' && $is_display['del_lnk'] != 'nn') {
505 $span = $num_rows +
floor($num_rows/$_SESSION['tmp_user_values']['repeat_cells']) +
1;
508 echo '<form action="sql.php" method="post">' . "\n";
509 echo PMA_generate_common_hidden_inputs($db, $table);
510 echo __('Sort by key') . ': <select name="sql_query" onchange="this.form.submit();">' . "\n";
512 $local_order = (isset($sort_expression) ?
$sort_expression : '');
513 foreach ($indexes as $index) {
514 $asc_sort = '`' . implode('` ASC, `', array_keys($index->getColumns())) . '` ASC';
515 $desc_sort = '`' . implode('` DESC, `', array_keys($index->getColumns())) . '` DESC';
516 $used_index = $used_index ||
$local_order == $asc_sort ||
$local_order == $desc_sort;
517 echo '<option value="'
518 . htmlspecialchars($unsorted_sql_query . ' ORDER BY ' . $asc_sort)
519 . '"' . ($local_order == $asc_sort ?
' selected="selected"' : '')
520 . '>' . htmlspecialchars($index->getName()) . ' ('
521 . __('Ascending') . ')</option>';
522 echo '<option value="'
523 . htmlspecialchars($unsorted_sql_query . ' ORDER BY ' . $desc_sort)
524 . '"' . ($local_order == $desc_sort ?
' selected="selected"' : '')
525 . '>' . htmlspecialchars($index->getName()) . ' ('
526 . __('Descending') . ')</option>';
528 echo '<option value="' . htmlspecialchars($unsorted_sql_query) . '"' . ($used_index ?
'' : ' selected="selected"') . '>' . __('None') . '</option>';
529 echo '</select>' . "\n";
530 echo '<noscript><input type="submit" value="' . __('Go') . '" /></noscript>';
531 echo '</form>' . "\n";
537 $vertical_display['emptypre'] = 0;
538 $vertical_display['emptyafter'] = 0;
539 $vertical_display['textbtn'] = '';
541 // Display options (if we are not in print view)
542 if (! (isset($GLOBALS['printview']) && $GLOBALS['printview'] == '1')) {
543 echo '<form method="post" action="sql.php" name="displayOptionsForm" id="displayOptionsForm">';
547 'sql_query' => $sql_query,
549 'display_options_form' => 1
551 echo PMA_generate_common_hidden_inputs($url_params);
553 PMA_generate_slider_effect('displayoptions',__('Options'));
556 echo '<div class="formelement">';
558 'P' => __('Partial Texts'),
559 'F' => __('Full Texts')
561 PMA_display_html_radio('display_text', $choices, $_SESSION['tmp_user_values']['display_text']);
564 // prepare full/partial text button or link
565 if ($_SESSION['tmp_user_values']['display_text']=='F') {
566 // currently in fulltext mode so show the opposite link
567 $tmp_image_file = $GLOBALS['pmaThemeImage'] . 's_partialtext.png';
568 $tmp_txt = __('Partial Texts');
569 $url_params['display_text'] = 'P';
571 $tmp_image_file = $GLOBALS['pmaThemeImage'] . 's_fulltext.png';
572 $tmp_txt = __('Full Texts');
573 $url_params['display_text'] = 'F';
576 $tmp_image = '<img class="fulltext" width="50" height="20" src="' . $tmp_image_file . '" alt="' . $tmp_txt . '" title="' . $tmp_txt . '" />';
577 $tmp_url = 'sql.php' . PMA_generate_common_url($url_params);
578 $full_or_partial_text_link = PMA_linkOrButton($tmp_url, $tmp_image, array(), false);
579 unset($tmp_image_file, $tmp_txt, $tmp_url, $tmp_image);
582 if ($GLOBALS['cfgRelation']['relwork'] && $GLOBALS['cfgRelation']['displaywork']) {
583 echo '<div class="formelement">';
585 'K' => __('Relational key'),
586 'D' => __('Relational display column')
588 PMA_display_html_radio('relational_display', $choices, $_SESSION['tmp_user_values']['relational_display']);
592 echo '<div class="formelement">';
593 PMA_display_html_checkbox('display_binary', __('Show binary contents'), ! empty($_SESSION['tmp_user_values']['display_binary']), false);
595 PMA_display_html_checkbox('display_blob', __('Show BLOB contents'), ! empty($_SESSION['tmp_user_values']['display_blob']), false);
597 PMA_display_html_checkbox('display_binary_as_hex', __('Show binary contents as HEX'), ! empty($_SESSION['tmp_user_values']['display_binary_as_hex']), false);
600 // I would have preferred to name this "display_transformation".
601 // This is the only way I found to be able to keep this setting sticky
602 // per SQL query, and at the same time have a default that displays
603 // the transformations.
604 echo '<div class="formelement">';
605 PMA_display_html_checkbox('hide_transformation', __('Hide') . ' ' . __('Browser transformation'), ! empty($_SESSION['tmp_user_values']['hide_transformation']), false);
608 echo '<div class="clearfloat"></div>';
611 echo '<fieldset class="tblFooters">';
612 echo '<input type="submit" value="' . __('Go') . '" />';
618 // Start of form for multi-rows edit/delete/export
620 if ($is_display['del_lnk'] == 'dr' ||
$is_display['del_lnk'] == 'kp') {
621 echo '<form method="post" action="tbl_row_action.php" name="rowsDeleteForm" id="rowsDeleteForm">' . "\n";
622 echo PMA_generate_common_hidden_inputs($db, $table, 1);
623 echo '<input type="hidden" name="goto" value="sql.php" />' . "\n";
626 echo '<table id="table_results" class="data">' . "\n";
627 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
628 ||
$_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
629 echo '<thead><tr>' . "\n";
632 // 1. Displays the full/partial text button (part 1)...
633 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
634 ||
$_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
635 $colspan = ($is_display['edit_lnk'] != 'nn' && $is_display['del_lnk'] != 'nn')
639 $rowspan = ($is_display['edit_lnk'] != 'nn' && $is_display['del_lnk'] != 'nn')
644 // ... before the result table
645 if (($is_display['edit_lnk'] == 'nn' && $is_display['del_lnk'] == 'nn')
646 && $is_display['text_btn'] == '1') {
647 $vertical_display['emptypre'] = ($is_display['edit_lnk'] != 'nn' && $is_display['del_lnk'] != 'nn') ?
3 : 0;
648 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
649 ||
$_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
651 <th colspan
="<?php echo $fields_cnt; ?>"></th
>
655 } // end horizontal/horizontalflipped mode
659 <th colspan
="<?php echo $num_rows + floor($num_rows/$_SESSION['tmp_user_values']['repeat_cells']) + 1; ?>"></th
>
662 } // end vertical mode
665 // ... at the left column of the result table header if possible
667 elseif ($GLOBALS['cfg']['ModifyDeleteAtLeft'] && $is_display['text_btn'] == '1') {
668 $vertical_display['emptypre'] = ($is_display['edit_lnk'] != 'nn' && $is_display['del_lnk'] != 'nn') ?
3 : 0;
669 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
670 ||
$_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
672 <th
<?php
echo $colspan; ?
>><?php
echo $full_or_partial_text_link;?
></th
>
674 } // end horizontal/horizontalflipped mode
676 $vertical_display['textbtn'] = ' <th ' . $rowspan . ' valign="middle">' . "\n"
679 } // end vertical mode
682 // ... elseif no button, displays empty(ies) col(s) if required
683 elseif ($GLOBALS['cfg']['ModifyDeleteAtLeft']
684 && ($is_display['edit_lnk'] != 'nn' ||
$is_display['del_lnk'] != 'nn')) {
685 $vertical_display['emptypre'] = ($is_display['edit_lnk'] != 'nn' && $is_display['del_lnk'] != 'nn') ?
3 : 0;
686 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
687 ||
$_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
689 <td
<?php
echo $colspan; ?
>></td
>
691 } // end horizontal/horizontalfipped mode
693 $vertical_display['textbtn'] = ' <td' . $rowspan . '></td>' . "\n";
694 } // end vertical mode
697 // 2. Displays the fields' name
698 // 2.0 If sorting links should be used, checks if the query is a "JOIN"
699 // statement (see 2.1.3)
701 // 2.0.1 Prepare Display column comments if enabled ($GLOBALS['cfg']['ShowBrowseComments']).
702 // Do not show comments, if using horizontalflipped mode, because of space usage
703 if ($GLOBALS['cfg']['ShowBrowseComments']
704 && $_SESSION['tmp_user_values']['disp_direction'] != 'horizontalflipped') {
705 $comments_map = array();
706 if (isset($analyzed_sql[0]) && is_array($analyzed_sql[0])) {
707 foreach ($analyzed_sql[0]['table_ref'] as $tbl) {
708 $tb = $tbl['table_true_name'];
709 $comments_map[$tb] = PMA_getComments($db, $tb);
715 if ($GLOBALS['cfgRelation']['commwork'] && $GLOBALS['cfgRelation']['mimework'] && $GLOBALS['cfg']['BrowseMIME'] && ! $_SESSION['tmp_user_values']['hide_transformation']) {
716 require_once './libraries/transformations.lib.php';
717 $GLOBALS['mime_map'] = PMA_getMIME($db, $table);
720 // See if we have to highlight any header fields of a WHERE query.
721 // Uses SQL-Parser results.
722 $highlight_columns = array();
723 if (isset($analyzed_sql) && isset($analyzed_sql[0]) &&
724 isset($analyzed_sql[0]['where_clause_identifiers'])) {
727 if (isset($analyzed_sql[0]['where_clause_identifiers']) && is_array($analyzed_sql[0]['where_clause_identifiers'])) {
728 foreach ($analyzed_sql[0]['where_clause_identifiers'] AS $wci_nr => $wci) {
729 $highlight_columns[$wci] = 'true';
734 for ($i = 0; $i < $fields_cnt; $i++
) {
735 // See if this column should get highlight because it's used in the
737 if (isset($highlight_columns[$fields_meta[$i]->name
]) ||
isset($highlight_columns[PMA_backquote($fields_meta[$i]->name
)])) {
738 $condition_field = true;
740 $condition_field = false;
743 // 2.0 Prepare comment-HTML-wrappers for each row, if defined/enabled.
744 if (isset($comments_map) &&
745 isset($comments_map[$fields_meta[$i]->table
]) &&
746 isset($comments_map[$fields_meta[$i]->table
][$fields_meta[$i]->name
])) {
747 $comments = '<span class="tblcomment">' . htmlspecialchars($comments_map[$fields_meta[$i]->table
][$fields_meta[$i]->name
]) . '</span>';
752 // 2.1 Results can be sorted
753 if ($is_display['sort_lnk'] == '1') {
755 // 2.1.1 Checks if the table name is required; it's the case
756 // for a query with a "JOIN" statement and if the column
757 // isn't aliased, or in queries like
758 // SELECT `1`.`master_field` , `2`.`master_field`
759 // FROM `PMA_relation` AS `1` , `PMA_relation` AS `2`
761 if (isset($fields_meta[$i]->table
) && strlen($fields_meta[$i]->table
)) {
762 $sort_tbl = PMA_backquote($fields_meta[$i]->table
) . '.';
767 // 2.1.2 Checks if the current column is used to sort the
769 // the orgname member does not exist for all MySQL versions
770 // but if found, it's the one on which to sort
771 $name_to_use_in_sort = $fields_meta[$i]->name
;
772 if (isset($fields_meta[$i]->orgname
) && strlen($fields_meta[$i]->orgname
)) {
773 $name_to_use_in_sort = $fields_meta[$i]->orgname
;
775 // $name_to_use_in_sort might contain a space due to
776 // formatting of function expressions like "COUNT(name )"
777 // so we remove the space in this situation
778 $name_to_use_in_sort = str_replace(' )', ')', $name_to_use_in_sort);
780 if (empty($sort_expression)) {
783 // Field name may be preceded by a space, or any number
784 // of characters followed by a dot (tablename.fieldname)
785 // so do a direct comparison for the sort expression;
786 // this avoids problems with queries like
787 // "SELECT id, count(id)..." and clicking to sort
788 // on id or on count(id).
789 // Another query to test this:
790 // SELECT p.*, FROM_UNIXTIME(p.temps) FROM mytable AS p
791 // (and try clicking on each column's header twice)
792 if (! empty($sort_tbl) && strpos($sort_expression_nodirection, $sort_tbl) === false && strpos($sort_expression_nodirection, '(') === false) {
793 $sort_expression_nodirection = $sort_tbl . $sort_expression_nodirection;
795 $is_in_sort = (str_replace('`', '', $sort_tbl) . $name_to_use_in_sort == str_replace('`', '', $sort_expression_nodirection) ?
true : false);
797 // 2.1.3 Check the field name for a bracket.
798 // If it contains one, it's probably a function column
799 // like 'COUNT(`field`)'
800 if (strpos($name_to_use_in_sort, '(') !== false) {
801 $sort_order = ' ORDER BY ' . $name_to_use_in_sort . ' ';
803 $sort_order = ' ORDER BY ' . $sort_tbl . PMA_backquote($name_to_use_in_sort) . ' ';
805 unset($name_to_use_in_sort);
807 // 2.1.4 Do define the sorting URL
809 // patch #455484 ("Smart" order)
810 $GLOBALS['cfg']['Order'] = strtoupper($GLOBALS['cfg']['Order']);
811 if ($GLOBALS['cfg']['Order'] === 'SMART') {
812 $sort_order .= (preg_match('@time|date@i', $fields_meta[$i]->type
)) ?
'DESC' : 'ASC';
814 $sort_order .= $GLOBALS['cfg']['Order'];
817 } elseif ('DESC' == $sort_direction) {
818 $sort_order .= ' ASC';
819 $order_img = ' <img class="icon" src="' . $GLOBALS['pmaThemeImage'] . 's_desc.png" width="11" height="9" alt="'. __('Descending') . '" title="'. __('Descending') . '" id="soimg' . $i . '" />';
821 $sort_order .= ' DESC';
822 $order_img = ' <img class="icon" src="' . $GLOBALS['pmaThemeImage'] . 's_asc.png" width="11" height="9" alt="'. __('Ascending') . '" title="'. __('Ascending') . '" id="soimg' . $i . '" />';
825 if (preg_match('@(.*)([[:space:]](LIMIT (.*)|PROCEDURE (.*)|FOR UPDATE|LOCK IN SHARE MODE))@i', $unsorted_sql_query, $regs3)) {
826 $sorted_sql_query = $regs3[1] . $sort_order . $regs3[2];
828 $sorted_sql_query = $unsorted_sql_query . $sort_order;
830 $_url_params = array(
833 'sql_query' => $sorted_sql_query,
835 $order_url = 'sql.php' . PMA_generate_common_url($_url_params);
837 // 2.1.5 Displays the sorting URL
838 // enable sort order swapping for image
839 $order_link_params = array();
840 if (isset($order_img) && $order_img!='') {
841 if (strstr($order_img, 'asc')) {
842 $order_link_params['onmouseover'] = 'if(document.getElementById(\'soimg' . $i . '\')){ document.getElementById(\'soimg' . $i . '\').src=\'' . $GLOBALS['pmaThemeImage'] . 's_desc.png\'; }';
843 $order_link_params['onmouseout'] = 'if(document.getElementById(\'soimg' . $i . '\')){ document.getElementById(\'soimg' . $i . '\').src=\'' . $GLOBALS['pmaThemeImage'] . 's_asc.png\'; }';
844 } elseif (strstr($order_img, 'desc')) {
845 $order_link_params['onmouseover'] = 'if(document.getElementById(\'soimg' . $i . '\')){ document.getElementById(\'soimg' . $i . '\').src=\'' . $GLOBALS['pmaThemeImage'] . 's_asc.png\'; }';
846 $order_link_params['onmouseout'] = 'if(document.getElementById(\'soimg' . $i . '\')){ document.getElementById(\'soimg' . $i . '\').src=\'' . $GLOBALS['pmaThemeImage'] . 's_desc.png\'; }';
849 if ($GLOBALS['cfg']['HeaderFlipType'] == 'auto') {
850 if (PMA_USR_BROWSER_AGENT
== 'IE') {
851 $GLOBALS['cfg']['HeaderFlipType'] = 'css';
853 $GLOBALS['cfg']['HeaderFlipType'] = 'fake';
856 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped'
857 && $GLOBALS['cfg']['HeaderFlipType'] == 'css') {
858 $order_link_params['style'] = 'direction: ltr; writing-mode: tb-rl;';
860 $order_link_params['title'] = __('Sort');
861 $order_link_content = ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped' && $GLOBALS['cfg']['HeaderFlipType'] == 'fake' ?
PMA_flipstring(htmlspecialchars($fields_meta[$i]->name
), "<br />\n") : htmlspecialchars($fields_meta[$i]->name
));
862 $order_link = PMA_linkOrButton($order_url, $order_link_content . $order_img, $order_link_params, false, true);
864 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
865 ||
$_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
867 if ($condition_field) {
868 echo ' class="condition"';
870 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
871 echo ' valign="bottom"';
873 echo '>' . $order_link . $comments . '</th>';
875 $vertical_display['desc'][] = ' <th '
876 . ($condition_field ?
' class="condition"' : '') . '>' . "\n"
877 . $order_link . $comments . ' </th>' . "\n";
880 // 2.2 Results can't be sorted
882 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
883 ||
$_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
885 if ($condition_field) {
886 echo ' class="condition"';
888 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
889 echo ' valign="bottom"';
891 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped'
892 && $GLOBALS['cfg']['HeaderFlipType'] == 'css') {
893 echo ' style="direction: ltr; writing-mode: tb-rl;"';
896 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped'
897 && $GLOBALS['cfg']['HeaderFlipType'] == 'fake') {
898 echo PMA_flipstring(htmlspecialchars($fields_meta[$i]->name
), '<br />');
900 echo htmlspecialchars($fields_meta[$i]->name
);
902 echo "\n" . $comments . '</th>';
904 $vertical_display['desc'][] = ' <th '
905 . ($condition_field ?
' class="condition"' : '') . '>' . "\n"
906 . ' ' . htmlspecialchars($fields_meta[$i]->name
) . "\n"
907 . $comments . ' </th>';
911 // 3. Displays the needed checkboxes at the right
912 // column of the result table header if possible and required...
913 if ($GLOBALS['cfg']['ModifyDeleteAtRight']
914 && ($is_display['edit_lnk'] != 'nn' ||
$is_display['del_lnk'] != 'nn')
915 && $is_display['text_btn'] == '1') {
916 $vertical_display['emptyafter'] = ($is_display['edit_lnk'] != 'nn' && $is_display['del_lnk'] != 'nn') ?
3 : 1;
917 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
918 ||
$_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
921 <th
<?php
echo $colspan; ?
>><?php
echo $full_or_partial_text_link;?
>
924 } // end horizontal/horizontalflipped mode
926 $vertical_display['textbtn'] = ' <th ' . $rowspan . ' valign="middle">' . "\n"
929 } // end vertical mode
932 // ... elseif no button, displays empty columns if required
933 // (unless coming from Browse mode print view)
934 elseif ($GLOBALS['cfg']['ModifyDeleteAtRight']
935 && ($is_display['edit_lnk'] == 'nn' && $is_display['del_lnk'] == 'nn')
936 && (!$GLOBALS['is_header_sent'])) {
937 $vertical_display['emptyafter'] = ($is_display['edit_lnk'] != 'nn' && $is_display['del_lnk'] != 'nn') ?
3 : 1;
938 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
939 ||
$_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
942 <td
<?php
echo $colspan; ?
>></td
>
944 } // end horizontal/horizontalflipped mode
946 $vertical_display['textbtn'] = ' <td' . $rowspan . '></td>' . "\n";
947 } // end vertical mode
950 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
951 ||
$_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
959 } // end of the 'PMA_displayTableHeaders()' function
964 * Displays the body of the results table
966 * @uses $_SESSION['tmp_user_values']['disp_direction']
967 * @uses $_SESSION['tmp_user_values']['repeat_cells']
968 * @uses $_SESSION['tmp_user_values']['max_rows']
969 * @uses $_SESSION['tmp_user_values']['display_text']
970 * @uses $_SESSION['tmp_user_values']['display_binary']
971 * @uses $_SESSION['tmp_user_values']['display_binary_as_hex']
972 * @uses $_SESSION['tmp_user_values']['display_blob']
973 * @param integer the link id associated to the query which results have
975 * @param array which elements to display
976 * @param array the list of relations
977 * @param array the analyzed query
979 * @return boolean always true
981 * @global string $db the database name
982 * @global string $table the table name
983 * @global string $goto the URL to go back in case of errors
984 * @global string $sql_query the SQL query
985 * @global array $fields_meta the list of fields properties
986 * @global integer $fields_cnt the total number of fields returned by
988 * @global array $vertical_display informations used with vertical display
990 * @global array $highlight_columns column names to highlight
991 * @global array $row current row data
995 * @see PMA_displayTable()
997 function PMA_displayTableBody(&$dt_result, &$is_display, $map, $analyzed_sql) {
998 global $db, $table, $goto;
999 global $sql_query, $fields_meta, $fields_cnt;
1000 global $vertical_display, $highlight_columns;
1001 global $row; // mostly because of browser transformations, to make the row-data accessible in a plugin
1003 $url_sql_query = $sql_query;
1005 // query without conditions to shorten URLs when needed, 200 is just
1006 // guess, it should depend on remaining URL length
1008 if (isset($analyzed_sql) && isset($analyzed_sql[0]) &&
1009 isset($analyzed_sql[0]['querytype']) && $analyzed_sql[0]['querytype'] == 'SELECT' &&
1010 strlen($sql_query) > 200) {
1012 $url_sql_query = 'SELECT ';
1013 if (isset($analyzed_sql[0]['queryflags']['distinct'])) {
1014 $url_sql_query .= ' DISTINCT ';
1016 $url_sql_query .= $analyzed_sql[0]['select_expr_clause'];
1017 if (!empty($analyzed_sql[0]['from_clause'])) {
1018 $url_sql_query .= ' FROM ' . $analyzed_sql[0]['from_clause'];
1022 if (!is_array($map)) {
1026 $vertical_display['edit'] = array();
1027 $vertical_display['delete'] = array();
1028 $vertical_display['data'] = array();
1029 $vertical_display['row_delete'] = array();
1030 // name of the class added to all inline editable elements
1031 $data_inline_edit_class = 'data_inline_edit';
1033 // Correction University of Virginia 19991216 in the while below
1034 // Previous code assumed that all tables have keys, specifically that
1035 // the phpMyAdmin GUI should support row delete/edit only for such
1037 // Although always using keys is arguably the prescribed way of
1038 // defining a relational table, it is not required. This will in
1039 // particular be violated by the novice.
1040 // We want to encourage phpMyAdmin usage by such novices. So the code
1041 // below has been changed to conditionally work as before when the
1042 // table being displayed has one or more keys; but to display
1043 // delete/edit options correctly for tables without keys.
1046 while ($row = PMA_DBI_fetch_row($dt_result)) {
1047 // "vertical display" mode stuff
1048 if ($row_no != 0 && $_SESSION['tmp_user_values']['repeat_cells'] != 0 && !($row_no %
$_SESSION['tmp_user_values']['repeat_cells'])
1049 && ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
1050 ||
$_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped'))
1053 if ($vertical_display['emptypre'] > 0) {
1054 echo ' <th colspan="' . $vertical_display['emptypre'] . '">' . "\n"
1055 .' </th>' . "\n";
1058 foreach ($vertical_display['desc'] as $val) {
1062 if ($vertical_display['emptyafter'] > 0) {
1063 echo ' <th colspan="' . $vertical_display['emptyafter'] . '">' . "\n"
1064 .' </th>' . "\n";
1066 echo '</tr>' . "\n";
1069 $class = $odd_row ?
'odd' : 'even';
1070 $odd_row = ! $odd_row;
1071 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
1072 ||
$_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
1073 // pointer code part
1074 echo ' <tr class="' . $class . '">' . "\n";
1078 // 1. Prepares the row
1079 // 1.1 Results from a "SELECT" statement -> builds the
1080 // WHERE clause to use in links (a unique key if possible)
1082 * @todo $where_clause could be empty, for example a table
1083 * with only one field and it's a BLOB; in this case,
1084 * avoid to display the delete and edit links
1086 list($where_clause, $clause_is_unique) = PMA_getUniqueCondition($dt_result, $fields_cnt, $fields_meta, $row);
1087 $where_clause_html = urlencode($where_clause);
1089 // 1.2 Defines the URLs for the modify/delete link(s)
1091 if ($is_display['edit_lnk'] != 'nn' ||
$is_display['del_lnk'] != 'nn') {
1092 // We need to copy the value or else the == 'both' check will always return true
1094 if ($GLOBALS['cfg']['PropertiesIconic'] === 'both') {
1095 $iconic_spacer = '<div class="nowrap">';
1097 $iconic_spacer = '';
1100 // 1.2.1 Modify link(s)
1101 if ($is_display['edit_lnk'] == 'ur') { // update row case
1102 $_url_params = array(
1105 'where_clause' => $where_clause,
1106 'clause_is_unique' => $clause_is_unique,
1107 'sql_query' => $url_sql_query,
1108 'goto' => 'sql.php',
1110 $edit_url = 'tbl_change.php' . PMA_generate_common_url($_url_params);
1112 $edit_str = PMA_getIcon('b_edit.png', __('Edit'), true);
1114 // Class definitions required for inline editing jQuery scripts
1115 $edit_anchor_class = "edit_row_anchor";
1116 if( $clause_is_unique == 0) {
1117 $edit_anchor_class .= ' nonunique';
1121 if (isset($GLOBALS['cfg']['Bookmark']['table']) && isset($GLOBALS['cfg']['Bookmark']['db']) && $table == $GLOBALS['cfg']['Bookmark']['table'] && $db == $GLOBALS['cfg']['Bookmark']['db'] && isset($row[1]) && isset($row[0])) {
1122 $_url_params = array(
1124 'id_bookmark' => $row[0],
1125 'action_bookmark' => '0',
1126 'action_bookmark_all' => '1',
1127 'SQL' => __('Execute bookmarked query'),
1129 $bookmark_go = '<a href="import.php'
1130 . PMA_generate_common_url($_url_params)
1131 .' " title="' . __('Execute bookmarked query') . '">';
1133 $bookmark_go .= PMA_getIcon('b_bookmark.png', __('Execute bookmarked query'), true);
1135 $bookmark_go .= '</a>';
1140 // 1.2.2 Delete/Kill link(s)
1141 if ($is_display['del_lnk'] == 'dr') { // delete row case
1142 $_url_params = array(
1145 'sql_query' => $url_sql_query,
1146 'message_to_show' => __('The row has been deleted'),
1147 'goto' => (empty($goto) ?
'tbl_sql.php' : $goto),
1149 $lnk_goto = 'sql.php' . PMA_generate_common_url($_url_params, 'text');
1151 $del_query = 'DELETE FROM ' . PMA_backquote($db) . '.' . PMA_backquote($table)
1152 . ' WHERE ' . $where_clause . ($clause_is_unique ?
'' : ' LIMIT 1');
1154 $_url_params = array(
1157 'sql_query' => $del_query,
1158 'message_to_show' => __('The row has been deleted'),
1159 'goto' => $lnk_goto,
1161 $del_url = 'sql.php' . PMA_generate_common_url($_url_params);
1163 $js_conf = 'DELETE FROM ' . PMA_jsFormat($db) . '.' . PMA_jsFormat($table)
1164 . ' WHERE ' . PMA_jsFormat($where_clause, false)
1165 . ($clause_is_unique ?
'' : ' LIMIT 1');
1166 $del_str = PMA_getIcon('b_drop.png', __('Delete'), true);
1167 } elseif ($is_display['del_lnk'] == 'kp') { // kill process case
1169 $_url_params = array(
1172 'sql_query' => $url_sql_query,
1173 'goto' => 'main.php',
1175 $lnk_goto = 'sql.php' . PMA_generate_common_url($_url_params, 'text');
1177 $_url_params = array(
1179 'sql_query' => 'KILL ' . $row[0],
1180 'goto' => $lnk_goto,
1182 $del_url = 'sql.php' . PMA_generate_common_url($_url_params);
1183 $del_query = 'KILL ' . $row[0];
1184 $js_conf = 'KILL ' . $row[0];
1185 $del_str = PMA_getIcon('b_drop.png', __('Kill'), true);
1188 // 1.3 Displays the links at left if required
1189 if ($GLOBALS['cfg']['ModifyDeleteAtLeft']
1190 && ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
1191 ||
$_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped')) {
1192 $doWriteModifyAt = 'left';
1193 require './libraries/display_tbl_links.lib.php';
1197 // 2. Displays the rows' values
1198 for ($i = 0; $i < $fields_cnt; ++
$i) {
1199 $meta = $fields_meta[$i];
1201 $is_field_truncated = false;
1202 //If the previous column had blob data, we need to reset the class
1203 // to $data_inline_edit_class
1204 $class = $data_inline_edit_class;
1205 //If this column's value is null, add the null class to it, needed
1206 //for inline editing
1207 if(is_null($row[$i])) {
1211 // See if this column should get highlight because it's used in the
1213 if (isset($highlight_columns) && (isset($highlight_columns[$meta->name
]) ||
isset($highlight_columns[PMA_backquote($meta->name
)]))) {
1214 $condition_field = true;
1216 $condition_field = false;
1220 if ($_SESSION['tmp_user_values']['disp_direction'] == 'vertical' && (!isset($GLOBALS['printview']) ||
($GLOBALS['printview'] != '1'))) {
1221 if ($GLOBALS['cfg']['BrowsePointerEnable'] == true) {
1222 $mouse_events .= ' onmouseover="setVerticalPointer(this, ' . $row_no . ', \'over\', \'odd\', \'even\', \'hover\', \'marked\');"'
1223 . ' onmouseout="setVerticalPointer(this, ' . $row_no . ', \'out\', \'odd\', \'even\', \'hover\', \'marked\');" ';
1225 if ($GLOBALS['cfg']['BrowseMarkerEnable'] == true) {
1226 $mouse_events .= ' onmousedown="setVerticalPointer(this, ' . $row_no . ', \'click\', \'odd\', \'even\', \'hover\', \'marked\'); setCheckboxColumn(\'id_rows_to_delete' . $row_no . '\');" ';
1228 $mouse_events .= ' onmousedown="setCheckboxColumn(\'id_rows_to_delete' . $row_no . '\');" ';
1232 // Wrap MIME-transformations. [MIME]
1233 $default_function = 'default_function'; // default_function
1234 $transform_function = $default_function;
1235 $transform_options = array();
1237 if ($GLOBALS['cfgRelation']['mimework'] && $GLOBALS['cfg']['BrowseMIME']) {
1239 if (isset($GLOBALS['mime_map'][$meta->name
]['mimetype']) && isset($GLOBALS['mime_map'][$meta->name
]['transformation']) && !empty($GLOBALS['mime_map'][$meta->name
]['transformation'])) {
1240 $include_file = $GLOBALS['mime_map'][$meta->name
]['transformation'];
1242 if (file_exists('./libraries/transformations/' . $include_file)) {
1243 $transformfunction_name = str_replace('.inc.php', '', $GLOBALS['mime_map'][$meta->name
]['transformation']);
1245 require_once './libraries/transformations/' . $include_file;
1247 if (function_exists('PMA_transformation_' . $transformfunction_name)) {
1248 $transform_function = 'PMA_transformation_' . $transformfunction_name;
1249 $transform_options = PMA_transformation_getOptions((isset($GLOBALS['mime_map'][$meta->name
]['transformation_options']) ?
$GLOBALS['mime_map'][$meta->name
]['transformation_options'] : ''));
1250 $meta->mimetype
= str_replace('_', '/', $GLOBALS['mime_map'][$meta->name
]['mimetype']);
1252 } // end if file_exists
1253 } // end if transformation is set
1254 } // end if mime/transformation works.
1256 $_url_params = array(
1259 'where_clause' => $where_clause,
1260 'transform_key' => $meta->name
,
1263 if (! empty($sql_query)) {
1264 $_url_params['sql_query'] = $url_sql_query;
1267 $transform_options['wrapper_link'] = PMA_generate_common_url($_url_params);
1270 if ($meta->numeric == 1) {
1272 // if two fields have the same name (this is possible
1273 // with self-join queries, for example), using $meta->name
1274 // will show both fields NULL even if only one is NULL,
1275 // so use the $pointer
1277 if (!isset($row[$i]) ||
is_null($row[$i])) {
1278 $vertical_display['data'][$row_no][$i] = ' <td align="right"' . $mouse_events . ' class="' . $class . ($condition_field ?
' condition' : '') . '"><i>NULL</i></td>' . "\n";
1279 } elseif ($row[$i] != '') {
1281 $nowrap = ' nowrap';
1282 $where_comparison = ' = ' . $row[$i];
1284 $vertical_display['data'][$row_no][$i] = '<td align="right"' . PMA_prepare_row_data($mouse_events, $class, $condition_field, $analyzed_sql, $meta, $map, $row[$i], $transform_function, $default_function, $nowrap, $where_comparison, $transform_options, $is_field_truncated);
1286 $vertical_display['data'][$row_no][$i] = ' <td align="right"' . $mouse_events . ' class="' . $class . ' nowrap' . ($condition_field ?
' condition' : '') . '"> </td>' . "\n";
1291 } elseif (stristr($meta->type
, 'BLOB')) {
1292 // PMA_mysql_fetch_fields returns BLOB in place of
1293 // TEXT fields type so we have to ensure it's really a BLOB
1294 $field_flags = PMA_DBI_field_flags($dt_result, $i);
1296 // reset $class from $data_inline_edit_class to '' as we can't edit binary data
1299 if (stristr($field_flags, 'BINARY')) {
1300 if (!isset($row[$i]) ||
is_null($row[$i])) {
1301 $vertical_display['data'][$row_no][$i] = ' <td align="right"' . $mouse_events . ' class="' . $class . ($condition_field ?
' condition' : '') . '"><i>NULL</i></td>' . "\n";
1303 // for blobstreaming
1304 // if valid BS reference exists
1305 if (PMA_BS_IsPBMSReference($row[$i], $db)) {
1306 $blobtext = PMA_BS_CreateReferenceLink($row[$i], $db);
1308 $blobtext = PMA_handle_non_printable_contents('BLOB', (isset($row[$i]) ?
$row[$i] : ''), $transform_function, $transform_options, $default_function, $meta, $_url_params);
1311 $vertical_display['data'][$row_no][$i] = ' <td align="left"' . $mouse_events . ' class="' . $class . ($condition_field ?
' condition' : '') . '">' . $blobtext . '</td>';
1316 if (!isset($row[$i]) ||
is_null($row[$i])) {
1317 $vertical_display['data'][$row_no][$i] = ' <td' . $mouse_events . ' class="' . $class . ($condition_field ?
' condition' : '') . '"><i>NULL</i></td>' . "\n";
1318 } elseif ($row[$i] != '') {
1319 // if a transform function for blob is set, none of these replacements will be made
1320 if (PMA_strlen($row[$i]) > $GLOBALS['cfg']['LimitChars'] && $_SESSION['tmp_user_values']['display_text'] == 'P') {
1321 $row[$i] = PMA_substr($row[$i], 0, $GLOBALS['cfg']['LimitChars']) . '...';
1322 $is_field_truncated = true;
1324 // displays all space characters, 4 space
1325 // characters for tabulations and <cr>/<lf>
1326 $row[$i] = ($default_function != $transform_function ?
$transform_function($row[$i], $transform_options, $meta) : $default_function($row[$i], array(), $meta));
1328 $vertical_display['data'][$row_no][$i] = ' <td' . $mouse_events . ' class="' . $class . ($condition_field ?
' condition' : '') . '">' . $row[$i] . '</td>' . "\n";
1330 $vertical_display['data'][$row_no][$i] = ' <td' . $mouse_events . ' class="' . $class . ($condition_field ?
' condition' : '') . '"> </td>' . "\n";
1333 // n o t n u m e r i c a n d n o t B L O B
1335 if (!isset($row[$i]) ||
is_null($row[$i])) {
1336 $vertical_display['data'][$row_no][$i] = ' <td' . $mouse_events . ' class="' . $class . ($condition_field ?
' condition' : '') . '"><i>NULL</i></td>' . "\n";
1337 } elseif ($row[$i] != '') {
1338 // support blanks in the key
1339 $relation_id = $row[$i];
1341 // Cut all fields to $GLOBALS['cfg']['LimitChars']
1342 // (unless it's a link-type transformation)
1343 if (PMA_strlen($row[$i]) > $GLOBALS['cfg']['LimitChars'] && $_SESSION['tmp_user_values']['display_text'] == 'P' && !strpos($transform_function, 'link') === true) {
1344 $row[$i] = PMA_substr($row[$i], 0, $GLOBALS['cfg']['LimitChars']) . '...';
1345 $is_field_truncated = true;
1348 // displays special characters from binaries
1349 $field_flags = PMA_DBI_field_flags($dt_result, $i);
1350 if (isset($meta->_type
) && $meta->_type
=== MYSQLI_TYPE_BIT
) {
1351 $row[$i] = PMA_printable_bit_value($row[$i], $meta->length
);
1352 // some results of PROCEDURE ANALYSE() are reported as
1353 // being BINARY but they are quite readable,
1354 // so don't treat them as BINARY
1355 } elseif (stristr($field_flags, 'BINARY') && $meta->type
== 'string' && !(isset($GLOBALS['is_analyse']) && $GLOBALS['is_analyse'])) {
1356 if ($_SESSION['tmp_user_values']['display_binary']) {
1357 // user asked to see the real contents of BINARY
1359 if ($_SESSION['tmp_user_values']['display_binary_as_hex'] && PMA_contains_nonprintable_ascii($row[$i])) {
1360 $row[$i] = bin2hex($row[$i]);
1362 $row[$i] = htmlspecialchars(PMA_replace_binary_contents($row[$i]));
1365 // we show the BINARY message and field's size
1366 // (or maybe use a transformation)
1367 $row[$i] = PMA_handle_non_printable_contents('BINARY', $row[$i], $transform_function, $transform_options, $default_function, $meta, $_url_params);
1371 // transform functions may enable no-wrapping:
1372 $function_nowrap = $transform_function . '_nowrap';
1373 $bool_nowrap = (($default_function != $transform_function && function_exists($function_nowrap)) ?
$function_nowrap($transform_options) : false);
1375 // do not wrap if date field type
1376 $nowrap = ((preg_match('@DATE|TIME@i', $meta->type
) ||
$bool_nowrap) ?
' nowrap' : '');
1377 $where_comparison = ' = \'' . PMA_sqlAddslashes($row[$i]) . '\'';
1378 $vertical_display['data'][$row_no][$i] = '<td ' . PMA_prepare_row_data($mouse_events, $class, $condition_field, $analyzed_sql, $meta, $map, $row[$i], $transform_function, $default_function, $nowrap, $where_comparison, $transform_options, $is_field_truncated);
1381 $vertical_display['data'][$row_no][$i] = ' <td' . $mouse_events . ' class="' . $class . ($condition_field ?
' condition' : '') . '"> </td>' . "\n";
1385 // output stored cell
1386 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
1387 ||
$_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
1388 echo $vertical_display['data'][$row_no][$i];
1391 if (isset($vertical_display['rowdata'][$i][$row_no])) {
1392 $vertical_display['rowdata'][$i][$row_no] .= $vertical_display['data'][$row_no][$i];
1394 $vertical_display['rowdata'][$i][$row_no] = $vertical_display['data'][$row_no][$i];
1398 // 3. Displays the modify/delete links on the right if required
1399 if ($GLOBALS['cfg']['ModifyDeleteAtRight']
1400 && ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
1401 ||
$_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped')) {
1402 $doWriteModifyAt = 'right';
1403 require './libraries/display_tbl_links.lib.php';
1406 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
1407 ||
$_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
1413 // 4. Gather links of del_urls and edit_urls in an array for later
1415 if (!isset($vertical_display['edit'][$row_no])) {
1416 $vertical_display['edit'][$row_no] = '';
1417 $vertical_display['delete'][$row_no] = '';
1418 $vertical_display['row_delete'][$row_no] = '';
1419 $vertical_display['where_clause'][$row_no] = '';
1422 $column_style_vertical = '';
1423 if ($GLOBALS['cfg']['BrowsePointerEnable'] == true) {
1424 $column_style_vertical .= ' onmouseover="setVerticalPointer(this, ' . $row_no . ', \'over\', \'odd\', \'even\', \'hover\', \'marked\');"'
1425 . ' onmouseout="setVerticalPointer(this, ' . $row_no . ', \'out\', \'odd\', \'even\', \'hover\', \'marked\');"';
1427 $column_marker_vertical = '';
1428 if ($GLOBALS['cfg']['BrowseMarkerEnable'] == true) {
1429 $column_marker_vertical .= 'setVerticalPointer(this, ' . $row_no . ', \'click\', \'odd\', \'even\', \'hover\', \'marked\');';
1432 if (!empty($del_url) && $is_display['del_lnk'] != 'kp') {
1433 $vertical_display['row_delete'][$row_no] .= ' <td align="center" class="' . $class . '" ' . $column_style_vertical . '>' . "\n"
1434 . ' <input type="checkbox" id="id_rows_to_delete' . $row_no . '[%_PMA_CHECKBOX_DIR_%]" name="rows_to_delete[' . $where_clause_html . ']"'
1435 . ' onclick="' . $column_marker_vertical . 'copyCheckboxesRange(\'rowsDeleteForm\', \'id_rows_to_delete' . $row_no . '\',\'[%_PMA_CHECKBOX_DIR_%]\');"'
1436 . ' value="' . htmlspecialchars($del_query) . '" ' . (isset($GLOBALS['checkall']) ?
'checked="checked"' : '') . ' />' . "\n"
1439 unset($vertical_display['row_delete'][$row_no]);
1442 if (isset($edit_url)) {
1443 $vertical_display['edit'][$row_no] .= ' <td align="center" class="' . $class . ' ' . $edit_anchor_class . '" ' . $column_style_vertical . '>' . "\n"
1444 . PMA_linkOrButton($edit_url, $edit_str, array(), false)
1448 unset($vertical_display['edit'][$row_no]);
1451 if (isset($del_url)) {
1452 $vertical_display['delete'][$row_no] .= ' <td align="center" class="' . $class . '" ' . $column_style_vertical . '>' . "\n"
1453 . PMA_linkOrButton($del_url, $del_str, (isset($js_conf) ?
$js_conf : ''), false)
1456 unset($vertical_display['delete'][$row_no]);
1459 if( !empty($where_clause) ) {
1460 $vertical_display['where_clause'][$row_no] = '<input type="hidden" class="where_clause" value ="' . $where_clause . '" />';
1463 unset($vertical_display['where_clause'][$row_no]);
1466 echo (($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal' ||
$_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') ?
"\n" : '');
1470 // this is needed by PMA_displayTable() to generate the proper param
1471 // in the multi-edit and multi-delete form
1472 return $clause_is_unique;
1473 } // end of the 'PMA_displayTableBody()' function
1477 * Do display the result table with the vertical direction mode.
1478 * Credits for this feature goes to Garvin Hicking <hicking@faktor-e.de>.
1480 * @return boolean always true
1482 * @uses $_SESSION['tmp_user_values']['repeat_cells']
1483 * @global array $vertical_display the information to display
1487 * @see PMA_displayTable()
1489 function PMA_displayVerticalTable()
1491 global $vertical_display;
1493 // Displays "multi row delete" link at top if required
1494 if ($GLOBALS['cfg']['ModifyDeleteAtLeft'] && is_array($vertical_display['row_delete']) && (count($vertical_display['row_delete']) > 0 ||
!empty($vertical_display['textbtn']))) {
1496 echo $vertical_display['textbtn'];
1498 foreach ($vertical_display['row_delete'] as $val) {
1499 if (($foo_counter != 0) && ($_SESSION['tmp_user_values']['repeat_cells'] != 0) && !($foo_counter %
$_SESSION['tmp_user_values']['repeat_cells'])) {
1500 echo '<th></th>' . "\n";
1503 echo str_replace('[%_PMA_CHECKBOX_DIR_%]', '', $val);
1506 echo '</tr>' . "\n";
1509 // Displays "edit" link at top if required
1510 if ($GLOBALS['cfg']['ModifyDeleteAtLeft'] && is_array($vertical_display['edit']) && (count($vertical_display['edit']) > 0 ||
!empty($vertical_display['textbtn']))) {
1512 if (!is_array($vertical_display['row_delete'])) {
1513 echo $vertical_display['textbtn'];
1516 foreach ($vertical_display['edit'] as $val) {
1517 if (($foo_counter != 0) && ($_SESSION['tmp_user_values']['repeat_cells'] != 0) && !($foo_counter %
$_SESSION['tmp_user_values']['repeat_cells'])) {
1518 echo ' <th></th>' . "\n";
1524 echo '</tr>' . "\n";
1527 // Displays "delete" link at top if required
1528 if ($GLOBALS['cfg']['ModifyDeleteAtLeft'] && is_array($vertical_display['delete']) && (count($vertical_display['delete']) > 0 ||
!empty($vertical_display['textbtn']))) {
1530 if (!is_array($vertical_display['edit']) && !is_array($vertical_display['row_delete'])) {
1531 echo $vertical_display['textbtn'];
1534 foreach ($vertical_display['delete'] as $val) {
1535 if (($foo_counter != 0) && ($_SESSION['tmp_user_values']['repeat_cells'] != 0) && !($foo_counter %
$_SESSION['tmp_user_values']['repeat_cells'])) {
1536 echo '<th></th>' . "\n";
1542 echo '</tr>' . "\n";
1545 // Generates the 'where_clause' hidden input field for inline ajax edit if required
1546 if ( is_array($vertical_display['delete']) && (count($vertical_display['delete']) > 0 ) ) {
1550 foreach ($vertical_display['where_clause'] as $val) {
1551 if (($foo_counter != 0) && ($_SESSION['tmp_user_values']['repeat_cells'] != 0) && !($foo_counter %
$_SESSION['tmp_user_values']['repeat_cells'])) {
1552 echo '<th></th>' . "\n";
1558 echo '</tr>' . "\n";
1562 foreach ($vertical_display['desc'] AS $key => $val) {
1568 foreach ($vertical_display['rowdata'][$key] as $subval) {
1569 if (($foo_counter != 0) && ($_SESSION['tmp_user_values']['repeat_cells'] != 0) and !($foo_counter %
$_SESSION['tmp_user_values']['repeat_cells'])) {
1577 echo '</tr>' . "\n";
1580 // Displays "multi row delete" link at bottom if required
1581 if ($GLOBALS['cfg']['ModifyDeleteAtRight'] && is_array($vertical_display['row_delete']) && (count($vertical_display['row_delete']) > 0 ||
!empty($vertical_display['textbtn']))) {
1583 echo $vertical_display['textbtn'];
1585 foreach ($vertical_display['row_delete'] as $val) {
1586 if (($foo_counter != 0) && ($_SESSION['tmp_user_values']['repeat_cells'] != 0) && !($foo_counter %
$_SESSION['tmp_user_values']['repeat_cells'])) {
1587 echo '<th></th>' . "\n";
1590 echo str_replace('[%_PMA_CHECKBOX_DIR_%]', 'r', $val);
1593 echo '</tr>' . "\n";
1596 // Displays "edit" link at bottom if required
1597 if ($GLOBALS['cfg']['ModifyDeleteAtRight'] && is_array($vertical_display['edit']) && (count($vertical_display['edit']) > 0 ||
!empty($vertical_display['textbtn']))) {
1599 if (!is_array($vertical_display['row_delete'])) {
1600 echo $vertical_display['textbtn'];
1603 foreach ($vertical_display['edit'] as $val) {
1604 if (($foo_counter != 0) && ($_SESSION['tmp_user_values']['repeat_cells'] != 0) && !($foo_counter %
$_SESSION['tmp_user_values']['repeat_cells'])) {
1605 echo '<th></th>' . "\n";
1611 echo '</tr>' . "\n";
1614 // Displays "delete" link at bottom if required
1615 if ($GLOBALS['cfg']['ModifyDeleteAtRight'] && is_array($vertical_display['delete']) && (count($vertical_display['delete']) > 0 ||
!empty($vertical_display['textbtn']))) {
1617 if (!is_array($vertical_display['edit']) && !is_array($vertical_display['row_delete'])) {
1618 echo $vertical_display['textbtn'];
1621 foreach ($vertical_display['delete'] as $val) {
1622 if (($foo_counter != 0) && ($_SESSION['tmp_user_values']['repeat_cells'] != 0) && !($foo_counter %
$_SESSION['tmp_user_values']['repeat_cells'])) {
1623 echo '<th></th>' . "\n";
1629 echo '</tr>' . "\n";
1633 } // end of the 'PMA_displayVerticalTable' function
1637 * @uses $_SESSION['tmp_user_values']['disp_direction']
1638 * @uses $_REQUEST['disp_direction']
1639 * @uses $GLOBALS['cfg']['DefaultDisplay']
1640 * @uses $_SESSION['tmp_user_values']['repeat_cells']
1641 * @uses $_REQUEST['repeat_cells']
1642 * @uses $GLOBALS['cfg']['RepeatCells']
1643 * @uses $_SESSION['tmp_user_values']['max_rows']
1644 * @uses $_REQUEST['session_max_rows']
1645 * @uses $GLOBALS['cfg']['MaxRows']
1646 * @uses $_SESSION['tmp_user_values']['pos']
1647 * @uses $_REQUEST['pos']
1648 * @uses $_SESSION['tmp_user_values']['display_text']
1649 * @uses $_REQUEST['display_text']
1650 * @uses $_SESSION['tmp_user_values']['relational_display']
1651 * @uses $_REQUEST['relational_display']
1652 * @uses $_SESSION['tmp_user_values']['display_binary']
1653 * @uses $_REQUEST['display_binary']
1654 * @uses $_SESSION['tmp_user_values']['display_binary_as_hex']
1655 * @uses $_REQUEST['display_binary_as_hex']
1656 * @uses $_SESSION['tmp_user_values']['display_blob']
1657 * @uses $_REQUEST['display_blob']
1658 * @uses PMA_isValid()
1659 * @uses $GLOBALS['sql_query']
1660 * @todo make maximum remembered queries configurable
1661 * @todo move/split into SQL class!?
1662 * @todo currently this is called twice unnecessary
1663 * @todo ignore LIMIT and ORDER in query!?
1665 function PMA_displayTable_checkConfigParams()
1667 $sql_md5 = md5($GLOBALS['sql_query']);
1669 $_SESSION['tmp_user_values']['query'][$sql_md5]['sql'] = $GLOBALS['sql_query'];
1671 if (PMA_isValid($_REQUEST['disp_direction'], array('horizontal', 'vertical', 'horizontalflipped'))) {
1672 $_SESSION['tmp_user_values']['query'][$sql_md5]['disp_direction'] = $_REQUEST['disp_direction'];
1673 unset($_REQUEST['disp_direction']);
1674 } elseif (empty($_SESSION['tmp_user_values']['query'][$sql_md5]['disp_direction'])) {
1675 $_SESSION['tmp_user_values']['query'][$sql_md5]['disp_direction'] = $GLOBALS['cfg']['DefaultDisplay'];
1678 if (PMA_isValid($_REQUEST['repeat_cells'], 'numeric')) {
1679 $_SESSION['tmp_user_values']['query'][$sql_md5]['repeat_cells'] = $_REQUEST['repeat_cells'];
1680 unset($_REQUEST['repeat_cells']);
1681 } elseif (empty($_SESSION['tmp_user_values']['query'][$sql_md5]['repeat_cells'])) {
1682 $_SESSION['tmp_user_values']['query'][$sql_md5]['repeat_cells'] = $GLOBALS['cfg']['RepeatCells'];
1685 // as this is a form value, the type is always string so we cannot
1686 // use PMA_isValid($_REQUEST['session_max_rows'], 'integer')
1687 if ((PMA_isValid($_REQUEST['session_max_rows'], 'numeric')
1688 && (int) $_REQUEST['session_max_rows'] == $_REQUEST['session_max_rows'])
1689 ||
$_REQUEST['session_max_rows'] == 'all') {
1690 $_SESSION['tmp_user_values']['query'][$sql_md5]['max_rows'] = $_REQUEST['session_max_rows'];
1691 unset($_REQUEST['session_max_rows']);
1692 } elseif (empty($_SESSION['tmp_user_values']['query'][$sql_md5]['max_rows'])) {
1693 $_SESSION['tmp_user_values']['query'][$sql_md5]['max_rows'] = $GLOBALS['cfg']['MaxRows'];
1696 if (PMA_isValid($_REQUEST['pos'], 'numeric')) {
1697 $_SESSION['tmp_user_values']['query'][$sql_md5]['pos'] = $_REQUEST['pos'];
1698 unset($_REQUEST['pos']);
1699 } elseif (empty($_SESSION['tmp_user_values']['query'][$sql_md5]['pos'])) {
1700 $_SESSION['tmp_user_values']['query'][$sql_md5]['pos'] = 0;
1703 if (PMA_isValid($_REQUEST['display_text'], array('P', 'F'))) {
1704 $_SESSION['tmp_user_values']['query'][$sql_md5]['display_text'] = $_REQUEST['display_text'];
1705 unset($_REQUEST['display_text']);
1706 } elseif (empty($_SESSION['tmp_user_values']['query'][$sql_md5]['display_text'])) {
1707 $_SESSION['tmp_user_values']['query'][$sql_md5]['display_text'] = 'P';
1710 if (PMA_isValid($_REQUEST['relational_display'], array('K', 'D'))) {
1711 $_SESSION['tmp_user_values']['query'][$sql_md5]['relational_display'] = $_REQUEST['relational_display'];
1712 unset($_REQUEST['relational_display']);
1713 } elseif (empty($_SESSION['tmp_user_values']['query'][$sql_md5]['relational_display'])) {
1714 $_SESSION['tmp_user_values']['query'][$sql_md5]['relational_display'] = 'K';
1717 if (isset($_REQUEST['display_binary'])) {
1718 $_SESSION['tmp_user_values']['query'][$sql_md5]['display_binary'] = true;
1719 unset($_REQUEST['display_binary']);
1720 } elseif (isset($_REQUEST['display_options_form'])) {
1721 // we know that the checkbox was unchecked
1722 unset($_SESSION['tmp_user_values']['query'][$sql_md5]['display_binary']);
1724 // selected by default because some operations like OPTIMIZE TABLE
1725 // and all queries involving functions return "binary" contents,
1726 // according to low-level field flags
1727 $_SESSION['tmp_user_values']['query'][$sql_md5]['display_binary'] = true;
1730 if (isset($_REQUEST['display_binary_as_hex'])) {
1731 $_SESSION['tmp_user_values']['query'][$sql_md5]['display_binary_as_hex'] = true;
1732 unset($_REQUEST['display_binary_as_hex']);
1733 } elseif (isset($_REQUEST['display_options_form'])) {
1734 // we know that the checkbox was unchecked
1735 unset($_SESSION['tmp_user_values']['query'][$sql_md5]['display_binary_as_hex']);
1737 // display_binary_as_hex config option
1738 if (isset($GLOBALS['cfg']['DisplayBinaryAsHex']) && true === $GLOBALS['cfg']['DisplayBinaryAsHex']) {
1739 $_SESSION['tmp_user_values']['query'][$sql_md5]['display_binary_as_hex'] = true;
1743 if (isset($_REQUEST['display_blob'])) {
1744 $_SESSION['tmp_user_values']['query'][$sql_md5]['display_blob'] = true;
1745 unset($_REQUEST['display_blob']);
1746 } elseif (isset($_REQUEST['display_options_form'])) {
1747 // we know that the checkbox was unchecked
1748 unset($_SESSION['tmp_user_values']['query'][$sql_md5]['display_blob']);
1751 if (isset($_REQUEST['hide_transformation'])) {
1752 $_SESSION['tmp_user_values']['query'][$sql_md5]['hide_transformation'] = true;
1753 unset($_REQUEST['hide_transformation']);
1754 } elseif (isset($_REQUEST['display_options_form'])) {
1755 // we know that the checkbox was unchecked
1756 unset($_SESSION['tmp_user_values']['query'][$sql_md5]['hide_transformation']);
1759 // move current query to the last position, to be removed last
1760 // so only least executed query will be removed if maximum remembered queries
1762 $tmp = $_SESSION['tmp_user_values']['query'][$sql_md5];
1763 unset($_SESSION['tmp_user_values']['query'][$sql_md5]);
1764 $_SESSION['tmp_user_values']['query'][$sql_md5] = $tmp;
1766 // do not exceed a maximum number of queries to remember
1767 if (count($_SESSION['tmp_user_values']['query']) > 10) {
1768 array_shift($_SESSION['tmp_user_values']['query']);
1769 //echo 'deleting one element ...';
1772 // populate query configuration
1773 $_SESSION['tmp_user_values']['display_text'] = $_SESSION['tmp_user_values']['query'][$sql_md5]['display_text'];
1774 $_SESSION['tmp_user_values']['relational_display'] = $_SESSION['tmp_user_values']['query'][$sql_md5]['relational_display'];
1775 $_SESSION['tmp_user_values']['display_binary'] = isset($_SESSION['tmp_user_values']['query'][$sql_md5]['display_binary']) ?
true : false;
1776 $_SESSION['tmp_user_values']['display_binary_as_hex'] = isset($_SESSION['tmp_user_values']['query'][$sql_md5]['display_binary_as_hex']) ?
true : false;
1777 $_SESSION['tmp_user_values']['display_blob'] = isset($_SESSION['tmp_user_values']['query'][$sql_md5]['display_blob']) ?
true : false;
1778 $_SESSION['tmp_user_values']['hide_transformation'] = isset($_SESSION['tmp_user_values']['query'][$sql_md5]['hide_transformation']) ?
true : false;
1779 $_SESSION['tmp_user_values']['pos'] = $_SESSION['tmp_user_values']['query'][$sql_md5]['pos'];
1780 $_SESSION['tmp_user_values']['max_rows'] = $_SESSION['tmp_user_values']['query'][$sql_md5]['max_rows'];
1781 $_SESSION['tmp_user_values']['repeat_cells'] = $_SESSION['tmp_user_values']['query'][$sql_md5]['repeat_cells'];
1782 $_SESSION['tmp_user_values']['disp_direction'] = $_SESSION['tmp_user_values']['query'][$sql_md5]['disp_direction'];
1787 var_dump($_SESSION['tmp_user_values']);
1793 * Displays a table of results returned by a SQL query.
1794 * This function is called by the "sql.php" script.
1796 * @param integer the link id associated to the query which results have
1798 * @param array the display mode
1799 * @param array the analyzed query
1801 * @uses $_SESSION['tmp_user_values']['pos']
1802 * @global string $db the database name
1803 * @global string $table the table name
1804 * @global string $goto the URL to go back in case of errors
1805 * @global string $sql_query the current SQL query
1806 * @global integer $num_rows the total number of rows returned by the
1808 * @global integer $unlim_num_rows the total number of rows returned by the
1809 * SQL query without any programmatically
1810 * appended "LIMIT" clause
1811 * @global array $fields_meta the list of fields properties
1812 * @global integer $fields_cnt the total number of fields returned by
1814 * @global array $vertical_display informations used with vertical display
1816 * @global array $highlight_columns column names to highlight
1817 * @global array $cfgRelation the relation settings
1821 * @see PMA_showMessage(), PMA_setDisplayMode(),
1822 * PMA_displayTableNavigation(), PMA_displayTableHeaders(),
1823 * PMA_displayTableBody(), PMA_displayResultsOperations()
1825 function PMA_displayTable(&$dt_result, &$the_disp_mode, $analyzed_sql)
1827 global $db, $table, $goto;
1828 global $sql_query, $num_rows, $unlim_num_rows, $fields_meta, $fields_cnt;
1829 global $vertical_display, $highlight_columns;
1830 global $cfgRelation;
1833 // why was this called here? (already called from sql.php)
1834 //PMA_displayTable_checkConfigParams();
1837 * @todo move this to a central place
1838 * @todo for other future table types
1840 $is_innodb = (isset($showtable['Type']) && $showtable['Type'] == 'InnoDB');
1843 && ! isset($analyzed_sql[0]['queryflags']['union'])
1844 && ! isset($analyzed_sql[0]['table_ref'][1]['table_name'])
1845 && (empty($analyzed_sql[0]['where_clause'])
1846 ||
$analyzed_sql[0]['where_clause'] == '1 ')) {
1847 // "j u s t b r o w s i n g"
1849 $after_count = PMA_showHint(PMA_sanitize(__('May be approximate. See [a@./Documentation.html#faq3_11@Documentation]FAQ 3.11[/a]')), true);
1855 // 1. ----- Prepares the work -----
1857 // 1.1 Gets the informations about which functionalities should be
1860 $is_display = PMA_setDisplayMode($the_disp_mode, $total);
1862 // 1.2 Defines offsets for the next and previous pages
1863 if ($is_display['nav_bar'] == '1') {
1864 if ($_SESSION['tmp_user_values']['max_rows'] == 'all') {
1868 $pos_next = $_SESSION['tmp_user_values']['pos'] +
$_SESSION['tmp_user_values']['max_rows'];
1869 $pos_prev = $_SESSION['tmp_user_values']['pos'] - $_SESSION['tmp_user_values']['max_rows'];
1870 if ($pos_prev < 0) {
1876 // 1.3 Find the sort expression
1878 // we need $sort_expression and $sort_expression_nodirection
1879 // even if there are many table references
1880 if (! empty($analyzed_sql[0]['order_by_clause'])) {
1881 $sort_expression = trim(str_replace(' ', ' ', $analyzed_sql[0]['order_by_clause']));
1883 * Get rid of ASC|DESC
1885 preg_match('@(.*)([[:space:]]*(ASC|DESC))@si', $sort_expression, $matches);
1886 $sort_expression_nodirection = isset($matches[1]) ?
trim($matches[1]) : $sort_expression;
1887 $sort_direction = isset($matches[2]) ?
trim($matches[2]) : '';
1890 $sort_expression = $sort_expression_nodirection = $sort_direction = '';
1893 // 1.4 Prepares display of first and last value of the sorted column
1895 if (! empty($sort_expression_nodirection)) {
1896 if (strpos($sort_expression_nodirection, '.') === false) {
1897 $sort_table = $table;
1898 $sort_column = $sort_expression_nodirection;
1900 list($sort_table, $sort_column) = explode('.', $sort_expression_nodirection);
1902 $sort_table = PMA_unQuote($sort_table);
1903 $sort_column = PMA_unQuote($sort_column);
1904 // find the sorted column index in row result
1905 // (this might be a multi-table query)
1906 $sorted_column_index = false;
1907 foreach($fields_meta as $key => $meta) {
1908 if ($meta->table
== $sort_table && $meta->name
== $sort_column) {
1909 $sorted_column_index = $key;
1913 if ($sorted_column_index !== false) {
1914 // fetch first row of the result set
1915 $row = PMA_DBI_fetch_row($dt_result);
1916 $column_for_first_row = substr($row[$sorted_column_index], 0, $GLOBALS['cfg']['LimitChars']);
1917 // fetch last row of the result set
1918 PMA_DBI_data_seek($dt_result, $num_rows - 1);
1919 $row = PMA_DBI_fetch_row($dt_result);
1920 $column_for_last_row = substr($row[$sorted_column_index], 0, $GLOBALS['cfg']['LimitChars']);
1921 // reset to first row for the loop in PMA_displayTableBody()
1922 PMA_DBI_data_seek($dt_result, 0);
1923 // we could also use here $sort_expression_nodirection
1924 $sorted_column_message = ' [' . htmlspecialchars($sort_column) . ': <strong>' . htmlspecialchars($column_for_first_row) . ' - ' . htmlspecialchars($column_for_last_row) . '</strong>]';
1925 unset($row, $column_for_first_row, $column_for_last_row);
1927 unset($sorted_column_index, $sort_table, $sort_column);
1930 // 2. ----- Displays the top of the page -----
1932 // 2.1 Displays a messages with position informations
1933 if ($is_display['nav_bar'] == '1' && isset($pos_next)) {
1934 if (isset($unlim_num_rows) && $unlim_num_rows != $total) {
1935 $selectstring = ', ' . $unlim_num_rows . ' ' . __('in query');
1939 $last_shown_rec = ($_SESSION['tmp_user_values']['max_rows'] == 'all' ||
$pos_next > $total)
1943 if (PMA_Table
::isView($db, $table)
1944 && $total == $GLOBALS['cfg']['MaxExactCountViews']) {
1945 $message = PMA_Message
::notice(__('This view has at least this number of rows. Please refer to %sdocumentation%s.'));
1946 $message->addParam('[a@./Documentation.html#cfg_MaxExactCount@_blank]');
1947 $message->addParam('[/a]');
1948 $message_view_warning = PMA_showHint($message);
1950 $message_view_warning = false;
1953 $message = PMA_Message
::success(__('Showing rows'));
1954 $message->addMessage($_SESSION['tmp_user_values']['pos']);
1955 if ($message_view_warning) {
1956 $message->addMessage('...', ' - ');
1957 $message->addMessage($message_view_warning);
1958 $message->addMessage('(');
1960 $message->addMessage($last_shown_rec, ' - ');
1961 $message->addMessage(' (');
1962 $message->addMessage($pre_count . PMA_formatNumber($total, 0));
1963 $message->addString(__('total'));
1964 if (!empty($after_count)) {
1965 $message->addMessage($after_count);
1967 $message->addMessage($selectstring, '');
1968 $message->addMessage(', ', '');
1971 $messagge_qt = PMA_Message
::notice(__('Query took %01.4f sec'));
1972 $messagge_qt->addParam($GLOBALS['querytime']);
1974 $message->addMessage($messagge_qt, '');
1975 $message->addMessage(')', '');
1977 $message->addMessage(isset($sorted_column_message) ?
$sorted_column_message : '', '');
1979 PMA_showMessage($message, $sql_query, 'success');
1981 } elseif (!isset($GLOBALS['printview']) ||
$GLOBALS['printview'] != '1') {
1982 PMA_showMessage(__('Your SQL query has been executed successfully'), $sql_query, 'success');
1985 // 2.3 Displays the navigation bars
1986 if (! strlen($table)) {
1987 if (isset($analyzed_sql[0]['query_type'])
1988 && $analyzed_sql[0]['query_type'] == 'SELECT') {
1989 // table does not always contain a real table name,
1990 // for example in MySQL 5.0.x, the query SHOW STATUS
1991 // returns STATUS as a table name
1992 $table = $fields_meta[0]->table
;
1998 if ($is_display['nav_bar'] == '1') {
1999 PMA_displayTableNavigation($pos_next, $pos_prev, $sql_query, 'top_direction_dropdown');
2001 } elseif (!isset($GLOBALS['printview']) ||
$GLOBALS['printview'] != '1') {
2002 echo "\n" . '<br /><br />' . "\n";
2005 // 2b ----- Get field references from Database -----
2006 // (see the 'relation' configuration variable)
2013 if (isset($analyzed_sql[0]['table_ref']) && is_array($analyzed_sql[0]['table_ref'])) {
2014 foreach ($analyzed_sql[0]['table_ref'] AS $table_ref_position => $table_ref) {
2015 $target[] = $analyzed_sql[0]['table_ref'][$table_ref_position]['table_true_name'];
2018 $tabs = '(\'' . join('\',\'', $target) . '\')';
2020 if ($cfgRelation['displaywork']) {
2021 if (! strlen($table)) {
2024 $exist_rel = PMA_getForeigners($db, $table, '', 'both');
2026 foreach ($exist_rel AS $master_field => $rel) {
2027 $display_field = PMA_getDisplayField($rel['foreign_db'], $rel['foreign_table']);
2028 $map[$master_field] = array($rel['foreign_table'],
2029 $rel['foreign_field'],
2031 $rel['foreign_db']);
2038 // 3. ----- Displays the results table -----
2039 PMA_displayTableHeaders($is_display, $fields_meta, $fields_cnt, $analyzed_sql, $sort_expression, $sort_expression_nodirection, $sort_direction);
2041 echo '<tbody>' . "\n";
2042 $clause_is_unique = PMA_displayTableBody($dt_result, $is_display, $map, $analyzed_sql);
2043 // vertical output case
2044 if ($_SESSION['tmp_user_values']['disp_direction'] == 'vertical') {
2045 PMA_displayVerticalTable();
2047 unset($vertical_display);
2048 echo '</tbody>' . "\n";
2053 // 4. ----- Displays the link for multi-fields edit and delete
2055 if ($is_display['del_lnk'] == 'dr' && $is_display['del_lnk'] != 'kp') {
2057 $delete_text = $is_display['del_lnk'] == 'dr' ?
__('Delete') : __('Kill');
2059 $_url_params = array(
2062 'sql_query' => $sql_query,
2065 $uncheckall_url = 'sql.php' . PMA_generate_common_url($_url_params);
2067 $_url_params['checkall'] = '1';
2068 $checkall_url = 'sql.php' . PMA_generate_common_url($_url_params);
2070 if ($_SESSION['tmp_user_values']['disp_direction'] == 'vertical') {
2071 $checkall_params['onclick'] = 'if (setCheckboxes(\'rowsDeleteForm\', true)) return false;';
2072 $uncheckall_params['onclick'] = 'if (setCheckboxes(\'rowsDeleteForm\', false)) return false;';
2074 $checkall_params['onclick'] = 'if (markAllRows(\'rowsDeleteForm\')) return false;';
2075 $uncheckall_params['onclick'] = 'if (unMarkAllRows(\'rowsDeleteForm\')) return false;';
2077 $checkall_link = PMA_linkOrButton($checkall_url, __('Check All'), $checkall_params, false);
2078 $uncheckall_link = PMA_linkOrButton($uncheckall_url, __('Uncheck All'), $uncheckall_params, false);
2079 if ($_SESSION['tmp_user_values']['disp_direction'] != 'vertical') {
2080 echo '<img class="selectallarrow" width="38" height="22"'
2081 .' src="' . $GLOBALS['pmaThemeImage'] . 'arrow_' . $GLOBALS['text_dir'] . '.png' . '"'
2082 .' alt="' . __('With selected:') . '" />';
2084 echo $checkall_link . "\n"
2086 .$uncheckall_link . "\n"
2087 .'<i>' . __('With selected:') . '</i>' . "\n";
2089 PMA_buttonOrImage('submit_mult', 'mult_submit',
2090 'submit_mult_change', __('Change'), 'b_edit.png');
2091 PMA_buttonOrImage('submit_mult', 'mult_submit',
2092 'submit_mult_delete', $delete_text, 'b_drop.png');
2093 if (isset($analyzed_sql[0]) && $analyzed_sql[0]['querytype'] == 'SELECT') {
2094 PMA_buttonOrImage('submit_mult', 'mult_submit',
2095 'submit_mult_export', __('Export'),
2100 echo '<input type="hidden" name="sql_query"'
2101 .' value="' . htmlspecialchars($sql_query) . '" />' . "\n";
2102 echo '<input type="hidden" name="url_query"'
2103 .' value="' . $GLOBALS['url_query'] . '" />' . "\n";
2105 echo '<input type="hidden" name="clause_is_unique"'
2106 .' value="' . $clause_is_unique . '" />' . "\n";
2108 echo '</form>' . "\n";
2111 // 5. ----- Displays the navigation bar at the bottom if required -----
2113 if ($is_display['nav_bar'] == '1') {
2114 echo '<br />' . "\n";
2115 PMA_displayTableNavigation($pos_next, $pos_prev, $sql_query, 'bottom_direction_dropdown');
2116 } elseif (!isset($GLOBALS['printview']) ||
$GLOBALS['printview'] != '1') {
2117 echo "\n" . '<br /><br />' . "\n";
2120 // 6. ----- Displays "Query results operations"
2121 if (!isset($GLOBALS['printview']) ||
$GLOBALS['printview'] != '1') {
2122 PMA_displayResultsOperations($the_disp_mode, $analyzed_sql);
2124 } // end of the 'PMA_displayTable()' function
2126 function default_function($buffer) {
2127 $buffer = htmlspecialchars($buffer);
2128 $buffer = str_replace("\011", ' ',
2129 str_replace(' ', ' ', $buffer));
2130 $buffer = preg_replace("@((\015\012)|(\015)|(\012))@", '<br />', $buffer);
2136 * Displays operations that are available on results.
2138 * @param array the display mode
2139 * @param array the analyzed query
2141 * @uses $_SESSION['tmp_user_values']['pos']
2142 * @uses $_SESSION['tmp_user_values']['display_text']
2143 * @global string $db the database name
2144 * @global string $table the table name
2145 * @global string $sql_query the current SQL query
2146 * @global integer $unlim_num_rows the total number of rows returned by the
2147 * SQL query without any programmatically
2148 * appended "LIMIT" clause
2152 * @see PMA_showMessage(), PMA_setDisplayMode(),
2153 * PMA_displayTableNavigation(), PMA_displayTableHeaders(),
2154 * PMA_displayTableBody(), PMA_displayResultsOperations()
2156 function PMA_displayResultsOperations($the_disp_mode, $analyzed_sql) {
2157 global $db, $table, $sql_query, $unlim_num_rows;
2159 $header_shown = FALSE;
2160 $header = '<fieldset><legend>' . __('Query results operations') . '</legend>';
2162 if ($the_disp_mode[6] == '1' ||
$the_disp_mode[9] == '1') {
2163 // Displays "printable view" link if required
2164 if ($the_disp_mode[9] == '1') {
2166 if (!$header_shown) {
2168 $header_shown = TRUE;
2171 $_url_params = array(
2175 'sql_query' => $sql_query,
2177 $url_query = PMA_generate_common_url($_url_params);
2179 echo PMA_linkOrButton(
2180 'sql.php' . $url_query,
2181 PMA_getIcon('b_print.png', __('Print view'), false, true),
2182 '', true, true, 'print_view') . "\n";
2184 if ($_SESSION['tmp_user_values']['display_text']) {
2185 $_url_params['display_text'] = 'F';
2186 echo PMA_linkOrButton(
2187 'sql.php' . PMA_generate_common_url($_url_params),
2188 PMA_getIcon('b_print.png', __('Print view (with full texts)'), false, true),
2189 '', true, true, 'print_view') . "\n";
2190 unset($_url_params['display_text']);
2192 } // end displays "printable view"
2196 // (the url_query has extra parameters that won't be used to export)
2197 // (the single_table parameter is used in display_export.lib.php
2198 // to hide the SQL and the structure export dialogs)
2199 // If the parser found a PROCEDURE clause
2200 // (most probably PROCEDURE ANALYSE()) it makes no sense to
2201 // display the Export link).
2202 if (isset($analyzed_sql[0]) && $analyzed_sql[0]['querytype'] == 'SELECT' && !isset($printview) && ! isset($analyzed_sql[0]['queryflags']['procedure'])) {
2203 if (isset($analyzed_sql[0]['table_ref'][0]['table_true_name']) && !isset($analyzed_sql[0]['table_ref'][1]['table_true_name'])) {
2204 $_url_params['single_table'] = 'true';
2206 if (!$header_shown) {
2208 $header_shown = TRUE;
2210 $_url_params['unlim_num_rows'] = $unlim_num_rows;
2213 * At this point we don't know the table name; this can happen
2214 * for example with a query like
2215 * SELECT bike_code FROM (SELECT bike_code FROM bikes) tmp
2216 * As a workaround we set in the table parameter the name of the
2217 * first table of this database, so that tbl_export.php and
2218 * the script it calls do not fail
2220 if (empty($_url_params['table'])) {
2221 $_url_params['table'] = PMA_DBI_fetch_value("SHOW TABLES");
2224 echo PMA_linkOrButton(
2225 'tbl_export.php' . PMA_generate_common_url($_url_params),
2226 PMA_getIcon('b_tblexport.png', __('Export'), false, true),
2227 '', true, true, '') . "\n";
2230 echo PMA_linkOrButton(
2231 'tbl_chart.php' . PMA_generate_common_url($_url_params),
2232 PMA_getIcon('b_chart.png', __('Display chart'), false, true),
2233 '', true, true, '') . "\n";
2239 * @todo detect privileges to create a view
2240 * (but see 2006-01-19 note in display_create_table.lib.php,
2241 * I think we cannot detect db-specific privileges reliably)
2242 * Note: we don't display a Create view link if we found a PROCEDURE clause
2244 if (!$header_shown) {
2246 $header_shown = TRUE;
2248 if (! isset($analyzed_sql[0]['queryflags']['procedure'])) {
2249 echo PMA_linkOrButton(
2250 'view_create.php' . $url_query,
2251 PMA_getIcon('b_views.png', 'CREATE VIEW', false, true),
2252 '', true, true, '') . "\n";
2254 if ($header_shown) {
2255 echo '</fieldset><br />';
2260 * Verifies what to do with non-printable contents (binary or BLOB)
2266 * @uses PMA_formatByteDown()
2268 * @uses str_replace()
2269 * @param string $category BLOB|BINARY
2270 * @param string $content the binary content
2271 * @param string $transform_function
2272 * @param string $transform_options
2273 * @param string $default_function
2274 * @param object $meta the meta-information about this field
2275 * @return mixed string or float
2277 function PMA_handle_non_printable_contents($category, $content, $transform_function, $transform_options, $default_function, $meta, $url_params = array()) {
2278 $result = '[' . $category;
2279 if (is_null($content)) {
2280 $result .= ' - NULL';
2282 } elseif (isset($content)) {
2283 $size = strlen($content);
2284 $display_size = PMA_formatByteDown($size, 3, 1);
2285 $result .= ' - '. $display_size[0] . $display_size[1];
2289 if (strpos($transform_function, 'octetstream')) {
2293 if ($default_function != $transform_function) {
2294 $result = $transform_function($result, $transform_options, $meta);
2296 $result = $default_function($result, array(), $meta);
2297 if (stristr($meta->type
, 'BLOB') && $_SESSION['tmp_user_values']['display_blob']) {
2298 // in this case, restart from the original $content
2299 $result = htmlspecialchars(PMA_replace_binary_contents($content));
2301 /* Create link to download */
2302 if (count($url_params) > 0) {
2303 $result = '<a href="tbl_get_field.php' . PMA_generate_common_url($url_params) . '">' . $result . '</a>';
2311 * Prepares the displayable content of a data cell in Browse mode,
2312 * taking into account foreign key description field and transformations
2315 * @uses PMA_backquote()
2316 * @uses PMA_DBI_try_query()
2317 * @uses PMA_DBI_num_rows()
2318 * @uses PMA_DBI_fetch_row()
2319 * @uses PMA_DBI_free_result()
2320 * @uses $GLOBALS['printview']
2321 * @uses htmlspecialchars()
2322 * @uses PMA_generate_common_url()
2323 * @param string $mouse_events
2324 * @param string $class
2325 * @param string $condition_field
2326 * @param string $analyzed_sql
2327 * @param object $meta the meta-information about this field
2328 * @param string $map
2329 * @param string $data
2330 * @param string $transform_function
2331 * @param string $default_function
2332 * @param string $nowrap
2333 * @param string $where_comparison
2334 * @param bool $is_field_truncated
2335 * @return string formatted data
2337 function PMA_prepare_row_data($mouse_events, $class, $condition_field, $analyzed_sql, $meta, $map, $data, $transform_function, $default_function, $nowrap, $where_comparison, $transform_options, $is_field_truncated ) {
2339 // Define classes to be added to this data field based on the type of data
2341 if(strpos($meta->flags
, 'enum') !== false) {
2342 $enum_class = ' enum';
2345 $mime_type_class = '';
2346 if(isset($meta->mimetype
)) {
2347 $mime_type_class = ' ' . preg_replace('/\//', '_', $meta->mimetype
);
2350 // continue the <td> tag started before calling this function:
2351 $result = $mouse_events . ' class="' . $class . ($condition_field ?
' condition' : '') . $nowrap
2352 . ' ' . ($is_field_truncated ?
' truncated' : '')
2353 . ($transform_function != $default_function ?
' transformed' : '')
2354 . (isset($map[$meta->name
]) ?
' relation' : '')
2355 . $enum_class . $mime_type_class . '">';
2357 if (isset($analyzed_sql[0]['select_expr']) && is_array($analyzed_sql[0]['select_expr'])) {
2358 foreach ($analyzed_sql[0]['select_expr'] AS $select_expr_position => $select_expr) {
2359 $alias = $analyzed_sql[0]['select_expr'][$select_expr_position]['alias'];
2360 if (isset($alias) && strlen($alias)) {
2361 $true_column = $analyzed_sql[0]['select_expr'][$select_expr_position]['column'];
2362 if ($alias == $meta->name
) {
2363 // this change in the parameter does not matter
2364 // outside of the function
2365 $meta->name
= $true_column;
2371 if (isset($map[$meta->name
])) {
2372 // Field to display from the foreign table?
2373 if (isset($map[$meta->name
][2]) && strlen($map[$meta->name
][2])) {
2374 $dispsql = 'SELECT ' . PMA_backquote($map[$meta->name
][2])
2375 . ' FROM ' . PMA_backquote($map[$meta->name
][3])
2376 . '.' . PMA_backquote($map[$meta->name
][0])
2377 . ' WHERE ' . PMA_backquote($map[$meta->name
][1])
2378 . $where_comparison;
2379 $dispresult = PMA_DBI_try_query($dispsql, null, PMA_DBI_QUERY_STORE
);
2380 if ($dispresult && PMA_DBI_num_rows($dispresult) > 0) {
2381 list($dispval) = PMA_DBI_fetch_row($dispresult, 0);
2383 $dispval = __('Link not found');
2385 @PMA_DBI_free_result
($dispresult);
2388 } // end if... else...
2390 if (isset($GLOBALS['printview']) && $GLOBALS['printview'] == '1') {
2391 $result .= ($transform_function != $default_function ?
$transform_function($data, $transform_options, $meta) : $transform_function($data, array(), $meta)) . ' <code>[->' . $dispval . ']</code>';
2394 if ('K' == $_SESSION['tmp_user_values']['relational_display']) {
2395 // user chose "relational key" in the display options, so
2396 // the title contains the display field
2397 $title = (! empty($dispval))?
' title="' . htmlspecialchars($dispval) . '"' : '';
2399 $title = ' title="' . htmlspecialchars($data) . '"';
2402 $_url_params = array(
2403 'db' => $map[$meta->name
][3],
2404 'table' => $map[$meta->name
][0],
2406 'sql_query' => 'SELECT * FROM '
2407 . PMA_backquote($map[$meta->name
][3]) . '.' . PMA_backquote($map[$meta->name
][0])
2408 . ' WHERE ' . PMA_backquote($map[$meta->name
][1])
2409 . $where_comparison,
2411 $result .= '<a href="sql.php' . PMA_generate_common_url($_url_params)
2412 . '"' . $title . '>';
2414 if ($transform_function != $default_function) {
2415 // always apply a transformation on the real data,
2416 // not on the display field
2417 $result .= $transform_function($data, $transform_options, $meta);
2419 if ('D' == $_SESSION['tmp_user_values']['relational_display']) {
2420 // user chose "relational display field" in the
2421 // display options, so show display field in the cell
2422 $result .= $transform_function($dispval, array(), $meta);
2424 // otherwise display data in the cell
2425 $result .= $transform_function($data, array(), $meta);
2431 $result .= ($transform_function != $default_function ?
$transform_function($data, $transform_options, $meta) : $transform_function($data, array(), $meta));
2433 $result .= '</td>' . "\n";