2
/* $Id: db_table_exists.lib.php 9636 2006-10-27 13:04:15Z nijel $ */
3
// vim: expandtab sw=4 ts=4 sts=4:
6
* Ensure the database and the table exist (else move to the "parent" script)
10
if (isset($db) && strlen($db)) {
11
$is_db = @PMA_DBI_select_db($db);
17
// not a valid db name -> back to the welcome page
18
if (! defined('IS_TRANSFORMATION_WRAPPER')) {
19
$url_params = array('reload' => 1);
20
if (isset($message)) {
21
$url_params['message'] = $message;
23
if (isset($sql_query)) {
24
$url_params['sql_query'] = $sql_query;
26
if (isset($show_as_php)) {
27
$url_params['show_as_php'] = $show_as_php;
29
PMA_sendHeaderLocation(
30
$cfg['PmaAbsoluteUri'] . 'main.php'
31
. PMA_generate_common_url($url_params, '&'));
35
} // end if (ensures db exists)
37
if (empty($is_table) && !defined('PMA_SUBMIT_MULT')) {
38
// Not a valid table name -> back to the db_sql.php
39
if (isset($table) && strlen($table)) {
40
$_result = PMA_DBI_try_query(
41
'SHOW TABLES LIKE \'' . PMA_sqlAddslashes($table, true) . '\';',
42
null, PMA_DBI_QUERY_STORE);
43
$is_table = @PMA_DBI_num_rows($_result);
44
PMA_DBI_free_result($_result);
50
if (! defined('IS_TRANSFORMATION_WRAPPER')) {
51
if (isset($table) && strlen($table)) {
52
// SHOW TABLES doesn't show temporary tables, so try select
53
// (as it can happen just in case temporary table, it should be
57
* @todo should this check really only happen if IS_TRANSFORMATION_WRAPPER?
59
$_result = PMA_DBI_try_query(
60
'SELECT COUNT(*) FROM `' . PMA_sqlAddslashes($table, true) . '`;',
61
null, PMA_DBI_QUERY_STORE);
62
$is_table = ($_result && @PMA_DBI_num_rows($_result));
63
PMA_DBI_free_result($_result);
67
$url_params = array('reload' => 1, 'db' => $db);
68
if (isset($message)) {
69
$url_params['message'] = $message;
71
if (isset($sql_query)) {
72
$url_params['sql_query'] = $sql_query;
74
if (isset($display_query)) {
75
$url_params['display_query'] = $display_query;
77
PMA_sendHeaderLocation(
78
$cfg['PmaAbsoluteUri'] . 'db_sql.php'
79
. PMA_generate_common_url($url_params, '&'));
87
} // end if (ensures table exists)