Просмотр файла news/libraries/api/classDB_1_1SQL.html

Конкурс дизайнеров на 15000 рублей
Милый пушистый сайт !!!!
Размер файла: 24.69Kb 
  1. <!-- HTML header for doxygen 1.8.5-->
  2. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  3. <html xmlns="http://www.w3.org/1999/xhtml">
  4. <head>
  5. <meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
  6. <meta http-equiv="X-UA-Compatible" content="IE=9"/>
  7. <meta name="generator" content="Doxygen 1.8.6"/>
  8. <title>Fat-Free Framework: DB\SQL Class Reference</title>
  9. <link href="tabs.css" rel="stylesheet" type="text/css"/>
  10. <script type="text/javascript" src="jquery.js"></script>
  11. <script type="text/javascript" src="dynsections.js"></script>
  12. <link href="doxygen.css" rel="stylesheet" type="text/css" />
  13. </head>
  14. <body>
  15. <div id="top"><!-- do not remove this div, it is closed by doxygen! -->
  16. <div id="titlearea">
  17. <table cellspacing="0" cellpadding="0">
  18.  <tbody>
  19.  <tr style="height: 56px;">
  20.   <td style="padding-left: 0.5em;">
  21.    <div id="projectname">Fat-Free Framework
  22.    &#160;<span id="projectnumber">3.2.2</span>
  23.    &#160;<span class="menu"><a href="index.html">Overview</a> <a href="annotated.html">Class List</a> <a href="hierarchy.html">Hierarchy</a></span>
  24.    </div>
  25.   </td>
  26.  </tr>
  27.  </tbody>
  28. </table>
  29. </div>
  30. <!-- end header part -->
  31. <!-- Generated by Doxygen 1.8.6 -->
  32. <div id="nav-path" class="navpath">
  33.   <ul>
  34. <li class="navelem"><b>DB</b></li><li class="navelem"><a class="el" href="classDB_1_1SQL.html">SQL</a></li>  </ul>
  35. </div>
  36. </div><!-- top -->
  37. <div class="header">
  38.   <div class="summary">
  39. <a href="#pub-methods">Public Member Functions</a> &#124;
  40. <a href="#pub-attribs">Public Attributes</a> &#124;
  41. <a href="#pro-attribs">Protected Attributes</a> &#124;
  42. <a href="classDB_1_1SQL-members.html">List of all members</a>  </div>
  43.   <div class="headertitle">
  44. <div class="title">DB\SQL Class Reference</div>  </div>
  45. </div><!--header-->
  46. <div class="contents">
  47.  
  48. <p>PDO wrapper.  
  49.  <a href="classDB_1_1SQL.html#details">More...</a></p>
  50. <div id="dynsection-0" onclick="return toggleVisibility(this)" class="dynheader closed" style="cursor:pointer;">
  51.   <img id="dynsection-0-trigger" src="closed.png" alt="+"/> Inheritance diagram for DB\SQL:</div>
  52. <div id="dynsection-0-summary" class="dynsummary" style="display:block;">
  53. </div>
  54. <div id="dynsection-0-content" class="dyncontent" style="display:none;">
  55.  <div class="center">
  56.   <img src="classDB_1_1SQL.png" usemap="#DB\SQL_map" alt=""/>
  57.   <map id="DB\SQL_map" name="DB\SQL_map">
  58. </map>
  59.  </div></div>
  60. <table class="memberdecls">
  61. <tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="pub-methods"></a>
  62. Public Member Functions</h2></td></tr>
  63. <tr class="memitem:a5f5ced00dfa005770876582222b4008b"><td class="memItemLeft" align="right" valign="top">&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#a5f5ced00dfa005770876582222b4008b">begin</a> ()</td></tr>
  64. <tr class="separator:a5f5ced00dfa005770876582222b4008b"><td class="memSeparator" colspan="2">&#160;</td></tr>
  65. <tr class="memitem:a44c5c212a997fa1c51cd10bdf0981bfe"><td class="memItemLeft" align="right" valign="top">&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#a44c5c212a997fa1c51cd10bdf0981bfe">rollback</a> ()</td></tr>
  66. <tr class="separator:a44c5c212a997fa1c51cd10bdf0981bfe"><td class="memSeparator" colspan="2">&#160;</td></tr>
  67. <tr class="memitem:a1c741bcdd850522bebe83ae9f3a89f8c"><td class="memItemLeft" align="right" valign="top">&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#a1c741bcdd850522bebe83ae9f3a89f8c">commit</a> ()</td></tr>
  68. <tr class="separator:a1c741bcdd850522bebe83ae9f3a89f8c"><td class="memSeparator" colspan="2">&#160;</td></tr>
  69. <tr class="memitem:a1cdbdcd5996d5b34e83ec1554ac2ded2"><td class="memItemLeft" align="right" valign="top">&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#a1cdbdcd5996d5b34e83ec1554ac2ded2">type</a> ($val)</td></tr>
  70. <tr class="separator:a1cdbdcd5996d5b34e83ec1554ac2ded2"><td class="memSeparator" colspan="2">&#160;</td></tr>
  71. <tr class="memitem:ac7f7ef1e3c360dee9d17dd3dea1eb127"><td class="memItemLeft" align="right" valign="top">&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#ac7f7ef1e3c360dee9d17dd3dea1eb127">value</a> ($<a class="el" href="classDB_1_1SQL.html#a1cdbdcd5996d5b34e83ec1554ac2ded2">type</a>, $val)</td></tr>
  72. <tr class="separator:ac7f7ef1e3c360dee9d17dd3dea1eb127"><td class="memSeparator" colspan="2">&#160;</td></tr>
  73. <tr class="memitem:aae9de7373718da0c28c9c70de287bbd5"><td class="memItemLeft" align="right" valign="top">&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#aae9de7373718da0c28c9c70de287bbd5">exec</a> ($cmds, $args=NULL, $ttl=0, $<a class="el" href="classDB_1_1SQL.html#a5bdb97cf5d6ac52c99d9ffe8a6f9e190">log</a>=TRUE)</td></tr>
  74. <tr class="separator:aae9de7373718da0c28c9c70de287bbd5"><td class="memSeparator" colspan="2">&#160;</td></tr>
  75. <tr class="memitem:a2da7fa08b61795e9dfad255b6204c7f8"><td class="memItemLeft" align="right" valign="top">&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#a2da7fa08b61795e9dfad255b6204c7f8">count</a> ()</td></tr>
  76. <tr class="separator:a2da7fa08b61795e9dfad255b6204c7f8"><td class="memSeparator" colspan="2">&#160;</td></tr>
  77. <tr class="memitem:a5bdb97cf5d6ac52c99d9ffe8a6f9e190"><td class="memItemLeft" align="right" valign="top">&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#a5bdb97cf5d6ac52c99d9ffe8a6f9e190">log</a> ()</td></tr>
  78. <tr class="separator:a5bdb97cf5d6ac52c99d9ffe8a6f9e190"><td class="memSeparator" colspan="2">&#160;</td></tr>
  79. <tr class="memitem:aceda87f3c9133d0ee03505f606422af4"><td class="memItemLeft" align="right" valign="top">&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#aceda87f3c9133d0ee03505f606422af4">schema</a> ($table, $fields=NULL, $ttl=0)</td></tr>
  80. <tr class="separator:aceda87f3c9133d0ee03505f606422af4"><td class="memSeparator" colspan="2">&#160;</td></tr>
  81. <tr class="memitem:aa4e387f439b8ce06a48ae57cdbb5af95"><td class="memItemLeft" align="right" valign="top">&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#aa4e387f439b8ce06a48ae57cdbb5af95">quote</a> ($val, $<a class="el" href="classDB_1_1SQL.html#a1cdbdcd5996d5b34e83ec1554ac2ded2">type</a>=\PDO::PARAM_STR)</td></tr>
  82. <tr class="separator:aa4e387f439b8ce06a48ae57cdbb5af95"><td class="memSeparator" colspan="2">&#160;</td></tr>
  83. <tr class="memitem:a3d41d6d72944573251f74b086b6173bc"><td class="memItemLeft" align="right" valign="top">&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#a3d41d6d72944573251f74b086b6173bc">uuid</a> ()</td></tr>
  84. <tr class="separator:a3d41d6d72944573251f74b086b6173bc"><td class="memSeparator" colspan="2">&#160;</td></tr>
  85. <tr class="memitem:a8a074032e56e1443e46b6f9470d58271"><td class="memItemLeft" align="right" valign="top">&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#a8a074032e56e1443e46b6f9470d58271">driver</a> ()</td></tr>
  86. <tr class="separator:a8a074032e56e1443e46b6f9470d58271"><td class="memSeparator" colspan="2">&#160;</td></tr>
  87. <tr class="memitem:a24b57a9967b47680e854dc2ea328ad1f"><td class="memItemLeft" align="right" valign="top">&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#a24b57a9967b47680e854dc2ea328ad1f">version</a> ()</td></tr>
  88. <tr class="separator:a24b57a9967b47680e854dc2ea328ad1f"><td class="memSeparator" colspan="2">&#160;</td></tr>
  89. <tr class="memitem:a98fea91c80657442689dd19dc8050dec"><td class="memItemLeft" align="right" valign="top">&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#a98fea91c80657442689dd19dc8050dec">name</a> ()</td></tr>
  90. <tr class="separator:a98fea91c80657442689dd19dc8050dec"><td class="memSeparator" colspan="2">&#160;</td></tr>
  91. <tr class="memitem:ab23e1524e183a0d21f5e9a4c02dde037"><td class="memItemLeft" align="right" valign="top">&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#ab23e1524e183a0d21f5e9a4c02dde037">quotekey</a> ($key)</td></tr>
  92. <tr class="separator:ab23e1524e183a0d21f5e9a4c02dde037"><td class="memSeparator" colspan="2">&#160;</td></tr>
  93. <tr class="memitem:a03e2d154e8308f8407f81ac04fa77261"><td class="memItemLeft" align="right" valign="top">&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#a03e2d154e8308f8407f81ac04fa77261">__construct</a> ($dsn, $user=NULL, $pw=NULL, array $options=NULL)</td></tr>
  94. <tr class="separator:a03e2d154e8308f8407f81ac04fa77261"><td class="memSeparator" colspan="2">&#160;</td></tr>
  95. </table><table class="memberdecls">
  96. <tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="pub-attribs"></a>
  97. Public Attributes</h2></td></tr>
  98. <tr class="memitem:a8a4a0eb6935bb0202f4acab135e214ed"><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a8a4a0eb6935bb0202f4acab135e214ed"></a>
  99. &#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#a8a4a0eb6935bb0202f4acab135e214ed">$dsn</a></td></tr>
  100. <tr class="memdesc:a8a4a0eb6935bb0202f4acab135e214ed"><td class="mdescLeft">&#160;</td><td class="mdescRight">Data source name. <br/></td></tr>
  101. <tr class="separator:a8a4a0eb6935bb0202f4acab135e214ed"><td class="memSeparator" colspan="2">&#160;</td></tr>
  102. <tr class="memitem:a19ed348edd0549a3f24bd462097f9e52"><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a19ed348edd0549a3f24bd462097f9e52"></a>
  103. &#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#a19ed348edd0549a3f24bd462097f9e52">$engine</a></td></tr>
  104. <tr class="memdesc:a19ed348edd0549a3f24bd462097f9e52"><td class="mdescLeft">&#160;</td><td class="mdescRight">Database engine. <br/></td></tr>
  105. <tr class="separator:a19ed348edd0549a3f24bd462097f9e52"><td class="memSeparator" colspan="2">&#160;</td></tr>
  106. <tr class="memitem:a9d54d723c3b9218b6068ef131b2def07"><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a9d54d723c3b9218b6068ef131b2def07"></a>
  107. &#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#a9d54d723c3b9218b6068ef131b2def07">$dbname</a></td></tr>
  108. <tr class="memdesc:a9d54d723c3b9218b6068ef131b2def07"><td class="mdescLeft">&#160;</td><td class="mdescRight">Database name. <br/></td></tr>
  109. <tr class="separator:a9d54d723c3b9218b6068ef131b2def07"><td class="memSeparator" colspan="2">&#160;</td></tr>
  110. <tr class="memitem:a9f1c991be6d0c09a2c58e6564cc657a2"><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a9f1c991be6d0c09a2c58e6564cc657a2"></a>
  111. &#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#a9f1c991be6d0c09a2c58e6564cc657a2">$trans</a> =FALSE</td></tr>
  112. <tr class="memdesc:a9f1c991be6d0c09a2c58e6564cc657a2"><td class="mdescLeft">&#160;</td><td class="mdescRight">Transaction flag. <br/></td></tr>
  113. <tr class="separator:a9f1c991be6d0c09a2c58e6564cc657a2"><td class="memSeparator" colspan="2">&#160;</td></tr>
  114. <tr class="memitem:a3deede01233c40789f837bca11dbd856"><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a3deede01233c40789f837bca11dbd856"></a>
  115. &#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#a3deede01233c40789f837bca11dbd856">$rows</a> =0</td></tr>
  116. <tr class="memdesc:a3deede01233c40789f837bca11dbd856"><td class="mdescLeft">&#160;</td><td class="mdescRight">Number of rows affected by query. <br/></td></tr>
  117. <tr class="separator:a3deede01233c40789f837bca11dbd856"><td class="memSeparator" colspan="2">&#160;</td></tr>
  118. <tr class="memitem:a95c93a06344cfdabd83824e38a527954"><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a95c93a06344cfdabd83824e38a527954"></a>
  119. &#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#a95c93a06344cfdabd83824e38a527954">$log</a></td></tr>
  120. <tr class="memdesc:a95c93a06344cfdabd83824e38a527954"><td class="mdescLeft">&#160;</td><td class="mdescRight">SQL log. <br/></td></tr>
  121. <tr class="separator:a95c93a06344cfdabd83824e38a527954"><td class="memSeparator" colspan="2">&#160;</td></tr>
  122. </table><table class="memberdecls">
  123. <tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="pro-attribs"></a>
  124. Protected Attributes</h2></td></tr>
  125. <tr class="memitem:a28eb5b9fdad772d69977b7251896fb9e"><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a28eb5b9fdad772d69977b7251896fb9e"></a>
  126. &#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#a28eb5b9fdad772d69977b7251896fb9e">$uuid</a></td></tr>
  127. <tr class="memdesc:a28eb5b9fdad772d69977b7251896fb9e"><td class="mdescLeft">&#160;</td><td class="mdescRight">UUID. <br/></td></tr>
  128. <tr class="separator:a28eb5b9fdad772d69977b7251896fb9e"><td class="memSeparator" colspan="2">&#160;</td></tr>
  129. </table>
  130. <a name="details" id="details"></a><h2 class="groupheader">Detailed Description</h2>
  131. <div class="textblock"><p>PDO wrapper. </p>
  132. </div><h2 class="groupheader">Constructor &amp; Destructor Documentation</h2>
  133. <a class="anchor" id="a03e2d154e8308f8407f81ac04fa77261"></a>
  134. <div class="memitem">
  135. <div class="memproto">
  136.       <table class="memname">
  137.         <tr>
  138.           <td class="memname">DB\SQL::__construct </td>
  139.           <td>(</td>
  140.           <td class="paramtype">&#160;</td>
  141.           <td class="paramname"><em>$dsn</em>, </td>
  142.         </tr>
  143.         <tr>
  144.           <td class="paramkey"></td>
  145.           <td></td>
  146.           <td class="paramtype">&#160;</td>
  147.           <td class="paramname"><em>$user</em> = <code>NULL</code>, </td>
  148.         </tr>
  149.         <tr>
  150.           <td class="paramkey"></td>
  151.           <td></td>
  152.           <td class="paramtype">&#160;</td>
  153.           <td class="paramname"><em>$pw</em> = <code>NULL</code>, </td>
  154.         </tr>
  155.         <tr>
  156.           <td class="paramkey"></td>
  157.           <td></td>
  158.           <td class="paramtype">array&#160;</td>
  159.           <td class="paramname"><em>$options</em> = <code>NULL</code>&#160;</td>
  160.         </tr>
  161.         <tr>
  162.           <td></td>
  163.           <td>)</td>
  164.           <td></td><td></td>
  165.         </tr>
  166.       </table>
  167. </div><div class="memdoc">
  168. <p>Instantiate class </p>
  169. <dl class="params"><dt>Parameters</dt><dd>
  170.   <table class="params">
  171.     <tr><td class="paramname">$dsn</td><td>string </td></tr>
  172.     <tr><td class="paramname">$user</td><td>string </td></tr>
  173.     <tr><td class="paramname">$pw</td><td>string </td></tr>
  174.     <tr><td class="paramname">$options</td><td>array </td></tr>
  175.   </table>
  176.   </dd>
  177. </dl>
  178.  
  179. </div>
  180. </div>
  181. <h2 class="groupheader">Member Function Documentation</h2>
  182. <a class="anchor" id="a5f5ced00dfa005770876582222b4008b"></a>
  183. <div class="memitem">
  184. <div class="memproto">
  185.       <table class="memname">
  186.         <tr>
  187.           <td class="memname">DB\SQL::begin </td>
  188.           <td>(</td>
  189.           <td class="paramname"></td><td>)</td>
  190.           <td></td>
  191.         </tr>
  192.       </table>
  193. </div><div class="memdoc">
  194. <p>Begin SQL transaction </p>
  195. <dl class="section return"><dt>Returns</dt><dd>bool </dd></dl>
  196.  
  197. </div>
  198. </div>
  199. <a class="anchor" id="a1c741bcdd850522bebe83ae9f3a89f8c"></a>
  200. <div class="memitem">
  201. <div class="memproto">
  202.       <table class="memname">
  203.         <tr>
  204.           <td class="memname">DB\SQL::commit </td>
  205.           <td>(</td>
  206.           <td class="paramname"></td><td>)</td>
  207.           <td></td>
  208.         </tr>
  209.       </table>
  210. </div><div class="memdoc">
  211. <p>Commit SQL transaction </p>
  212. <dl class="section return"><dt>Returns</dt><dd>bool </dd></dl>
  213.  
  214. </div>
  215. </div>
  216. <a class="anchor" id="a2da7fa08b61795e9dfad255b6204c7f8"></a>
  217. <div class="memitem">
  218. <div class="memproto">
  219.       <table class="memname">
  220.         <tr>
  221.           <td class="memname">DB\SQL::count </td>
  222.           <td>(</td>
  223.           <td class="paramname"></td><td>)</td>
  224.           <td></td>
  225.         </tr>
  226.       </table>
  227. </div><div class="memdoc">
  228. <p>Return number of rows affected by last query </p>
  229. <dl class="section return"><dt>Returns</dt><dd>int </dd></dl>
  230.  
  231. </div>
  232. </div>
  233. <a class="anchor" id="a8a074032e56e1443e46b6f9470d58271"></a>
  234. <div class="memitem">
  235. <div class="memproto">
  236.       <table class="memname">
  237.         <tr>
  238.           <td class="memname">DB\SQL::driver </td>
  239.           <td>(</td>
  240.           <td class="paramname"></td><td>)</td>
  241.           <td></td>
  242.         </tr>
  243.       </table>
  244. </div><div class="memdoc">
  245. <p>Return database engine </p>
  246. <dl class="section return"><dt>Returns</dt><dd>string </dd></dl>
  247.  
  248. </div>
  249. </div>
  250. <a class="anchor" id="aae9de7373718da0c28c9c70de287bbd5"></a>
  251. <div class="memitem">
  252. <div class="memproto">
  253.       <table class="memname">
  254.         <tr>
  255.           <td class="memname">DB\SQL::exec </td>
  256.           <td>(</td>
  257.           <td class="paramtype">&#160;</td>
  258.           <td class="paramname"><em>$cmds</em>, </td>
  259.         </tr>
  260.         <tr>
  261.           <td class="paramkey"></td>
  262.           <td></td>
  263.           <td class="paramtype">&#160;</td>
  264.           <td class="paramname"><em>$args</em> = <code>NULL</code>, </td>
  265.         </tr>
  266.         <tr>
  267.           <td class="paramkey"></td>
  268.           <td></td>
  269.           <td class="paramtype">&#160;</td>
  270.           <td class="paramname"><em>$ttl</em> = <code>0</code>, </td>
  271.         </tr>
  272.         <tr>
  273.           <td class="paramkey"></td>
  274.           <td></td>
  275.           <td class="paramtype">&#160;</td>
  276.           <td class="paramname"><em>$log</em> = <code>TRUE</code>&#160;</td>
  277.         </tr>
  278.         <tr>
  279.           <td></td>
  280.           <td>)</td>
  281.           <td></td><td></td>
  282.         </tr>
  283.       </table>
  284. </div><div class="memdoc">
  285. <p>Execute SQL statement(s) </p>
  286. <dl class="section return"><dt>Returns</dt><dd>array|int|FALSE </dd></dl>
  287. <dl class="params"><dt>Parameters</dt><dd>
  288.   <table class="params">
  289.     <tr><td class="paramname">$cmds</td><td>string|array </td></tr>
  290.     <tr><td class="paramname">$args</td><td>string|array </td></tr>
  291.     <tr><td class="paramname">$ttl</td><td>int </td></tr>
  292.     <tr><td class="paramname">$log</td><td>bool </td></tr>
  293.   </table>
  294.   </dd>
  295. </dl>
  296.  
  297. </div>
  298. </div>
  299. <a class="anchor" id="a5bdb97cf5d6ac52c99d9ffe8a6f9e190"></a>
  300. <div class="memitem">
  301. <div class="memproto">
  302.       <table class="memname">
  303.         <tr>
  304.           <td class="memname">DB\SQL::log </td>
  305.           <td>(</td>
  306.           <td class="paramname"></td><td>)</td>
  307.           <td></td>
  308.         </tr>
  309.       </table>
  310. </div><div class="memdoc">
  311. <p>Return SQL profiler results </p>
  312. <dl class="section return"><dt>Returns</dt><dd>string </dd></dl>
  313.  
  314. </div>
  315. </div>
  316. <a class="anchor" id="a98fea91c80657442689dd19dc8050dec"></a>
  317. <div class="memitem">
  318. <div class="memproto">
  319.       <table class="memname">
  320.         <tr>
  321.           <td class="memname">DB\SQL::name </td>
  322.           <td>(</td>
  323.           <td class="paramname"></td><td>)</td>
  324.           <td></td>
  325.         </tr>
  326.       </table>
  327. </div><div class="memdoc">
  328. <p>Return database name </p>
  329. <dl class="section return"><dt>Returns</dt><dd>string </dd></dl>
  330.  
  331. </div>
  332. </div>
  333. <a class="anchor" id="aa4e387f439b8ce06a48ae57cdbb5af95"></a>
  334. <div class="memitem">
  335. <div class="memproto">
  336.       <table class="memname">
  337.         <tr>
  338.           <td class="memname">DB\SQL::quote </td>
  339.           <td>(</td>
  340.           <td class="paramtype">&#160;</td>
  341.           <td class="paramname"><em>$val</em>, </td>
  342.         </tr>
  343.         <tr>
  344.           <td class="paramkey"></td>
  345.           <td></td>
  346.           <td class="paramtype">&#160;</td>
  347.           <td class="paramname"><em>$type</em> = <code>\PDO::PARAM_STR</code>&#160;</td>
  348.         </tr>
  349.         <tr>
  350.           <td></td>
  351.           <td>)</td>
  352.           <td></td><td></td>
  353.         </tr>
  354.       </table>
  355. </div><div class="memdoc">
  356. <p>Quote string </p>
  357. <dl class="section return"><dt>Returns</dt><dd>string </dd></dl>
  358. <dl class="params"><dt>Parameters</dt><dd>
  359.   <table class="params">
  360.     <tr><td class="paramname">$val</td><td>mixed </td></tr>
  361.     <tr><td class="paramname">$type</td><td>int </td></tr>
  362.   </table>
  363.   </dd>
  364. </dl>
  365.  
  366. </div>
  367. </div>
  368. <a class="anchor" id="ab23e1524e183a0d21f5e9a4c02dde037"></a>
  369. <div class="memitem">
  370. <div class="memproto">
  371.       <table class="memname">
  372.         <tr>
  373.           <td class="memname">DB\SQL::quotekey </td>
  374.           <td>(</td>
  375.           <td class="paramtype">&#160;</td>
  376.           <td class="paramname"><em>$key</em></td><td>)</td>
  377.           <td></td>
  378.         </tr>
  379.       </table>
  380. </div><div class="memdoc">
  381. <p>Return quoted identifier name </p>
  382. <dl class="section return"><dt>Returns</dt><dd>string </dd></dl>
  383. <dl class="params"><dt>Parameters</dt><dd>
  384.   <table class="params">
  385.     <tr><td class="paramname">$key</td><td></td></tr>
  386.   </table>
  387.   </dd>
  388. </dl>
  389.  
  390. </div>
  391. </div>
  392. <a class="anchor" id="a44c5c212a997fa1c51cd10bdf0981bfe"></a>
  393. <div class="memitem">
  394. <div class="memproto">
  395.       <table class="memname">
  396.         <tr>
  397.           <td class="memname">DB\SQL::rollback </td>
  398.           <td>(</td>
  399.           <td class="paramname"></td><td>)</td>
  400.           <td></td>
  401.         </tr>
  402.       </table>
  403. </div><div class="memdoc">
  404. <p>Rollback SQL transaction </p>
  405. <dl class="section return"><dt>Returns</dt><dd>bool </dd></dl>
  406.  
  407. </div>
  408. </div>
  409. <a class="anchor" id="aceda87f3c9133d0ee03505f606422af4"></a>
  410. <div class="memitem">
  411. <div class="memproto">
  412.       <table class="memname">
  413.         <tr>
  414.           <td class="memname">DB\SQL::schema </td>
  415.           <td>(</td>
  416.           <td class="paramtype">&#160;</td>
  417.           <td class="paramname"><em>$table</em>, </td>
  418.         </tr>
  419.         <tr>
  420.           <td class="paramkey"></td>
  421.           <td></td>
  422.           <td class="paramtype">&#160;</td>
  423.           <td class="paramname"><em>$fields</em> = <code>NULL</code>, </td>
  424.         </tr>
  425.         <tr>
  426.           <td class="paramkey"></td>
  427.           <td></td>
  428.           <td class="paramtype">&#160;</td>
  429.           <td class="paramname"><em>$ttl</em> = <code>0</code>&#160;</td>
  430.         </tr>
  431.         <tr>
  432.           <td></td>
  433.           <td>)</td>
  434.           <td></td><td></td>
  435.         </tr>
  436.       </table>
  437. </div><div class="memdoc">
  438. <p>Retrieve schema of SQL table </p>
  439. <dl class="section return"><dt>Returns</dt><dd>array|FALSE </dd></dl>
  440. <dl class="params"><dt>Parameters</dt><dd>
  441.   <table class="params">
  442.     <tr><td class="paramname">$table</td><td>string </td></tr>
  443.     <tr><td class="paramname">$fields</td><td>array|string </td></tr>
  444.     <tr><td class="paramname">$ttl</td><td>int </td></tr>
  445.   </table>
  446.   </dd>
  447. </dl>
  448.  
  449. </div>
  450. </div>
  451. <a class="anchor" id="a1cdbdcd5996d5b34e83ec1554ac2ded2"></a>
  452. <div class="memitem">
  453. <div class="memproto">
  454.       <table class="memname">
  455.         <tr>
  456.           <td class="memname">DB\SQL::type </td>
  457.           <td>(</td>
  458.           <td class="paramtype">&#160;</td>
  459.           <td class="paramname"><em>$val</em></td><td>)</td>
  460.           <td></td>
  461.         </tr>
  462.       </table>
  463. </div><div class="memdoc">
  464. <p>Map data type of argument to a PDO constant </p>
  465. <dl class="section return"><dt>Returns</dt><dd>int </dd></dl>
  466. <dl class="params"><dt>Parameters</dt><dd>
  467.   <table class="params">
  468.     <tr><td class="paramname">$val</td><td>scalar </td></tr>
  469.   </table>
  470.   </dd>
  471. </dl>
  472.  
  473. </div>
  474. </div>
  475. <a class="anchor" id="a3d41d6d72944573251f74b086b6173bc"></a>
  476. <div class="memitem">
  477. <div class="memproto">
  478.       <table class="memname">
  479.         <tr>
  480.           <td class="memname">DB\SQL::uuid </td>
  481.           <td>(</td>
  482.           <td class="paramname"></td><td>)</td>
  483.           <td></td>
  484.         </tr>
  485.       </table>
  486. </div><div class="memdoc">
  487. <p>Return UUID </p>
  488. <dl class="section return"><dt>Returns</dt><dd>string </dd></dl>
  489.  
  490. </div>
  491. </div>
  492. <a class="anchor" id="ac7f7ef1e3c360dee9d17dd3dea1eb127"></a>
  493. <div class="memitem">
  494. <div class="memproto">
  495.       <table class="memname">
  496.         <tr>
  497.           <td class="memname">DB\SQL::value </td>
  498.           <td>(</td>
  499.           <td class="paramtype">&#160;</td>
  500.           <td class="paramname"><em>$type</em>, </td>
  501.         </tr>
  502.         <tr>
  503.           <td class="paramkey"></td>
  504.           <td></td>
  505.           <td class="paramtype">&#160;</td>
  506.           <td class="paramname"><em>$val</em>&#160;</td>
  507.         </tr>
  508.         <tr>
  509.           <td></td>
  510.           <td>)</td>
  511.           <td></td><td></td>
  512.         </tr>
  513.       </table>
  514. </div><div class="memdoc">
  515. <p>Cast value to PHP type </p>
  516. <dl class="section return"><dt>Returns</dt><dd>scalar </dd></dl>
  517. <dl class="params"><dt>Parameters</dt><dd>
  518.   <table class="params">
  519.     <tr><td class="paramname">$type</td><td>string </td></tr>
  520.     <tr><td class="paramname">$val</td><td>scalar </td></tr>
  521.   </table>
  522.   </dd>
  523. </dl>
  524.  
  525. </div>
  526. </div>
  527. <a class="anchor" id="a24b57a9967b47680e854dc2ea328ad1f"></a>
  528. <div class="memitem">
  529. <div class="memproto">
  530.       <table class="memname">
  531.         <tr>
  532.           <td class="memname">DB\SQL::version </td>
  533.           <td>(</td>
  534.           <td class="paramname"></td><td>)</td>
  535.           <td></td>
  536.         </tr>
  537.       </table>
  538. </div><div class="memdoc">
  539. <p>Return server version </p>
  540. <dl class="section return"><dt>Returns</dt><dd>string </dd></dl>
  541.  
  542. </div>
  543. </div>
  544. <hr/>The documentation for this class was generated from the following file:<ul>
  545. <li>db/sql.php</li>
  546. </ul>
  547. </div><!-- contents -->