MySQLi
PHP Manual

The mysqli class

Introduction

Represents a connection between PHP and a MySQL database.

Class synopsis

mysqli
/* Properties */
public readonly intstring $affected_rows;
public readonly string $client_info;
public readonly int $client_version;
public readonly int $connect_errno;
public readonly stringnull $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 stringnull $info;
public readonly intstring $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;
/* Methods */
public __construct(
    stringnull $hostname = null,
    stringnull $username = null,
    #[\SensitiveParameter]stringnull $password = null,
    stringnull $database = null,
    intnull $port = null,
    stringnull $socket = null
)
public bool autocommit(bool $enable)
public bool begin_transaction(int $flags = 0, stringnull $name = null)
public bool change_user(string $username, #[\SensitiveParameter]string $password, stringnull $database)
public string character_set_name()
public true close()
public bool commit(int $flags = 0, stringnull $name = null)
public bool connect(
    stringnull $hostname = null,
    stringnull $username = null,
    #[\SensitiveParameter]stringnull $password = null,
    stringnull $database = null,
    intnull $port = null,
    stringnull $socket = null
)
public true debug(string $options)
public bool dump_debug_info()
public mysqli_resultbool execute_query(string $query, arraynull $params = null)
public objectnull get_charset()
#[\Deprecated] public string get_client_info()
public array get_connection_stats()
public string get_server_info()
public mysqli_warningfalse get_warnings()
#[\Deprecated] public boolnull init()
#[\Deprecated] public bool kill(int $process_id)
public bool more_results()
public bool multi_query(string $query)
public bool next_result()
public bool options(int $option, stringint $value)
#[\Deprecated] public bool ping()
public static intfalse poll(
    arraynull &$read,
    arraynull &$error,
    array &$reject,
    int $seconds,
    int $microseconds = 0
)
public mysqli_stmtfalse prepare(string $query)
public mysqli_resultbool query(string $query, int $result_mode = MYSQLI_STORE_RESULT)
public bool real_connect(
    stringnull $hostname = null,
    stringnull $username = null,
    #[\SensitiveParameter]stringnull $password = null,
    stringnull $database = null,
    intnull $port = null,
    stringnull $socket = null,
    int $flags = 0
)
public string real_escape_string(string $string)
public bool real_query(string $query)
public mysqli_resultbool reap_async_query()
#[\Deprecated] public bool refresh(int $flags)
public bool release_savepoint(string $name)
public bool rollback(int $flags = 0, stringnull $name = null)
public bool savepoint(string $name)
public bool select_db(string $database)
public bool set_charset(string $charset)
public true ssl_set(
    stringnull $key,
    stringnull $certificate,
    stringnull $ca_certificate,
    stringnull $ca_path,
    stringnull $cipher_algos
)
public stringfalse stat()
public mysqli_stmtfalse stmt_init()
public mysqli_resultfalse store_result(int $mode = 0)
public bool thread_safe()
public mysqli_resultfalse use_result()
Table of Contents