libraries/tbl_properties_table_info.inc.php

   1 <?php
   2 /* $Id$ */
   3 // vim: expandtab sw=4 ts=4 sts=4:
   4
   5 require_once './libraries/Table.class.php';
   6
   7 /**
   8  * extracts table properties from create statement
   9  *
  10  * @TODO this should be recoded as functions,
  11  * to avoid messing with global variables
  12  */
  13
  14 /**
  15  * requirements
  16  */
  17 require_once('./libraries/common.lib.php');
  18
  19 // Check parameters
  20 PMA_checkParameters(array('db', 'table'));
  21
  22 /**
  23  * Defining global variables, in case this script is included by a function.
  24  * This is necessary because this script can be included by libraries/header.inc.php.
  25  */
  26 global $showtable, $tbl_is_view, $tbl_type, $show_comment, $tbl_collation,
  27        $table_info_num_rows, $auto_increment;
  28
  29 /**
  30  * Gets table informations
  31  */
  32 // Seems we need to do this in MySQL 5.0.2,
  33 // otherwise error #1046, no database selected
  34 PMA_DBI_select_db($GLOBALS['db']);
  35
  36 // The 'show table' statement works correct since 3.23.03
  37 $table_info_result   = PMA_DBI_query(
  38     'SHOW TABLE STATUS LIKE \'' . PMA_sqlAddslashes($GLOBALS['table'], true) . '\';',
  39     null, PMA_DBI_QUERY_STORE);
  40
  41 // need this test because when we are creating a table, we get 0 rows
  42 // from the SHOW TABLE query
  43 // and we don't want to mess up the $tbl_type coming from the form
  44
  45 if ($table_info_result && PMA_DBI_num_rows($table_info_result) > 0) {
  46     $showtable           = PMA_DBI_fetch_assoc($table_info_result);
  47     PMA_DBI_free_result($table_info_result);
  48     unset( $table_info_result );
  49
  50     if (!isset($showtable['Type']) && isset($showtable['Engine'])) {
  51         $showtable['Type'] =& $showtable['Engine'];
  52     }
  53     // MySQL < 5.0.13 returns "view", >= 5.0.13 returns "VIEW"
  54     if ( PMA_MYSQL_INT_VERSION >= 50000 && !isset($showtable['Type'])
  55       && isset($showtable['Comment'])
  56       && strtoupper($showtable['Comment']) == 'VIEW' ) {
  57         $tbl_is_view     = true;
  58         $tbl_type        = $GLOBALS['strView'];
  59         $show_comment    = null;
  60     } else {
  61         $tbl_is_view     = false;
  62         $tbl_type        = isset($showtable['Type'])
  63             ? strtoupper($showtable['Type'])
  64             : '';
  65         // a new comment could be coming from tbl_properties_operations.php
  66         // and we want to show it in the header
  67         if (isset($submitcomment) && isset($comment)) {
  68             $show_comment = $comment;
  69         } else {
  70             $show_comment    = isset($showtable['Comment'])
  71                 ? $showtable['Comment']
  72                 : '';
  73         }
  74     }
  75     $tbl_collation       = empty($showtable['Collation'])
  76         ? ''
  77         : $showtable['Collation'];
  78
  79     if ( null === $showtable['Rows'] ) {
  80         $showtable['Rows']   = PMA_Table::countRecords( $GLOBALS['db'],
  81             $showtable['Name'], true, true );
  82     }
  83     $table_info_num_rows = isset($showtable['Rows']) ? $showtable['Rows'] : 0;
  84     $auto_increment      = isset($showtable['Auto_increment'])
  85         ? $showtable['Auto_increment']
  86         : '';
  87
  88     $create_options      = isset($showtable['Create_options'])
  89         ? explode(' ', $showtable['Create_options'])
  90         : array();
  91
  92     // export create options by its name as variables into gloabel namespace
  93     // f.e. pack_keys=1 becomes available as $pack_keys with value of '1'
  94     unset($pack_keys);
  95     foreach ( $create_options as $each_create_option ) {
  96         $each_create_option = explode('=', $each_create_option);
  97         if ( isset( $each_create_option[1] ) ) {
  98             $$each_create_option[0]    = $each_create_option[1];
  99         }
 100     }
 101     // we need explicit DEFAULT value here (different from '0')
 102     $pack_keys = (!isset($pack_keys) || strlen($pack_keys) == 0) ? 'DEFAULT' : $pack_keys;
 103     unset( $create_options, $each_create_option );
 104 } // end if
 105 ?>