tbl_get_field.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * Provides download to a given field defined in parameters.
   5  *
   6  * @package PhpMyAdmin
   7  */
   8 declare(strict_types=1);
   9
  10 use PhpMyAdmin\Core;
  11 use PhpMyAdmin\DatabaseInterface;
  12 use PhpMyAdmin\Di\Container;
  13 use PhpMyAdmin\Mime;
  14 use PhpMyAdmin\Response;
  15
  16 if (! defined('ROOT_PATH')) {
  17     define('ROOT_PATH', __DIR__ . DIRECTORY_SEPARATOR);
  18 }
  19
  20 /**
  21  * Common functions.
  22  */
  23 require_once ROOT_PATH . 'libraries/common.inc.php';
  24
  25 $container = Container::getDefaultContainer();
  26 $container->set(Response::class, Response::getInstance());
  27
  28 /** @var Response $response */
  29 $response = $container->get(Response::class);
  30
  31 /** @var DatabaseInterface $dbi */
  32 $dbi = $container->get(DatabaseInterface::class);
  33
  34 $response->disable();
  35
  36 /* Check parameters */
  37 PhpMyAdmin\Util::checkParameters(
  38     [
  39         'db',
  40         'table',
  41     ]
  42 );
  43
  44 /* Select database */
  45 if (! $dbi->selectDb($db)) {
  46     PhpMyAdmin\Util::mysqlDie(
  47         sprintf(__('\'%s\' database does not exist.'), htmlspecialchars($db)),
  48         '',
  49         false
  50     );
  51 }
  52
  53 /* Check if table exists */
  54 if (! $dbi->getColumns($db, $table)) {
  55     PhpMyAdmin\Util::mysqlDie(__('Invalid table name'));
  56 }
  57
  58 /* Grab data */
  59 $sql = 'SELECT ' . PhpMyAdmin\Util::backquote($_GET['transform_key'])
  60     . ' FROM ' . PhpMyAdmin\Util::backquote($table)
  61     . ' WHERE ' . $_GET['where_clause'] . ';';
  62 $result = $dbi->fetchValue($sql);
  63
  64 /* Check return code */
  65 if ($result === false) {
  66     PhpMyAdmin\Util::mysqlDie(
  67         __('MySQL returned an empty result set (i.e. zero rows).'),
  68         $sql
  69     );
  70 }
  71
  72 /* Avoid corrupting data */
  73 ini_set('url_rewriter.tags', '');
  74
  75 Core::downloadHeader(
  76     $table . '-' . $_GET['transform_key'] . '.bin',
  77     Mime::detect($result),
  78     strlen($result)
  79 );
  80 echo $result;