The mysqli class

    (PHP 5, PHP 7, PHP 8)

    Introduction

    Represents a connection between PHP and a MySQL database.

    Class synopsis

    classmysqli {
    publicreadonlyint|string$affected_rows;
    publicreadonlystring$client_info;
    publicreadonlyint$client_version;
    publicreadonlyint$connect_errno;
    publicreadonly?string$connect_error;
    publicreadonlyint$errno;
    publicreadonlystring$error;
    publicreadonlyarray$error_list;
    publicreadonlyint$field_count;
    publicreadonlystring$host_info;
    publicreadonly?string$info;
    publicreadonlyint|string$insert_id;
    publicreadonlystring$server_info;
    publicreadonlyint$server_version;
    publicreadonlystring$sqlstate;
    publicreadonlyint$protocol_version;
    publicreadonlyint$thread_id;
    publicreadonlyint$warning_count;
    public__construct(
        ?string$hostname = null,
        ?string$username = null,
        ?string$password = null,
        ?string$database = null,
        ?int$port = null,
        ?string$socket = null
    )
    publicautocommit(bool$enable): bool
    publicbegin_transaction(int$flags = 0, ?string$name = null): bool
    publicchange_user(string$username, string$password, ?string$database): bool
    publiccharacter_set_name(): string
    publicclose(): true
    publiccommit(int$flags = 0, ?string$name = null): bool
    publicconnect(
        ?string$hostname = null,
        ?string$username = null,
        ?string$password = null,
        ?string$database = null,
        ?int$port = null,
        ?string$socket = null
    ): bool
    publicdebug(string$options): true
    publicdump_debug_info(): bool
    publicexecute_query(string$query, ?array$params = null): mysqli_result|bool
    publicget_charset(): ?object
    publicget_client_info(): string
    publicget_connection_stats(): array
    publicget_server_info(): string
    publicget_warnings(): mysqli_warning|false
    publicinit(): ?bool
    publickill(int$process_id): bool
    publicmore_results(): bool
    publicmulti_query(string$query): bool
    publicnext_result(): bool
    publicoptions(int$option, string|int$value): bool
    publicping(): bool
    publicstaticpoll(
        ?array&$read,
        ?array&$error,
        array&$reject,
        int$seconds,
        int$microseconds = 0
    ): int|false
    publicprepare(string$query): mysqli_stmt|false
    publicquery(string$query, int$result_mode = MYSQLI_STORE_RESULT): mysqli_result|bool
    publicreal_connect(
        ?string$hostname = null,
        ?string$username = null,
        ?string$password = null,
        ?string$database = null,
        ?int$port = null,
        ?string$socket = null,
        int$flags = 0
    ): bool
    publicreal_escape_string(string$string): string
    publicreal_query(string$query): bool
    publicreap_async_query(): mysqli_result|bool
    publicrefresh(int$flags): bool
    publicrelease_savepoint(string$name): bool
    publicrollback(int$flags = 0, ?string$name = null): bool
    publicsavepoint(string$name): bool
    publicselect_db(string$database): bool
    publicset_charset(string$charset): bool
    publicssl_set(
        ?string$key,
        ?string$certificate,
        ?string$ca_certificate,
        ?string$ca_path,
        ?string$cipher_algos
    ): true
    publicstat(): string|false
    publicstmt_init(): mysqli_stmt|false
    publicstore_result(int$mode = 0): mysqli_result|false
    publicthread_safe(): bool
    publicuse_result(): mysqli_result|false
    }

    Table of Contents

    To Top