简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > 类库下载 > PHP类库 > body text

PHP mysqli_autocommit() function

高洛峰
Release： 2016-10-09 12:52:36
Original
1522 people have browsed it

Definition and usage

mysqli_autocommit() function turns on or off automatic submission of database modifications.

Tip: Please take a look at the mysqli_commit() function, which is used to commit the current transaction for the specified database connection. Please see the mysqli_rollback() function for rolling back the current transaction.

Syntax

mysqli_autocommit(connection,mode);

PHP mysqli_autocommit() function

Technical details

PHP mysqli_autocommit() function

Example

Turn off autocommit, do some queries, and then submit the query: 

<?php 
// 假定数据库用户名：root，密码：123456，数据库：RUNOOB 
$con=mysqli_connect("localhost","root","123456","RUNOOB"); 
if (mysqli_connect_errno($con)) 
{ 
    echo "连接 MySQL 失败: " . mysqli_connect_error(); 
} 
// 关闭自动提交
mysqli_autocommit($con,FALSE);
// 插入一些值
mysqli_query($con,"INSERT INTO websites (name, url, alexa, country)
VALUES (&#39;百度&#39;,&#39;https://www.baidu.com/&#39;,&#39;4&#39;,&#39;CN&#39;)");
// 提交事务
mysqli_commit($con);
// 关闭连接
mysqli_close($con);
?>
Copy after login


Related labels：
PHP mysqli_autocommit() 函数
source：php.cn
Previous article：[Strengthening the PHP series] Shopping cart code explains PHP’s anonymous functions Next article：PHP source code learning thread safety
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
function_exists() cannot determine the custom function Function test () {return true;} if (function_exists ('test')) {echo "test is function...
From 2024-04-29 11:01:01
0
2
1429
PHP arrays obtained from URL parameters do not behave as expected I have a URL parameter that contains the category ID and I want to treat it as an array li...
From 2024-04-06 22:09:02
0
1
1428
What is the format of the variables in the return value? I am a new learner of php. I found a piece of code: if($x<time()){return[false,'error']...
From 2024-04-06 21:55:20
0
1
778
Set a private member of a class as a constructor parameter classFoo{#one#two#three#four#five#six#seven#eight#nine#ten#eleven#twelve#thirteen#fourteen...
From 2024-04-06 21:48:47
0
1
637
Scatterplot points do not maintain values ​​when zooming in d3.js This is my first time using d3.js, so please bear with me. I implemented it as pure JavaSc...
From 2024-04-06 18:16:26
0
1
403
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！