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(
  20         sprintf(__('\'%s\' database does not exist.'), htmlspecialchars($db)),
  21         '', ''
  22     );
  23 }
  24
  25 /* Check if table exists */
  26 if (!PMA_DBI_get_columns($db, $table)) {
  27     PMA_mysqlDie(__('Invalid table name'));
  28 }
  29
  30 /* Grab data */
  31 $sql = 'SELECT ' . PMA_backquote($transform_key) . ' FROM ' . PMA_backquote($table) . ' WHERE ' . $where_clause . ';';
  32 $result = PMA_DBI_fetch_value($sql);
  33
  34 /* Check return code */
  35 if ($result === false) {
  36     PMA_mysqlDie(__('MySQL returned an empty result set (i.e. zero rows).'), $sql);
  37 }
  38
  39 /* Avoid corrupting data */
  40 @ini_set('url_rewriter.tags', '');
  41
  42 PMA_download_header(
  43     $table . '-' .  $transform_key . '.bin',
  44     PMA_detectMIME($result),
  45     strlen($result)
  46     );
  47 echo $result;
  48 ?>