<?php
header(
"Content-type:text/html; charset=utf-8"
);
$mysqli
=
new
mysqli(
"localhost"
,
"root"
,
"064319"
,
"php"
);
$mysqli
->set_charset(
"utf8"
);
if
(
$mysqli
->connect_errno) {
die
(
'数据库连接失败'
.
$mysqli
->connect_error);
}
$mysqli
->autocommit(false);
$flag
= true;
$query
=
"update account set balance=balance-1000 where id=3"
;
$result
=
$mysqli
->query(
$query
);
$affected_count
=
$mysqli
->affected_rows;
if
(!result ||
$affected_count
== 0) {
$flag
= false;
}
$query
=
"update account set balance=balance+1000 where id=2"
;
$result
=
$mysqli
->query(
$query
);
$affected_count
=
$mysqli
->affected_rows;
if
(!
$result
||
$affected_count
== 0) {
$flag
= false;
}
if
(
$flag
) {
$mysqli
->commit();
echo
'转账成功'
;
}
else
{
$mysqli
->rollback();
echo
'转账失败'
;
}
$mysqli
->autocommit(true);
$mysqli
->close();
?>