| 0,0 → 1,100 |
|---|
| <?php |
| /* $Id: tbl_properties_table_info.inc.php,v 1.3 2005/12/08 12:14:34 cybot_tm Exp $ */ |
| // vim: expandtab sw=4 ts=4 sts=4: |
| |
| /** |
| * extracts table properties from create statement |
| * |
| * @TODO this should be recoded as functions, |
| * to avoid messing with global variables |
| */ |
| |
| /** |
| * requirements |
| */ |
| require_once('./libraries/common.lib.php'); |
| |
| // Check parameters |
| PMA_checkParameters(array('db', 'table')); |
| |
| /** |
| * Defining global variables, in case this script is included by a function. |
| * This is necessary because this script can be included by libraries/header.inc.php. |
| */ |
| global $showtable, $tbl_is_view, $tbl_type, $show_comment, $tbl_collation, |
| $table_info_num_rows, $auto_increment; |
| |
| /** |
| * Gets table informations |
| */ |
| // Seems we need to do this in MySQL 5.0.2, |
| // otherwise error #1046, no database selected |
| PMA_DBI_select_db($GLOBALS['db']); |
| |
| // The 'show table' statement works correct since 3.23.03 |
| $table_info_result = PMA_DBI_query( |
| 'SHOW TABLE STATUS LIKE \'' . PMA_sqlAddslashes($GLOBALS['table'], true) . '\';', |
| null, PMA_DBI_QUERY_STORE); |
| |
| // need this test because when we are creating a table, we get 0 rows |
| // from the SHOW TABLE query |
| // and we don't want to mess up the $tbl_type coming from the form |
| |
| if ($table_info_result && PMA_DBI_num_rows($table_info_result) > 0) { |
| $showtable = PMA_DBI_fetch_assoc($table_info_result); |
| PMA_DBI_free_result($table_info_result); |
| unset( $table_info_result ); |
| |
| if (!isset($showtable['Type']) && isset($showtable['Engine'])) { |
| $showtable['Type'] =& $showtable['Engine']; |
| } |
| // MySQL < 5.0.13 returns "view", >= 5.0.13 returns "VIEW" |
| if ( PMA_MYSQL_INT_VERSION >= 50000 && !isset($showtable['Type']) |
| && isset($showtable['Comment']) |
| && strtoupper($showtable['Comment']) == 'VIEW' ) { |
| $tbl_is_view = true; |
| $tbl_type = $GLOBALS['strView']; |
| $show_comment = null; |
| } else { |
| $tbl_is_view = false; |
| $tbl_type = isset($showtable['Type']) |
| ? strtoupper($showtable['Type']) |
| : ''; |
| // a new comment could be coming from tbl_properties_operations.php |
| // and we want to show it in the header |
| if (isset($submitcomment) && isset($comment)) { |
| $show_comment = $comment; |
| } else { |
| $show_comment = isset($showtable['Comment']) |
| ? $showtable['Comment'] |
| : ''; |
| } |
| } |
| $tbl_collation = empty($showtable['Collation']) |
| ? '' |
| : $showtable['Collation']; |
| |
| if ( null === $showtable['Rows'] ) { |
| $showtable['Rows'] = PMA_countRecords( $GLOBALS['db'], |
| $showtable['Name'], true, true ); |
| } |
| $table_info_num_rows = isset($showtable['Rows']) ? $showtable['Rows'] : 0; |
| $auto_increment = isset($showtable['Auto_increment']) |
| ? $showtable['Auto_increment'] |
| : ''; |
| |
| $create_options = isset($showtable['Create_options']) |
| ? explode(' ', $showtable['Create_options']) |
| : array(); |
| |
| // export create options by its name as variables into gloabel namespace |
| // f.e. pack_keys=1 becomes available as $pack_keys with value of '1' |
| foreach ( $create_options as $each_create_option ) { |
| $each_create_option = explode('=', $each_create_option); |
| if ( isset( $each_create_option[1] ) ) { |
| $$each_create_option[0] = $each_create_option[1]; |
| } |
| } |
| unset( $create_options, $each_create_option ); |
| } // end if |
| ?> |