���� JFIF �� � ( %"1"%)+...383,7(-.-
![]() Server : Apache/2.4.6 (CentOS) OpenSSL/1.0.2k-fips PHP/7.4.20 System : Linux st2.domain.com 3.10.0-1127.10.1.el7.x86_64 #1 SMP Wed Jun 3 14:28:03 UTC 2020 x86_64 User : apache ( 48) PHP Version : 7.4.20 Disable Function : NONE Directory : /proc/self/root/usr/share/phpMyAdmin/libraries/classes/Table/ |
<?php declare(strict_types=1); namespace PhpMyAdmin\Table; use PhpMyAdmin\DatabaseInterface; use PhpMyAdmin\Index; use PhpMyAdmin\Util; use function implode; use function sprintf; final class Maintenance { /** @var DatabaseInterface */ private $dbi; public function __construct(DatabaseInterface $dbi) { $this->dbi = $dbi; } /** * @param string[] $tables * * @return array */ public function getAnalyzeTableRows(string $db, array $tables): array { $backQuotedTables = Util::backquote($tables); $query = 'ANALYZE TABLE ' . implode(', ', $backQuotedTables) . ';'; $this->dbi->selectDb($db); $result = $this->dbi->fetchResult($query); $rows = []; foreach ($result as $row) { $rows[$row['Table']][] = $row; } return [$rows, $query]; } /** * @param string[] $tables * * @return array */ public function getCheckTableRows(string $db, array $tables): array { $backQuotedTables = Util::backquote($tables); $query = 'CHECK TABLE ' . implode(', ', $backQuotedTables) . ';'; $this->dbi->selectDb($db); $result = $this->dbi->fetchResult($query); $rows = []; foreach ($result as $row) { $rows[$row['Table']][] = $row; } return [$rows, $query]; } /** * @param string[] $tables * * @return array */ public function getChecksumTableRows(string $db, array $tables): array { $backQuotedTables = Util::backquote($tables); $query = 'CHECKSUM TABLE ' . implode(', ', $backQuotedTables) . ';'; $this->dbi->selectDb($db); $rows = $this->dbi->fetchResult($query); $warnings = $this->dbi->getWarnings(); return [$rows, $query, $warnings]; } /** @param string[] $tables */ public function getIndexesProblems(string $db, array $tables): string { $indexesProblems = ''; foreach ($tables as $table) { $check = Index::findDuplicates($table, $db); if (empty($check)) { continue; } $indexesProblems .= sprintf(__('Problems with indexes of table `%s`'), $table); $indexesProblems .= $check; } return $indexesProblems; } /** * @param string[] $tables * * @return array */ public function getOptimizeTableRows(string $db, array $tables): array { $backQuotedTables = Util::backquote($tables); $query = 'OPTIMIZE TABLE ' . implode(', ', $backQuotedTables) . ';'; $this->dbi->selectDb($db); $result = $this->dbi->fetchResult($query); $rows = []; foreach ($result as $row) { $rows[$row['Table']][] = $row; } return [$rows, $query]; } /** * @param string[] $tables * * @return array */ public function getRepairTableRows(string $db, array $tables): array { $backQuotedTables = Util::backquote($tables); $query = 'REPAIR TABLE ' . implode(', ', $backQuotedTables) . ';'; $this->dbi->selectDb($db); $result = $this->dbi->fetchResult($query); $rows = []; foreach ($result as $row) { $rows[$row['Table']][] = $row; } return [$rows, $query]; } }