普通网友 2016-10-12 06:02
浏览 64
已采纳

PHP / MySQL - 如何在PDO中使用MySQL BEGIN / COMMIT

I was wondering how to use a MySQL BEGIN/COMMIT with a PDO. I've read that it's best to create a query that either inserts all data or none at all to provide 'consistency' in the database Here's my code

$query = $db -> prepare 
                        ("
                        BEGIN;
                        INSERT INTO chat (chat_id,msg,datetime) 
                        VALUES (:cid,:msg,:datetime)
                        INSERT INTO chat_connect (chat_id,sender_id,receiver_id)
                        VALUES (:cid2,:sender_id,:receiver_id);
                        COMMIT;
                        ");
$query -> execute(array(
            "cid" => $cid,
            "msg" => $msg,
            "datetime" => $datetime,
            "sender_id" => $getid,
            "receiver_id" => $frid,
            "cid2" => $cid
            ));
  • 写回答

2条回答 默认 最新

  • dongque20030402 2016-10-12 06:20
    关注

    Transaction syntax:

    START TRANSACTION [transaction_characteristic [, transaction_characteristic] ...]

    transaction_characteristic: WITH CONSISTENT SNAPSHOT | READ WRITE | READ ONLY

    BEGIN [WORK] COMMIT [WORK] [AND [NO] CHAIN] [[NO] RELEASE] ROLLBACK [WORK] [AND [NO] CHAIN] [[NO] RELEASE] SET autocommit = {0 | 1}

    Transaction example:

    START TRANSACTION;
    SELECT @A:=SUM(salary) FROM table1 WHERE type=1;
    UPDATE table2 SET summary=@A WHERE type=1;
    COMMIT;
    

    Taken from here.

    You intend to create a transaction via PDO. That is not really a problem. You can do it by generating the query text accordingly:

    $query = $db -> prepare 
                            ("
                            START TRANSACTION;
                            INSERT INTO chat (chat_id,msg,datetime) 
                            VALUES (:cid,:msg,:datetime)
                            INSERT INTO chat_connect (chat_id,sender_id,receiver_id)
                            VALUES (:cid2,:sender_id,:receiver_id);
                            COMMIT;
                            ");
    $query -> execute(array(
                "cid" => $cid,
                "msg" => $msg,
                "datetime" => $datetime,
                "sender_id" => $getid,
                "receiver_id" => $frid,
                "cid2" => $cid
                ));
    

    Here you can see how you can write a bullet-proof transaction.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥50 MATLAB APP 制作出现问题
  • ¥15 wannier复现图像时berry曲率极值点与高对称点严重偏移
  • ¥15 利用决策森林为什么会出现这样·的问题(关键词-情感分析)
  • ¥15 DispatcherServlet.noHandlerFound No mapping found for HTTP request with URI[/untitled30_war_e
  • ¥15 使用deepspeed训练,发现想要训练的参数没有梯度
  • ¥15 寻找一块做为智能割草机的驱动板(标签-stm32|关键词-m3)
  • ¥15 信息管理系统的查找和排序
  • ¥15 基于STM32,电机驱动模块为L298N,四路运放电磁传感器,三轮智能小车电磁组电磁循迹(两个电机,一个万向轮),怎么用读取的电磁传感器信号表示小车所在的位置
  • ¥15 如何解决y_true和y_predict数据类型不匹配的问题(相关搜索:机器学习)
  • ¥15 PB中矩阵文本型数据的总计问题。