Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

mysqli(3) [php man page]

MYSQLI(3)								 1								 MYSQLI(3)

The mysqli class

INTRODUCTION
Represents a connection between PHP and a MySQL database. CLASS SYNOPSIS
mysqli mysqli Properties o int$mysqli->affected_rows o string$mysqli->client_info o int$mysqli->client_version o int$mysqli->connect_errno o string$mysqli->connect_error o int$mysqli->errno o array$mysqli->error_list o string$mysqli->error o int$mysqli->field_count o int$mysqli->client_version o string$mysqli->host_info o string$mysqli->protocol_version o string$mysqli->server_info o int$mysqli->server_version o string$mysqli->info o mixed$mysqli->insert_id o string$mysqli->sqlstate o int$mysqli->thread_id o int$mysqli->warning_count Methods o 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")]) o bool mysqli::autocommit (bool $mode) o bool mysqli::change_user (string $user, string $password, string $database) o string mysqli::character_set_name (void ) o bool mysqli::close (void ) o bool mysqli::commit ([int $flags], [string $name]) o bool mysqli::debug (string $message) o bool mysqli::dump_debug_info (void ) o object mysqli::get_charset (void ) o string mysqli::get_client_info (void ) o bool mysqli::get_connection_stats (void ) o mysqli_warning mysqli::get_warnings (void ) o mysqli mysqli::init (void ) o bool mysqli::kill (int $processid) o bool mysqli::more_results (void ) o bool mysqli::multi_query (string $query) o bool mysqli::next_result (void ) o bool mysqli::options (int $option, mixed $value) o bool mysqli::ping (void ) o publicstatic int mysqli::poll (array &$read, array &$error, array &$reject, int $sec, [int $usec]) o mysqli_stmt mysqli::prepare (string $query) o mixed mysqli::query (string $query, [int $resultmode = MYSQLI_STORE_RESULT]) o bool mysqli::real_connect ([string $host], [string $username], [string $passwd], [string $dbname], [int $port], [string $socket], [int $flags]) o string mysqli::escape_string (string $escapestr) o bool mysqli::real_query (string $query) o public mysqli_result mysqli::reap_async_query (void ) o public bool mysqli::refresh (int $options) o bool mysqli::rollback ([int $flags], [string $name]) o int mysqli::rpl_query_type (string $query) o bool mysqli::select_db (string $dbname) o bool mysqli::send_query (string $query) o bool mysqli::set_charset (string $charset) o bool mysqli::set_local_infile_handler (mysqli $link, callable $read_func) o bool mysqli::ssl_set (string $key, string $cert, string $ca, string $capath, string $cipher) o string mysqli::stat (void ) o mysqli_stmt mysqli::stmt_init (void ) o mysqli_result mysqli::store_result ([int $option]) o mysqli_result mysqli::use_result (void ) PHP Documentation Group MYSQLI(3)

Check Out this Related Man Page

MYSQLI_AUTOCOMMIT(3)							 1						      MYSQLI_AUTOCOMMIT(3)

mysqli::autocommit - Turns on or off auto-committing database modifications

       Object oriented style

SYNOPSIS
bool mysqli::autocommit (bool $mode) DESCRIPTION
Procedural style bool mysqli_autocommit (mysqli $link, bool $mode) Turns on or off auto-commit mode on queries for the database connection. To determine the current state of autocommit use the SQL command SELECT @@autocommit. PARAMETERS
o $ link -Procedural style only: A link identifier returned by mysqli_connect(3) or mysqli_init(3) o $mode - Whether to turn on auto-commit or not. RETURN VALUES
Returns TRUE on success or FALSE on failure. NOTES
Note This function doesn't work with non transactional table types (like MyISAM or ISAM). EXAMPLES
Example #1 mysqli::autocommit example Object oriented style <?php $mysqli = new mysqli("localhost", "my_user", "my_password", "world"); if (mysqli_connect_errno()) { printf("Connect failed: %s ", mysqli_connect_error()); exit(); } /* turn autocommit on */ $mysqli->autocommit(TRUE); if ($result = $mysqli->query("SELECT @@autocommit")) { $row = $result->fetch_row(); printf("Autocommit is %s ", $row[0]); $result->free(); } /* close connection */ $mysqli->close(); ?> Procedural style <?php $link = mysqli_connect("localhost", "my_user", "my_password", "world"); if (!$link) { printf("Can't connect to localhost. Error: %s ", mysqli_connect_error()); exit(); } /* turn autocommit on */ mysqli_autocommit($link, TRUE); if ($result = mysqli_query($link, "SELECT @@autocommit")) { $row = mysqli_fetch_row($result); printf("Autocommit is %s ", $row[0]); mysqli_free_result($result); } /* close connection */ mysqli_close($link); ?> The above examples will output: Autocommit is 1 SEE ALSO
mysqli_begin_transaction(3), mysqli_commit(3), mysqli_rollback(3). PHP Documentation Group MYSQLI_AUTOCOMMIT(3)
Man Page