mysqli クラス

(PHP 5, PHP 7, PHP 8)

はじめに

PHP と MySQL データベースの間の接続を表します。

クラス概要

class mysqli {

/* プロパティ */

public readonly int |string $affected_rows ;

public readonly string $client_info ;

public readonly int $client_version ;

public readonly int $connect_errno ;

public readonly ?string $connect_error ;

public readonly int $errno ;

public readonly string $error ;

public readonly array $error_list ;

public readonly int $field_count ;

public readonly string $host_info ;

public readonly ?string $info ;

public readonly int |string $insert_id ;

public readonly string $server_info ;

public readonly int $server_version ;

public readonly string $sqlstate ;

public readonly int $protocol_version ;

public readonly int $thread_id ;

public readonly int $warning_count ;

/* メソッド */

public __construct (
? string $hostname = null ,
? string $username = null ,
#[\SensitiveParameter] ? string $password = null ,
? string $database = null ,
? int $port = null ,
? string $socket = null
)

public autocommit (bool $enable): bool

public begin_transaction (int $flags = 0, ? string $name = null ): bool

public change_user (string $username, #[\SensitiveParameter] string $password, ? string $database): bool

public character_set_name (): string

public close (): true

public commit (int $flags = 0, ? string $name = null ): bool

public connect (
? string $hostname = null ,
? string $username = null ,
#[\SensitiveParameter] ? string $password = null ,
? string $database = null ,
? int $port = null ,
? string $socket = null
): bool

public debug (string $options): true

public dump_debug_info (): bool

public execute_query (string $query, ? array $params = null ): mysqli_result |bool

public get_charset (): ? object

#[\Deprecated]
public get_client_info (): string

public get_connection_stats (): array

public get_server_info (): string

public get_warnings (): mysqli_warning |false

#[\Deprecated]
public init (): ? bool

#[\Deprecated]
public kill (int $process_id): bool

public more_results (): bool

public multi_query (string $query): bool

public next_result (): bool

public options (int $option, string |int $value): bool

#[\Deprecated]
public ping (): bool

public static poll (
? array &$read,
? array &$error,
array &$reject,
int $seconds,
int $microseconds = 0
): int |false

public prepare (string $query): mysqli_stmt |false

public query (string $query, int $result_mode = MYSQLI_STORE_RESULT ): mysqli_result |bool

public real_connect (
? string $hostname = null ,
? string $username = null ,
#[\SensitiveParameter] ? string $password = null ,
? string $database = null ,
? int $port = null ,
? string $socket = null ,
int $flags = 0
): bool

public real_escape_string (string $string): string

public real_query (string $query): bool

public reap_async_query (): mysqli_result |bool

#[\Deprecated]
public refresh (int $flags): bool

public release_savepoint (string $name): bool