?  search:
summary | log | graphiclog1 | graphiclog2 | commit | commitdiff | tree | refs | edit | fork
blame | history | raw | HEAD
Drizzle dbi - PMA_DBI_get_host_info - work around a segfault
[phpmyadmin.git] / libraries / display_tbl.lib.php
blob566b4a39aec219d26bd35af41bd2e2a25c2b77dc
1 <?php
2 /* vim: set expandtab sw=4 ts=4 sts=4: */
3 /**
4 * library for displaying table with results from all sort of select queries
5 *
6 * @package phpMyAdmin
7 */
8
9 /**
10 *
11 */
12 require_once './libraries/Index.class.php';
13
14 /**
15 * Defines the display mode to use for the results of a SQL query
16 *
17 * It uses a synthetic string that contains all the required informations.
18 * In this string:
19 * - the first two characters stand for the action to do while
20 * clicking on the "edit" link (e.g. 'ur' for update a row, 'nn' for no
21 * edit link...);
22 * - the next two characters stand for the action to do while
23 * clicking on the "delete" link (e.g. 'kp' for kill a process, 'nn' for
24 * no delete link...);
25 * - the next characters are boolean values (1/0) and respectively stand
26 * for sorting links, navigation bar, "insert a new row" link, the
27 * bookmark feature, the expand/collapse text/blob fields button and
28 * the "display printable view" option.
29 * Of course '0'/'1' means the feature won't/will be enabled.
30 *
31 * @param string &$the_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)
37 *
38 * @return array an array with explicit indexes for all the display
39 * elements
40 *
41 * @global string the database name
42 * @global string the table name
43 * @global integer the total number of rows returned by the SQL query
44 * without any programmatically appended "LIMIT" clause
45 * @global array the properties of the fields returned by the query
46 * @global string the URL to return to in case of error in a SQL
47 * statement
48 *
49 * @access private
50 *
51 * @see PMA_displayTable()
52 */
53 function PMA_setDisplayMode(&$the_disp_mode, &$the_total)
54 {
55 global $db, $table;
56 global $unlim_num_rows, $fields_meta;
57 global $err_url;
58
59 // 1. Initializes the $do_display array
60 $do_display = array();
61 $do_display['edit_lnk'] = $the_disp_mode[0] . $the_disp_mode[1];
62 $do_display['del_lnk'] = $the_disp_mode[2] . $the_disp_mode[3];
63 $do_display['sort_lnk'] = (string) $the_disp_mode[4];
64 $do_display['nav_bar'] = (string) $the_disp_mode[5];
65 $do_display['ins_row'] = (string) $the_disp_mode[6];
66 $do_display['bkm_form'] = (string) $the_disp_mode[7];
67 $do_display['text_btn'] = (string) $the_disp_mode[8];
68 $do_display['pview_lnk'] = (string) $the_disp_mode[9];
69
70 // 2. Display mode is not "false for all elements" -> updates the
71 // display mode
72 if ($the_disp_mode != 'nnnn000000') {
73 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';
95 } else {
96 $do_display['text_btn'] = (string) '0';
97 }
98 $do_display['pview_lnk'] = (string) '1';
99 } elseif ($GLOBALS['is_show']) {
100 // 2.2 Statement is a "SHOW..."
101 /**
102 * 2.2.1
103 * @todo defines edit/delete links depending on show statement
104 */
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
109 } else {
110 // Default case -> no links
111 $do_display['edit_lnk'] = 'nn'; // no edit link
112 $do_display['del_lnk'] = 'nn'; // no delete link
113 }
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';
121 } else {
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?
133 if ($is_link
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';
137 /**
138 * @todo May be problematic with same fields names in two joined table.
139 */
140 // $do_display['sort_lnk'] = (string) '0';
141 $do_display['ins_row'] = (string) '0';
142 if ($do_display['text_btn'] == '1') {
143 break;
144 }
145 } // end if (2.3.2)
146 // 2.3.3 Always display print view link
147 $do_display['pview_lnk'] = (string) '1';
148 $prev_table = $fields_meta[$i]->table;
149 } // end for
150 } // end if..elseif...else (2.1 -> 2.3)
151 } // end if (2)
152
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);
159 }
160
161 // 4. If navigation bar or sorting fields names URLs should be
162 // displayed but there is only one row, change these settings to
163 // false
164 if ($do_display['nav_bar'] == '1' || $do_display['sort_lnk'] == '1') {
165
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';
174 }
175 } // end if (3)
176
177 // 5. Updates the synthetic var
178 $the_disp_mode = join('', $do_display);
179
180 return $do_display;
181 } // end of the 'PMA_setDisplayMode()' function
182
183
184 /**
185 * Return true if we are executing a query in the form of
186 * "SELECT * FROM <a table> ..."
187 *
188 * @return boolean
189 */
190 function PMA_isSelect()
191 {
192 // global variables set from sql.php
193 global $is_count, $is_export, $is_func, $is_analyse;
194 global $analyzed_sql;
195
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;
200 }
201
202
203 /**
204 * Displays a navigation button
205 *
206 *
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
214 *
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
218 *
219 * @access private
220 *
221 * @see PMA_displayTableNavigation()
222 */
223 function PMA_displayTableNavigationOneButton($caption, $title, $pos, $html_sql_query, $onsubmit = '', $input_for_real_end = '', $onclick = '') {
224
225 global $db, $table, $goto;
226
227 $caption_output = '';
228 // for true or 'both'
229 if ($GLOBALS['cfg']['NavigationBarIconic']) {
230 $caption_output .= $caption;
231 }
232 // for false or 'both'
233 if (false === $GLOBALS['cfg']['NavigationBarIconic'] || 'both' === $GLOBALS['cfg']['NavigationBarIconic']) {
234 $caption_output .= '&nbsp;' . $title;
235 }
236 $title_output = ' title="' . $title . '"';
237 ?>
238 <td>
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; ?> />
246 </form>
247 </td>
248 <?php
249 } // end function PMA_displayTableNavigationOneButton()
250
251 /**
252 * Displays a navigation bar to browse among the results of a SQL query
253 *
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
258 *
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
263 * SQL query
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
268 *
269 * @access private
270 *
271 * @see PMA_displayTable()
272 */
273 function PMA_displayTableNavigation($pos_next, $pos_prev, $sql_query, $id_for_direction_dropdown)
274 {
275 global $db, $table, $goto;
276 global $num_rows, $unlim_num_rows;
277 global $is_innodb;
278 global $showtable;
279
280 // here, using htmlentities() would cause problems if the query
281 // contains accented characters
282 $html_sql_query = htmlspecialchars($sql_query);
283
284 /**
285 * @todo move this to a central place
286 * @todo for other future table types
287 */
288 $is_innodb = (isset($showtable['Type']) && $showtable['Type'] == 'InnoDB');
289
290 ?>
291
292 <!-- Navigation bar -->
293 <table border="0" cellpadding="0" cellspacing="0" class="navigation">
294 <tr>
295 <td class="navigation_separator"></td>
296 <?php
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('&lt;&lt;', __('Begin'), 0, $html_sql_query);
300 PMA_displayTableNavigationOneButton('&lt;', __('Previous'), $pos_prev, $html_sql_query);
301
302 } // end move back
303
304 //page redirection
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']);
309
310 if ($nbTotalPage > 1) { //if2
311 ?>
312 <td>
313 <?php
314 $_url_params = array(
315 'db' => $db,
316 'table' => $table,
317 'sql_query' => $sql_query,
318 'goto' => $goto,
319 );
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'],
325 $pageNow,
326 $nbTotalPage,
327 200,
328 5,
329 5,
330 20,
331 10
332 );
333 ?>
334 </form>
335 </td>
336 <?php
337 } //_if2
338 } //_if1
339
340 // Display the "Show all" button if allowed
341 if ($GLOBALS['cfg']['ShowAll'] && ($num_rows < $unlim_num_rows)) {
342 echo "\n";
343 ?>
344 <td>
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'); ?>" />
352 </form>
353 </td>
354 <?php
355 } // end show all
356
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') {
360
361 // display the Next button
362 PMA_displayTableNavigationOneButton('&gt;',
363 __('Next'),
364 $pos_next,
365 $html_sql_query);
366
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
371 $onclick = '';
372 } else {
373 $input_for_real_end = $onclick = '';
374 }
375
376 // display the End button
377 PMA_displayTableNavigationOneButton('&gt;&gt;',
378 __('End'),
379 @((ceil($unlim_num_rows / $_SESSION['tmp_user_values']['max_rows'])- 1) * $_SESSION['tmp_user_values']['max_rows']),
380 $html_sql_query,
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') . '"',
382 $input_for_real_end,
383 $onclick
384 );
385 } // end move toward
386
387 // show separator if pagination happen
388 if ($nbTotalPage > 1) {
389 echo '<td><div class="navigation_separator">|</div></td>';
390 }
391 ?>
392 <td>
393 <div class="restore_column hide">
394 <input type="submit" value="<?php echo __('Restore column order'); ?>" />
395 <div class="navigation_separator">|</div>
396 </div>
397 <?php
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);
402 if ($col_order) {
403 echo '<input id="col_order" type="hidden" value="' . implode(',', $col_order) . '" />';
404 }
405 $col_visib = $pmatable->getUiProp(PMA_Table::PROP_COLUMN_VISIB);
406 if ($col_visib) {
407 echo '<input id="col_visib" type="hidden" value="' . implode(',', $col_visib) . '" />';
408 }
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') . '" />';
412 }
413 // generate hints
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') . '" />';
419 ?>
420 </td>
421
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) &amp;&amp; checkFormElementInRange(this, 'pos', '<?php echo str_replace('\'', '\\\'', __('%d is not valid row number.')); ?>', 0<?php echo $unlim_num_rows > 0 ? ',' . $unlim_num_rows - 1 : ''; ?>))">
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()" />
437 <?php
438 if ($GLOBALS['cfg']['ShowDisplayDirection']) {
439 // Display mode (horizontal/vertical and repeat headers)
440 echo __('Mode') . ': ' . "\n";
441 $choices = array(
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);
446 unset($choices);
447 }
448
449 printf(__('Headers every %s rows'),
450 '<input type="text" size="3" name="repeat_cells" value="' . $_SESSION['tmp_user_values']['repeat_cells'] . '" class="textfield" />');
451 echo "\n";
452 ?>
453 </form>
454 </td>
455 <td class="navigation_separator"></td>
456 </tr>
457 </table>
458
459 <?php
460 } // end of the 'PMA_displayTableNavigation()' function
461
462
463 /**
464 * Displays the headers of the results table
465 *
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
470 *
471 * @return boolean $clause_is_unique
472 *
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
478 * SQL query
479 * @global array $vertical_display informations used with vertical display
480 * mode
481 *
482 * @access private
483 *
484 * @see PMA_displayTable()
485 */
486 function PMA_displayTableHeaders(&$is_display, &$fields_meta, $fields_cnt = 0, $analyzed_sql = '', $sort_expression, $sort_expression_nodirection, $sort_direction)
487 {
488 global $db, $table, $goto;
489 global $sql_query, $num_rows;
490 global $vertical_display, $highlight_columns;
491
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'];
496
497 if ($analyzed_sql == '') {
498 $analyzed_sql = array();
499 }
500
501 // can the result be sorted?
502 if ($is_display['sort_lnk'] == '1') {
503
504 // Just as fallback
505 $unsorted_sql_query = $sql_query;
506 if (isset($analyzed_sql[0]['unsorted_query'])) {
507 $unsorted_sql_query = $analyzed_sql[0]['unsorted_query'];
508 }
509 // Handles the case of multiple clicks on a column's header
510 // which would add many spaces before "ORDER BY" in the
511 // generated query.
512 $unsorted_sql_query = trim($unsorted_sql_query);
513
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) {
518
519 // grab indexes data:
520 $indexes = PMA_Index::getFromTable($table, $db);
521
522 // do we have any index?
523 if ($indexes) {
524
525 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
526 || $_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
527 $span = $fields_cnt;
528 if ($is_display['edit_lnk'] != 'nn') {
529 $span++;
530 }
531 if ($is_display['del_lnk'] != 'nn') {
532 $span++;
533 }
534 if ($is_display['del_lnk'] != 'kp' && $is_display['del_lnk'] != 'nn') {
535 $span++;
536 }
537 } else {
538 $span = $num_rows + floor($num_rows/$_SESSION['tmp_user_values']['repeat_cells']) + 1;
539 }
540
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";
544 $used_index = false;
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>';
560 }
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";
565 }
566 }
567 }
568
569
570 $vertical_display['emptypre'] = 0;
571 $vertical_display['emptyafter'] = 0;
572 $vertical_display['textbtn'] = '';
573
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" ';
579 }
580 echo '>';
581 $url_params = array(
582 'db' => $db,
583 'table' => $table,
584 'sql_query' => $sql_query,
585 'goto' => $goto,
586 'display_options_form' => 1
587 );
588 echo PMA_generate_common_hidden_inputs($url_params);
589 echo '<br />';
590 PMA_generate_slider_effect('displayoptions',__('Options'));
591 echo '<fieldset>';
592
593 echo '<div class="formelement">';
594 $choices = array(
595 'P' => __('Partial texts'),
596 'F' => __('Full texts')
597 );
598 PMA_display_html_radio('display_text', $choices, $_SESSION['tmp_user_values']['display_text']);
599 echo '</div>';
600
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';
607 } else {
608 $tmp_image_file = $GLOBALS['pmaThemeImage'] . 's_fulltext.png';
609 $tmp_txt = __('Full texts');
610 $url_params['display_text'] = 'F';
611 }
612
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);
617
618
619 if ($GLOBALS['cfgRelation']['relwork'] && $GLOBALS['cfgRelation']['displaywork']) {
620 echo '<div class="formelement">';
621 $choices = array(
622 'K' => __('Relational key'),
623 'D' => __('Relational display column')
624 );
625 PMA_display_html_radio('relational_display', $choices, $_SESSION['tmp_user_values']['relational_display']);
626 echo '</div>';
627 }
628
629 echo '<div class="formelement">';
630 PMA_display_html_checkbox('display_binary', __('Show binary contents'), ! empty($_SESSION['tmp_user_values']['display_binary']), false);
631 echo '<br />';
632 PMA_display_html_checkbox('display_blob', __('Show BLOB contents'), ! empty($_SESSION['tmp_user_values']['display_blob']), false);
633 echo '<br />';
634 PMA_display_html_checkbox('display_binary_as_hex', __('Show binary contents as HEX'), ! empty($_SESSION['tmp_user_values']['display_binary_as_hex']), false);
635 echo '</div>';
636
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);
643 echo '</div>';
644
645 echo '<div class="formelement">';
646 $choices = array(
647 'GEOM' => __('Geometry'),
648 'WKT' => __('Well Known Text'),
649 'WKB' => __('Well Known Binary')
650 );
651 PMA_display_html_radio('geometry_display', $choices, $_SESSION['tmp_user_values']['geometry_display']);
652 echo '</div>';
653
654 echo '<div class="clearfloat"></div>';
655 echo '</fieldset>';
656
657 echo '<fieldset class="tblFooters">';
658 echo '<input type="submit" value="' . __('Go') . '" />';
659 echo '</fieldset>';
660 echo '</div>';
661 echo '</form>';
662 }
663
664 // Start of form for multi-rows edit/delete/export
665
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" ';
670 }
671 echo '>' . "\n";
672 echo PMA_generate_common_hidden_inputs($db, $table, 1);
673 echo '<input type="hidden" name="goto" value="sql.php" />' . "\n";
674 }
675
676 echo '<table id="table_results" class="data';
677 if ($GLOBALS['cfg']['AjaxEnable']) {
678 echo ' ajax';
679 }
680 echo '">' . "\n";
681 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
682 || $_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
683 echo '<thead><tr>' . "\n";
684 }
685
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')
690 ? ' colspan="4"'
691 : '';
692 } else {
693 $rowspan = ($is_display['edit_lnk'] != 'nn' && $is_display['del_lnk'] != 'nn')
694 ? ' rowspan="4"'
695 : '';
696 }
697
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') {
704 ?>
705 <th colspan="<?php echo $fields_cnt; ?>"></th>
706 </tr>
707 <tr>
708 <?php
709 } // end horizontal/horizontalflipped mode
710 else {
711 ?>
712 <tr>
713 <th colspan="<?php echo $num_rows + floor($num_rows/$_SESSION['tmp_user_values']['repeat_cells']) + 1; ?>"></th>
714 </tr>
715 <?php
716 } // end vertical mode
717 }
718
719 // ... at the left column of the result table header if possible
720 // and required
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') {
726 ?>
727 <th <?php echo $colspan; ?>><?php echo $full_or_partial_text_link;?></th>
728 <?php
729 } // end horizontal/horizontalflipped mode
730 else {
731 $vertical_display['textbtn'] = ' <th ' . $rowspan . ' valign="middle">' . "\n"
732 . ' ' . "\n"
733 . ' </th>' . "\n";
734 } // end vertical mode
735 }
736
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') {
743 ?>
744 <td<?php echo $colspan; ?>></td>
745 <?php
746 } // end horizontal/horizontalfipped mode
747 else {
748 $vertical_display['textbtn'] = ' <td' . $rowspan . '></td>' . "\n";
749 } // end vertical mode
750 }
751
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')) {
755 echo '<th></th>';
756 }
757
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)
761
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);
771 unset($tb);
772 }
773 }
774 }
775
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);
779 }
780
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'])) {
786
787 $wi = 0;
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';
791 }
792 }
793 }
794
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);
800 } else {
801 $col_order = false;
802 $col_visib = false;
803 }
804
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
809 // where-query.
810 if (isset($highlight_columns[$fields_meta[$i]->name]) || isset($highlight_columns[PMA_backquote($fields_meta[$i]->name)])) {
811 $condition_field = true;
812 } else {
813 $condition_field = false;
814 }
815
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>';
821 } else {
822 $comments = '';
823 }
824
825 // 2.1 Results can be sorted
826 if ($is_display['sort_lnk'] == '1') {
827
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`
833
834 if (isset($fields_meta[$i]->table) && strlen($fields_meta[$i]->table)) {
835 $sort_tbl = PMA_backquote($fields_meta[$i]->table) . '.';
836 } else {
837 $sort_tbl = '';
838 }
839
840 // 2.1.2 Checks if the current column is used to sort the
841 // results
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;
847 }
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);
852
853 if (empty($sort_expression)) {
854 $is_in_sort = false;
855 } else {
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;
867 }
868 $is_in_sort = (str_replace('`', '', $sort_tbl) . $name_to_use_in_sort == str_replace('`', '', $sort_expression_nodirection) ? true : false);
869 }
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 . ' ';
875 } else {
876 $sort_order = ' ORDER BY ' . $sort_tbl . PMA_backquote($name_to_use_in_sort) . ' ';
877 }
878 unset($name_to_use_in_sort);
879
880 // 2.1.4 Do define the sorting URL
881 if (! $is_in_sort) {
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';
886 } else {
887 $sort_order .= $GLOBALS['cfg']['Order'];
888 }
889 $order_img = '';
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 . '" />';
893 } else {
894 $sort_order .= ' DESC';
895 $order_img = ' <img class="icon ic_s_asc" src="themes/dot.gif" alt="'. __('Ascending') . '" title="'. __('Ascending') . '" id="soimg' . $i . '" />';
896 }
897
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];
900 } else {
901 $sorted_sql_query = $unsorted_sql_query . $sort_order;
902 }
903 $_url_params = array(
904 'db' => $db,
905 'table' => $table,
906 'sql_query' => $sorted_sql_query,
907 'session_max_rows' => $session_max_rows
908 );
909 $order_url = 'sql.php' . PMA_generate_common_url($_url_params);
910
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\'); }';
921 }
922 }
923 if ($GLOBALS['cfg']['HeaderFlipType'] == 'auto') {
924 if (PMA_USR_BROWSER_AGENT == 'IE') {
925 $GLOBALS['cfg']['HeaderFlipType'] = 'css';
926 } else {
927 $GLOBALS['cfg']['HeaderFlipType'] = 'fake';
928 }
929 }
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;';
933 }
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);
937
938 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
939 || $_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
940 echo '<th';
941 $th_class = array();
942 $th_class[] = 'draggable';
943 if ($col_visib && !$col_visib[$j]) {
944 $th_class[] = 'hide';
945 }
946 if ($condition_field) {
947 $th_class[] = 'condition';
948 }
949 $th_class[] = 'column_heading';
950 if ($GLOBALS['cfg']['BrowsePointerEnable'] == true) {
951 $th_class[] = 'pointer';
952 }
953 if ($GLOBALS['cfg']['BrowseMarkerEnable'] == true) {
954 $th_class[] = 'marker';
955 }
956 echo ' class="' . implode(' ', $th_class) . '"';
957
958 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
959 echo ' valign="bottom"';
960 }
961 echo '>' . $order_link . $comments . '</th>';
962 }
963 $vertical_display['desc'][] = ' <th '
964 . 'class="draggable'
965 . ($condition_field ? ' condition' : '')
966 . '">' . "\n"
967 . $order_link . $comments . ' </th>' . "\n";
968 } // end if (2.1)
969
970 // 2.2 Results can't be sorted
971 else {
972 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
973 || $_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
974 echo '<th';
975 $th_class = array();
976 $th_class[] = 'draggable';
977 if ($col_visib && !$col_visib[$j]) {
978 $th_class[] = 'hide';
979 }
980 if ($condition_field) {
981 $th_class[] = 'condition';
982 }
983 echo ' class="' . implode(' ', $th_class) . '"';
984 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
985 echo ' valign="bottom"';
986 }
987 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped'
988 && $GLOBALS['cfg']['HeaderFlipType'] == 'css') {
989 echo ' style="direction: ltr; writing-mode: tb-rl;"';
990 }
991 echo '>';
992 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped'
993 && $GLOBALS['cfg']['HeaderFlipType'] == 'fake') {
994 echo PMA_flipstring(htmlspecialchars($fields_meta[$i]->name), '<br />');
995 } else {
996 echo htmlspecialchars($fields_meta[$i]->name);
997 }
998 echo "\n" . $comments . '</th>';
999 }
1000 $vertical_display['desc'][] = ' <th '
1001 . 'class="draggable'
1002 . ($condition_field ? ' condition"' : '')
1003 . '">' . "\n"
1004 . ' ' . htmlspecialchars($fields_meta[$i]->name) . "\n"
1005 . $comments . ' </th>';
1006 } // end else (2.2)
1007 } // end for
1008
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') {
1017 echo "\n";
1018 ?>
1019 <th <?php echo $colspan; ?>><?php echo $full_or_partial_text_link;?>
1020 </th>
1021 <?php
1022 } // end horizontal/horizontalflipped mode
1023 else {
1024 $vertical_display['textbtn'] = ' <th ' . $rowspan . ' valign="middle">' . "\n"
1025 . ' ' . "\n"
1026 . ' </th>' . "\n";
1027 } // end vertical mode
1028 }
1029
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') {
1038 echo "\n";
1039 ?>
1040 <td<?php echo $colspan; ?>></td>
1041 <?php
1042 } // end horizontal/horizontalflipped mode
1043 else {
1044 $vertical_display['textbtn'] = ' <td' . $rowspan . '></td>' . "\n";
1045 } // end vertical mode
1046 }
1047
1048 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
1049 || $_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
1050 ?>
1051 </tr>
1052 </thead>
1053 <?php
1054 }
1055
1056 return true;
1057 } // end of the 'PMA_displayTableHeaders()' function
1058
1059
1060 /**
1061 * Prepares the display for a value
1062 *
1063 * @param string $class
1064 * @param string $condition_field
1065 * @param string $value
1066 *
1067 * @return string the td
1068 */
1069 function PMA_buildValueDisplay($class, $condition_field, $value) {
1070 return '<td align="left"' . ' class="' . $class . ($condition_field ? ' condition' : '') . '">' . $value . '</td>';
1071 }
1072
1073 /**
1074 * Prepares the display for a null value
1075 *
1076 * @param string $class
1077 * @param string $condition_field
1078 *
1079 * @return string the td
1080 */
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>';
1084 }
1085
1086 /**
1087 * Prepares the display for an empty value
1088 *
1089 * @param string $class
1090 * @param string $condition_field
1091 * @param string $align
1092 *
1093 * @return string the td
1094 */
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>';
1098 }
1099
1100 /**
1101 * Adds the relavant classes.
1102 *
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
1110 *
1111 * @return string the list of classes
1112 */
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
1115 $enum_class = '';
1116 if (strpos($meta->flags, 'enum') !== false) {
1117 $enum_class = ' enum';
1118 }
1119
1120 $set_class = '';
1121 if (strpos($meta->flags, 'set') !== false) {
1122 $set_class = ' set';
1123 }
1124
1125 $bit_class = '';
1126 if (strpos($meta->type, 'bit') !== false) {
1127 $bit_class = ' bit';
1128 }
1129
1130 $mime_type_class = '';
1131 if (isset($meta->mimetype)) {
1132 $mime_type_class = ' ' . preg_replace('/\//', '_', $meta->mimetype);
1133 }
1134
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;
1139
1140 return $result;
1141 }
1142 /**
1143 * Displays the body of the results table
1144 *
1145 * @param integer the link id associated to the query which results have
1146 * to be displayed
1147 * @param array which elements to display
1148 * @param array the list of relations
1149 * @param array the analyzed query
1150 *
1151 * @return boolean always true
1152 *
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
1159 * the SQL query
1160 * @global array $vertical_display informations used with vertical display
1161 * mode
1162 * @global array $highlight_columns column names to highlight
1163 * @global array $row current row data
1164 *
1165 * @access private
1166 *
1167 * @see PMA_displayTable()
1168 */
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
1174
1175 $url_sql_query = $sql_query;
1176
1177 // query without conditions to shorten URLs when needed, 200 is just
1178 // guess, it should depend on remaining URL length
1179
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) {
1183
1184 $url_sql_query = 'SELECT ';
1185 if (isset($analyzed_sql[0]['queryflags']['distinct'])) {
1186 $url_sql_query .= ' DISTINCT ';
1187 }
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'];
1191 }
1192 }
1193
1194 if (! is_array($map)) {
1195 $map = array();
1196 }
1197 $row_no = 0;
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';
1205
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);
1211 } else {
1212 $col_order = false;
1213 $col_visib = false;
1214 }
1215
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
1219 // tables.
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.
1227
1228 $odd_row = true;
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'))
1234 {
1235 echo '<tr>' . "\n";
1236 if ($vertical_display['emptypre'] > 0) {
1237 echo ' <th colspan="' . $vertical_display['emptypre'] . '">' . "\n"
1238 .' &nbsp;</th>' . "\n";
1239 } else if ($GLOBALS['cfg']['RowActionLinks'] == 'none') {
1240 echo ' <th></th>' . "\n";
1241 }
1242
1243 foreach ($vertical_display['desc'] as $val) {
1244 echo $val;
1245 }
1246
1247 if ($vertical_display['emptyafter'] > 0) {
1248 echo ' <th colspan="' . $vertical_display['emptyafter'] . '">' . "\n"
1249 .' &nbsp;</th>' . "\n";
1250 }
1251 echo '</tr>' . "\n";
1252 } // end if
1253
1254 $alternating_color_class = ($odd_row ? 'odd' : 'even');
1255 $odd_row = ! $odd_row;
1256
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 . '">';
1261 }
1262
1263
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)
1267 /**
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
1271 */
1272 list($where_clause, $clause_is_unique) = PMA_getUniqueCondition($dt_result, $fields_cnt, $fields_meta, $row);
1273 $where_clause_html = urlencode($where_clause);
1274
1275 // 1.2 Defines the URLs for the modify/delete link(s)
1276
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
1279
1280 if ($GLOBALS['cfg']['PropertiesIconic'] === 'both') {
1281 $iconic_spacer = '<div class="nowrap">';
1282 } else {
1283 $iconic_spacer = '';
1284 }
1285
1286 // 1.2.1 Modify link(s)
1287 if ($is_display['edit_lnk'] == 'ur') { // update row case
1288 $_url_params = array(
1289 'db' => $db,
1290 'table' => $table,
1291 'where_clause' => $where_clause,
1292 'clause_is_unique' => $clause_is_unique,
1293 'sql_query' => $url_sql_query,
1294 'goto' => 'sql.php',
1295 );
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'));
1298
1299 $edit_str = PMA_getIcon('b_edit.png', __('Edit'), true);
1300 $copy_str = PMA_getIcon('b_insrow.png', __('Copy'), true);
1301
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';
1306 }
1307 } // end if (1.2.1)
1308
1309 // 1.2.2 Delete/Kill link(s)
1310 if ($is_display['del_lnk'] == 'dr') { // delete row case
1311 $_url_params = array(
1312 'db' => $db,
1313 'table' => $table,
1314 'sql_query' => $url_sql_query,
1315 'message_to_show' => __('The row has been deleted'),
1316 'goto' => (empty($goto) ? 'tbl_sql.php' : $goto),
1317 );
1318 $lnk_goto = 'sql.php' . PMA_generate_common_url($_url_params, 'text');
1319
1320 $del_query = 'DELETE FROM ' . PMA_backquote($db) . '.' . PMA_backquote($table)
1321 . ' WHERE ' . $where_clause . ($clause_is_unique ? '' : ' LIMIT 1');
1322
1323 $_url_params = array(
1324 'db' => $db,
1325 'table' => $table,
1326 'sql_query' => $del_query,
1327 'message_to_show' => __('The row has been deleted'),
1328 'goto' => $lnk_goto,
1329 );
1330 $del_url = 'sql.php' . PMA_generate_common_url($_url_params);
1331
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
1337
1338 $_url_params = array(
1339 'db' => $db,
1340 'table' => $table,
1341 'sql_query' => $url_sql_query,
1342 'goto' => 'main.php',
1343 );
1344 $lnk_goto = 'sql.php' . PMA_generate_common_url($_url_params, 'text');
1345
1346 $_url_params = array(
1347 'db' => 'mysql',
1348 'sql_query' => 'KILL ' . $row[0],
1349 'goto' => $lnk_goto,
1350 );
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);
1355 } // end if (1.2.2)
1356
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)) {
1362 $js_conf = '';
1363 }
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)) {
1369 $js_conf = '';
1370 }
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);
1372 } // end if (1.3)
1373 } // end if (1)
1374
1375 // 2. Displays the rows' values
1376
1377 for ($j = 0; $j < $fields_cnt; ++$j) {
1378 // assign $i with appropriate column order
1379 $i = $col_order ? $col_order[$j] : $j;
1380
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' : '';
1387 $pointer = $i;
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 .
1392
1393 // See if this column should get highlight because it's used in the
1394 // where-query.
1395 if (isset($highlight_columns) && (isset($highlight_columns[$meta->name]) || isset($highlight_columns[PMA_backquote($meta->name)]))) {
1396 $condition_field = true;
1397 } else {
1398 $condition_field = false;
1399 }
1400
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';
1406 }
1407 if ($GLOBALS['cfg']['BrowseMarkerEnable'] == true) {
1408 $class .= ' vmarker';
1409 }
1410 }// end if
1411
1412 // Wrap MIME-transformations. [MIME]
1413 $default_function = 'default_function'; // default_function
1414 $transform_function = $default_function;
1415 $transform_options = array();
1416
1417 if ($GLOBALS['cfgRelation']['mimework'] && $GLOBALS['cfg']['BrowseMIME']) {
1418
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']);
1421
1422 if (file_exists('./libraries/transformations/' . $include_file)) {
1423 $transformfunction_name = str_replace('.inc.php', '', $GLOBALS['mime_map'][$meta->name]['transformation']);
1424
1425 require_once './libraries/transformations/' . $include_file;
1426
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']);
1431 }
1432 } // end if file_exists
1433 } // end if transformation is set
1434 } // end if mime/transformation works.
1435
1436 $_url_params = array(
1437 'db' => $db,
1438 'table' => $table,
1439 'where_clause' => $where_clause,
1440 'transform_key' => $meta->name,
1441 );
1442
1443 if (! empty($sql_query)) {
1444 $_url_params['sql_query'] = $url_sql_query;
1445 }
1446
1447 $transform_options['wrapper_link'] = PMA_generate_common_url($_url_params);
1448
1449 // n u m e r i c
1450 if ($meta->numeric == 1) {
1451
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
1456
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] != '') {
1460
1461 $nowrap = ' nowrap';
1462 $where_comparison = ' = ' . $row[$i];
1463
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);
1465 } else {
1466 $vertical_display['data'][$row_no][$i] = PMA_buildEmptyDisplay($class, $condition_field, $meta, 'align="right"');
1467 }
1468
1469 // b l o b
1470
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);
1475
1476 // remove 'inline_edit' from $class as we can't edit binary data.
1477 $class = str_replace('inline_edit', '', $class);
1478
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);
1482 } else {
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);
1487 } else {
1488 $blobtext = PMA_handle_non_printable_contents('BLOB', (isset($row[$i]) ? $row[$i] : ''), $transform_function, $transform_options, $default_function, $meta, $_url_params);
1489 }
1490
1491 $vertical_display['data'][$row_no][$i] = PMA_buildValueDisplay($class, $condition_field, $blobtext);
1492 unset($blobtext);
1493 }
1494 // not binary:
1495 } else {
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;
1503 }
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));
1507
1508 $vertical_display['data'][$row_no][$i] = PMA_buildValueDisplay($class, $condition_field, $row[$i]);
1509 } else {
1510 $vertical_display['data'][$row_no][$i] = PMA_buildEmptyDisplay($class, $condition_field, $meta);
1511 }
1512 }
1513 // g e o m e t r y
1514 } elseif ($meta->type == 'geometry') {
1515
1516 // Remove 'inline_edit' from $class as we do not allow to inline-edit geometry data.
1517 $class = str_replace('inline_edit', '', $class);
1518
1519 // Display as [GEOMETRY - (size)]
1520 if ('GEOM' == $_SESSION['tmp_user_values']['geometry_display']) {
1521 $geometry_text = PMA_handle_non_printable_contents(
1522 'GEOMETRY', (isset($row[$i]) ? $row[$i] : ''), $transform_function,
1523 $transform_options, $default_function, $meta
1524 );
1525 $vertical_display['data'][$row_no][$i] = PMA_buildValueDisplay(
1526 $class, $condition_field, $geometry_text
1527 );
1528
1529 // Display in Well Known Text(WKT) format.
1530 } elseif ('WKT' == $_SESSION['tmp_user_values']['geometry_display']) {
1531 // Convert to WKT format
1532 $wktsql = "SELECT ASTEXT (GeomFromWKB(x'" . PMA_substr(bin2hex($row[$i]), 8) . "'))";
1533 $wktresult = PMA_DBI_try_query($wktsql, null, PMA_DBI_QUERY_STORE);
1534 $wktarr = PMA_DBI_fetch_row($wktresult, 0);
1535 $wktval = $wktarr[0];
1536 @PMA_DBI_free_result($wktresult);
1537
1538 if (PMA_strlen($wktval) > $GLOBALS['cfg']['LimitChars']
1539 && $_SESSION['tmp_user_values']['display_text'] == 'P'
1540 ) {
1541 $wktval = PMA_substr($wktval, 0, $GLOBALS['cfg']['LimitChars']) . '...';
1542 $is_field_truncated = true;
1543 }
1544
1545 $vertical_display['data'][$row_no][$i] = '<td ' . PMA_prepare_row_data(
1546 $class, $condition_field, $analyzed_sql, $meta, $map, $wktval, $transform_function,
1547 $default_function, $nowrap, $where_comparison, $transform_options, $is_field_truncated
1548 );
1549
1550 // Display in Well Known Binary(WKB) format.
1551 } else {
1552 if ($_SESSION['tmp_user_values']['display_binary']) {
1553 if ($_SESSION['tmp_user_values']['display_binary_as_hex']
1554 && PMA_contains_nonprintable_ascii($row[$i])
1555 ) {
1556 $wkbval = PMA_substr(bin2hex($row[$i]), 8);
1557 } else {
1558 $wkbval = htmlspecialchars(PMA_replace_binary_contents($row[$i]));
1559 }
1560
1561 if (PMA_strlen($wkbval) > $GLOBALS['cfg']['LimitChars']
1562 && $_SESSION['tmp_user_values']['display_text'] == 'P'
1563 ) {
1564 $wkbval = PMA_substr($wkbval, 0, $GLOBALS['cfg']['LimitChars']) . '...';
1565 $is_field_truncated = true;
1566 }
1567
1568 $vertical_display['data'][$row_no][$i] = '<td ' . PMA_prepare_row_data(
1569 $class, $condition_field, $analyzed_sql, $meta, $map, $wkbval, $transform_function,
1570 $default_function, $nowrap, $where_comparison, $transform_options, $is_field_truncated
1571 );
1572 } else {
1573 $wkbval = PMA_handle_non_printable_contents(
1574 'BINARY', $row[$i], $transform_function, $transform_options, $default_function, $meta, $_url_params
1575 );
1576 $vertical_display['data'][$row_no][$i] = PMA_buildValueDisplay($class, $condition_field, $wkbval);
1577 }
1578 }
1579
1580 // n o t n u m e r i c a n d n o t B L O B
1581 } else {
1582 if (! isset($row[$i]) || is_null($row[$i])) {
1583 $vertical_display['data'][$row_no][$i] = PMA_buildNullDisplay($class, $condition_field);
1584 } elseif ($row[$i] != '') {
1585 // support blanks in the key
1586 $relation_id = $row[$i];
1587
1588 // Cut all fields to $GLOBALS['cfg']['LimitChars']
1589 // (unless it's a link-type transformation)
1590 if (PMA_strlen($row[$i]) > $GLOBALS['cfg']['LimitChars'] && $_SESSION['tmp_user_values']['display_text'] == 'P' && !strpos($transform_function, 'link') === true) {
1591 $row[$i] = PMA_substr($row[$i], 0, $GLOBALS['cfg']['LimitChars']) . '...';
1592 $is_field_truncated = true;
1593 }
1594
1595 // displays special characters from binaries
1596 $field_flags = PMA_DBI_field_flags($dt_result, $i);
1597 if (isset($meta->_type) && $meta->_type === MYSQLI_TYPE_BIT) {
1598 $row[$i] = PMA_printable_bit_value($row[$i], $meta->length);
1599 // some results of PROCEDURE ANALYSE() are reported as
1600 // being BINARY but they are quite readable,
1601 // so don't treat them as BINARY
1602 } elseif (stristr($field_flags, 'BINARY') && $meta->type == 'string' && !(isset($GLOBALS['is_analyse']) && $GLOBALS['is_analyse'])) {
1603 if ($_SESSION['tmp_user_values']['display_binary']) {
1604 // user asked to see the real contents of BINARY
1605 // fields
1606 if ($_SESSION['tmp_user_values']['display_binary_as_hex'] && PMA_contains_nonprintable_ascii($row[$i])) {
1607 $row[$i] = bin2hex($row[$i]);
1608 } else {
1609 $row[$i] = htmlspecialchars(PMA_replace_binary_contents($row[$i]));
1610 }
1611 } else {
1612 // we show the BINARY message and field's size
1613 // (or maybe use a transformation)
1614 $row[$i] = PMA_handle_non_printable_contents('BINARY', $row[$i], $transform_function, $transform_options, $default_function, $meta, $_url_params);
1615 }
1616 }
1617
1618 // transform functions may enable no-wrapping:
1619 $function_nowrap = $transform_function . '_nowrap';
1620 $bool_nowrap = (($default_function != $transform_function && function_exists($function_nowrap)) ? $function_nowrap($transform_options) : false);
1621
1622 // do not wrap if date field type
1623 $nowrap = ((preg_match('@DATE|TIME@i', $meta->type) || $bool_nowrap) ? ' nowrap' : '');
1624 $where_comparison = ' = \'' . PMA_sqlAddSlashes($row[$i]) . '\'';
1625 $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);
1626
1627 } else {
1628 $vertical_display['data'][$row_no][$i] = PMA_buildEmptyDisplay($class, $condition_field, $meta);
1629 }
1630 }
1631
1632 // output stored cell
1633 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
1634 || $_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
1635 echo $vertical_display['data'][$row_no][$i];
1636 }
1637
1638 if (isset($vertical_display['rowdata'][$i][$row_no])) {
1639 $vertical_display['rowdata'][$i][$row_no] .= $vertical_display['data'][$row_no][$i];
1640 } else {
1641 $vertical_display['rowdata'][$i][$row_no] = $vertical_display['data'][$row_no][$i];
1642 }
1643 } // end for (2)
1644
1645 // 3. Displays the modify/delete links on the right if required
1646 if (($GLOBALS['cfg']['RowActionLinks'] == 'right' || $GLOBALS['cfg']['RowActionLinks'] == 'both')
1647 && ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
1648 || $_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped')) {
1649 if (! isset($js_conf)) {
1650 $js_conf = '';
1651 }
1652 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);
1653 } // end if (3)
1654
1655 if ($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal'
1656 || $_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') {
1657 ?>
1658 </tr>
1659 <?php
1660 } // end if
1661
1662 // 4. Gather links of del_urls and edit_urls in an array for later
1663 // output
1664 if (! isset($vertical_display['edit'][$row_no])) {
1665 $vertical_display['edit'][$row_no] = '';
1666 $vertical_display['copy'][$row_no] = '';
1667 $vertical_display['delete'][$row_no] = '';
1668 $vertical_display['row_delete'][$row_no] = '';
1669 }
1670 $vertical_class = ' row_' . $row_no;
1671 if ($GLOBALS['cfg']['BrowsePointerEnable'] == true) {
1672 $vertical_class .= ' vpointer';
1673 }
1674 if ($GLOBALS['cfg']['BrowseMarkerEnable'] == true) {
1675 $vertical_class .= ' vmarker';
1676 }
1677
1678 if (!empty($del_url) && $is_display['del_lnk'] != 'kp') {
1679 $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);
1680 } else {
1681 unset($vertical_display['row_delete'][$row_no]);
1682 }
1683
1684 if (isset($edit_url)) {
1685 $vertical_display['edit'][$row_no] .= PMA_generateEditLink($edit_url, $alternating_color_class . ' ' . $edit_anchor_class . $vertical_class, $edit_str, $where_clause, $where_clause_html);
1686 } else {
1687 unset($vertical_display['edit'][$row_no]);
1688 }
1689
1690 if (isset($copy_url)) {
1691 $vertical_display['copy'][$row_no] .= PMA_generateCopyLink($copy_url, $copy_str, $where_clause, $where_clause_html, $alternating_color_class . $vertical_class);
1692 } else {
1693 unset($vertical_display['copy'][$row_no]);
1694 }
1695
1696 if (isset($del_url)) {
1697 if (! isset($js_conf)) {
1698 $js_conf = '';
1699 }
1700 $vertical_display['delete'][$row_no] .= PMA_generateDeleteLink($del_url, $del_str, $js_conf, $alternating_color_class . $vertical_class);
1701 } else {
1702 unset($vertical_display['delete'][$row_no]);
1703 }
1704
1705 echo (($_SESSION['tmp_user_values']['disp_direction'] == 'horizontal' || $_SESSION['tmp_user_values']['disp_direction'] == 'horizontalflipped') ? "\n" : '');
1706 $row_no++;
1707 } // end while
1708
1709 // this is needed by PMA_displayTable() to generate the proper param
1710 // in the multi-edit and multi-delete form
1711 return $clause_is_unique;
1712 } // end of the 'PMA_displayTableBody()' function
1713
1714
1715 /**
1716 * Do display the result table with the vertical direction mode.
1717 *
1718 * @return boolean always true
1719 *
1720 * @global array $vertical_display the information to display
1721 *
1722 * @access private
1723 *
1724 * @see PMA_displayTable()
1725 */
1726 function PMA_displayVerticalTable()
1727 {
1728 global $vertical_display;
1729
1730 // Displays "multi row delete" link at top if required
1731 if (($GLOBALS['cfg']['RowActionLinks'] != 'right')
1732 && is_array($vertical_display['row_delete']) && (count($vertical_display['row_delete']) > 0 || !empty($vertical_display['textbtn']))) {
1733 echo '<tr>' . "\n";
1734 if ($GLOBALS['cfg']['RowActionLinks'] == 'none') {
1735 // if we are not showing the RowActionLinks, then we need to show the Multi-Row-Action checkboxes
1736 echo '<th></th>' . "\n";
1737 }
1738 echo $vertical_display['textbtn'];
1739 $cell_displayed = 0;
1740 foreach ($vertical_display['row_delete'] as $val) {
1741 if (($cell_displayed != 0) && ($_SESSION['tmp_user_values']['repeat_cells'] != 0) && !($cell_displayed % $_SESSION['tmp_user_values']['repeat_cells'])) {
1742 echo '<th' .
1743 (($is_display['edit_lnk'] != 'nn' && $is_display['del_lnk'] != 'nn') ? ' rowspan="4"' : '') .
1744 '></th>' . "\n";
1745 }
1746 echo str_replace('[%_PMA_CHECKBOX_DIR_%]', '_left', $val);
1747 $cell_displayed++;
1748 } // end while
1749 echo '</tr>' . "\n";
1750 } // end if
1751
1752 // Displays "edit" link at top if required
1753 if (($GLOBALS['cfg']['RowActionLinks'] == 'left' || $GLOBALS['cfg']['RowActionLinks'] == 'both')
1754 && is_array($vertical_display['edit']) && (count($vertical_display['edit']) > 0 || !empty($vertical_display['textbtn']))) {
1755 echo '<tr>' . "\n";
1756 if (! is_array($vertical_display['row_delete'])) {
1757 echo $vertical_display['textbtn'];
1758 }
1759 foreach ($vertical_display['edit'] as $val) {
1760 echo $val;
1761 } // end while
1762 echo '</tr>' . "\n";
1763 } // end if
1764
1765 // Displays "copy" link at top if required
1766 if (($GLOBALS['cfg']['RowActionLinks'] == 'left' || $GLOBALS['cfg']['RowActionLinks'] == 'both')
1767 && is_array($vertical_display['copy']) && (count($vertical_display['copy']) > 0 || !empty($vertical_display['textbtn']))) {
1768 echo '<tr>' . "\n";
1769 if (! is_array($vertical_display['row_delete'])) {
1770 echo $vertical_display['textbtn'];
1771 }
1772 foreach ($vertical_display['copy'] as $val) {
1773 echo $val;
1774 } // end while
1775 echo '</tr>' . "\n";
1776 } // end if
1777
1778 // Displays "delete" link at top if required
1779 if (($GLOBALS['cfg']['RowActionLinks'] == 'left' || $GLOBALS['cfg']['RowActionLinks'] == 'both')
1780 && is_array($vertical_display['delete']) && (count($vertical_display['delete']) > 0 || !empty($vertical_display['textbtn']))) {
1781 echo '<tr>' . "\n";
1782 if (! is_array($vertical_display['edit']) && ! is_array($vertical_display['row_delete'])) {
1783 echo $vertical_display['textbtn'];
1784 }
1785 foreach ($vertical_display['delete'] as $val) {
1786 echo $val;
1787 } // end while
1788 echo '</tr>' . "\n";
1789 } // end if
1790
1791 if (PMA_isSelect()) {
1792 // prepare to get the column order, if available
1793 $pmatable = new PMA_Table($GLOBALS['table'], $GLOBALS['db']);
1794 $col_order = $pmatable->getUiProp(PMA_Table::PROP_COLUMN_ORDER);
1795 $col_visib = $pmatable->getUiProp(PMA_Table::PROP_COLUMN_VISIB);
1796 } else {
1797 $col_order = false;
1798 $col_visib = false;
1799 }
1800
1801 // Displays data
1802 foreach ($vertical_display['desc'] AS $j => $val) {
1803 // assign appropriate key with current column order
1804 $key = $col_order ? $col_order[$j] : $j;
1805
1806 echo '<tr' . (($col_visib && !$col_visib[$j]) ? ' class="hide"' : '') . '>' . "\n";
1807 echo $val;
1808
1809 $cell_displayed = 0;
1810 foreach ($vertical_display['rowdata'][$key] as $subval) {
1811 if (($cell_displayed != 0) && ($_SESSION['tmp_user_values']['repeat_cells'] != 0) and !($cell_displayed % $_SESSION['tmp_user_values']['repeat_cells'])) {
1812 echo $val;
1813 }
1814
1815 echo $subval;
1816 $cell_displayed++;
1817 } // end while
1818
1819 echo '</tr>' . "\n";
1820 } // end while
1821
1822 // Displays "multi row delete" link at bottom if required
1823 if (($GLOBALS['cfg']['RowActionLinks'] == 'right' || $GLOBALS['cfg']['RowActionLinks'] == 'both')
1824 && is_array($vertical_display['row_delete']) && (count($vertical_display['row_delete']) > 0 || !empty($vertical_display['textbtn']))) {
1825 echo '<tr>' . "\n";
1826 echo $vertical_display['textbtn'];
1827 $cell_displayed = 0;
1828 foreach ($vertical_display['row_delete'] as $val) {
1829 if (($cell_displayed != 0) && ($_SESSION['tmp_user_values']['repeat_cells'] != 0) && !($cell_displayed % $_SESSION['tmp_user_values']['repeat_cells'])) {
1830 echo '<th' .
1831 (($is_display['edit_lnk'] != 'nn' && $is_display['del_lnk'] != 'nn') ? ' rowspan="4"' : '') .
1832 '></th>' . "\n";
1833 }
1834
1835 echo str_replace('[%_PMA_CHECKBOX_DIR_%]', '_right', $val);
1836 $cell_displayed++;
1837 } // end while
1838 echo '</tr>' . "\n";
1839 } // end if
1840
1841 // Displays "edit" link at bottom if required
1842 if (($GLOBALS['cfg']['RowActionLinks'] == 'right' || $GLOBALS['cfg']['RowActionLinks'] == 'both')
1843 && is_array($vertical_display['edit']) && (count($vertical_display['edit']) > 0 || !empty($vertical_display['textbtn']))) {
1844 echo '<tr>' . "\n";
1845 if (! is_array($vertical_display['row_delete'])) {
1846 echo $vertical_display['textbtn'];
1847 }
1848 foreach ($vertical_display['edit'] as $val) {
1849 echo $val;
1850 } // end while
1851 echo '</tr>' . "\n";
1852 } // end if
1853
1854 // Displays "copy" link at bottom if required
1855 if (($GLOBALS['cfg']['RowActionLinks'] == 'right' || $GLOBALS['cfg']['RowActionLinks'] == 'both')
1856 && is_array($vertical_display['copy']) && (count($vertical_display['copy']) > 0 || !empty($vertical_display['textbtn']))) {
1857 echo '<tr>' . "\n";
1858 if (! is_array($vertical_display['row_delete'])) {
1859 echo $vertical_display['textbtn'];
1860 }
1861 foreach ($vertical_display['copy'] as $val) {
1862 echo $val;
1863 } // end while
1864 echo '</tr>' . "\n";
1865 } // end if
1866
1867 // Displays "delete" link at bottom if required
1868 if (($GLOBALS['cfg']['RowActionLinks'] == 'right' || $GLOBALS['cfg']['RowActionLinks'] == 'both')
1869 && is_array($vertical_display['delete']) && (count($vertical_display['delete']) > 0 || !empty($vertical_display['textbtn']))) {
1870 echo '<tr>' . "\n";
1871 if (! is_array($vertical_display['edit']) && ! is_array($vertical_display['row_delete'])) {
1872 echo $vertical_display['textbtn'];
1873 }
1874 foreach ($vertical_display['delete'] as $val) {
1875 echo $val;
1876 } // end while
1877 echo '</tr>' . "\n";
1878 }
1879
1880 return true;
1881 } // end of the 'PMA_displayVerticalTable' function
1882
1883 /**
1884 *
1885 * @todo make maximum remembered queries configurable
1886 * @todo move/split into SQL class!?
1887 * @todo currently this is called twice unnecessary
1888 * @todo ignore LIMIT and ORDER in query!?
1889 */
1890 function PMA_displayTable_checkConfigParams()
1891 {
1892 $sql_md5 = md5($GLOBALS['sql_query']);
1893
1894 $_SESSION['tmp_user_values']['query'][$sql_md5]['sql'] = $GLOBALS['sql_query'];
1895
1896 if (PMA_isValid($_REQUEST['disp_direction'], array('horizontal', 'vertical', 'horizontalflipped'))) {
1897 $_SESSION['tmp_user_values']['query'][$sql_md5]['disp_direction'] = $_REQUEST['disp_direction'];
1898 unset($_REQUEST['disp_direction']);
1899 } elseif (empty($_SESSION['tmp_user_values']['query'][$sql_md5]['disp_direction'])) {
1900 $_SESSION['tmp_user_values']['query'][$sql_md5]['disp_direction'] = $GLOBALS['cfg']['DefaultDisplay'];
1901 }
1902
1903 if (PMA_isValid($_REQUEST['repeat_cells'], 'numeric')) {
1904 $_SESSION['tmp_user_values']['query'][$sql_md5]['repeat_cells'] = $_REQUEST['repeat_cells'];
1905 unset($_REQUEST['repeat_cells']);
1906 } elseif (empty($_SESSION['tmp_user_values']['query'][$sql_md5]['repeat_cells'])) {
1907 $_SESSION['tmp_user_values']['query'][$sql_md5]['repeat_cells'] = $GLOBALS['cfg']['RepeatCells'];
1908 }
1909
1910 // as this is a form value, the type is always string so we cannot
1911 // use PMA_isValid($_REQUEST['session_max_rows'], 'integer')
1912 if ((PMA_isValid($_REQUEST['session_max_rows'], 'numeric')
1913 && (int) $_REQUEST['session_max_rows'] == $_REQUEST['session_max_rows'])
1914 || $_REQUEST['session_max_rows'] == 'all') {
1915 $_SESSION['tmp_user_values']['query'][$sql_md5]['max_rows'] = $_REQUEST['session_max_rows'];
1916 unset($_REQUEST['session_max_rows']);
1917 } elseif (empty($_SESSION['tmp_user_values']['query'][$sql_md5]['max_rows'])) {
1918 $_SESSION['tmp_user_values']['query'][$sql_md5]['max_rows'] = $GLOBALS['cfg']['MaxRows'];
1919 }
1920
1921 if (PMA_isValid($_REQUEST['pos'], 'numeric')) {
1922 $_SESSION['tmp_user_values']['query'][$sql_md5]['pos'] = $_REQUEST['pos'];
1923 unset($_REQUEST['pos']);
1924 } elseif (empty($_SESSION['tmp_user_values']['query'][$sql_md5]['pos'])) {
1925 $_SESSION['tmp_user_values']['query'][$sql_md5]['pos'] = 0;
1926 }
1927
1928 if (PMA_isValid($_REQUEST['display_text'], array('P', 'F'))) {
1929 $_SESSION['tmp_user_values']['query'][$sql_md5]['display_text'] = $_REQUEST['display_text'];
1930 unset($_REQUEST['display_text']);
1931 } elseif (empty($_SESSION['tmp_user_values']['query'][$sql_md5]['display_text'])) {
1932 $_SESSION['tmp_user_values']['query'][$sql_md5]['display_text'] = 'P';
1933 }
1934
1935 if (PMA_isValid($_REQUEST['relational_display'], array('K', 'D'))) {
1936 $_SESSION['tmp_user_values']['query'][$sql_md5]['relational_display'] = $_REQUEST['relational_display'];
1937 unset($_REQUEST['relational_display']);
1938 } elseif (empty($_SESSION['tmp_user_values']['query'][$sql_md5]['relational_display'])) {
1939 $_SESSION['tmp_user_values']['query'][$sql_md5]['relational_display'] = 'K';
1940 }
1941
1942 if (PMA_isValid($_REQUEST['geometry_display'], array('WKT', 'WKB', 'GEOM'))) {
1943 $_SESSION['tmp_user_values']['query'][$sql_md5]['geometry_display'] = $_REQUEST['geometry_display'];
1944 unset($_REQUEST['geometry_display']);
1945 } elseif (empty($_SESSION['tmp_user_values']['query'][$sql_md5]['geometry_display'])) {
1946 $_SESSION['tmp_user_values']['query'][$sql_md5]['geometry_display'] = 'GEOM';
1947 }
1948
1949 if (isset($_REQUEST['display_binary'])) {
1950 $_SESSION['tmp_user_values']['query'][$sql_md5]['display_binary'] = true;
1951 unset($_REQUEST['display_binary']);
1952 } elseif (isset($_REQUEST['display_options_form'])) {
1953 // we know that the checkbox was unchecked
1954 unset($_SESSION['tmp_user_values']['query'][$sql_md5]['display_binary']);
1955 } else {
1956 // selected by default because some operations like OPTIMIZE TABLE
1957 // and all queries involving functions return "binary" contents,
1958 // according to low-level field flags
1959 $_SESSION['tmp_user_values']['query'][$sql_md5]['display_binary'] = true;
1960 }
1961
1962 if (isset($_REQUEST['display_binary_as_hex'])) {
1963 $_SESSION['tmp_user_values']['query'][$sql_md5]['display_binary_as_hex'] = true;
1964 unset($_REQUEST['display_binary_as_hex']);
1965 } elseif (isset($_REQUEST['display_options_form'])) {
1966 // we know that the checkbox was unchecked
1967 unset($_SESSION['tmp_user_values']['query'][$sql_md5]['display_binary_as_hex']);
1968 } else {
1969 // display_binary_as_hex config option
1970 if (isset($GLOBALS['cfg']['DisplayBinaryAsHex']) && true === $GLOBALS['cfg']['DisplayBinaryAsHex']) {
1971 $_SESSION['tmp_user_values']['query'][$sql_md5]['display_binary_as_hex'] = true;
1972 }
1973 }
1974
1975 if (isset($_REQUEST['display_blob'])) {
1976 $_SESSION['tmp_user_values']['query'][$sql_md5]['display_blob'] = true;
1977 unset($_REQUEST['display_blob']);
1978 } elseif (isset($_REQUEST['display_options_form'])) {
1979 // we know that the checkbox was unchecked
1980 unset($_SESSION['tmp_user_values']['query'][$sql_md5]['display_blob']);
1981 }
1982
1983 if (isset($_REQUEST['hide_transformation'])) {
1984 $_SESSION['tmp_user_values']['query'][$sql_md5]['hide_transformation'] = true;
1985 unset($_REQUEST['hide_transformation']);
1986 } elseif (isset($_REQUEST['display_options_form'])) {
1987 // we know that the checkbox was unchecked
1988 unset($_SESSION['tmp_user_values']['query'][$sql_md5]['hide_transformation']);
1989 }
1990
1991 // move current query to the last position, to be removed last
1992 // so only least executed query will be removed if maximum remembered queries
1993 // limit is reached
1994 $tmp = $_SESSION['tmp_user_values']['query'][$sql_md5];
1995 unset($_SESSION['tmp_user_values']['query'][$sql_md5]);
1996 $_SESSION['tmp_user_values']['query'][$sql_md5] = $tmp;
1997
1998 // do not exceed a maximum number of queries to remember
1999 if (count($_SESSION['tmp_user_values']['query']) > 10) {
2000 array_shift($_SESSION['tmp_user_values']['query']);
2001 //echo 'deleting one element ...';
2002 }
2003
2004 // populate query configuration
2005 $_SESSION['tmp_user_values']['display_text'] = $_SESSION['tmp_user_values']['query'][$sql_md5]['display_text'];
2006 $_SESSION['tmp_user_values']['relational_display'] = $_SESSION['tmp_user_values']['query'][$sql_md5]['relational_display'];
2007 $_SESSION['tmp_user_values']['geometry_display'] = $_SESSION['tmp_user_values']['query'][$sql_md5]['geometry_display'];
2008 $_SESSION['tmp_user_values']['display_binary'] = isset($_SESSION['tmp_user_values']['query'][$sql_md5]['display_binary']) ? true : false;
2009 $_SESSION['tmp_user_values']['display_binary_as_hex'] = isset($_SESSION['tmp_user_values']['query'][$sql_md5]['display_binary_as_hex']) ? true : false;
2010 $_SESSION['tmp_user_values']['display_blob'] = isset($_SESSION['tmp_user_values']['query'][$sql_md5]['display_blob']) ? true : false;
2011 $_SESSION['tmp_user_values']['hide_transformation'] = isset($_SESSION['tmp_user_values']['query'][$sql_md5]['hide_transformation']) ? true : false;
2012 $_SESSION['tmp_user_values']['pos'] = $_SESSION['tmp_user_values']['query'][$sql_md5]['pos'];
2013 $_SESSION['tmp_user_values']['max_rows'] = $_SESSION['tmp_user_values']['query'][$sql_md5]['max_rows'];
2014 $_SESSION['tmp_user_values']['repeat_cells'] = $_SESSION['tmp_user_values']['query'][$sql_md5]['repeat_cells'];
2015 $_SESSION['tmp_user_values']['disp_direction'] = $_SESSION['tmp_user_values']['query'][$sql_md5]['disp_direction'];
2016
2017 /*
2018 * debugging
2019 echo '<pre>';
2020 var_dump($_SESSION['tmp_user_values']);
2021 echo '</pre>';
2022 */
2023 }
2024
2025 /**
2026 * Displays a table of results returned by a SQL query.
2027 * This function is called by the "sql.php" script.
2028 *
2029 * @param integer the link id associated to the query which results have
2030 * to be displayed
2031 * @param array the display mode
2032 * @param array the analyzed query
2033 *
2034 * @global string $db the database name
2035 * @global string $table the table name
2036 * @global string $goto the URL to go back in case of errors
2037 * @global string $sql_query the current SQL query
2038 * @global integer $num_rows the total number of rows returned by the
2039 * SQL query
2040 * @global integer $unlim_num_rows the total number of rows returned by the
2041 * SQL query without any programmatically
2042 * appended "LIMIT" clause
2043 * @global array $fields_meta the list of fields properties
2044 * @global integer $fields_cnt the total number of fields returned by
2045 * the SQL query
2046 * @global array $vertical_display informations used with vertical display
2047 * mode
2048 * @global array $highlight_columns column names to highlight
2049 * @global array $cfgRelation the relation settings
2050 *
2051 * @access private
2052 *
2053 * @see PMA_showMessage(), PMA_setDisplayMode(),
2054 * PMA_displayTableNavigation(), PMA_displayTableHeaders(),
2055 * PMA_displayTableBody(), PMA_displayResultsOperations()
2056 */
2057 function PMA_displayTable(&$dt_result, &$the_disp_mode, $analyzed_sql)
2058 {
2059 global $db, $table, $goto;
2060 global $sql_query, $num_rows, $unlim_num_rows, $fields_meta, $fields_cnt;
2061 global $vertical_display, $highlight_columns;
2062 global $cfgRelation;
2063 global $showtable;
2064
2065 // why was this called here? (already called from sql.php)
2066 //PMA_displayTable_checkConfigParams();
2067
2068 /**
2069 * @todo move this to a central place
2070 * @todo for other future table types
2071 */
2072 $is_innodb = (isset($showtable['Type']) && $showtable['Type'] == 'InnoDB');
2073
2074 if ($is_innodb
2075 && ! isset($analyzed_sql[0]['queryflags']['union'])
2076 && ! isset($analyzed_sql[0]['table_ref'][1]['table_name'])
2077 && (empty($analyzed_sql[0]['where_clause'])
2078 || $analyzed_sql[0]['where_clause'] == '1 ')) {
2079 // "j u s t b r o w s i n g"
2080 $pre_count = '~';
2081 $after_count = PMA_showHint(PMA_sanitize(__('May be approximate. See [a@./Documentation.html#faq3_11@Documentation]FAQ 3.11[/a]')));
2082 } else {
2083 $pre_count = '';
2084 $after_count = '';
2085 }
2086
2087 // 1. ----- Prepares the work -----
2088
2089 // 1.1 Gets the informations about which functionalities should be
2090 // displayed
2091 $total = '';
2092 $is_display = PMA_setDisplayMode($the_disp_mode, $total);
2093
2094 // 1.2 Defines offsets for the next and previous pages
2095 if ($is_display['nav_bar'] == '1') {
2096 if ($_SESSION['tmp_user_values']['max_rows'] == 'all') {
2097 $pos_next = 0;
2098 $pos_prev = 0;
2099 } else {
2100 $pos_next = $_SESSION['tmp_user_values']['pos'] + $_SESSION['tmp_user_values']['max_rows'];
2101 $pos_prev = $_SESSION['tmp_user_values']['pos'] - $_SESSION['tmp_user_values']['max_rows'];
2102 if ($pos_prev < 0) {
2103 $pos_prev = 0;
2104 }
2105 }
2106 } // end if
2107
2108 // 1.3 Find the sort expression
2109
2110 // we need $sort_expression and $sort_expression_nodirection
2111 // even if there are many table references
2112 if (! empty($analyzed_sql[0]['order_by_clause'])) {
2113 $sort_expression = trim(str_replace(' ', ' ', $analyzed_sql[0]['order_by_clause']));
2114 /**
2115 * Get rid of ASC|DESC
2116 */
2117 preg_match('@(.*)([[:space:]]*(ASC|DESC))@si', $sort_expression, $matches);
2118 $sort_expression_nodirection = isset($matches[1]) ? trim($matches[1]) : $sort_expression;
2119 $sort_direction = isset($matches[2]) ? trim($matches[2]) : '';
2120 unset($matches);
2121 } else {
2122 $sort_expression = $sort_expression_nodirection = $sort_direction = '';
2123 }
2124
2125 // 1.4 Prepares display of first and last value of the sorted column
2126
2127 if (! empty($sort_expression_nodirection)) {
2128 if (strpos($sort_expression_nodirection, '.') === false) {
2129 $sort_table = $table;
2130 $sort_column = $sort_expression_nodirection;
2131 } else {
2132 list($sort_table, $sort_column) = explode('.', $sort_expression_nodirection);
2133 }
2134 $sort_table = PMA_unQuote($sort_table);
2135 $sort_column = PMA_unQuote($sort_column);
2136 // find the sorted column index in row result
2137 // (this might be a multi-table query)
2138 $sorted_column_index = false;
2139 foreach ($fields_meta as $key => $meta) {
2140 if ($meta->table == $sort_table && $meta->name == $sort_column) {
2141 $sorted_column_index = $key;
2142 break;
2143 }
2144 }
2145 if ($sorted_column_index !== false) {
2146 // fetch first row of the result set
2147 $row = PMA_DBI_fetch_row($dt_result);
2148 // initializing default arguments
2149 $default_function = 'default_function';
2150 $transform_function = $default_function;
2151 $transform_options = array();
2152 // check for non printable sorted row data
2153 $meta = $fields_meta[$sorted_column_index];
2154 if (stristr($meta->type, 'BLOB') || $meta->type == 'geometry') {
2155 $column_for_first_row = PMA_handle_non_printable_contents($meta->type, $row[$sorted_column_index], $transform_function, $transform_options, $default_function, $meta, NULL);
2156 } else {
2157 $column_for_first_row = $row[$sorted_column_index];
2158 }
2159 $column_for_first_row = strtoupper(substr($column_for_first_row, 0, $GLOBALS['cfg']['LimitChars']));
2160 // fetch last row of the result set
2161 PMA_DBI_data_seek($dt_result, $num_rows - 1);
2162 $row = PMA_DBI_fetch_row($dt_result);
2163 // check for non printable sorted row data
2164 $meta = $fields_meta[$sorted_column_index];
2165 if (stristr($meta->type, 'BLOB') || $meta->type == 'geometry') {
2166 $column_for_last_row = PMA_handle_non_printable_contents($meta->type, $row[$sorted_column_index], $transform_function, $transform_options, $default_function, $meta, NULL);
2167 } else {
2168 $column_for_last_row = $row[$sorted_column_index];
2169 }
2170 $column_for_last_row = strtoupper(substr($column_for_last_row, 0, $GLOBALS['cfg']['LimitChars']));
2171 // reset to first row for the loop in PMA_displayTableBody()
2172 PMA_DBI_data_seek($dt_result, 0);
2173 // we could also use here $sort_expression_nodirection
2174 $sorted_column_message = ' [' . htmlspecialchars($sort_column) . ': <strong>' . htmlspecialchars($column_for_first_row) . ' - ' . htmlspecialchars($column_for_last_row) . '</strong>]';
2175 unset($row, $column_for_first_row, $column_for_last_row, $meta, $default_function, $transform_function, $transform_options);
2176 }
2177 unset($sorted_column_index, $sort_table, $sort_column);
2178 }
2179
2180 // 2. ----- Displays the top of the page -----
2181
2182 // 2.1 Displays a messages with position informations
2183 if ($is_display['nav_bar'] == '1' && isset($pos_next)) {
2184 if (isset($unlim_num_rows) && $unlim_num_rows != $total) {
2185 $selectstring = ', ' . $unlim_num_rows . ' ' . __('in query');
2186 } else {
2187 $selectstring = '';
2188 }
2189 $last_shown_rec = ($_SESSION['tmp_user_values']['max_rows'] == 'all' || $pos_next > $total)
2190 ? $total - 1
2191 : $pos_next - 1;
2192
2193 if (PMA_Table::isView($db, $table)
2194 && $total == $GLOBALS['cfg']['MaxExactCountViews']) {
2195 $message = PMA_Message::notice(__('This view has at least this number of rows. Please refer to %sdocumentation%s.'));
2196 $message->addParam('[a@./Documentation.html#cfg_MaxExactCount@_blank]');
2197 $message->addParam('[/a]');
2198 $message_view_warning = PMA_showHint($message);
2199 } else {
2200 $message_view_warning = false;
2201 }
2202
2203 $message = PMA_Message::success(__('Showing rows'));
2204 $message->addMessage($_SESSION['tmp_user_values']['pos']);
2205 if ($message_view_warning) {
2206 $message->addMessage('...', ' - ');
2207 $message->addMessage($message_view_warning);
2208 $message->addMessage('(');
2209 } else {
2210 $message->addMessage($last_shown_rec, ' - ');
2211 $message->addMessage(' (');
2212 $message->addMessage($pre_count . PMA_formatNumber($total, 0));
2213 $message->addString(__('total'));
2214 if (!empty($after_count)) {
2215 $message->addMessage($after_count);
2216 }
2217 $message->addMessage($selectstring, '');
2218 $message->addMessage(', ', '');
2219 }
2220
2221 $messagge_qt = PMA_Message::notice(__('Query took %01.4f sec'));
2222 $messagge_qt->addParam($GLOBALS['querytime']);
2223
2224 $message->addMessage($messagge_qt, '');
2225 $message->addMessage(')', '');
2226
2227 $message->addMessage(isset($sorted_column_message) ? $sorted_column_message : '', '');
2228
2229 PMA_showMessage($message, $sql_query, 'success');
2230
2231 } elseif (! isset($GLOBALS['printview']) || $GLOBALS['printview'] != '1') {
2232 PMA_showMessage(__('Your SQL query has been executed successfully'), $sql_query, 'success');
2233 }
2234
2235 // 2.3 Displays the navigation bars
2236 if (! strlen($table)) {
2237 if (isset($analyzed_sql[0]['query_type'])
2238 && $analyzed_sql[0]['query_type'] == 'SELECT') {
2239 // table does not always contain a real table name,
2240 // for example in MySQL 5.0.x, the query SHOW STATUS
2241 // returns STATUS as a table name
2242 $table = $fields_meta[0]->table;
2243 } else {
2244 $table = '';
2245 }
2246 }
2247
2248 if ($is_display['nav_bar'] == '1') {
2249 PMA_displayTableNavigation($pos_next, $pos_prev, $sql_query, 'top_direction_dropdown');
2250 echo "\n";
2251 } elseif (! isset($GLOBALS['printview']) || $GLOBALS['printview'] != '1') {
2252 echo "\n" . '<br /><br />' . "\n";
2253 }
2254
2255 // 2b ----- Get field references from Database -----
2256 // (see the 'relation' configuration variable)
2257
2258 // initialize map
2259 $map = array();
2260
2261 // find tables
2262 $target=array();
2263 if (isset($analyzed_sql[0]['table_ref']) && is_array($analyzed_sql[0]['table_ref'])) {
2264 foreach ($analyzed_sql[0]['table_ref'] AS $table_ref_position => $table_ref) {
2265 $target[] = $analyzed_sql[0]['table_ref'][$table_ref_position]['table_true_name'];
2266 }
2267 }
2268 $tabs = '(\'' . join('\',\'', $target) . '\')';
2269
2270 if (! strlen($table)) {
2271 $exist_rel = false;
2272 } else {
2273 // To be able to later display a link to the related table,
2274 // we verify both types of relations: either those that are
2275 // native foreign keys or those defined in the phpMyAdmin
2276 // configuration storage. If no PMA storage, we won't be able
2277 // to use the "column to display" notion (for example show
2278 // the name related to a numeric id).
2279 $exist_rel = PMA_getForeigners($db, $table, '', 'both');
2280 if ($exist_rel) {
2281 foreach ($exist_rel AS $master_field => $rel) {
2282 $display_field = PMA_getDisplayField($rel['foreign_db'], $rel['foreign_table']);
2283 $map[$master_field] = array($rel['foreign_table'],
2284 $rel['foreign_field'],
2285 $display_field,
2286 $rel['foreign_db']);
2287 } // end while
2288 } // end if
2289 } // end if
2290 // end 2b
2291
2292 // 3. ----- Displays the results table -----
2293 PMA_displayTableHeaders($is_display, $fields_meta, $fields_cnt, $analyzed_sql, $sort_expression, $sort_expression_nodirection, $sort_direction);
2294 $url_query = '';
2295 echo '<tbody>' . "\n";
2296 $clause_is_unique = PMA_displayTableBody($dt_result, $is_display, $map, $analyzed_sql);
2297 // vertical output case
2298 if ($_SESSION['tmp_user_values']['disp_direction'] == 'vertical') {
2299 PMA_displayVerticalTable();
2300 } // end if
2301 unset($vertical_display);
2302 echo '</tbody>' . "\n";
2303 ?>
2304 </table>
2305
2306 <?php
2307 // 4. ----- Displays the link for multi-fields edit and delete
2308
2309 if ($is_display['del_lnk'] == 'dr' && $is_display['del_lnk'] != 'kp') {
2310
2311 $delete_text = $is_display['del_lnk'] == 'dr' ? __('Delete') : __('Kill');
2312
2313 $_url_params = array(
2314 'db' => $db,
2315 'table' => $table,
2316 'sql_query' => $sql_query,
2317 'goto' => $goto,
2318 );
2319 $uncheckall_url = 'sql.php' . PMA_generate_common_url($_url_params);
2320
2321 $_url_params['checkall'] = '1';
2322 $checkall_url = 'sql.php' . PMA_generate_common_url($_url_params);
2323
2324 if ($_SESSION['tmp_user_values']['disp_direction'] == 'vertical') {
2325 $checkall_params['onclick'] = 'if (setCheckboxes(\'resultsForm\', true)) return false;';
2326 $uncheckall_params['onclick'] = 'if (setCheckboxes(\'resultsForm\', false)) return false;';
2327 } else {
2328 $checkall_params['onclick'] = 'if (markAllRows(\'resultsForm\')) return false;';
2329 $uncheckall_params['onclick'] = 'if (unMarkAllRows(\'resultsForm\')) return false;';
2330 }
2331 $checkall_link = PMA_linkOrButton($checkall_url, __('Check All'), $checkall_params, false);
2332 $uncheckall_link = PMA_linkOrButton($uncheckall_url, __('Uncheck All'), $uncheckall_params, false);
2333 if ($_SESSION['tmp_user_values']['disp_direction'] != 'vertical') {
2334 echo '<img class="selectallarrow" width="38" height="22"'
2335 .' src="' . $GLOBALS['pmaThemeImage'] . 'arrow_' . $GLOBALS['text_dir'] . '.png' . '"'
2336 .' alt="' . __('With selected:') . '" />';
2337 }
2338 echo $checkall_link . "\n"
2339 .' / ' . "\n"
2340 .$uncheckall_link . "\n"
2341 .'<i>' . __('With selected:') . '</i>' . "\n";
2342
2343 PMA_buttonOrImage('submit_mult', 'mult_submit',
2344 'submit_mult_change', __('Change'), 'b_edit.png', 'edit');
2345 PMA_buttonOrImage('submit_mult', 'mult_submit',
2346 'submit_mult_delete', $delete_text, 'b_drop.png', 'delete');
2347 if (isset($analyzed_sql[0]) && $analyzed_sql[0]['querytype'] == 'SELECT') {
2348 PMA_buttonOrImage('submit_mult', 'mult_submit',
2349 'submit_mult_export', __('Export'),
2350 'b_tblexport.png', 'export');
2351 }
2352 echo "\n";
2353
2354 echo '<input type="hidden" name="sql_query"'
2355 .' value="' . htmlspecialchars($sql_query) . '" />' . "\n";
2356
2357 if (! empty($GLOBALS['url_query'])) {
2358 echo '<input type="hidden" name="url_query"'
2359 .' value="' . $GLOBALS['url_query'] . '" />' . "\n";
2360 }
2361
2362 echo '<input type="hidden" name="clause_is_unique"'
2363 .' value="' . $clause_is_unique . '" />' . "\n";
2364
2365 echo '</form>' . "\n";
2366 }
2367
2368 // 5. ----- Displays the navigation bar at the bottom if required -----
2369
2370 if ($is_display['nav_bar'] == '1') {
2371 echo '<br />' . "\n";
2372 PMA_displayTableNavigation($pos_next, $pos_prev, $sql_query, 'bottom_direction_dropdown');
2373 } elseif (! isset($GLOBALS['printview']) || $GLOBALS['printview'] != '1') {
2374 echo "\n" . '<br /><br />' . "\n";
2375 }
2376
2377 // 6. ----- Displays "Query results operations"
2378 if (! isset($GLOBALS['printview']) || $GLOBALS['printview'] != '1') {
2379 PMA_displayResultsOperations($the_disp_mode, $analyzed_sql);
2380 }
2381 } // end of the 'PMA_displayTable()' function
2382
2383 function default_function($buffer) {
2384 $buffer = htmlspecialchars($buffer);
2385 $buffer = str_replace("\011", ' &nbsp;&nbsp;&nbsp;',
2386 str_replace(' ', ' &nbsp;', $buffer));
2387 $buffer = preg_replace("@((\015\012)|(\015)|(\012))@", '<br />', $buffer);
2388
2389 return $buffer;
2390 }
2391
2392 /**
2393 * Displays operations that are available on results.
2394 *
2395 * @param array the display mode
2396 * @param array the analyzed query
2397 *
2398 * @global string $db the database name
2399 * @global string $table the table name
2400 * @global string $sql_query the current SQL query
2401 * @global integer $unlim_num_rows the total number of rows returned by the
2402 * SQL query without any programmatically
2403 * appended "LIMIT" clause
2404 *
2405 * @access private
2406 *
2407 * @see PMA_showMessage(), PMA_setDisplayMode(),
2408 * PMA_displayTableNavigation(), PMA_displayTableHeaders(),
2409 * PMA_displayTableBody(), PMA_displayResultsOperations()
2410 */
2411 function PMA_displayResultsOperations($the_disp_mode, $analyzed_sql) {
2412 global $db, $table, $sql_query, $unlim_num_rows, $fields_meta;
2413
2414 $header_shown = false;
2415 $header = '<fieldset><legend>' . __('Query results operations') . '</legend>';
2416
2417 if ($the_disp_mode[6] == '1' || $the_disp_mode[9] == '1') {
2418 // Displays "printable view" link if required
2419 if ($the_disp_mode[9] == '1') {
2420
2421 if (!$header_shown) {
2422 echo $header;
2423 $header_shown = true;
2424 }
2425
2426 $_url_params = array(
2427 'db' => $db,
2428 'table' => $table,
2429 'printview' => '1',
2430 'sql_query' => $sql_query,
2431 );
2432 $url_query = PMA_generate_common_url($_url_params);
2433
2434 echo PMA_linkOrButton(
2435 'sql.php' . $url_query,
2436 PMA_getIcon('b_print.png', __('Print view'), false, true),
2437 '', true, true, 'print_view') . "\n";
2438
2439 if ($_SESSION['tmp_user_values']['display_text']) {
2440 $_url_params['display_text'] = 'F';
2441 echo PMA_linkOrButton(
2442 'sql.php' . PMA_generate_common_url($_url_params),
2443 PMA_getIcon('b_print.png', __('Print view (with full texts)'), false, true),
2444 '', true, true, 'print_view') . "\n";
2445 unset($_url_params['display_text']);
2446 }
2447 } // end displays "printable view"
2448 }
2449
2450 // Export link
2451 // (the url_query has extra parameters that won't be used to export)
2452 // (the single_table parameter is used in display_export.lib.php
2453 // to hide the SQL and the structure export dialogs)
2454 // If the parser found a PROCEDURE clause
2455 // (most probably PROCEDURE ANALYSE()) it makes no sense to
2456 // display the Export link).
2457 if (isset($analyzed_sql[0]) && $analyzed_sql[0]['querytype'] == 'SELECT' && ! isset($printview) && ! isset($analyzed_sql[0]['queryflags']['procedure'])) {
2458 if (isset($analyzed_sql[0]['table_ref'][0]['table_true_name']) && ! isset($analyzed_sql[0]['table_ref'][1]['table_true_name'])) {
2459 $_url_params['single_table'] = 'true';
2460 }
2461 if (!$header_shown) {
2462 echo $header;
2463 $header_shown = true;
2464 }
2465 $_url_params['unlim_num_rows'] = $unlim_num_rows;
2466
2467 /**
2468 * At this point we don't know the table name; this can happen
2469 * for example with a query like
2470 * SELECT bike_code FROM (SELECT bike_code FROM bikes) tmp
2471 * As a workaround we set in the table parameter the name of the
2472 * first table of this database, so that tbl_export.php and
2473 * the script it calls do not fail
2474 */
2475 if (empty($_url_params['table']) && !empty($_url_params['db'])) {
2476 $_url_params['table'] = PMA_DBI_fetch_value("SHOW TABLES");
2477 /* No result (probably no database selected) */
2478 if ($_url_params['table'] === FALSE) {
2479 unset($_url_params['table']);
2480 }
2481 }
2482
2483 echo PMA_linkOrButton(
2484 'tbl_export.php' . PMA_generate_common_url($_url_params),
2485 PMA_getIcon('b_tblexport.png', __('Export'), false, true),
2486 '', true, true, '') . "\n";
2487
2488 // show chart
2489 echo PMA_linkOrButton(
2490 'tbl_chart.php' . PMA_generate_common_url($_url_params),
2491 PMA_getIcon('b_chart.png', __('Display chart'), false, true),
2492 '', true, true, '') . "\n";
2493
2494 // show GIS chart
2495 $geometry_found = false;
2496 // If atleast one geometry field is found
2497 foreach ($fields_meta as $meta) {
2498 if ($meta->type == 'geometry') {
2499 $geometry_found = true;
2500 break;
2501 }
2502 }
2503 if ($geometry_found) {
2504 echo PMA_linkOrButton(
2505 'tbl_gis_visualization.php' . PMA_generate_common_url($_url_params),
2506 PMA_getIcon('b_globe.gif', __('Visualize GIS data'), false, true),
2507 '', true, true, '') . "\n";
2508 }
2509 }
2510
2511 // CREATE VIEW
2512 /**
2513 *
2514 * @todo detect privileges to create a view
2515 * (but see 2006-01-19 note in display_create_table.lib.php,
2516 * I think we cannot detect db-specific privileges reliably)
2517 * Note: we don't display a Create view link if we found a PROCEDURE clause
2518 */
2519 if (!$header_shown) {
2520 echo $header;
2521 $header_shown = true;
2522 }
2523 if (!PMA_DRIZZLE && !isset($analyzed_sql[0]['queryflags']['procedure'])) {
2524 echo PMA_linkOrButton(
2525 'view_create.php' . $url_query,
2526 PMA_getIcon('b_views.png', __('Create view'), false, true),
2527 '', true, true, '') . "\n";
2528 }
2529 if ($header_shown) {
2530 echo '</fieldset><br />';
2531 }
2532 }
2533
2534 /**
2535 * Verifies what to do with non-printable contents (binary or BLOB)
2536 * in Browse mode.
2537 *
2538 * @param string $category BLOB|BINARY|GEOMETRY
2539 * @param string $content the binary content
2540 * @param string $transform_function
2541 * @param string $transform_options
2542 * @param string $default_function
2543 * @param object $meta the meta-information about this field
2544 * @return mixed string or float
2545 */
2546 function PMA_handle_non_printable_contents($category, $content, $transform_function, $transform_options, $default_function, $meta, $url_params = array()) {
2547 $result = '[' . $category;
2548 if (is_null($content)) {
2549 $result .= ' - NULL';
2550 $size = 0;
2551 } elseif (isset($content)) {
2552 $size = strlen($content);
2553 $display_size = PMA_formatByteDown($size, 3, 1);
2554 $result .= ' - '. $display_size[0] . ' ' . $display_size[1];
2555 }
2556 $result .= ']';
2557
2558 if (strpos($transform_function, 'octetstream')) {
2559 $result = $content;
2560 }
2561 if ($size > 0) {
2562 if ($default_function != $transform_function) {
2563 $result = $transform_function($result, $transform_options, $meta);
2564 } else {
2565 $result = $default_function($result, array(), $meta);
2566 if (stristr($meta->type, 'BLOB') && $_SESSION['tmp_user_values']['display_blob']) {
2567 // in this case, restart from the original $content
2568 $result = htmlspecialchars(PMA_replace_binary_contents($content));
2569 }
2570 /* Create link to download */
2571 if (count($url_params) > 0) {
2572 $result = '<a href="tbl_get_field.php' . PMA_generate_common_url($url_params) . '">' . $result . '</a>';
2573 }
2574 }
2575 }
2576 return($result);
2577 }
2578
2579 /**
2580 * Prepares the displayable content of a data cell in Browse mode,
2581 * taking into account foreign key description field and transformations
2582 *
2583 * @param string $class
2584 * @param string $condition_field
2585 * @param string $analyzed_sql
2586 * @param object $meta the meta-information about this field
2587 * @param string $map
2588 * @param string $data
2589 * @param string $transform_function
2590 * @param string $default_function
2591 * @param string $nowrap
2592 * @param string $where_comparison
2593 * @param bool $is_field_truncated
2594 * @return string formatted data
2595 */
2596 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 ) {
2597
2598 $result = ' class="' . PMA_addClass($class, $condition_field, $meta, $nowrap, $is_field_truncated, $transform_function, $default_function) . '">';
2599
2600 if (isset($analyzed_sql[0]['select_expr']) && is_array($analyzed_sql[0]['select_expr'])) {
2601 foreach ($analyzed_sql[0]['select_expr'] AS $select_expr_position => $select_expr) {
2602 $alias = $analyzed_sql[0]['select_expr'][$select_expr_position]['alias'];
2603 if (isset($alias) && strlen($alias)) {
2604 $true_column = $analyzed_sql[0]['select_expr'][$select_expr_position]['column'];
2605 if ($alias == $meta->name) {
2606 // this change in the parameter does not matter
2607 // outside of the function
2608 $meta->name = $true_column;
2609 } // end if
2610 } // end if
2611 } // end foreach
2612 } // end if
2613
2614 if (isset($map[$meta->name])) {
2615 // Field to display from the foreign table?
2616 if (isset($map[$meta->name][2]) && strlen($map[$meta->name][2])) {
2617 $dispsql = 'SELECT ' . PMA_backquote($map[$meta->name][2])
2618 . ' FROM ' . PMA_backquote($map[$meta->name][3])
2619 . '.' . PMA_backquote($map[$meta->name][0])
2620 . ' WHERE ' . PMA_backquote($map[$meta->name][1])
2621 . $where_comparison;
2622 $dispresult = PMA_DBI_try_query($dispsql, null, PMA_DBI_QUERY_STORE);
2623 if ($dispresult && PMA_DBI_num_rows($dispresult) > 0) {
2624 list($dispval) = PMA_DBI_fetch_row($dispresult, 0);
2625 } else {
2626 $dispval = __('Link not found');
2627 }
2628 @PMA_DBI_free_result($dispresult);
2629 } else {
2630 $dispval = '';
2631 } // end if... else...
2632
2633 if (isset($GLOBALS['printview']) && $GLOBALS['printview'] == '1') {
2634 $result .= ($transform_function != $default_function ? $transform_function($data, $transform_options, $meta) : $transform_function($data, array(), $meta)) . ' <code>[-&gt;' . $dispval . ']</code>';
2635 } else {
2636
2637 if ('K' == $_SESSION['tmp_user_values']['relational_display']) {
2638 // user chose "relational key" in the display options, so
2639 // the title contains the display field
2640 $title = (! empty($dispval))? ' title="' . htmlspecialchars($dispval) . '"' : '';
2641 } else {
2642 $title = ' title="' . htmlspecialchars($data) . '"';
2643 }
2644
2645 $_url_params = array(
2646 'db' => $map[$meta->name][3],
2647 'table' => $map[$meta->name][0],
2648 'pos' => '0',
2649 'sql_query' => 'SELECT * FROM '
2650 . PMA_backquote($map[$meta->name][3]) . '.' . PMA_backquote($map[$meta->name][0])
2651 . ' WHERE ' . PMA_backquote($map[$meta->name][1])
2652 . $where_comparison,
2653 );
2654 $result .= '<a href="sql.php' . PMA_generate_common_url($_url_params)
2655 . '"' . $title . '>';
2656
2657 if ($transform_function != $default_function) {
2658 // always apply a transformation on the real data,
2659 // not on the display field
2660 $result .= $transform_function($data, $transform_options, $meta);
2661 } else {
2662 if ('D' == $_SESSION['tmp_user_values']['relational_display']) {
2663 // user chose "relational display field" in the
2664 // display options, so show display field in the cell
2665 $result .= $transform_function($dispval, array(), $meta);
2666 } else {
2667 // otherwise display data in the cell
2668 $result .= $transform_function($data, array(), $meta);
2669 }
2670 }
2671 $result .= '</a>';
2672 }
2673 } else {
2674 $result .= ($transform_function != $default_function ? $transform_function($data, $transform_options, $meta) : $transform_function($data, array(), $meta));
2675 }
2676 $result .= '</td>' . "\n";
2677
2678 return $result;
2679 }
2680
2681 /**
2682 * Generates a checkbox for multi-row submits
2683 *
2684 * @param string $del_url
2685 * @param array $is_display
2686 * @param string $row_no
2687 * @param string $where_clause_html
2688 * @param string $del_query
2689 * @param string $id_suffix
2690 * @param string $class
2691 * @return string the generated HTML
2692 */
2693
2694 function PMA_generateCheckboxForMulti($del_url, $is_display, $row_no, $where_clause_html, $del_query, $id_suffix, $class) {
2695 $ret = '';
2696 if (! empty($del_url) && $is_display['del_lnk'] != 'kp') {
2697 $ret .= '<td ';
2698 if (! empty($class)) {
2699 $ret .= 'class="' . $class . '"';
2700 }
2701 $ret .= ' align="center">'
2702 . '<input type="checkbox" id="id_rows_to_delete' . $row_no . $id_suffix . '" name="rows_to_delete[' . $where_clause_html . ']"'
2703 . ' class="multi_checkbox"'
2704 . ' value="' . htmlspecialchars($del_query) . '" ' . (isset($GLOBALS['checkall']) ? 'checked="checked"' : '') . ' />'
2705 . ' </td>';
2706 }
2707 return $ret;
2708 }
2709
2710 /**
2711 * Generates an Edit link
2712 *
2713 * @param string $edit_url
2714 * @param string $class
2715 * @param string $edit_str
2716 * @param string $where_clause
2717 * @param string $where_clause_html
2718 * @return string the generated HTML
2719 */
2720 function PMA_generateEditLink($edit_url, $class, $edit_str, $where_clause, $where_clause_html) {
2721 $ret = '';
2722 if (! empty($edit_url)) {
2723 $ret .= '<td class="' . $class . '" align="center" ' . ' ><span class="nowrap">'
2724 . PMA_linkOrButton($edit_url, $edit_str, array(), false);
2725 /*
2726 * Where clause for selecting this row uniquely is provided as
2727 * a hidden input. Used by jQuery scripts for handling inline editing
2728 */
2729 if (! empty($where_clause)) {
2730 $ret .= '<input type="hidden" class="where_clause" value ="' . $where_clause_html . '" />';
2731 }
2732 $ret .= '</span></td>';
2733 }
2734 return $ret;
2735 }
2736
2737 /**
2738 * Generates an Copy link
2739 *
2740 * @param string $copy_url
2741 * @param string $copy_str
2742 * @param string $where_clause
2743 * @param string $where_clause_html
2744 * @return string the generated HTML
2745 */
2746 function PMA_generateCopyLink($copy_url, $copy_str, $where_clause, $where_clause_html, $class) {
2747 $ret = '';
2748 if (! empty($copy_url)) {
2749 $ret .= '<td ';
2750 if (! empty($class)) {
2751 $ret .= 'class="' . $class . '" ';
2752 }
2753 $ret .= 'align="center" ' . ' ><span class="nowrap">'
2754 . PMA_linkOrButton($copy_url, $copy_str, array(), false);
2755 /*
2756 * Where clause for selecting this row uniquely is provided as
2757 * a hidden input. Used by jQuery scripts for handling inline editing
2758 */
2759 if (! empty($where_clause)) {
2760 $ret .= '<input type="hidden" class="where_clause" value ="' . $where_clause_html . '" />';
2761 }
2762 $ret .= '</span></td>';
2763 }
2764 return $ret;
2765 }
2766
2767 /**
2768 * Generates a Delete link
2769 *
2770 * @param string $del_url
2771 * @param string $del_str
2772 * @param string $js_conf
2773 * @param string $class
2774 * @return string the generated HTML
2775 */
2776 function PMA_generateDeleteLink($del_url, $del_str, $js_conf, $class) {
2777 $ret = '';
2778 if (! empty($del_url)) {
2779 $ret .= '<td ';
2780 if (! empty($class)) {
2781 $ret .= 'class="' . $class . '" ';
2782 }
2783 $ret .= 'align="center" ' . ' >'
2784 . PMA_linkOrButton($del_url, $del_str, $js_conf, false)
2785 . '</td>';
2786 }
2787 return $ret;
2788 }
2789
2790 /**
2791 * Generates checkbox and links at some position (left or right)
2792 * (only called for horizontal mode)
2793 *
2794 * @param string $position
2795 * @param string $del_url
2796 * @param array $is_display
2797 * @param string $row_no
2798 * @param string $where_clause
2799 * @param string $where_clause_html
2800 * @param string $del_query
2801 * @param string $id_suffix
2802 * @param string $edit_url
2803 * @param string $copy_url
2804 * @param string $class
2805 * @param string $edit_str
2806 * @param string $del_str
2807 * @param string $js_conf
2808 * @return string the generated HTML
2809 */
2810 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) {
2811 $ret = '';
2812
2813 if ($position == 'left') {
2814 $ret .= PMA_generateCheckboxForMulti($del_url, $is_display, $row_no, $where_clause_html, $del_query, $id_suffix='_left', '', '', '');
2815
2816 $ret .= PMA_generateEditLink($edit_url, $class, $edit_str, $where_clause, $where_clause_html, '');
2817
2818 $ret .= PMA_generateCopyLink($copy_url, $copy_str, $where_clause, $where_clause_html, '');
2819
2820 $ret .= PMA_generateDeleteLink($del_url, $del_str, $js_conf, '', '');
2821
2822 } elseif ($position == 'right') {
2823 $ret .= PMA_generateDeleteLink($del_url, $del_str, $js_conf, '', '');
2824
2825 $ret .= PMA_generateCopyLink($copy_url, $copy_str, $where_clause, $where_clause_html, '');
2826
2827 $ret .= PMA_generateEditLink($edit_url, $class, $edit_str, $where_clause, $where_clause_html, '');
2828
2829 $ret .= PMA_generateCheckboxForMulti($del_url, $is_display, $row_no, $where_clause_html, $del_query, $id_suffix='_right', '', '', '');
2830 } else { // $position == 'none'
2831 $ret .= PMA_generateCheckboxForMulti($del_url, $is_display, $row_no, $where_clause_html, $del_query, $id_suffix='_left', '', '', '');
2832 }
2833 return $ret;
2834 }
2835 ?>
phpMyAdmin