<!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"/>
<title>Bontiv CMS: sqld Class Reference</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="search/search.js"></script>
<link href="doxygen.css" rel="stylesheet" type="text/css"/>
</head>
<body onload='searchBox.OnSelectItem(0);'>
<!-- Generated by Doxygen 1.7.4 -->
<script type="text/javascript"><!--
var searchBox = new SearchBox("searchBox", "search",false,'Search');
--></script>
<div id="top">
<div id="titlearea">
<table cellspacing="0" cellpadding="0">
<tbody>
<tr style="height: 56px;">
<td style="padding-left: 0.5em;">
<div id="projectname">Bontiv CMS <span id="projectnumber">0.1</span></div>
<div id="projectbrief">The most flexible CMS of the world</div>
</td>
</tr>
</tbody>
</table>
</div>
<div id="navrow1" class="tabs">
<ul class="tablist">
<li><a href="index.html"><span>Main Page</span></a></li>
<li><a href="modules.html"><span>Modules</span></a></li>
<li><a href="namespaces.html"><span>Namespaces</span></a></li>
<li class="current"><a href="annotated.html"><span>Data Structures</span></a></li>
<li><a href="files.html"><span>Files</span></a></li>
<li id="searchli">
<div id="MSearchBox" class="MSearchBoxInactive">
<span class="left">
<img id="MSearchSelect" src="search/mag_sel.png"
onmouseover="return searchBox.OnSearchSelectShow()"
onmouseout="return searchBox.OnSearchSelectHide()"
alt=""/>
<input type="text" id="MSearchField" value="Search" accesskey="S"
onfocus="searchBox.OnSearchFieldFocus(true)"
onblur="searchBox.OnSearchFieldFocus(false)"
onkeyup="searchBox.OnSearchFieldChange(event)"/>
</span><span class="right">
<a id="MSearchClose" href="javascript:searchBox.CloseResultsWindow()"><img id="MSearchCloseImg" border="0" src="search/close.png" alt=""/></a>
</span>
</div>
</li>
</ul>
</div>
<div id="navrow2" class="tabs2">
<ul class="tablist">
<li><a href="annotated.html"><span>Data Structures</span></a></li>
<li><a href="classes.html"><span>Data Structure Index</span></a></li>
<li><a href="inherits.html"><span>Class Hierarchy</span></a></li>
<li><a href="functions.html"><span>Data Fields</span></a></li>
</ul>
</div>
</div>
<div class="header">
<div class="summary">
<a href="#pub-static-methods">Static Public Member Functions</a> |
<a href="#pro-methods">Protected Member Functions</a> |
<a href="#pro-static-methods">Static Protected Member Functions</a> |
<a href="#pro-attribs">Protected Attributes</a> |
<a href="#pro-static-attribs">Static Protected Attributes</a> </div>
<div class="headertitle">
<div class="title">sqld Class Reference<div class="ingroups"><a class="el" href="group__mysqld.html">Lib MySQL Driver</a></div></div> </div>
</div>
<div class="contents">
<!-- doxytag: class="sqld" -->
<p>MySQL driver for <a class="el" href="class_s_q_l.html">SQL</a>.
<a href="classsqld.html#details">More...</a></p>
<div class="dynheader">
Inheritance diagram for sqld:</div>
<div class="dyncontent">
<div class="center"><img src="classsqld__inherit__graph.png" border="0" usemap="#sqld_inherit__map" alt="Inheritance graph"/></div>
<map name="sqld_inherit__map" id="sqld_inherit__map">
<area shape="rect" id="node3" href="class_s_q_l.html" title="SQL" alt="" coords="5,83,53,112"/><area shape="rect" id="node5" href="class_s_q_l_reslut.html" title="SQLReslut" alt="" coords="77,83,163,112"/><area shape="rect" id="node7" href="class_s_q_l_row.html" title="SQLRow" alt="" coords="187,83,261,112"/></map>
<center><span class="legend">[<a href="graph_legend.html">legend</a>]</span></center></div>
<table class="memberdecls">
<tr><td colspan="2"><h2><a name="pub-static-methods"></a>
Static Public Member Functions</h2></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">static </td><td class="memItemRight" valign="bottom"><a class="el" href="classsqld.html#a69bd796936545df32435fd0da0f786f1">connect</a> ($<a class="el" href="classuser.html">user</a>, $pass, $server, $port, $database)</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Connect to the MySQL Server. <a href="#a69bd796936545df32435fd0da0f786f1"></a><br/></td></tr>
<tr><td colspan="2"><h2><a name="pro-methods"></a>
Protected Member Functions</h2></td></tr>
<tr><td class="memItemLeft" align="right" valign="top"> </td><td class="memItemRight" valign="bottom"><a class="el" href="classsqld.html#ac9fddec3f6bd1db128887a1b211d90f0">query</a> ($query)</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Execute a query. <a href="#ac9fddec3f6bd1db128887a1b211d90f0"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top"> </td><td class="memItemRight" valign="bottom"><a class="el" href="classsqld.html#abebe5574a2d1d459ffa5bfbebea19a86">nbRow</a> ()</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">num rows affected <a href="#abebe5574a2d1d459ffa5bfbebea19a86"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top"> </td><td class="memItemRight" valign="bottom"><a class="el" href="classsqld.html#a812cda4574715397b7ffd0be994adf10">escape</a> ($string)</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Escape string. <a href="#a812cda4574715397b7ffd0be994adf10"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top"> </td><td class="memItemRight" valign="bottom"><a class="el" href="classsqld.html#a9783c6e3a4b8dfb37178a3565e6f0714">freeResult</a> ()</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Free result. <a href="#a9783c6e3a4b8dfb37178a3565e6f0714"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top"> </td><td class="memItemRight" valign="bottom"><a class="el" href="classsqld.html#a8f8ad53f696ccb73bc1b69c0228b8761">lastID</a> ()</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Return the last insert ID. <a href="#a8f8ad53f696ccb73bc1b69c0228b8761"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top"> </td><td class="memItemRight" valign="bottom"><a class="el" href="classsqld.html#ad40c766ec8aced9770fe6ae269a1e781">getKey</a> ()</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Get pirmary Keys. <a href="#ad40c766ec8aced9770fe6ae269a1e781"></a><br/></td></tr>
<tr><td colspan="2"><h2><a name="pro-static-methods"></a>
Static Protected Member Functions</h2></td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a1d68d0d72e16e18dfe327f39868b8fb5"></a><!-- doxytag: member="sqld::close" ref="a1d68d0d72e16e18dfe327f39868b8fb5" args="()" -->
static </td><td class="memItemRight" valign="bottom"><a class="el" href="classsqld.html#a1d68d0d72e16e18dfe327f39868b8fb5">close</a> ()</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Close <a class="el" href="class_s_q_l.html">SQL</a> connection. <br/></td></tr>
<tr><td colspan="2"><h2><a name="pro-attribs"></a>
Protected Attributes</h2></td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a2be392f8030f21380d711ba96bcd4e8e"></a><!-- doxytag: member="sqld::$mysqldResult" ref="a2be392f8030f21380d711ba96bcd4e8e" args="" -->
 </td><td class="memItemRight" valign="bottom"><a class="el" href="classsqld.html#a2be392f8030f21380d711ba96bcd4e8e">$mysqldResult</a></td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Result array. <br/></td></tr>
