+ 3
Is mysqli_autocommit, mysqli_commit and mysqli_rollback are synchronous?
I mean if I create a dynamic webpage using php. In that page if user enter "1", multiple queries will run if user enter "0", only single query will run. For multiple queries I need to use autocommit, rollback and commit so that if one query fails all queries will rollback. And for single query I don't need those functions. My question is that if user1 from a pc entered "1" and user2 from other pc entered "0". Since user1 entered "1", autocommit is going to be false. Does that effect user2? Same for rollback and commit. If user1 queries failed it calls for rollback does it effect user2 query? Please help me I'm new to this concept.
2 Answers
+ 1
sai vamsi
Pls try visiting
"PHP: MySQL Database"
https://www.w3schools.com/php/php_mysql_intro.asp
+ 1
And pls you can also visit w3schools foot more