{"id":3783,"date":"2025-06-28T12:56:13","date_gmt":"2025-06-28T04:56:13","guid":{"rendered":"https:\/\/www.laixuexila.com\/?p=3783"},"modified":"2025-06-28T12:56:13","modified_gmt":"2025-06-28T04:56:13","slug":"%e5%a6%82%e4%bd%95%e4%bd%bf%e7%94%a8%e4%ba%a4%e6%98%93%e6%9d%a5%e7%a1%ae%e4%bf%9dphp%e4%b8%ad%e7%9a%84%e6%95%b0%e6%8d%ae%e4%b8%80%e8%87%b4%e6%80%a7%ef%bc%9f","status":"publish","type":"post","link":"https:\/\/www.laixuexila.com\/index.php\/2025\/06\/28\/%e5%a6%82%e4%bd%95%e4%bd%bf%e7%94%a8%e4%ba%a4%e6%98%93%e6%9d%a5%e7%a1%ae%e4%bf%9dphp%e4%b8%ad%e7%9a%84%e6%95%b0%e6%8d%ae%e4%b8%80%e8%87%b4%e6%80%a7%ef%bc%9f\/","title":{"rendered":"\u5982\u4f55\u4f7f\u7528\u4ea4\u6613\u6765\u786e\u4fddPHP\u4e2d\u7684\u6570\u636e\u4e00\u81f4\u6027\uff1f"},"content":{"rendered":"\n

\u5728 PHP \u4e2d\uff0c\u4e3a\u4e86\u786e\u4fdd\u6570\u636e\u4e00\u81f4\u6027<\/strong>\uff08\u5c24\u5176\u5728\u591a\u6b65\u5199\u5165\u6570\u636e\u5e93\u7684\u64cd\u4f5c\u4e2d\uff09\uff0c\u6211\u4eec\u4f7f\u7528 \u6570\u636e\u5e93\u4e8b\u52a1\uff08transaction\uff09<\/strong>\u3002\u4e8b\u52a1\u53ef\u4ee5\u4fdd\u8bc1\u8981\u4e48\u5168\u90e8\u6210\u529f\uff0c\u8981\u4e48\u5168\u90e8\u5931\u8d25<\/strong>\uff0c\u9632\u6b62\u56e0\u90e8\u5206\u6267\u884c\u6210\u529f\u800c\u5bfc\u81f4\u6570\u636e\u5f02\u5e38\u3002<\/p>\n\n\n\n

\n\n\n\n

\u4e00\u3001\u4ec0\u4e48\u662f\u4e8b\u52a1\uff08Transaction\uff09<\/h2>\n\n\n\n

\u4e8b\u52a1\u662f\u4e00\u7ec4 SQL \u64cd\u4f5c\u7684\u96c6\u5408\uff0c\u8fd9\u4e9b\u64cd\u4f5c\u8981\u4e48\u5168\u90e8\u6267\u884c\uff0c\u8981\u4e48\u4e00\u4e2a\u4e5f\u4e0d\u6267\u884c\u3002\u4e8b\u52a1\u5177\u6709\u56db\u5927\u7279\u6027\uff0c\u7b80\u79f0 ACID<\/strong>\uff1a<\/p>\n\n\n\n

\u7279\u6027<\/th>\u542b\u4e49<\/th><\/tr><\/thead>
\u539f\u5b50\u6027\uff08Atomicity\uff09<\/td>\u64cd\u4f5c\u4e0d\u53ef\u5206\u5272\uff0c\u5168\u90e8\u6210\u529f\u6216\u5168\u90e8\u5931\u8d25<\/td><\/tr>
\u4e00\u81f4\u6027\uff08Consistency\uff09<\/td>\u6267\u884c\u524d\u540e\u6570\u636e\u6ee1\u8db3\u4e00\u81f4\u6027\u89c4\u5219<\/td><\/tr>
\u9694\u79bb\u6027\uff08Isolation\uff09<\/td>\u591a\u4e2a\u4e8b\u52a1\u4e4b\u95f4\u4e92\u4e0d\u5e72\u6270<\/td><\/tr>
\u6301\u4e45\u6027\uff08Durability\uff09<\/td>\u63d0\u4ea4\u540e\u7ed3\u679c\u6c38\u4e45\u4fdd\u5b58<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\n

\u4e8c\u3001\u5728 PHP \u4e2d\u4f7f\u7528\u4e8b\u52a1\u7684\u524d\u63d0\u6761\u4ef6<\/h2>\n\n\n\n
\n

\u5fc5\u987b\u4f7f\u7528\u652f\u6301\u4e8b\u52a1\u7684\u6570\u636e\u5e93\u5f15\u64ce<\/strong>\uff0c\u5982 MySQL \u7684 InnoDB\uff08\u274c MyISAM \u4e0d\u652f\u6301\u4e8b\u52a1\uff09\u3002<\/p>\n<\/blockquote>\n\n\n\n

\n\n\n\n

\u4e09\u3001\u4f7f\u7528 PDO \u6267\u884c\u4e8b\u52a1\uff08\u63a8\u8350\uff09<\/h2>\n\n\n\n

\u793a\u4f8b\uff1a\u8f6c\u8d26\u64cd\u4f5c\uff08A \u2192 B\uff09<\/h3>\n\n\n\n
<?php\n$pdo = new PDO(\"mysql:host=localhost;dbname=test\", \"root\", \"\");\n\n\/\/ \u8bbe\u7f6e\u4e3a\u629b\u51fa\u5f02\u5e38\n$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);\n\ntry {\n    \/\/ \u5f00\u542f\u4e8b\u52a1\n    $pdo->beginTransaction();\n\n    \/\/ \u7528\u6237 A \u6263\u6b3e\n    $stmt1 = $pdo->prepare(\"UPDATE users SET balance = balance - :amount WHERE id = :from\");\n    $stmt1->execute([':amount' => 100, ':from' => 1]);\n\n    \/\/ \u7528\u6237 B \u52a0\u6b3e\n    $stmt2 = $pdo->prepare(\"UPDATE users SET balance = balance + :amount WHERE id = :to\");\n    $stmt2->execute([':amount' => 100, ':to' => 2]);\n\n    \/\/ \u63d0\u4ea4\u4e8b\u52a1\n    $pdo->commit();\n    echo \"\u8f6c\u8d26\u6210\u529f\uff01\";\n\n} catch (Exception $e) {\n    \/\/ \u56de\u6eda\u4e8b\u52a1\n    $pdo->rollBack();\n    echo \"\u8f6c\u8d26\u5931\u8d25\uff1a\" . $e->getMessage();\n}<\/code><\/pre>\n\n\n\n
\n
\u4e00\u65e6\u4efb\u610f SQL \u62a5\u9519\uff08\u6bd4\u5982\u4f59\u989d\u4e0d\u8db3\u6216\u8bed\u6cd5\u9519\u8bef\uff09\uff0c\u4e8b\u52a1\u4f1a\u56de\u6eda\uff0c\u4fdd\u8bc1\u4e0d\u4f1a\u53d1\u751f\u201c\u6263\u4e86 A \u6ca1\u52a0\u5230 B\u201d\u7684\u6570\u636e\u9519\u4e71\u3002<\/p>\n<\/blockquote>\n\n\n\n
\n\n\n\n
\u56db\u3001\u4e8b\u52a1\u5931\u6548\u7684\u5e38\u89c1\u539f\u56e0<\/h2>\n\n\n\n
\u539f\u56e0<\/th>\u63cf\u8ff0<\/th><\/tr><\/thead>
\u4f7f\u7528\u4e86 MyISAM \u8868<\/td>\u4e0d\u652f\u6301\u4e8b\u52a1\uff0c\u9700\u6539\u4e3a InnoDB<\/td><\/tr>
\u6ca1\u542f\u7528\u5f02\u5e38\u5904\u7406<\/td>PDO \u9ed8\u8ba4\u4e0d\u629b\u5f02\u5e38\uff0c\u9700\u624b\u52a8\u8bbe\u7f6e ERRMODE_EXCEPTION<\/code><\/td><\/tr>
\u90e8\u5206\u8bed\u53e5\u4e0d\u5728\u4e8b\u52a1\u4e2d<\/td>\u6bd4\u5982\u67d0\u4e9b\u5199\u64cd\u4f5c\u5728\u4e8b\u52a1\u5f00\u59cb\u4e4b\u5916<\/td><\/tr>
\u5199\u64cd\u4f5c\u81ea\u52a8\u63d0\u4ea4<\/td>\u5982 autocommit \u6ca1\u5173\u95ed\u6216\u5199\u5728\u975e\u4e8b\u52a1\u5185<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\n
\u4e94\u3001\u4f7f\u7528 mysqli \u4e8b\u52a1\uff08\u8f83\u4f4e\u7ea7\uff09<\/h2>\n\n\n\n
$conn = new mysqli(\"localhost\", \"root\", \"\", \"test\");\n$conn->autocommit(false); \/\/ \u5173\u95ed\u81ea\u52a8\u63d0\u4ea4\n\ntry {\n    $conn->query(\"UPDATE users SET balance = balance - 100 WHERE id = 1\");\n    $conn->query(\"UPDATE users SET balance = balance + 100 WHERE id = 2\");\n\n    $conn->commit();\n    echo \"\u8f6c\u8d26\u6210\u529f\";\n} catch (Exception $e) {\n    $conn->rollback();\n    echo \"\u8f6c\u8d26\u5931\u8d25\uff1a\" . $e->getMessage();\n}<\/code><\/pre>\n\n\n\n
\n\n\n\n
\u516d\u3001\u5b9e\u6218\u5efa\u8bae<\/h2>\n\n\n\n
\u573a\u666f<\/th>\u662f\u5426\u5efa\u8bae\u7528\u4e8b\u52a1<\/th><\/tr><\/thead>
\u7528\u6237\u6ce8\u518c\uff08\u591a\u8868\uff09<\/td>\u2705 \u662f<\/td><\/tr>
\u7528\u6237\u53d1\u5e16\uff08\u5e16\u5b50 + \u9644\u4ef6\uff09<\/td>\u2705 \u662f<\/td><\/tr>
\u7535\u5546\u4e0b\u5355\uff08\u8ba2\u5355\u3001\u5e93\u5b58\u3001\u652f\u4ed8\uff09<\/td>\u2705 \u5fc5\u987b<\/td><\/tr>
\u4ec5\u67e5\u8be2\u64cd\u4f5c<\/td>\u274c \u4e0d\u5efa\u8bae\uff08\u65e0\u610f\u4e49\uff09<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\n
\u4e03\u3001\u5b89\u5168\u4e0e\u6027\u80fd\u63d0\u793a<\/h2>\n\n\n\n