When you have alot of transactions to make, say you are applying inserting items to the database from a loop, it will be better to use the mysqli_commit for this kind of process as it will only hit the database once. //Wrong way Example 1: $con = mysqli_connect(“host”, “username”, “password”, “database”) or die(“Could not establish connection to database”); $users = [“chris”, “james”, “peter”, “mark”, “joe”, “alice”, “bob”] for($i=0; $i
