Gecko [ 35.178.45.201 ]

Name	Size	Permission
Connection.php	183 B	-rw-r--r--
ConnectionException.php	125 B	-rw-r--r--
ConnectionType.php	298 B	-rw-r--r--
DbalInterface.php	18.08 KB	-rw-r--r--
DbiExtension.php	3.07 KB	-rw-r--r--
DbiMysqli.php	10.39 KB	-rw-r--r--
MysqliResult.php	5.71 KB	-rw-r--r--
MysqliStatement.php	769 B	-rw-r--r--
ResultInterface.php	2.91 KB	-rw-r--r--
Statement.php	350 B	-rw-r--r--
Warning.php	1.43 KB	-rw-r--r--

Code Editor : MysqliResult.php

<?php
/**
 * Extension independent database result
 */

declare(strict_types=1);

namespace PhpMyAdmin\Dbal;

use Generator;
use mysqli_result;
use PhpMyAdmin\FieldMetadata;
use Webmozart\Assert\Assert;

use function array_column;
use function array_key_exists;
use function is_array;
use function is_bool;
use function is_string;

use const MYSQLI_ASSOC;
use const MYSQLI_NUM;

/**
 * Extension independent database result
 */
final class MysqliResult implements ResultInterface
{
    /**
     * The result identifier produced by the DBiExtension
     */
    private mysqli_result|null $result;

public function __construct(mysqli_result|bool $result)
    {
        $this->result = is_bool($result) ? null : $result;
    }

/**
     * Returns a generator that traverses through the whole result set
     * and returns each row as an associative array
     *
     * @psalm-return Generator<int, array<array-key, string|null>, mixed, void>
     */
    public function getIterator(): Generator
    {
        if ($this->result === null) {
            return;
        }

$this->result->data_seek(0);
        /** @var array<string, string|null> $row */
        foreach ($this->result as $row) {
            yield $row;
        }
    }

/**
     * Returns the next row of the result with associative keys
     *
     * @return array<string|null>
     * @psalm-return array<array-key, string|null>
     */
    public function fetchAssoc(): array
    {
        if ($this->result === null) {
            return [];
        }

$row = $this->result->fetch_assoc();

return is_array($row) ? $row : [];
    }

/**
     * Returns the next row of the result with numeric keys
     *
     * @return array<int,string|null>
     * @psalm-return list<string|null>
     */
    public function fetchRow(): array
    {
        if ($this->result === null) {
            return [];
        }

$row = $this->result->fetch_row();

return is_array($row) ? $row : [];
    }

/**
     * Returns a single value from the given result; false on error
     */
    public function fetchValue(int|string $field = 0): string|false|null
    {
        $row = is_string($field) ? $this->fetchAssoc() : $this->fetchRow();

if (! array_key_exists($field, $row)) {
            return false;
        }

return $row[$field];
    }

/**
     * Returns all rows of the result
     *
     * @return array<array<string|null>>
     * @psalm-return list<array<array-key, string|null>>
     */
    public function fetchAllAssoc(): array
    {
        if ($this->result === null) {
            return [];
        }

// This function should return all rows, not only the remaining rows
        $this->result->data_seek(0);

return $this->result->fetch_all(MYSQLI_ASSOC);
    }

/**
     * Returns values from the selected column of each row
     *
     * @return array<int, string|null>
     * @psalm-return list<string|null>
     */
    public function fetchAllColumn(int|string $column = 0): array
    {
        if ($this->result === null) {
            return [];
        }

// This function should return all rows, not only the remaining rows
        $this->result->data_seek(0);

$result = is_string($column) ? $this->result->fetch_all(MYSQLI_ASSOC) : $this->result->fetch_all(MYSQLI_NUM);

return array_column($result, $column);
    }

/**
     * Returns values as single dimensional array where the key is the first column
     * and the value is the second column, e.g.
     * SELECT id, name FROM users
     * produces: ['123' => 'John', '124' => 'Jane']
     *
     * @return array<string|null>
     * @psalm-return array<array-key, string|null>
     */
    public function fetchAllKeyPair(): array
    {
        if ($this->result === null) {
            return [];
        }

Assert::greaterThanEq($this->result->field_count, 2);

// This function should return all rows, not only the remaining rows
        $this->result->data_seek(0);

return array_column($this->result->fetch_all(), 1, 0);
    }

/**
     * Returns the number of fields in the result
     */
    public function numFields(): int
    {
        if ($this->result === null) {
            return 0;
        }

return $this->result->field_count;
    }

/**
     * Returns the number of rows in the result
     *
     * @psalm-return int|numeric-string
     */
    public function numRows(): string|int
    {
        if ($this->result === null) {
            return 0;
        }

return $this->result->num_rows;
    }

/**
     * Adjusts the result pointer to an arbitrary row in the result
     *
     * @param int $offset offset to seek
     *
     * @return bool True if the offset exists, false otherwise
     */
    public function seek(int $offset): bool
    {
        if ($this->result === null) {
            return false;
        }

return $this->result->data_seek($offset);
    }

/**
     * returns meta info for fields in $result
     *
     * @return array<int, FieldMetadata> meta info for fields in $result
     * @psalm-return list<FieldMetadata>
     */
    public function getFieldsMeta(): array
    {
        if ($this->result === null) {
            return [];
        }

$fields = [];
        foreach ($this->result->fetch_fields() as $field) {
            $fields[] = new FieldMetadata($field);
        }

return $fields;
    }

/**
     * Returns the names of the fields in the result
     *
     * @return array<int, string> Fields names
     * @psalm-return list<non-empty-string>
     */
    public function getFieldNames(): array
    {
        if ($this->result === null) {
            return [];
        }

return array_column($this->result->fetch_fields(), 'name');
    }
}

${this.title}

Code Editor : MysqliResult.php