browse_foreigners.php

<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
 * display selection for relational field values
 *
 * @package PhpMyAdmin
 */
declare(strict_types=1);

use PhpMyAdmin\BrowseForeigners;
use PhpMyAdmin\Relation;
use PhpMyAdmin\Response;
use PhpMyAdmin\Util;

if (! defined('ROOT_PATH')) {
    define('ROOT_PATH', __DIR__ . DIRECTORY_SEPARATOR);
}

require_once ROOT_PATH . 'libraries/common.inc.php';

/**
 * Sets globals from $_POST
 */
$request_params = [
    'data',
    'field',
];

foreach ($request_params as $one_request_param) {
    if (isset($_POST[$one_request_param])) {
        $GLOBALS[$one_request_param] = $_POST[$one_request_param];
    }
}

Util::checkParameters(['db', 'table', 'field']);

$response = Response::getInstance();
$response->getFooter()->setMinimal();
$header = $response->getHeader();
$header->disableMenuAndConsole();
$header->setBodyId('body_browse_foreigners');

$relation = new Relation($GLOBALS['dbi']);

/**
 * Displays the frame
 */
$foreigners = $relation->getForeigners($db, $table);
$browseForeigners = new BrowseForeigners(
    $GLOBALS['cfg']['LimitChars'],
    $GLOBALS['cfg']['MaxRows'],
    $GLOBALS['cfg']['RepeatCells'],
    $GLOBALS['cfg']['ShowAll'],
    $GLOBALS['pmaThemeImage']
);
$foreign_limit = $browseForeigners->getForeignLimit(
    isset($_POST['foreign_showAll']) ? $_POST['foreign_showAll'] : null
);

$foreignData = $relation->getForeignData(
    $foreigners,
    $_POST['field'],
    true,
    isset($_POST['foreign_filter'])
    ? $_POST['foreign_filter']
    : '',
    isset($foreign_limit) ? $foreign_limit : null,
    true // for getting value in $foreignData['the_total']
);

// HTML output
$html = $browseForeigners->getHtmlForRelationalFieldSelection(
    $db,
    $table,
    $_POST['field'],
    $foreignData,
    isset($fieldkey) ? $fieldkey : '',
    isset($data) ? $data : ''
);

$response->addHTML($html);