diff options
Diffstat (limited to 'management-interface/lib/api/classDB_1_1SQL.html')
| -rw-r--r-- | management-interface/lib/api/classDB_1_1SQL.html | 547 |
1 files changed, 547 insertions, 0 deletions
diff --git a/management-interface/lib/api/classDB_1_1SQL.html b/management-interface/lib/api/classDB_1_1SQL.html new file mode 100644 index 0000000..f993b6a --- /dev/null +++ b/management-interface/lib/api/classDB_1_1SQL.html @@ -0,0 +1,547 @@ +<!-- HTML header for doxygen 1.8.5--> +<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> +<html xmlns="http://www.w3.org/1999/xhtml"> +<head> +<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/> +<meta http-equiv="X-UA-Compatible" content="IE=9"/> +<meta name="generator" content="Doxygen 1.8.6"/> +<title>Fat-Free Framework: DB\SQL Class Reference</title> +<link href="tabs.css" rel="stylesheet" type="text/css"/> +<script type="text/javascript" src="jquery.js"></script> +<script type="text/javascript" src="dynsections.js"></script> +<link href="doxygen.css" rel="stylesheet" type="text/css" /> +</head> +<body> +<div id="top"><!-- do not remove this div, it is closed by doxygen! --> +<div id="titlearea"> +<table cellspacing="0" cellpadding="0"> + <tbody> + <tr style="height: 56px;"> + <td style="padding-left: 0.5em;"> + <div id="projectname">Fat-Free Framework +  <span id="projectnumber">3.2.2</span> +  <span class="menu"><a href="index.html">Overview</a> <a href="annotated.html">Class List</a> <a href="hierarchy.html">Hierarchy</a></span> + </div> + </td> + </tr> + </tbody> +</table> +</div> +<!-- end header part --> +<!-- Generated by Doxygen 1.8.6 --> +<div id="nav-path" class="navpath"> + <ul> +<li class="navelem"><b>DB</b></li><li class="navelem"><a class="el" href="classDB_1_1SQL.html">SQL</a></li> </ul> +</div> +</div><!-- top --> +<div class="header"> + <div class="summary"> +<a href="#pub-methods">Public Member Functions</a> | +<a href="#pub-attribs">Public Attributes</a> | +<a href="#pro-attribs">Protected Attributes</a> | +<a href="classDB_1_1SQL-members.html">List of all members</a> </div> + <div class="headertitle"> +<div class="title">DB\SQL Class Reference</div> </div> +</div><!--header--> +<div class="contents"> + +<p>PDO wrapper. + <a href="classDB_1_1SQL.html#details">More...</a></p> +<div id="dynsection-0" onclick="return toggleVisibility(this)" class="dynheader closed" style="cursor:pointer;"> + <img id="dynsection-0-trigger" src="closed.png" alt="+"/> Inheritance diagram for DB\SQL:</div> +<div id="dynsection-0-summary" class="dynsummary" style="display:block;"> +</div> +<div id="dynsection-0-content" class="dyncontent" style="display:none;"> + <div class="center"> + <img src="classDB_1_1SQL.png" usemap="#DB\SQL_map" alt=""/> + <map id="DB\SQL_map" name="DB\SQL_map"> +</map> + </div></div> +<table class="memberdecls"> +<tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="pub-methods"></a> +Public Member Functions</h2></td></tr> +<tr class="memitem:a5f5ced00dfa005770876582222b4008b"><td class="memItemLeft" align="right" valign="top"> </td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#a5f5ced00dfa005770876582222b4008b">begin</a> ()</td></tr> +<tr class="separator:a5f5ced00dfa005770876582222b4008b"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a44c5c212a997fa1c51cd10bdf0981bfe"><td class="memItemLeft" align="right" valign="top"> </td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#a44c5c212a997fa1c51cd10bdf0981bfe">rollback</a> ()</td></tr> +<tr class="separator:a44c5c212a997fa1c51cd10bdf0981bfe"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a1c741bcdd850522bebe83ae9f3a89f8c"><td class="memItemLeft" align="right" valign="top"> </td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#a1c741bcdd850522bebe83ae9f3a89f8c">commit</a> ()</td></tr> +<tr class="separator:a1c741bcdd850522bebe83ae9f3a89f8c"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a1cdbdcd5996d5b34e83ec1554ac2ded2"><td class="memItemLeft" align="right" valign="top"> </td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#a1cdbdcd5996d5b34e83ec1554ac2ded2">type</a> ($val)</td></tr> +<tr class="separator:a1cdbdcd5996d5b34e83ec1554ac2ded2"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:ac7f7ef1e3c360dee9d17dd3dea1eb127"><td class="memItemLeft" align="right" valign="top"> </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> +<tr class="separator:ac7f7ef1e3c360dee9d17dd3dea1eb127"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:aae9de7373718da0c28c9c70de287bbd5"><td class="memItemLeft" align="right" valign="top"> </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> +<tr class="separator:aae9de7373718da0c28c9c70de287bbd5"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a2da7fa08b61795e9dfad255b6204c7f8"><td class="memItemLeft" align="right" valign="top"> </td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#a2da7fa08b61795e9dfad255b6204c7f8">count</a> ()</td></tr> +<tr class="separator:a2da7fa08b61795e9dfad255b6204c7f8"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a5bdb97cf5d6ac52c99d9ffe8a6f9e190"><td class="memItemLeft" align="right" valign="top"> </td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#a5bdb97cf5d6ac52c99d9ffe8a6f9e190">log</a> ()</td></tr> +<tr class="separator:a5bdb97cf5d6ac52c99d9ffe8a6f9e190"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:aceda87f3c9133d0ee03505f606422af4"><td class="memItemLeft" align="right" valign="top"> </td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#aceda87f3c9133d0ee03505f606422af4">schema</a> ($table, $fields=NULL, $ttl=0)</td></tr> +<tr class="separator:aceda87f3c9133d0ee03505f606422af4"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:aa4e387f439b8ce06a48ae57cdbb5af95"><td class="memItemLeft" align="right" valign="top"> </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> +<tr class="separator:aa4e387f439b8ce06a48ae57cdbb5af95"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a3d41d6d72944573251f74b086b6173bc"><td class="memItemLeft" align="right" valign="top"> </td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#a3d41d6d72944573251f74b086b6173bc">uuid</a> ()</td></tr> +<tr class="separator:a3d41d6d72944573251f74b086b6173bc"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a8a074032e56e1443e46b6f9470d58271"><td class="memItemLeft" align="right" valign="top"> </td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#a8a074032e56e1443e46b6f9470d58271">driver</a> ()</td></tr> +<tr class="separator:a8a074032e56e1443e46b6f9470d58271"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a24b57a9967b47680e854dc2ea328ad1f"><td class="memItemLeft" align="right" valign="top"> </td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#a24b57a9967b47680e854dc2ea328ad1f">version</a> ()</td></tr> +<tr class="separator:a24b57a9967b47680e854dc2ea328ad1f"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a98fea91c80657442689dd19dc8050dec"><td class="memItemLeft" align="right" valign="top"> </td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#a98fea91c80657442689dd19dc8050dec">name</a> ()</td></tr> +<tr class="separator:a98fea91c80657442689dd19dc8050dec"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:ab23e1524e183a0d21f5e9a4c02dde037"><td class="memItemLeft" align="right" valign="top"> </td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#ab23e1524e183a0d21f5e9a4c02dde037">quotekey</a> ($key)</td></tr> +<tr class="separator:ab23e1524e183a0d21f5e9a4c02dde037"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a03e2d154e8308f8407f81ac04fa77261"><td class="memItemLeft" align="right" valign="top"> </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> +<tr class="separator:a03e2d154e8308f8407f81ac04fa77261"><td class="memSeparator" colspan="2"> </td></tr> +</table><table class="memberdecls"> +<tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="pub-attribs"></a> +Public Attributes</h2></td></tr> +<tr class="memitem:a8a4a0eb6935bb0202f4acab135e214ed"><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a8a4a0eb6935bb0202f4acab135e214ed"></a> + </td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#a8a4a0eb6935bb0202f4acab135e214ed">$dsn</a></td></tr> +<tr class="memdesc:a8a4a0eb6935bb0202f4acab135e214ed"><td class="mdescLeft"> </td><td class="mdescRight">Data source name. <br/></td></tr> +<tr class="separator:a8a4a0eb6935bb0202f4acab135e214ed"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a19ed348edd0549a3f24bd462097f9e52"><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a19ed348edd0549a3f24bd462097f9e52"></a> + </td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#a19ed348edd0549a3f24bd462097f9e52">$engine</a></td></tr> +<tr class="memdesc:a19ed348edd0549a3f24bd462097f9e52"><td class="mdescLeft"> </td><td class="mdescRight">Database engine. <br/></td></tr> +<tr class="separator:a19ed348edd0549a3f24bd462097f9e52"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a9d54d723c3b9218b6068ef131b2def07"><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a9d54d723c3b9218b6068ef131b2def07"></a> + </td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#a9d54d723c3b9218b6068ef131b2def07">$dbname</a></td></tr> +<tr class="memdesc:a9d54d723c3b9218b6068ef131b2def07"><td class="mdescLeft"> </td><td class="mdescRight">Database name. <br/></td></tr> +<tr class="separator:a9d54d723c3b9218b6068ef131b2def07"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a9f1c991be6d0c09a2c58e6564cc657a2"><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a9f1c991be6d0c09a2c58e6564cc657a2"></a> + </td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#a9f1c991be6d0c09a2c58e6564cc657a2">$trans</a> =FALSE</td></tr> +<tr class="memdesc:a9f1c991be6d0c09a2c58e6564cc657a2"><td class="mdescLeft"> </td><td class="mdescRight">Transaction flag. <br/></td></tr> +<tr class="separator:a9f1c991be6d0c09a2c58e6564cc657a2"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a3deede01233c40789f837bca11dbd856"><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a3deede01233c40789f837bca11dbd856"></a> + </td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#a3deede01233c40789f837bca11dbd856">$rows</a> =0</td></tr> +<tr class="memdesc:a3deede01233c40789f837bca11dbd856"><td class="mdescLeft"> </td><td class="mdescRight">Number of rows affected by query. <br/></td></tr> +<tr class="separator:a3deede01233c40789f837bca11dbd856"><td class="memSeparator" colspan="2"> </td></tr> +<tr class="memitem:a95c93a06344cfdabd83824e38a527954"><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a95c93a06344cfdabd83824e38a527954"></a> + </td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#a95c93a06344cfdabd83824e38a527954">$log</a></td></tr> +<tr class="memdesc:a95c93a06344cfdabd83824e38a527954"><td class="mdescLeft"> </td><td class="mdescRight">SQL log. <br/></td></tr> +<tr class="separator:a95c93a06344cfdabd83824e38a527954"><td class="memSeparator" colspan="2"> </td></tr> +</table><table class="memberdecls"> +<tr class="heading"><td colspan="2"><h2 class="groupheader"><a name="pro-attribs"></a> +Protected Attributes</h2></td></tr> +<tr class="memitem:a28eb5b9fdad772d69977b7251896fb9e"><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a28eb5b9fdad772d69977b7251896fb9e"></a> + </td><td class="memItemRight" valign="bottom"><a class="el" href="classDB_1_1SQL.html#a28eb5b9fdad772d69977b7251896fb9e">$uuid</a></td></tr> +<tr class="memdesc:a28eb5b9fdad772d69977b7251896fb9e"><td class="mdescLeft"> </td><td class="mdescRight">UUID. <br/></td></tr> +<tr class="separator:a28eb5b9fdad772d69977b7251896fb9e"><td class="memSeparator" colspan="2"> </td></tr> +</table> +<a name="details" id="details"></a><h2 class="groupheader">Detailed Description</h2> +<div class="textblock"><p>PDO wrapper. </p> +</div><h2 class="groupheader">Constructor & Destructor Documentation</h2> +<a class="anchor" id="a03e2d154e8308f8407f81ac04fa77261"></a> +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">DB\SQL::__construct </td> + <td>(</td> + <td class="paramtype"> </td> + <td class="paramname"><em>$dsn</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype"> </td> + <td class="paramname"><em>$user</em> = <code>NULL</code>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype"> </td> + <td class="paramname"><em>$pw</em> = <code>NULL</code>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype">array </td> + <td class="paramname"><em>$options</em> = <code>NULL</code> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> +<p>Instantiate class </p> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">$dsn</td><td>string </td></tr> + <tr><td class="paramname">$user</td><td>string </td></tr> + <tr><td class="paramname">$pw</td><td>string </td></tr> + <tr><td class="paramname">$options</td><td>array </td></tr> + </table> + </dd> +</dl> + +</div> +</div> +<h2 class="groupheader">Member Function Documentation</h2> +<a class="anchor" id="a5f5ced00dfa005770876582222b4008b"></a> +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">DB\SQL::begin </td> + <td>(</td> + <td class="paramname"></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> +<p>Begin SQL transaction </p> +<dl class="section return"><dt>Returns</dt><dd>bool </dd></dl> + +</div> +</div> +<a class="anchor" id="a1c741bcdd850522bebe83ae9f3a89f8c"></a> +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">DB\SQL::commit </td> + <td>(</td> + <td class="paramname"></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> +<p>Commit SQL transaction </p> +<dl class="section return"><dt>Returns</dt><dd>bool </dd></dl> + +</div> +</div> +<a class="anchor" id="a2da7fa08b61795e9dfad255b6204c7f8"></a> +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">DB\SQL::count </td> + <td>(</td> + <td class="paramname"></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> +<p>Return number of rows affected by last query </p> +<dl class="section return"><dt>Returns</dt><dd>int </dd></dl> + +</div> +</div> +<a class="anchor" id="a8a074032e56e1443e46b6f9470d58271"></a> +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">DB\SQL::driver </td> + <td>(</td> + <td class="paramname"></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> +<p>Return database engine </p> +<dl class="section return"><dt>Returns</dt><dd>string </dd></dl> + +</div> +</div> +<a class="anchor" id="aae9de7373718da0c28c9c70de287bbd5"></a> +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">DB\SQL::exec </td> + <td>(</td> + <td class="paramtype"> </td> + <td class="paramname"><em>$cmds</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype"> </td> + <td class="paramname"><em>$args</em> = <code>NULL</code>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype"> </td> + <td class="paramname"><em>$ttl</em> = <code>0</code>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype"> </td> + <td class="paramname"><em>$log</em> = <code>TRUE</code> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> +<p>Execute SQL statement(s) </p> +<dl class="section return"><dt>Returns</dt><dd>array|int|FALSE </dd></dl> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">$cmds</td><td>string|array </td></tr> + <tr><td class="paramname">$args</td><td>string|array </td></tr> + <tr><td class="paramname">$ttl</td><td>int </td></tr> + <tr><td class="paramname">$log</td><td>bool </td></tr> + </table> + </dd> +</dl> + +</div> +</div> +<a class="anchor" id="a5bdb97cf5d6ac52c99d9ffe8a6f9e190"></a> +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">DB\SQL::log </td> + <td>(</td> + <td class="paramname"></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> +<p>Return SQL profiler results </p> +<dl class="section return"><dt>Returns</dt><dd>string </dd></dl> + +</div> +</div> +<a class="anchor" id="a98fea91c80657442689dd19dc8050dec"></a> +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">DB\SQL::name </td> + <td>(</td> + <td class="paramname"></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> +<p>Return database name </p> +<dl class="section return"><dt>Returns</dt><dd>string </dd></dl> + +</div> +</div> +<a class="anchor" id="aa4e387f439b8ce06a48ae57cdbb5af95"></a> +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">DB\SQL::quote </td> + <td>(</td> + <td class="paramtype"> </td> + <td class="paramname"><em>$val</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype"> </td> + <td class="paramname"><em>$type</em> = <code>\PDO::PARAM_STR</code> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> +<p>Quote string </p> +<dl class="section return"><dt>Returns</dt><dd>string </dd></dl> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">$val</td><td>mixed </td></tr> + <tr><td class="paramname">$type</td><td>int </td></tr> + </table> + </dd> +</dl> + +</div> +</div> +<a class="anchor" id="ab23e1524e183a0d21f5e9a4c02dde037"></a> +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">DB\SQL::quotekey </td> + <td>(</td> + <td class="paramtype"> </td> + <td class="paramname"><em>$key</em></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> +<p>Return quoted identifier name </p> +<dl class="section return"><dt>Returns</dt><dd>string </dd></dl> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">$key</td><td></td></tr> + </table> + </dd> +</dl> + +</div> +</div> +<a class="anchor" id="a44c5c212a997fa1c51cd10bdf0981bfe"></a> +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">DB\SQL::rollback </td> + <td>(</td> + <td class="paramname"></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> +<p>Rollback SQL transaction </p> +<dl class="section return"><dt>Returns</dt><dd>bool </dd></dl> + +</div> +</div> +<a class="anchor" id="aceda87f3c9133d0ee03505f606422af4"></a> +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">DB\SQL::schema </td> + <td>(</td> + <td class="paramtype"> </td> + <td class="paramname"><em>$table</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype"> </td> + <td class="paramname"><em>$fields</em> = <code>NULL</code>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype"> </td> + <td class="paramname"><em>$ttl</em> = <code>0</code> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> +<p>Retrieve schema of SQL table </p> +<dl class="section return"><dt>Returns</dt><dd>array|FALSE </dd></dl> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">$table</td><td>string </td></tr> + <tr><td class="paramname">$fields</td><td>array|string </td></tr> + <tr><td class="paramname">$ttl</td><td>int </td></tr> + </table> + </dd> +</dl> + +</div> +</div> +<a class="anchor" id="a1cdbdcd5996d5b34e83ec1554ac2ded2"></a> +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">DB\SQL::type </td> + <td>(</td> + <td class="paramtype"> </td> + <td class="paramname"><em>$val</em></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> +<p>Map data type of argument to a PDO constant </p> +<dl class="section return"><dt>Returns</dt><dd>int </dd></dl> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">$val</td><td>scalar </td></tr> + </table> + </dd> +</dl> + +</div> +</div> +<a class="anchor" id="a3d41d6d72944573251f74b086b6173bc"></a> +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">DB\SQL::uuid </td> + <td>(</td> + <td class="paramname"></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> +<p>Return UUID </p> +<dl class="section return"><dt>Returns</dt><dd>string </dd></dl> + +</div> +</div> +<a class="anchor" id="ac7f7ef1e3c360dee9d17dd3dea1eb127"></a> +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">DB\SQL::value </td> + <td>(</td> + <td class="paramtype"> </td> + <td class="paramname"><em>$type</em>, </td> + </tr> + <tr> + <td class="paramkey"></td> + <td></td> + <td class="paramtype"> </td> + <td class="paramname"><em>$val</em> </td> + </tr> + <tr> + <td></td> + <td>)</td> + <td></td><td></td> + </tr> + </table> +</div><div class="memdoc"> +<p>Cast value to PHP type </p> +<dl class="section return"><dt>Returns</dt><dd>scalar </dd></dl> +<dl class="params"><dt>Parameters</dt><dd> + <table class="params"> + <tr><td class="paramname">$type</td><td>string </td></tr> + <tr><td class="paramname">$val</td><td>scalar </td></tr> + </table> + </dd> +</dl> + +</div> +</div> +<a class="anchor" id="a24b57a9967b47680e854dc2ea328ad1f"></a> +<div class="memitem"> +<div class="memproto"> + <table class="memname"> + <tr> + <td class="memname">DB\SQL::version </td> + <td>(</td> + <td class="paramname"></td><td>)</td> + <td></td> + </tr> + </table> +</div><div class="memdoc"> +<p>Return server version </p> +<dl class="section return"><dt>Returns</dt><dd>string </dd></dl> + +</div> +</div> +<hr/>The documentation for this class was generated from the following file:<ul> +<li>db/sql.php</li> +</ul> +</div><!-- contents --> |