autocommit, commit and rollback

[thisishard]

I have been browsing over at the php manual site on the documentation of the mysqli class and have found something that i might possible find useful but can’t understand exactly what it does. Perhaps someone could enlighten me.

It seems to start of with setting autocommit to false bu doing this,
$mysqli->autocommit(FALSE);
But why are they doing this?

They then go and either use, $mysqli->commit() or $mysqli->rollback()

So what is the purpose of these functions?

Many Thanks
Chris

[Rob MacKay]

Some stuff about it in the comments here that might help :)

http://php.net/manual/en/mysqli.autocommit.php

http://php.net/manual/en/mysqli.rollback.php

[Author]

Posts