PageRenderTime 47ms CodeModel.GetById 17ms RepoModel.GetById 0ms app.codeStats 0ms

/php/function.sqlsrv-begin-transaction.html

https://bitbucket.org/thncr/manuals
HTML | 108 lines | 90 code | 18 blank | 0 comment | 0 complexity | 441e39f9590dc52ed1d9284175dca166 MD5 | raw file
    

  1. <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    2. 

  2. <html>
    3. 

  3.  <head>
    4. 

  4.   <meta http-equiv="content-type" content="text/html; charset=UTF-8">
    5. 

  5.   <title>Begins a database transaction</title>
    6. 

  6. 

  7.  </head>
    8. 

  8.  <body><div class="manualnavbar" style="text-align: center;">
    9. 

  9.  <div class="prev" style="text-align: left; float: left;"><a href="ref.sqlsrv.html">SQLSRV 函数</a></div>
    10. 

  10.  <div class="next" style="text-align: right; float: right;"><a href="function.sqlsrv-cancel.html">sqlsrv_cancel</a></div>
    11. 

  11.  <div class="up"><a href="ref.sqlsrv.html">SQLSRV 函数</a></div>
    12. 

  12.  <div class="home"><a href="index.html">PHP Manual</a></div>
    13. 

  13. </div><hr /><div id="function.sqlsrv-begin-transaction" class="refentry">
    14. 

  14.  <div class="refnamediv">
    15. 

  15.   <h1 class="refname">sqlsrv_begin_transaction</h1>
    16. 

  16.   <p class="verinfo">(No version information available, might only be in SVN)</p><p class="refpurpose"><span class="refname">sqlsrv_begin_transaction</span> &mdash; <span class="dc-title">Begins a database transaction</span></p>
    17. 

  17. 

  18.  </div>
    19. 

  19.  <div class="refsect1 description" id="refsect1-function.sqlsrv-begin-transaction-description">
    20. 

  20.   <h3 class="title">说明</h3>
    21. 

  21.   <div class="methodsynopsis dc-description">
    22. 

  22.    <span class="type">bool</span> <span class="methodname"><strong>sqlsrv_begin_transaction</strong></span>
    23. 

  23.     ( <span class="methodparam"><span class="type">resource</span> <code class="parameter">$conn</code></span>
    24. 

  24.    )</div>
    25. 

  25. 

  26.   <p class="para rdfs-comment">
    27. 

  27.    The transaction begun by  <span class="function"><strong>sqlsrv_begin_transaction()</strong></span> includes 
    28. 

  28.    all statements that were executed after the call to 
    29. 

  29.     <span class="function"><strong>sqlsrv_begin_transaction()</strong></span> and before calls to 
    30. 

  30.     <span class="function"><a href="function.sqlsrv-rollback.html" class="function">sqlsrv_rollback()</a></span> or  <span class="function"><a href="function.sqlsrv-commit.html" class="function">sqlsrv_commit()</a></span>. 
    31. 

  31.    Explicit transactions should be started and committed or rolled back using 
    32. 

  32.    these functions instead of executing SQL statements that begin and committ/roll 
    33. 

  33.    back transactions. For more information, see 
    34. 

  34.    <a href="http://msdn.microsoft.com/en-us/library/cc296206.aspx" class="link external">&raquo;&nbsp;SQLSRV Transactions</a>.
    35. 

  35.   </p>
    36. 

  36.  </div>
    37. 

  37. 

  38.  <div class="refsect1 parameters" id="refsect1-function.sqlsrv-begin-transaction-parameters">
    39. 

  39.   <h3 class="title">参数</h3>
    40. 

  40.   <p class="para">
    41. 

  41.    <dl>
    42. 

  42. 

  43.     <dt>
    44. 

  44. 

  45.      <span class="term"><em><code class="parameter">conn</code></em></span>
    46. 

  46.      <dd>
    47. 

  47. 

  48.       <p class="para">
    49. 

  49.        The connection resource returned by a call to  <span class="function"><a href="function.sqlsrv-connect.html" class="function">sqlsrv_connect()</a></span>.
    50. 

  50.       </p>
    51. 

  51.      </dd>
    52. 

  52. 

  53.     </dt>
    54. 

  54. 

  55.    </dl>
    56. 

  56. 

  57.   </p>
    58. 

  58.  </div>
    59. 

  59. 

  60.  
    61. 

  61.  <div class="refsect1 returnvalues" id="refsect1-function.sqlsrv-begin-transaction-returnvalues">
    62. 

  62.   <h3 class="title">返回值</h3>
    63. 

  63.   <p class="para">
    64. 

  64.    成功时返回 <strong><code>TRUE</code></strong>， 或者在失败时返回 <strong><code>FALSE</code></strong>.
    65. 

  65.   </p>
    66. 

  66.  </div>
    67. 

  67. 

  68.  
    69. 

  69.  <div class="refsect1 examples" id="refsect1-function.sqlsrv-begin-transaction-examples">
    70. 

  70.   <h3 class="title">范例</h3>
    71. 

  71.   <p class="para">
    72. 

  72.    <div class="example" id="example-2135">
    73. 

  73.     <p><strong>Example #1  <span class="function"><strong>sqlsrv_begin_transaction()</strong></span> example</strong></p>
    74. 

  74.     <div class="example-contents"><p>
    75. 

  75.     The following example demonstrates how to use 
    76. 

  76.      <span class="function"><strong>sqlsrv_begin_transaction()</strong></span> together with 
    77. 

  77.      <span class="function"><a href="function.sqlsrv-commit.html" class="function">sqlsrv_commit()</a></span> and  <span class="function"><a href="function.sqlsrv-rollback.html" class="function">sqlsrv_rollback()</a></span>.
    78. 

  78.     </p></div>
    79. 

  79.     <div class="example-contents">
    80. 

  80. <div class="phpcode"><code><span style="color: #000000">
    81. 

  81. <span style="color: #0000BB">&lt;?php<br />$serverName&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">"serverName\sqlexpress"</span><span style="color: #007700">;<br /></span><span style="color: #0000BB">$connectionInfo&nbsp;</span><span style="color: #007700">=&nbsp;array(&nbsp;</span><span style="color: #DD0000">"Database"</span><span style="color: #007700">=&gt;</span><span style="color: #DD0000">"dbName"</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">"UID"</span><span style="color: #007700">=&gt;</span><span style="color: #DD0000">"userName"</span><span style="color: #007700">,&nbsp;</span><span style="color: #DD0000">"PWD"</span><span style="color: #007700">=&gt;</span><span style="color: #DD0000">"password"</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">$conn&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">sqlsrv_connect</span><span style="color: #007700">(&nbsp;</span><span style="color: #0000BB">$serverName</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">$connectionInfo</span><span style="color: #007700">);<br />if(&nbsp;</span><span style="color: #0000BB">$conn&nbsp;</span><span style="color: #007700">===&nbsp;</span><span style="color: #0000BB">false&nbsp;</span><span style="color: #007700">)&nbsp;{<br />&nbsp;&nbsp;&nbsp;&nbsp;die(&nbsp;</span><span style="color: #0000BB">print_r</span><span style="color: #007700">(&nbsp;</span><span style="color: #0000BB">sqlsrv_errors</span><span style="color: #007700">(),&nbsp;</span><span style="color: #0000BB">true&nbsp;</span><span style="color: #007700">));<br />}<br /><br /></span><span style="color: #FF8000">/*&nbsp;Begin&nbsp;the&nbsp;transaction.&nbsp;*/<br /></span><span style="color: #007700">if&nbsp;(&nbsp;</span><span style="color: #0000BB">sqlsrv_begin_transaction</span><span style="color: #007700">(&nbsp;</span><span style="color: #0000BB">$conn&nbsp;</span><span style="color: #007700">)&nbsp;===&nbsp;</span><span style="color: #0000BB">false&nbsp;</span><span style="color: #007700">)&nbsp;{<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;die(&nbsp;</span><span style="color: #0000BB">print_r</span><span style="color: #007700">(&nbsp;</span><span style="color: #0000BB">sqlsrv_errors</span><span style="color: #007700">(),&nbsp;</span><span style="color: #0000BB">true&nbsp;</span><span style="color: #007700">));<br />}<br /><br /></span><span style="color: #FF8000">/*&nbsp;Initialize&nbsp;parameter&nbsp;values.&nbsp;*/<br /></span><span style="color: #0000BB">$orderId&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">1</span><span style="color: #007700">;&nbsp;</span><span style="color: #0000BB">$qty&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">10</span><span style="color: #007700">;&nbsp;</span><span style="color: #0000BB">$productId&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">100</span><span style="color: #007700">;<br /><br /></span><span style="color: #FF8000">/*&nbsp;Set&nbsp;up&nbsp;and&nbsp;execute&nbsp;the&nbsp;first&nbsp;query.&nbsp;*/<br /></span><span style="color: #0000BB">$sql1&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">"INSERT&nbsp;INTO&nbsp;OrdersTable&nbsp;(ID,&nbsp;Quantity,&nbsp;ProductID)<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;VALUES&nbsp;(?,&nbsp;?,&nbsp;?)"</span><span style="color: #007700">;<br /></span><span style="color: #0000BB">$params1&nbsp;</span><span style="color: #007700">=&nbsp;array(&nbsp;</span><span style="color: #0000BB">$orderId</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">$qty</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">$productId&nbsp;</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">$stmt1&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">sqlsrv_query</span><span style="color: #007700">(&nbsp;</span><span style="color: #0000BB">$conn</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">$sql1</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">$params1&nbsp;</span><span style="color: #007700">);<br /><br /></span><span style="color: #FF8000">/*&nbsp;Set&nbsp;up&nbsp;and&nbsp;execute&nbsp;the&nbsp;second&nbsp;query.&nbsp;*/<br /></span><span style="color: #0000BB">$sql2&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #DD0000">"UPDATE&nbsp;InventoryTable&nbsp;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SET&nbsp;Quantity&nbsp;=&nbsp;(Quantity&nbsp;-&nbsp;?)&nbsp;<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WHERE&nbsp;ProductID&nbsp;=&nbsp;?"</span><span style="color: #007700">;<br /></span><span style="color: #0000BB">$params2&nbsp;</span><span style="color: #007700">=&nbsp;array(</span><span style="color: #0000BB">$qty</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">$productId</span><span style="color: #007700">);<br /></span><span style="color: #0000BB">$stmt2&nbsp;</span><span style="color: #007700">=&nbsp;</span><span style="color: #0000BB">sqlsrv_query</span><span style="color: #007700">(&nbsp;</span><span style="color: #0000BB">$conn</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">$sql2</span><span style="color: #007700">,&nbsp;</span><span style="color: #0000BB">$params2&nbsp;</span><span style="color: #007700">);<br /><br /></span><span style="color: #FF8000">/*&nbsp;If&nbsp;both&nbsp;queries&nbsp;were&nbsp;successful,&nbsp;commit&nbsp;the&nbsp;transaction.&nbsp;*/<br />/*&nbsp;Otherwise,&nbsp;rollback&nbsp;the&nbsp;transaction.&nbsp;*/<br /></span><span style="color: #007700">if(&nbsp;</span><span style="color: #0000BB">$stmt1&nbsp;</span><span style="color: #007700">&amp;&amp;&nbsp;</span><span style="color: #0000BB">$stmt2&nbsp;</span><span style="color: #007700">)&nbsp;{<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">sqlsrv_commit</span><span style="color: #007700">(&nbsp;</span><span style="color: #0000BB">$conn&nbsp;</span><span style="color: #007700">);<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;echo&nbsp;</span><span style="color: #DD0000">"Transaction&nbsp;committed.&lt;br&nbsp;/&gt;"</span><span style="color: #007700">;<br />}&nbsp;else&nbsp;{<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</span><span style="color: #0000BB">sqlsrv_rollback</span><span style="color: #007700">(&nbsp;</span><span style="color: #0000BB">$conn&nbsp;</span><span style="color: #007700">);<br />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;echo&nbsp;</span><span style="color: #DD0000">"Transaction&nbsp;rolled&nbsp;back.&lt;br&nbsp;/&gt;"</span><span style="color: #007700">;<br />}<br /></span><span style="color: #0000BB">?&gt;</span>
    82. 

  82. </span>
    83. 

  83. </code></div>
    84. 

  84.     </div>
    85. 

  85. 

  86.     <div class="example-contents"><p>以上例程的输出类似于：</p></div>
    87. 

  87.    </div>
    88. 

  88.   </p>
    89. 

  89.  </div>
    90. 

  90. 

  91.  
    92. 

  92.  <div class="refsect1 seealso" id="refsect1-function.sqlsrv-begin-transaction-seealso">
    93. 

  93.   <h3 class="title">参见</h3>
    94. 

  94.   <p class="para">
    95. 

  95.    <ul class="simplelist">
    96. 

  96.     <li class="member"> <span class="function"><a href="function.sqlsrv-commit.html" class="function" rel="rdfs-seeAlso">sqlsrv_commit()</a> - Commits a transaction that was begun with sqlsrv_begin_transaction</span></li>
    97. 

  97.     <li class="member"> <span class="function"><a href="function.sqlsrv-rollback.html" class="function" rel="rdfs-seeAlso">sqlsrv_rollback()</a> - Rolls back a transaction that was begun with 
    98. 

  98.   sqlsrv_begin_transaction</span></li>
    99. 

  99.    </ul>
    100. 

  100.   </p>
    101. 

  101.  </div>
    102. 

  102. 

  103. </div><hr /><div class="manualnavbar" style="text-align: center;">
    104. 

  104.  <div class="prev" style="text-align: left; float: left;"><a href="ref.sqlsrv.html">SQLSRV 函数</a></div>
    105. 

  105.  <div class="next" style="text-align: right; float: right;"><a href="function.sqlsrv-cancel.html">sqlsrv_cancel</a></div>
    106. 

  106.  <div class="up"><a href="ref.sqlsrv.html">SQLSRV 函数</a></div>
    107. 

  107.  <div class="home"><a href="index.html">PHP Manual</a></div>
    108. 

  108. </div></body></html>
    109. 

  109.