libraries/db_table_exists.lib.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * Ensure the database and the table exist (else move to the "parent" script)
   5  * and display headers
   6  *
   7  * @package PhpMyAdmin
   8  */
   9 if (! defined('PHPMYADMIN')) {
  10     exit;
  11 }
  12
  13 if (empty($is_db)) {
  14     if (strlen($db)) {
  15         $is_db = @PMA_DBI_select_db($db);
  16     } else {
  17         $is_db = false;
  18     }
  19
  20     if (! $is_db) {
  21         // not a valid db name -> back to the welcome page
  22         if (! defined('IS_TRANSFORMATION_WRAPPER')) {
  23             $url_params = array('reload' => 1);
  24             if (isset($message)) {
  25                 $url_params['message'] = $message;
  26             }
  27             if (! empty($sql_query)) {
  28                 $url_params['sql_query'] = $sql_query;
  29             }
  30             if (isset($show_as_php)) {
  31                 $url_params['show_as_php'] = $show_as_php;
  32             }
  33             PMA_sendHeaderLocation(
  34                 $cfg['PmaAbsoluteUri'] . 'main.php'
  35                     . PMA_generate_common_url($url_params, '&'));
  36         }
  37         exit;
  38     }
  39 } // end if (ensures db exists)
  40
  41 if (empty($is_table) && !defined('PMA_SUBMIT_MULT') && ! defined('TABLE_MAY_BE_ABSENT')) {
  42     // Not a valid table name -> back to the db_sql.php
  43
  44     if (strlen($table)) {
  45         $is_table = isset(PMA_Table::$cache[$db][$table]);
  46
  47         if (! $is_table) {
  48             $_result = PMA_DBI_try_query(
  49                 'SHOW TABLES LIKE \'' . PMA_sqlAddSlashes($table, true) . '\';',
  50                 null, PMA_DBI_QUERY_STORE);
  51             $is_table = @PMA_DBI_num_rows($_result);
  52             PMA_DBI_free_result($_result);
  53         }
  54     } else {
  55         $is_table = false;
  56     }
  57
  58     if (! $is_table) {
  59         if (! defined('IS_TRANSFORMATION_WRAPPER')) {
  60             if (strlen($table)) {
  61                 // SHOW TABLES doesn't show temporary tables, so try select
  62                 // (as it can happen just in case temporary table, it should be
  63                 // fast):
  64
  65                 /**
  66                  * @todo should this check really only happen if IS_TRANSFORMATION_WRAPPER?
  67                  */
  68                 $_result = PMA_DBI_try_query(
  69                     'SELECT COUNT(*) FROM ' . PMA_backquote($table) . ';',
  70                     null, PMA_DBI_QUERY_STORE);
  71                 $is_table = ($_result && @PMA_DBI_num_rows($_result));
  72                 PMA_DBI_free_result($_result);
  73             }
  74
  75             if (! $is_table) {
  76                 include './db_sql.php';
  77                 exit;
  78             }
  79         }
  80
  81         if (! $is_table) {
  82             exit;
  83         }
  84     }
  85 } // end if (ensures table exists)
  86 ?>