title: PHP/MySQL - How to use MySQL BEGIN/COMMIT with PDO
body: <p>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</p>
  
  <pre><code>$query = $db -&gt; 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 -&gt; execute(array(
              "cid" =&gt; $cid,
              "msg" =&gt; $msg,
              "datetime" =&gt; $datetime,
              "sender_id" =&gt; $getid,
              "receiver_id" =&gt; $frid,
              "cid2" =&gt; $cid
              ));
  </code></pre>