Documentation Home
Connectors and APIs Manual
Download this Manual

Connectors and APIs Manual  /  ...  /  The mysqli class

7.3.8 The mysqli class

7.3.8.1 mysqli::$affected_rows, mysqli_affected_rows
7.3.8.2 mysqli::autocommit, mysqli_autocommit
7.3.8.3 mysqli::begin_transaction, mysqli_begin_transaction
7.3.8.4 mysqli::change_user, mysqli_change_user
7.3.8.5 mysqli::character_set_name, mysqli_character_set_name
7.3.8.6 mysqli::close, mysqli_close
7.3.8.7 mysqli::commit, mysqli_commit
7.3.8.8 mysqli::$connect_errno, mysqli_connect_errno
7.3.8.9 mysqli::$connect_error, mysqli_connect_error
7.3.8.10 mysqli::__construct, mysqli::connect, mysqli_connect
7.3.8.11 mysqli::debug, mysqli_debug
7.3.8.12 mysqli::dump_debug_info, mysqli_dump_debug_info
7.3.8.13 mysqli::$errno, mysqli_errno
7.3.8.14 mysqli::$error_list, mysqli_error_list
7.3.8.15 mysqli::$error, mysqli_error
7.3.8.16 mysqli::$field_count, mysqli_field_count
7.3.8.17 mysqli::get_charset, mysqli_get_charset
7.3.8.18 mysqli::$client_info, mysqli::get_client_info, mysqli_get_client_info
7.3.8.19 mysqli::$client_version, mysqli_get_client_version
7.3.8.20 mysqli::get_connection_stats, mysqli_get_connection_stats
7.3.8.21 mysqli::$host_info, mysqli_get_host_info
7.3.8.22 mysqli::$protocol_version, mysqli_get_proto_info
7.3.8.23 mysqli::$server_info, mysqli::get_server_info, mysqli_get_server_info
7.3.8.24 mysqli::$server_version, mysqli_get_server_version
7.3.8.25 mysqli::get_warnings, mysqli_get_warnings
7.3.8.26 mysqli::$info, mysqli_info
7.3.8.27 mysqli::init, mysqli_init
7.3.8.28 mysqli::$insert_id, mysqli_insert_id
7.3.8.29 mysqli::kill, mysqli_kill
7.3.8.30 mysqli::more_results, mysqli_more_results
7.3.8.31 mysqli::multi_query, mysqli_multi_query
7.3.8.32 mysqli::next_result, mysqli_next_result
7.3.8.33 mysqli::options, mysqli_options
7.3.8.34 mysqli::ping, mysqli_ping
7.3.8.35 mysqli::poll, mysqli_poll
7.3.8.36 mysqli::prepare, mysqli_prepare
7.3.8.37 mysqli::query, mysqli_query
7.3.8.38 mysqli::real_connect, mysqli_real_connect
7.3.8.39 mysqli::real_escape_string, mysqli_real_escape_string
7.3.8.40 mysqli::real_query, mysqli_real_query
7.3.8.41 mysqli::reap_async_query, mysqli_reap_async_query
7.3.8.42 mysqli::refresh, mysqli_refresh
7.3.8.43 mysqli::release_savepoint, mysqli_release_savepoint
7.3.8.44 mysqli::rollback, mysqli_rollback
7.3.8.45 mysqli::savepoint, mysqli_savepoint
7.3.8.46 mysqli::select_db, mysqli_select_db
7.3.8.47 mysqli::set_charset, mysqli_set_charset
7.3.8.48 mysqli::$sqlstate, mysqli_sqlstate
7.3.8.49 mysqli::ssl_set, mysqli_ssl_set
7.3.8.50 mysqli::stat, mysqli_stat
7.3.8.51 mysqli::stmt_init, mysqli_stmt_init
7.3.8.52 mysqli::store_result, mysqli_store_result
7.3.8.53 mysqli::$thread_id, mysqli_thread_id
7.3.8.54 mysqli::thread_safe, mysqli_thread_safe
7.3.8.55 mysqli::use_result, mysqli_use_result
7.3.8.56 mysqli::$warning_count, mysqli_warning_count

Copyright 1997-2021 the PHP Documentation Group.

Represents a connection between PHP and a MySQL database.

 mysqli {
mysqli Properties  int mysqli->affected_rows ;
  static int mysqli->connect_errno ;
  static string|null|int|array|string|int|string|null|int|string|int|string|int|string|null|int|string|string|int|int mysqli->warning_count ;
Methods  public mysqli::__construct(string host= =ini_get("mysqli.default_host"),
                             string username= =ini_get("mysqli.default_user"),
                             string passwd= =ini_get("mysqli.default_pw"),
                             string dbname= ="",
                             int port= =ini_get("mysqli.default_port"),
                             string socket= =ini_get("mysqli.default_socket"));

  public bool mysqli::autocommit(bool enable);
  public bool mysqli::begin_transaction(int flags= =0,
                                        string|null name= =null);

  public bool mysqli::change_user(string username,
                                  string password,
                                  string|null database);

  public string mysqli::character_set_name();
  public bool mysqli::close();
  public bool mysqli::commit(int flags= =0,
                             string|null name= =null);

  public void mysqli::connect(string host= =ini_get("mysqli.default_host"),
                              string username= =ini_get("mysqli.default_user"),
                              string passwd= =ini_get("mysqli.default_pw"),
                              string dbname= ="",
                              int port= =ini_get("mysqli.default_port"),
                              string socket= =ini_get("mysqli.default_socket"));

  public bool mysqli::debug(string options);
  public bool mysqli::dump_debug_info();
  public object|null mysqli::get_charset();
  public string|null mysqli::get_client_info();
  public array mysqli::get_connection_stats();
  public string mysqli::get_server_info();
  public mysqli_warning|false mysqli::get_warnings();
  public mysqli mysqli::init();
  public bool mysqli::kill(int process_id);
  public bool mysqli::more_results();
  public bool mysqli::multi_query(string query);
  public bool mysqli::next_result();
  public bool mysqli::options(int option,
                              string|int value);

  public bool mysqli::ping();
  public static int|false mysqli::poll(array|null read,
                                       array|null error,
                                       array reject,
                                       int seconds,
                                       int microseconds= =0);

  public mysqli_stmt|false mysqli::prepare(string query);
  public mysqli_result|bool mysqli::query(string query,
                                          int result_mode= =MYSQLI_STORE_RESULT);

  public bool mysqli::real_connect(string host,
                                   string username,
                                   string passwd,
                                   string dbname,
                                   int port,
                                   string socket,
                                   int flags);

  public string mysqli::real_escape_string(string string);
  public bool mysqli::real_query(string query);
  public mysqli_result|bool mysqli::reap_async_query();
  public bool mysqli::refresh(int flags);
  public bool mysqli::release_savepoint(string name);
  public bool mysqli::rollback(int flags= =0,
                               string|null name= =null);

  public bool mysqli::savepoint(string name);
  public bool mysqli::select_db(string database);
  public bool mysqli::set_charset(string charset);
  public bool mysqli::ssl_set(string|null key,
                              string|null certificate,
                              string|null ca_certificate,
                              string|null ca_path,
                              string|null cipher_algos);

  public string|false mysqli::stat();
  public mysqli_stmt|false mysqli::stmt_init();
  public mysqli_result|false mysqli::store_result(int mode= =0);
  public bool mysqli::thread_safe();
  public mysqli_result|false mysqli::use_result();
}