what is mysqli_autocommit?

[deathisonitsway]

hi,Im from join from turkey...I have question...what is mysqli_autocommit? I did not find its response.

please, can you explain what is mysqli_autocommit?

 

<?php

$mysqli = new mysqli("localhost", "my_user", "my_password", "world");

 

if (mysqli_connect_errno()) {

    printf("Connect failed: %s\n", mysqli_connect_error());

    exit();

}

 

/* turn autocommit on */

$mysqli->autocommit(TRUE);

 

if ($result = $mysqli->query("SELECT @@autocommit")) {

    $row = $result->fetch_row();

    printf("Autocommit is %s\n", $row[0]);

    $result->free();

}

 

/* close connection */

$mysqli->close();

?>

 

 

why  this command autocommit 1 returned ?

 

regards

[deathisonitsway]

help me? ???

[rajivgonsalves]

it say it turns on autocommit that means you do not have to commit explicitly

[deathisonitsway]

thanks,my friend

but I did not still understand it. please, can you tell me explicitly it

may be for example.

[rajivgonsalves]

If you have read on a transaction database it is nothing get affected unless you commit. so if you insert a row, delete a row, or update it, it does not actually take place until you commit with autocommit it make the transaction complete meaning that immediately after running the statement the database is affected