github.com

classZtdMysqli

packages/ztd-query-mysqli-adapter/src/ZtdMysqli.php:52
class ZtdMysqli
    extends mysqli
Public API: explicitly declared with @visibility public.

mysqli proxy that enforces ZTD behavior for reads and writes.

Uses delegation pattern: extends mysqli for type compatibility, but delegates all operations to an inner mysqli instance when using fromMysqli().

All public methods are explicitly overridden to prevent parent class implementation from being called when constructed via fromMysqli().

Properties are delegated via __get/__isset to the inner mysqli instance.

Supports optional Platform injection. If no platform is provided, MySqlPlatform is used by default (mysqli is MySQL-only).

Simulate writes without changing the native tabledoctest
$container = \Testcontainers\Testcontainers::run(\Container\MySqlRelease::fromEnvironment());
    $endpoint = $container->getData(\Container\Endpoint::class);
    $native = new \mysqli($endpoint->host, $endpoint->username, $endpoint->password, $endpoint->database, $endpoint->port);
    $native->set_charset('utf8mb4');
    $native->query('CREATE TABLE accounts (id INT PRIMARY KEY, balance INT)');
    $native->query('INSERT INTO accounts VALUES (1, 10)');
    $ztd = \ZtdQuery\Adapter\Mysqli\ZtdMysqli::fromMysqli($native);
    $ztd->query('INSERT INTO accounts VALUES (2, 20)');
    $ztd->lastAffectedRows() // => 1
    $ztd->query('SELECT id FROM accounts')->fetch_all(MYSQLI_ASSOC) // => [['id' => 2]]
    $native->query('SELECT id FROM accounts')->fetch_all(MYSQLI_ASSOC) // => [['id' => '1']]
    $native->query('DROP TABLE accounts');
    $container->stop();

Methods§

public function __construct(
    ?string $hostname = null,
    ?string $username = null,
    ?string $password = null,
    ?string $database = null,
    ?int $port = null,
    ?string $socket = null,
    ?ZtdConfig $config = null,
    ?Platform $platform = null,
)
source§

Configure a new ZTD-enabled mysqli wrapper.

If $platform is provided, its database semantics are used by the core executor. If $platform is null, MySqlPlatform is used by default.

Parameters

$hostname?string
$username?string
$password?string
$database?string
$port?int
$socket?string
$config?ZtdConfig
$platform?Platform
Calls 3
public static function fromMysqli(
    mysqli $mysqli,
    ?ZtdConfig $config = null,
    ?Platform $platform = null,
): self
source§

Create a ZtdMysqli wrapper around an existing mysqli instance.

This allows reusing an existing mysqli connection instead of creating a new one. The wrapped mysqli instance will be used for all database operations.

If $platform is provided, its database semantics are used by the core executor. If $platform is null, MySqlPlatform is used by default.

Parameters

$mysqlimysqli
$config?ZtdConfig
$platform?Platform

Returns

self
Test cases 103
Calls 4
public function enableZtd(): void
source§

Enable ZTD mode for this connection.

Calls 1
public function disableZtd(): void
source§

Disable ZTD mode for this connection.

Calls 1
public function isZtdEnabled(): bool
source§

Check whether ZTD mode is enabled.

Returns

bool
Test cases 1
Calls 1
public function lastAffectedRows(): int
source§

Get the affected row count from the last ZTD or regular operation.

Note: Direct property access ($this->affected_rows) is not supported because PHP's C extension property handler for mysqli takes precedence over __get when the parent constructor was not called. Use this method instead.

Returns

int
Calls 1
public function __get(string $name): mixed
source§

Delegate property access to the inner mysqli instance.

Handles affected_rows specially when ZTD has tracked affected rows.

Parameters

$namestring

Returns

mixed
Calls 4
public function __isset(string $name): bool
source§

Delegate property isset check to the inner mysqli instance.

Parameters

$namestring

Returns

bool
Calls 3
public function prepare(string $query): mysqli_stmt|false
source§

{@inheritDoc}

Parameters

$querystring

Returns

mysqli_stmt|false

Throws

ZtdMysqliException When ZTD-specific exception occurs (wraps DatabaseException).
mysqli_sql_exception When native execution fails.
Called from 2
Calls 2
public function query(string $query, int $resultMode = MYSQLI_STORE_RESULT): mysqli_result|bool
source§

{@inheritDoc}

Parameters

$querystring
$resultModeint

Returns

mysqli_result|bool

Throws

ZtdMysqliException When ZTD-specific exception occurs (wraps DatabaseException).
mysqli_sql_exception When native execution fails.
Test cases 2
Calls 2
public function real_query(string $query): bool
source§

{@inheritDoc}

Parameters

$querystring

Returns

bool

Throws

ZtdMysqliException When ZTD-specific exception occurs (wraps DatabaseException).
mysqli_sql_exception When native execution fails.
Calls 2
public function multi_query(string $query): bool
source§

{@inheritDoc}

Parameters

$querystring

Returns

bool
Calls 1
public function begin_transaction(int $flags = 0, ?string $name = null): bool
source§

{@inheritDoc}

Parameters

$flagsint
$name?string

Returns

bool
Calls 1
public function commit(int $flags = 0, ?string $name = null): bool
source§

{@inheritDoc}

Parameters

$flagsint
$name?string

Returns

bool
Calls 1
public function rollback(int $flags = 0, ?string $name = null): bool
source§

{@inheritDoc}

Parameters

$flagsint
$name?string

Returns

bool
Calls 1
public function autocommit(bool $enable): bool
source§

{@inheritDoc}

Parameters

$enablebool

Returns

bool
Calls 1
public function select_db(string $database): bool
source§

