browse_foreigners.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * display selection for relational field values
   5  *
   6  * @package PhpMyAdmin
   7  */
   8 use PMA\libraries\Response;
   9
  10 require_once 'libraries/common.inc.php';
  11 require_once 'libraries/transformations.lib.php';
  12 require_once 'libraries/browse_foreigners.lib.php';
  13
  14 /**
  15  * Sets globals from $_REQUEST
  16  */
  17 $request_params = array(
  18     'data',
  19     'field'
  20 );
  21
  22 foreach ($request_params as $one_request_param) {
  23     if (isset($_REQUEST[$one_request_param])) {
  24         $GLOBALS[$one_request_param] = $_REQUEST[$one_request_param];
  25     }
  26 }
  27
  28 PMA\libraries\Util::checkParameters(array('db', 'table', 'field'));
  29
  30 $response = Response::getInstance();
  31 $response->getFooter()->setMinimal();
  32 $header = $response->getHeader();
  33 $header->disableMenuAndConsole();
  34 $header->setBodyId('body_browse_foreigners');
  35
  36 /**
  37  * Displays the frame
  38  */
  39
  40 $cfgRelation = PMA_getRelationsParam();
  41 $foreigners  = ($cfgRelation['relwork'] ? PMA_getForeigners($db, $table) : false);
  42 $foreign_limit = PMA_getForeignLimit(
  43     isset($_REQUEST['foreign_showAll']) ? $_REQUEST['foreign_showAll'] : null
  44 );
  45
  46 $foreignData = PMA_getForeignData(
  47     $foreigners, $_REQUEST['field'], true,
  48     isset($_REQUEST['foreign_filter'])
  49     ? $_REQUEST['foreign_filter']
  50     : '',
  51     isset($foreign_limit) ? $foreign_limit : null,
  52     true // for getting value in $foreignData['the_total']
  53 );
  54
  55 // HTML output
  56 $html = PMA_getHtmlForRelationalFieldSelection(
  57     $db, $table, $_REQUEST['field'], $foreignData,
  58     isset($fieldkey) ? $fieldkey : null,
  59     isset($data) ? $data : null
  60 );
  61
  62 $response->addHtml($html);