PHP mysqli_autocommit() Function

In this chapter you will learn:

1. Definition for PHP mysqli_autocommit() Function
2. Syntax for PHP mysqli_autocommit() Function
3. Parameter for PHP mysqli_autocommit() Function
4. Return for PHP mysqli_autocommit() Function
5. Related functions
6. Example - turns off auto-committing, make some queries, then commit the queries

Definition

The mysqli_autocommit() function turns on or off auto-committing database modifications.

Syntax

PHP mysqli_autocommit() Function has the following syntax.

Parameter

Return

It returns TRUE on success or FALSE on failure.

Related functions

The mysqli_commit() function commits the current transaction. The mysqli_rollback() function rolls back the current transaction.

Example

The following code turns off auto-committing, make some queries, then commit the queries.

<?php//from   j  av a2s  .  c o  m
$con=mysqli_connect("localhost","my_user","my_password","my_db");

if (mysqli_connect_errno($con)){
   echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

// Set autocommit to off
mysqli_autocommit($con,FALSE);

// Insert some values 
mysqli_query($con,"INSERT INTO emp (FirstName)VALUES ('PHP')");
mysqli_query($con,"INSERT INTO emp (FirstName)VALUES ('Java')");

// Commit transaction
mysqli_commit($con);

mysqli_close($con);
?>

Next chapter...

What you will learn in the next chapter:

1. Definition for PHP mysqli_change_user() Function
2. Syntax for PHP mysqli_change_user() Function
3. Parameter for PHP mysqli_change_user() Function
4. Return for PHP mysqli_change_user() Function
5. Example - changes the user of the specified database connection

PHP mysqli_affected_rows() Function

PHP mysqli_autocommit() Function

PHP mysqli_change_user() Function

PHP mysqli_character_set_name() Function

PHP mysqli_close() Function

PHP mysqli_commit() Function

PHP mysqli_connect() Function

PHP mysqli_connect_errno() Function

PHP mysqli_connect_error() Function

PHP mysqli_data_seek() Function

PHP mysqli_dump_debug_info() Function

PHP mysqli_errno() Function

PHP mysqli_error() Function

PHP mysqli_error_list() Function

PHP mysqli_fetch_all() Function

PHP mysqli_fetch_array() Function

PHP mysqli_fetch_assoc() Function

PHP mysqli_fetch_field() Function

PHP mysqli_fetch_field_direct() Function

PHP mysqli_fetch_fields() Function

PHP mysqli_fetch_lengths() Function

PHP mysqli_fetch_object() Function

PHP mysqli_fetch_row() Function

PHP mysqli_field_count() Function

PHP mysqli_field_seek() Function

PHP mysqli_field_tell() Function

PHP mysqli_free_result() Function

PHP mysqli_get_charset() Function

PHP mysqli_get_client_info() Function

PHP mysqli_get_client_stats() Function

PHP mysqli_get_client_version() Function

PHP mysqli_get_connection_stats() Function

PHP mysqli_get_host_info() Function

PHP mysqli_get_proto_info() Function

PHP mysqli_get_server_info() Function

PHP mysqli_get_server_version() Function

PHP mysqli_info() Function

PHP mysqli_init() Function

PHP mysqli_insert_id() Function

PHP mysqli_kill() Function

PHP mysqli_more_results() Function

PHP mysqli_multi_query() Function

PHP mysqli_next_result() Function

PHP mysqli_num_fields() Function

PHP mysqli_num_rows() Function

PHP mysqli_options() Function

PHP mysqli_ping() Function

PHP mysqli_query() Function

PHP mysqli_real_connect() Function

PHP mysqli_real_escape_string() Function

PHP mysqli_refresh() Function

PHP mysqli_rollback() Function

PHP mysqli_select_db() Function

PHP mysqli_set_charset() Function

PHP mysqli_sqlstate() Function

PHP mysqli_ssl_set() Function

PHP mysqli_stat() Function

PHP mysqli_stmt_init() Function

PHP MySQL mysqli_thread_id() Function

PHP mysqli_thread_safe() Function