home *** CD-ROM | disk | FTP | other *** search
- <?php
- /* $Id: tbl_properties_table_info.php,v 2.9 2004/10/21 10:18:12 nijel Exp $ */
- // vim: expandtab sw=4 ts=4 sts=4:
-
- // this should be recoded as functions, to avoid messing with global
- // variables
-
- // Check parameters
-
- require_once('./libraries/common.lib.php');
-
- PMA_checkParameters(array('db', 'table'));
-
- /**
- * Gets table informations
- */
- // The 'show table' statement works correct since 3.23.03
- $table_info_result = PMA_DBI_query('SHOW TABLE STATUS LIKE \'' . PMA_sqlAddslashes($table, TRUE) . '\';');
- $showtable = PMA_DBI_fetch_assoc($table_info_result);
- if (!isset($showtable['Type']) && isset($showtable['Engine'])) {
- $showtable['Type'] =& $showtable['Engine'];
- }
- $tbl_type = isset($showtable['Type']) ? strtoupper($showtable['Type']) : '';
- $tbl_collation = empty($showtable['Collation']) ? '' : $showtable['Collation'];
- $table_info_num_rows = (isset($showtable['Rows']) ? $showtable['Rows'] : 0);
- $show_comment = (isset($showtable['Comment']) ? $showtable['Comment'] : '');
- $auto_increment = (isset($showtable['Auto_increment']) ? $showtable['Auto_increment'] : '');
-
- $tmp = isset($showtable['Create_options']) ? explode(' ', $showtable['Create_options']) : array();
- $tmp_cnt = count($tmp);
- for ($i = 0; $i < $tmp_cnt; $i++) {
- $tmp1 = explode('=', $tmp[$i]);
- if (isset($tmp1[1])) {
- $$tmp1[0] = $tmp1[1];
- }
- } // end for
- unset($tmp1, $tmp);
- PMA_DBI_free_result($table_info_result);
- ?>
-