src/DbTableExists.php

   1 <?php
   2
   3 declare(strict_types=1);
   4
   5 namespace PhpMyAdmin;
   6
   7 use PhpMyAdmin\Dbal\DatabaseInterface;
   8 use PhpMyAdmin\Identifiers\DatabaseName;
   9 use PhpMyAdmin\Identifiers\TableName;
  10
  11 use function in_array;
  12 use function sprintf;
  13
  14 final class DbTableExists
  15 {
  16     /** @psalm-var list<non-empty-string> */
  17     private array $tables = [];
  18
  19     public function __construct(private readonly DatabaseInterface $dbi)
  20     {
  21     }
  22
  23     public function selectDatabase(DatabaseName $databaseName): bool
  24     {
  25         return $this->dbi->selectDb($databaseName);
  26     }
  27
  28     /**
  29      * Check if a table exists in the given database.
  30      * It will return true if the table exists, regardless if it's temporary or permanent.
  31      */
  32     public function hasTable(DatabaseName $database, TableName $table): bool
  33     {
  34         if (in_array($database->getName() . '.' . $table->getName(), $this->tables, true)) {
  35             return true;
  36         }
  37
  38         if ($this->tableExists($database, $table)) {
  39             $this->tables[] = $database->getName() . '.' . $table->getName();
  40
  41             return true;
  42         }
  43
  44         return false;
  45     }
  46
  47     private function tableExists(DatabaseName $database, TableName $table): bool
  48     {
  49         // SHOW TABLES doesn't show temporary tables, so try select.
  50         return $this->dbi->tryQuery(sprintf(
  51             'SELECT 1 FROM %s.%s LIMIT 1;',
  52             Util::backquote($database),
  53             Util::backquote($table),
  54         )) !== false;
  55     }
  56 }