0,0 → 1,74 |
<?php |
/* $Id: db_table_exists.lib.php,v 2.11.2.2 2006/04/12 18:51:11 lem9 Exp $ */ |
// vim: expandtab sw=4 ts=4 sts=4: |
|
/** |
* Ensure the database and the table exist (else move to the "parent" script) |
* and display headers |
*/ |
if (empty($is_db)) { |
if (isset($db) && strlen($db)) { |
$is_db = @PMA_DBI_select_db($db); |
} else { |
$is_db = false; |
} |
|
if (! $is_db) { |
// not a valid db name -> back to the welcome page |
if (! defined('IS_TRANSFORMATION_WRAPPER')) { |
$url_params = array('reload' => 1); |
if (isset($message)) { |
$url_params['message'] = $message; |
} |
PMA_sendHeaderLocation( |
$cfg['PmaAbsoluteUri'] . 'main.php' |
. PMA_generate_common_url($url_params, '&')); |
} |
exit; |
} |
} // end if (ensures db exists) |
|
if (empty($is_table)) { |
// Not a valid table name -> back to the db_details.php |
if (isset($table) && strlen($table)) { |
$_result = PMA_DBI_try_query( |
'SHOW TABLES LIKE \'' . PMA_sqlAddslashes($table, true) . '\';', |
null, PMA_DBI_QUERY_STORE); |
$is_table = @PMA_DBI_num_rows($_result); |
PMA_DBI_free_result($_result); |
} else { |
$is_table = false; |
} |
|
if (! $is_table) { |
if (! defined('IS_TRANSFORMATION_WRAPPER')) { |
if (isset($table) && strlen($table)) { |
// SHOW TABLES doesn't show temporary tables, so try select |
// (as it can happen just in case temporary table, it should be |
// fast): |
|
// @todo should this check really only happen if IS_TRANSFORMATION_WRAPPER? |
$_result = PMA_DBI_try_query( |
'SELECT COUNT(*) FROM `' . PMA_sqlAddslashes($table, true) . '`;', |
null, PMA_DBI_QUERY_STORE); |
$is_table = ($_result && @PMA_DBI_num_rows($_result)); |
PMA_DBI_free_result($_result); |
} |
|
if (! $is_table) { |
$url_params = array('reload' => 1, 'db' => $db); |
if (isset($message)) { |
$url_params['message'] = $message; |
} |
PMA_sendHeaderLocation( |
$cfg['PmaAbsoluteUri'] . 'db_details.php' |
. PMA_generate_common_url($url_params, '&')); |
} |
} |
|
if (! $is_table) { |
exit; |
} |
} |
} // end if (ensures table exists) |
?> |