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  * @package phpMyAdmin
   6  */
   7
   8 /**
   9  * Common functions.
  10  */
  11 require_once './libraries/common.inc.php';
  12 require_once './libraries/mime.lib.php';
  13
  14 /* Check parameters */
  15 PMA_checkParameters(array('db', 'table', 'where_clause', 'transform_key'));
  16
  17 /* Select database */
  18 if (!PMA_DBI_select_db($db)) {
  19     PMA_mysqlDie(sprintf(__('\'%s\' database does not exist.'), htmlspecialchars($db)),
  20         '', '');
  21 }
  22
  23 /* Check if table exists */
  24 if (!PMA_DBI_get_columns($db, $table)) {
  25     PMA_mysqlDie(__('Invalid table name'));
  26 }
  27
  28 /* Grab data */
  29 $sql = 'SELECT ' . PMA_backquote($transform_key) . ' FROM ' . PMA_backquote($table) . ' WHERE ' . $where_clause . ';';
  30 $result = PMA_DBI_fetch_value($sql);
  31
  32 /* Check return code */
  33 if ($result === false) {
  34     PMA_mysqlDie(__('MySQL returned an empty result set (i.e. zero rows).'), $sql);
  35 }
  36
  37 /* Avoid corrupting data */
  38 @ini_set('url_rewriter.tags', '');
  39
  40 PMA_download_header(
  41     $table . '-' .  $transform_key . '.bin',
  42     PMA_detectMIME($result),
  43     strlen($result)
  44     );
  45 echo $result;
  46 ?>