src/ShowGrants.php

   1 <?php
   2
   3 declare(strict_types=1);
   4
   5 namespace PhpMyAdmin;
   6
   7 use function mb_strpos;
   8 use function mb_substr;
   9
  10 final class ShowGrants
  11 {
  12     public readonly string $grants;
  13     public readonly string $tableName;
  14     public readonly string $dbName;
  15     private int $tableNameEndOffset;
  16     private int $tableNameStartOffset;
  17     private int $dbNameOffset;
  18
  19     public function __construct(string $showGrants)
  20     {
  21         $this->dbNameOffset = (int) mb_strpos($showGrants, ' ON ') + 4;
  22         $this->tableNameEndOffset = (int) mb_strpos($showGrants, ' TO ');
  23         $this->tableNameStartOffset = $this->getTableNameStartOffset($showGrants);
  24         $this->grants = $this->getShowGrantsString($showGrants);
  25         $this->tableName = $this->getGrantsTableName($showGrants);
  26         $this->dbName = $this->getGrantsDbName($showGrants);
  27     }
  28
  29     private function getTableNameStartOffset(string $showGrants): int
  30     {
  31         $tableNameStartOffset = mb_strpos($showGrants, '`.', $this->dbNameOffset);
  32
  33         if (
  34             $tableNameStartOffset !== false
  35             && $tableNameStartOffset !== 0
  36             && $tableNameStartOffset < $this->tableNameEndOffset
  37         ) {
  38             return $tableNameStartOffset + 1;
  39         }
  40
  41         return (int) mb_strpos($showGrants, '.', $this->dbNameOffset);
  42     }
  43
  44     private function getShowGrantsString(string $showGrants): string
  45     {
  46         return mb_substr($showGrants, 6, (int) mb_strpos($showGrants, ' ON ') - 6);
  47     }
  48
  49     private function getGrantsTableName(string $showGrants): string
  50     {
  51         $showGrantsTableName = mb_substr(
  52             $showGrants,
  53             $this->tableNameStartOffset + 1,
  54             $this->tableNameEndOffset - $this->tableNameStartOffset - 1,
  55         );
  56
  57         return Util::unQuote($showGrantsTableName, '`');
  58     }
  59
  60     private function getGrantsDbName(string $showGrants): string
  61     {
  62         $showGrantsDbName = mb_substr(
  63             $showGrants,
  64             $this->dbNameOffset,
  65             $this->tableNameStartOffset - $this->dbNameOffset,
  66         );
  67
  68         return Util::unQuote($showGrantsDbName, '`');
  69     }
  70 }