{@inheritDoc}

Parameters

$databasestring

Returns

bool
Calls 1
public function set_charset(string $charset): bool
source§

{@inheritDoc}

Parameters

$charsetstring

Returns

bool
Calls 1
public function real_escape_string(string $string): string
source§

{@inheritDoc}

Parameters

$stringstring

Returns

string
Calls 1
public function escape_string(string $string): string
source§

{@inheritDoc}

Parameters

$stringstring

Returns

string
Calls 1
public function ping(): bool
source§

{@inheritDoc}

Returns

bool
Calls 1
public function character_set_name(): string
source§

{@inheritDoc}

Returns

string
Calls 1
public function change_user(string $username, string $password, ?string $database): bool
source§

{@inheritDoc}

Parameters

$usernamestring
$passwordstring
$database?string

Returns

bool
Calls 1
public function connect(
    ?string $hostname = null,
    ?string $username = null,
    ?string $password = null,
    ?string $database = null,
    ?int $port = null,
    ?string $socket = null,
): bool
source§

{@inheritDoc}

Parameters

$hostname?string
$username?string
$password?string
$database?string
$port?int
$socket?string

Returns

bool
Calls 1
public function debug(string $options)
source§

{@inheritDoc}

Parameters

$optionsstring
Calls 1
public function dump_debug_info(): bool
source§

{@inheritDoc}

Returns

bool
Calls 1
public function get_charset(): ?object
source§

{@inheritDoc}

Returns

?object
Calls 1
public function get_client_info(): string
source§
Deprecated: 8.1

{@inheritDoc}

Returns

string
Calls 1
public function get_connection_stats(): array<string, mixed>
source§

{@inheritDoc}

Returns

array<string, mixed>
Calls 2
public function get_server_info(): string
source§

{@inheritDoc}

Returns

string
Calls 1
public function get_warnings(): mysqli_warning|false
source§

{@inheritDoc}

Returns

mysqli_warning|false
Calls 1
public function init(): ?bool
source§
Deprecated: 8.1

{@inheritDoc}

Returns

?bool
Calls 1
public function kill(int $process_id): bool
source§

{@inheritDoc}

Parameters

$process_idint

Returns

bool
Calls 1
public function more_results(): bool
source§

{@inheritDoc}

Returns

bool
Calls 1
public function next_result(): bool
source§

{@inheritDoc}

Returns

bool
Calls 1
public function options(int $option, mixed $value): bool
source§

{@inheritDoc}

Parameters

$optionint
$valuemixed

Returns

bool
Calls 1
public function real_connect(
    ?string $hostname = null,
    ?string $username = null,
    ?string $password = null,
    ?string $database = null,
    ?int $port = null,
    ?string $socket = null,
    int $flags = 0,
): bool
source§

{@inheritDoc}

Parameters

$hostname?string
$username?string
$password?string
$database?string
$port?int
$socket?string
$flagsint

Returns

bool
Calls 1
public function reap_async_query(): mysqli_result|bool
source§

{@inheritDoc}

Returns

mysqli_result|bool
Calls 1
public function refresh(int $flags): bool
source§

{@inheritDoc}

Parameters

$flagsint

Returns

bool
Calls 1
public function release_savepoint(string $name): bool
source§

{@inheritDoc}

Parameters

$namestring

Returns

bool
Calls 1
public function savepoint(string $name): bool
source§

{@inheritDoc}

Parameters

$namestring

Returns

bool
Calls 1
public function ssl_set(
    ?string $key,
    ?string $certificate,
    ?string $ca_certificate,
    ?string $ca_path,
    ?string $cipher_algos,
)
source§

{@inheritDoc}

Parameters

$key?string
$certificate?string
$ca_certificate?string
$ca_path?string
$cipher_algos?string
Calls 1
public function stat(): string|false
source§

{@inheritDoc}

Returns

string|false
Calls 1
public function stmt_init(): mysqli_stmt
source§

{@inheritDoc}

Returns

mysqli_stmt
Calls 1
public function store_result(int $mode = 0): mysqli_result|false
source§

{@inheritDoc}

Parameters

$modeint

Returns

mysqli_result|false
Calls 1
public function thread_safe(): bool
source§

{@inheritDoc}

Returns

bool
Calls 1
public function use_result(): mysqli_result|false
source§

{@inheritDoc}

Returns

mysqli_result|false
Calls 1
public function set_opt(int $option, mixed $value): bool
source§

{@inheritDoc}

Parameters

$optionint
$valuemixed

Returns

bool
Calls 1
public static function poll(
    array<mixed, mixed>|null &$read,
    array<mixed, mixed>|null &$error,
    array<mixed, mixed> &$reject,
    int $seconds,
    int $microseconds = 0,
): int|false
source§

{@inheritDoc}

Parameters

$readarray<mixed, mixed>|null
$errorarray<mixed, mixed>|null
$rejectarray<mixed, mixed>
$secondsint
$microsecondsint

Returns

int|false
Test cases 1
Calls 1
public function execute_query(
    string $query,
    array<mixed, mixed>|null $params = null,
): mysqli_result|bool
source§

{@inheritDoc}

Parameters

$querystring
$paramsarray<mixed, mixed>|null

Returns

mysqli_result|bool

Throws

ZtdMysqliException When ZTD-specific exception occurs (wraps DatabaseException).
mysqli_sql_exception When native execution fails.
Called from 1
Calls 3

Private surface 1§

Implementation details, listed for orientation only.

private ConnectionExecution $execution

Test cases 105§

Test cases that cover or call this symbol, from the coverage report and from the analyzed test sources.

Dedicated tests 57
Other tests reaching this symbol 48