<tr><td colspan="2"><h2><a name="pro-static-attribs"></a>
Static Protected Attributes</h2></td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="adfb271b72cbdc80e0fe958a6b881a2d8"></a><!-- doxytag: member="sqld::$mysqldInstance" ref="adfb271b72cbdc80e0fe958a6b881a2d8" args="" -->
static </td><td class="memItemRight" valign="bottom"><a class="el" href="classsqld.html#adfb271b72cbdc80e0fe958a6b881a2d8">$mysqldInstance</a> = null</td></tr>
<tr><td class="mdescLeft"> </td><td class="mdescRight">Connection instance. <br/></td></tr>
</table>
<hr/><a name="details" id="details"></a><h2>Detailed Description</h2>
<div class="textblock"><p>MySQL driver for <a class="el" href="class_s_q_l.html">SQL</a>. </p>
<p>lib_mysqld </p>
</div><hr/><h2>Member Function Documentation</h2>
<a class="anchor" id="a69bd796936545df32435fd0da0f786f1"></a><!-- doxytag: member="sqld::connect" ref="a69bd796936545df32435fd0da0f786f1" args="($user, $pass, $server, $port, $database)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">static connect </td>
<td>(</td>
<td class="paramtype">$ </td>
<td class="paramname"><em>user</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">$ </td>
<td class="paramname"><em>pass</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">$ </td>
<td class="paramname"><em>server</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">$ </td>
<td class="paramname"><em>port</em>, </td>
</tr>
<tr>
<td class="paramkey"></td>
<td></td>
<td class="paramtype">$ </td>
<td class="paramname"><em>database</em> </td>
</tr>
<tr>
<td></td>
<td>)</td>
<td></td><td><code> [static]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>Connect to the MySQL Server. </p>
<dl><dt><b>Parameters:</b></dt><dd>
<table class="params">
<tr><td class="paramtype">mixed</td><td class="paramname">$user</td><td>User </td></tr>
<tr><td class="paramtype">mixed</td><td class="paramname">$pass</td><td>Password </td></tr>
<tr><td class="paramtype">mixed</td><td class="paramname">$server</td><td>MySQL server </td></tr>
<tr><td class="paramtype">mixed</td><td class="paramname">$port</td><td>port of the server </td></tr>
<tr><td class="paramtype">mixed</td><td class="paramname">$database</td><td>database name </td></tr>
</table>
</dd>
</dl>
</div>
</div>
<a class="anchor" id="a812cda4574715397b7ffd0be994adf10"></a><!-- doxytag: member="sqld::escape" ref="a812cda4574715397b7ffd0be994adf10" args="($string)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">escape </td>
<td>(</td>
<td class="paramtype">$ </td>
<td class="paramname"><em>string</em></td><td>)</td>
<td><code> [protected]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>Escape string. </p>
<p>Escape a string to prepare it for query. </p>
<dl><dt><b>Parameters:</b></dt><dd>
<table class="params">
<tr><td class="paramtype">string</td><td class="paramname">$string</td><td>what you want to escape. </td></tr>
</table>
</dd>
</dl>
<dl class="return"><dt><b>Returns:</b></dt><dd>string escaped string. </dd></dl>
</div>
</div>
<a class="anchor" id="a9783c6e3a4b8dfb37178a3565e6f0714"></a><!-- doxytag: member="sqld::freeResult" ref="a9783c6e3a4b8dfb37178a3565e6f0714" args="()" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">freeResult </td>
<td>(</td>
<td class="paramname"></td><td>)</td>
<td><code> [protected]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>Free result. </p>
<p>Free result memory </p>
</div>
</div>
<a class="anchor" id="ad40c766ec8aced9770fe6ae269a1e781"></a><!-- doxytag: member="sqld::getKey" ref="ad40c766ec8aced9770fe6ae269a1e781" args="()" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">getKey </td>
<td>(</td>
<td class="paramname"></td><td>)</td>
<td><code> [protected]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>Get pirmary Keys. </p>
<p>Return an associative array that associate key field with their tables of the last query. </p>
<dl class="return"><dt><b>Returns:</b></dt><dd>Array which associate primary key with his table. </dd></dl>
</div>
</div>
<a class="anchor" id="a8f8ad53f696ccb73bc1b69c0228b8761"></a><!-- doxytag: member="sqld::lastID" ref="a8f8ad53f696ccb73bc1b69c0228b8761" args="()" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">lastID </td>
<td>(</td>
<td class="paramname"></td><td>)</td>
<td><code> [protected]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>Return the last insert ID. </p>
<dl class="return"><dt><b>Returns:</b></dt><dd>int ID of the last insered data. </dd></dl>
</div>
</div>
<a class="anchor" id="abebe5574a2d1d459ffa5bfbebea19a86"></a><!-- doxytag: member="sqld::nbRow" ref="abebe5574a2d1d459ffa5bfbebea19a86" args="()" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">nbRow </td>
<td>(</td>
<td class="paramname"></td><td>)</td>
<td><code> [protected]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>num rows affected </p>
<p>Return nuber of rows in the result </p>
<dl class="return"><dt><b>Returns:</b></dt><dd>int nums rows </dd></dl>
</div>
</div>
<a class="anchor" id="ac9fddec3f6bd1db128887a1b211d90f0"></a><!-- doxytag: member="sqld::query" ref="ac9fddec3f6bd1db128887a1b211d90f0" args="($query)" -->
<div class="memitem">
<div class="memproto">
<table class="memname">
<tr>
<td class="memname">query </td>
<td>(</td>
<td class="paramtype">$ </td>
<td class="paramname"><em>query</em></td><td>)</td>
<td><code> [protected]</code></td>
</tr>
</table>
</div>
<div class="memdoc">
<p>Execute a query. </p>
<p>Execute a <a class="el" href="class_s_q_l.html">SQL</a> Query string $query and return an array of result rows. </p>
<dl><dt><b>Parameters:</b></dt><dd>
<table class="params">
<tr><td class="paramtype">string</td><td class="paramname">$query</td><td>: An sql requet you want to execute </td></tr>
</table>
</dd>
</dl>
<dl class="return"><dt><b>Returns:</b></dt><dd>Array of associative Array. </dd></dl>
</div>
</div>
<hr/>The documentation for this class was generated from the following file:<ul>
<li>libs/mysqld/<a class="el" href="sqld_8php.html">sqld.php</a></li>
</ul>
</div>
<!-- window showing the filter options -->
<div id="MSearchSelectWindow"
onmouseover="return searchBox.OnSearchSelectShow()"
onmouseout="return searchBox.OnSearchSelectHide()"
onkeydown="return searchBox.OnSearchSelectKey(event)">
<a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(0)"><span class="SelectionMark"> </span>All</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(1)"><span class="SelectionMark"> </span>Data Structures</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(2)"><span class="SelectionMark"> </span>Namespaces</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(3)"><span class="SelectionMark"> </span>Files</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(4)"><span class="SelectionMark"> </span>Functions</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(5)"><span class="SelectionMark"> </span>Variables</a></div>
<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="javascript:void(0)" frameborder="0"
name="MSearchResults" id="MSearchResults">
</iframe>
</div>
<hr class="footer"/><address class="footer"><small>Generated on Tue Sep 20 2011 for Bontiv CMS by 
<a href="http://www.doxygen.org/index.html">
<img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.7.4 </small></address>
</body>
</html>