<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>测试事务处理</title>
</head>
<body>
<?php
$link = mysqli_connect("localhost", "root", "", "my_db");
/* check connection */
if (mysqli_connect_errno()) {
printf("Connect failed: %s\n", mysqli_connect_error());
exit();
}
/* disable autocommit */
mysqli_autocommit($link, FALSE);
mysqli_query($link, "update T_test set Ttype='9' where Id='2'");
/* commit insert */
mysqli_commit($link);
/* delete all rows */
//mysqli_query($link, "DELETE FROM myCity");
if ($result = mysqli_query($link, "SELECT COUNT(*) FROM T_test where Ttype='111'")) {
$row = mysqli_fetch_row($result);
printf("%d rows in table test.\n", $row[0]);
/* Free result */
mysqli_free_result($result);
}
/* Rollback */
mysqli_rollback($link);
if ($result = mysqli_query($link, "SELECT COUNT(*) FROM T_test where Ttype='111'")) {
$row = mysqli_fetch_row($result);
printf("%d rows in table test (after rollback).\n", $row[0]);
/* Free result */
mysqli_free_result($result);
}
/* Drop table myCity */
//mysqli_query($link, "DROP TABLE myCity");
mysqli_close($link);
?>
</body>
</html>
php连接数据库几个学习例子
3星 · 超过75%的资源 需积分: 9 112 浏览量
2010-10-11
15:29:19
上传
评论
收藏 5KB RAR 举报 
PHPMysql.rar （8个子文件） 
PHPMysql 
connect.php 728B UpdateAndDelete.php 989B
insert.html 514B ODBC.php 907B TestRock.php 1KB createDB.php 854B select.php 1KB insert.php 1KB资源评论
乡村阿土哥2013-08-24例子虽然简单，但是挺不错的
石头98702014-06-09这个例子很好，但是没有给.sql文件上来
大星喵喵2012-08-16是链接mysql的，只有一个吧？
