+ 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.

20th Jul 2020, 5:41 PM
Padala Vamsi
Padala Vamsi - avatar
2 Answers
+ 1
sai vamsi Pls try visiting "PHP: MySQL Database" https://www.w3schools.com/php/php_mysql_intro.asp
3rd Aug 2020, 12:51 AM
Princess Jessica
Princess Jessica - avatar
+ 1
And pls you can also visit w3schools foot more
3rd Aug 2020, 12:52 AM
Princess Jessica
Princess Jessica - avatar