Location: PHPKode > scripts > Table Data Management > table-data-management/MySQLConnection.html
<html>
<head>
<title>Docs For Class MySQLConnection</title>
<link rel="stylesheet" type="text/css" href="../media/style.css">
</head>
<body>

<table border="0" cellspacing="0" cellpadding="0" height="48" width="100%">
  <tr>
    <td class="header_top">database</td>
  </tr>
  <tr><td class="header_line"><img src="../media/empty.png" width="1" height="1" border="0" alt=""  /></td></tr>
  <tr>
    <td class="header_menu">
  		  [ <a href="../classtrees_database.html" class="menu">class tree: database</a> ]
		  [ <a href="../elementindex_database.html" class="menu">index: database</a> ]
		  [ <a href="../elementindex.html" class="menu">all elements</a> ]
    </td>
  </tr>
  <tr><td class="header_line"><img src="../media/empty.png" width="1" height="1" border="0" alt=""  /></td></tr>
</table>

<table width="100%" border="0" cellpadding="0" cellspacing="0">
  <tr valign="top">
    <td width="200" class="menu">
      <b>Packages:</b><br />
              <a href="../li_database.html">database</a><br />
            <br /><br />
                        <b>Files:</b><br />
      	  <div class="package">
			<a href="../database/_MySQLConnection_class_php.html">		MySQLConnection.class.php
		</a><br>
			<a href="../database/_TableColumn_class_php.html">		TableColumn.class.php
		</a><br>
			<a href="../database/_TableDataManagement_class_php.html">		TableDataManagement.class.php
		</a><br>
	  </div><br />
      
            <b>Classes:</b><br />
        <div class="package">
		    		<a href="../database/MySQLConnection.html">MySQLConnection</a><br />
	    		<a href="../database/TableColumn.html">TableColumn</a><br />
	    		<a href="../database/TableDataManagement.html">TableDataManagement</a><br />
	  </div>
                </td>
    <td>
      <table cellpadding="10" cellspacing="0" width="100%" border="0"><tr><td valign="top">

<h1>Class: MySQLConnection</h1>
Source Location: /MySQLConnection.class.php<br /><br />


<table width="100%" border="0">
<tr><td valign="top">

<h3><a href="#class_details">Class Overview</a></h3>
<pre></pre><br />
<div class="description"></div><br /><br />







</td>

<td valign="top">
<h3><a href="#class_vars">Variables</a></h3>
<ul>
    <li><a href="../database/MySQLConnection.html#var$_arrQuery">$_arrQuery</a></li>
    <li><a href="../database/MySQLConnection.html#var$_arrResult">$_arrResult</a></li>
    <li><a href="../database/MySQLConnection.html#var$_begincount">$_begincount</a></li>
    <li><a href="../database/MySQLConnection.html#var$_blnRollbackSet">$_blnRollbackSet</a></li>
    <li><a href="../database/MySQLConnection.html#var$_connected">$_connected</a></li>
    <li><a href="../database/MySQLConnection.html#var$_database">$_database</a></li>
    <li><a href="../database/MySQLConnection.html#var$_host">$_host</a></li>
    <li><a href="../database/MySQLConnection.html#var$_link">$_link</a></li>
    <li><a href="../database/MySQLConnection.html#var$_pass">$_pass</a></li>
    <li><a href="../database/MySQLConnection.html#var$_user">$_user</a></li>
  </ul>
</td>


<td valign="top">
<h3><a href="#class_methods">Methods</a></h3>
<ul>
    <li><a href="../database/MySQLConnection.html#methodMySQLConnection">MySQLConnection</a></li>
    <li><a href="../database/MySQLConnection.html#methodassocArrayResult">assocArrayResult</a></li>
    <li><a href="../database/MySQLConnection.html#methodbegin">begin</a></li>
    <li><a href="../database/MySQLConnection.html#methodclose">close</a></li>
    <li><a href="../database/MySQLConnection.html#methodcommit">commit</a></li>
    <li><a href="../database/MySQLConnection.html#methodgenerateQuery">generateQuery</a></li>
    <li><a href="../database/MySQLConnection.html#methodgetFieldType">getFieldType</a></li>
    <li><a href="../database/MySQLConnection.html#methodgetNumRows">getNumRows</a></li>
    <li><a href="../database/MySQLConnection.html#methodinsertId">insertId</a></li>
    <li><a href="../database/MySQLConnection.html#methodquery">query</a></li>
    <li><a href="../database/MySQLConnection.html#methodresult">result</a></li>
    <li><a href="../database/MySQLConnection.html#methodrollback">rollback</a></li>
    <li><a href="../database/MySQLConnection.html#methodselectDatabase">selectDatabase</a></li>
  </ul>
</td>

</tr></table>
<hr />

<table width="100%" border="0"><tr>






</tr></table>
<hr />

<a name="class_details"></a>
<h3>Class Details</h3>
<div class="tags">
[line 17]<br />
</div><br /><br />
<div class="top">[ <a href="#top">Top</a> ]</div><br />

<hr />
<a name="class_vars"></a>
<h3>Class Variables</h3>
<div class="tags">
	<a name="var$_arrQuery"></a>
	<p></p>
	<h4>$_arrQuery = <span class="value"></span></h4>
	<p>[line 27]</p>
  
  <br />
	<div class="tags">
  <table border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td><b>Type:</b>&nbsp;&nbsp;</td>
      <td>mixed</td>
    </tr>
      </table>
	</div><br /><br />
	<div class="top">[ <a href="#top">Top</a> ]</div><br />
	<a name="var$_arrResult"></a>
	<p></p>
	<h4>$_arrResult = <span class="value"></span></h4>
	<p>[line 28]</p>
  
  <br />
	<div class="tags">
  <table border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td><b>Type:</b>&nbsp;&nbsp;</td>
      <td>mixed</td>
    </tr>
      </table>
	</div><br /><br />
	<div class="top">[ <a href="#top">Top</a> ]</div><br />
	<a name="var$_begincount"></a>
	<p></p>
	<h4>$_begincount = <span class="value"></span></h4>
	<p>[line 31]</p>
  <br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>var:</b>&nbsp;&nbsp;</td><td>Used for keeping track of the amount of commits</td>
  </tr>
</table>
</div>

  <br />
	<div class="tags">
  <table border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td><b>Type:</b>&nbsp;&nbsp;</td>
      <td>_begincount</td>
    </tr>
      </table>
	</div><br /><br />
	<div class="top">[ <a href="#top">Top</a> ]</div><br />
	<a name="var$_blnRollbackSet"></a>
	<p></p>
	<h4>$_blnRollbackSet = <span class="value"></span></h4>
	<p>[line 33]</p>
  <br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>var:</b>&nbsp;&nbsp;</td><td>Can we rollback yet?</td>
  </tr>
</table>
</div>

  <br />
	<div class="tags">
  <table border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td><b>Type:</b>&nbsp;&nbsp;</td>
      <td>_blnRollbackSet</td>
    </tr>
      </table>
	</div><br /><br />
	<div class="top">[ <a href="#top">Top</a> ]</div><br />
	<a name="var$_connected"></a>
	<p></p>
	<h4>$_connected = <span class="value">&nbsp;false</span></h4>
	<p>[line 25]</p>
  
  <br />
	<div class="tags">
  <table border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td><b>Type:</b>&nbsp;&nbsp;</td>
      <td>mixed</td>
    </tr>
      </table>
	</div><br /><br />
	<div class="top">[ <a href="#top">Top</a> ]</div><br />
	<a name="var$_database"></a>
	<p></p>
	<h4>$_database = <span class="value"></span></h4>
	<p>[line 20]</p>
  Database information *<br /><br />
  <br />
	<div class="tags">
  <table border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td><b>Type:</b>&nbsp;&nbsp;</td>
      <td>mixed</td>
    </tr>
      </table>
	</div><br /><br />
	<div class="top">[ <a href="#top">Top</a> ]</div><br />
	<a name="var$_host"></a>
	<p></p>
	<h4>$_host = <span class="value"></span></h4>
	<p>[line 23]</p>
  
  <br />
	<div class="tags">
  <table border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td><b>Type:</b>&nbsp;&nbsp;</td>
      <td>mixed</td>
    </tr>
      </table>
	</div><br /><br />
	<div class="top">[ <a href="#top">Top</a> ]</div><br />
	<a name="var$_link"></a>
	<p></p>
	<h4>$_link = <span class="value"></span></h4>
	<p>[line 24]</p>
  
  <br />
	<div class="tags">
  <table border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td><b>Type:</b>&nbsp;&nbsp;</td>
      <td>mixed</td>
    </tr>
      </table>
	</div><br /><br />
	<div class="top">[ <a href="#top">Top</a> ]</div><br />
	<a name="var$_pass"></a>
	<p></p>
	<h4>$_pass = <span class="value"></span></h4>
	<p>[line 22]</p>
  
  <br />
	<div class="tags">
  <table border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td><b>Type:</b>&nbsp;&nbsp;</td>
      <td>mixed</td>
    </tr>
      </table>
	</div><br /><br />
	<div class="top">[ <a href="#top">Top</a> ]</div><br />
	<a name="var$_user"></a>
	<p></p>
	<h4>$_user = <span class="value"></span></h4>
	<p>[line 21]</p>
  
  <br />
	<div class="tags">
  <table border="0" cellspacing="0" cellpadding="0">
    <tr>
      <td><b>Type:</b>&nbsp;&nbsp;</td>
      <td>mixed</td>
    </tr>
      </table>
	</div><br /><br />
	<div class="top">[ <a href="#top">Top</a> ]</div><br />
</div><br />

<hr />
<a name="class_methods"></a>
<h3>Class Methods</h3>
<div class="tags">
  <hr />
	<a name="methodMySQLConnection"></a>
	<h3>constructor MySQLConnection <span class="smalllinenumber">[line 43]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>MySQLConnection MySQLConnection(
String
$database, String
$user, [String
$pass = null], [String
$host = "mysqlhost"])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Initialize the class with the correct parameters needed to connect to the database<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />


        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">String&nbsp;&nbsp;</td>
        <td><b>$database</b>&nbsp;&nbsp;</td>
        <td>Name of the database to connect to</td>
      </tr>
          <tr>
        <td class="type">String&nbsp;&nbsp;</td>
        <td><b>$user</b>&nbsp;&nbsp;</td>
        <td>Name of the user connecting to the database</td>
      </tr>
          <tr>
        <td class="type">String&nbsp;&nbsp;</td>
        <td><b>$pass</b>&nbsp;&nbsp;</td>
        <td>Password of the user connectin to the database</td>
      </tr>
          <tr>
        <td class="type">String&nbsp;&nbsp;</td>
        <td><b>$host</b>&nbsp;&nbsp;</td>
        <td>Host where the database resides</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodassocArrayResult"></a>
	<h3>method assocArrayResult <span class="smalllinenumber">[line 167]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>void assocArrayResult(
[Int
$resultNr = 0], [String
$columnName = null], [mixed
$indexColumn = null])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Retrieve a complete associative array containing the results<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />


        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">Int&nbsp;&nbsp;</td>
        <td><b>$resultNr</b>&nbsp;&nbsp;</td>
        <td>The nr of the resultset (the place/index in the array)</td>
      </tr>
          <tr>
        <td class="type">String&nbsp;&nbsp;</td>
        <td><b>$columnName</b>&nbsp;&nbsp;</td>
        <td>Name of the specific column to store into the assoc array</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodbegin"></a>
	<h3>method begin <span class="smalllinenumber">[line 208]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>void begin(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Start a transaction by executing a &quot;BEGIN&quot; query<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />


        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodclose"></a>
	<h3>method close <span class="smalllinenumber">[line 76]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>void close(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Close link to database if it is open<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />


        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodcommit"></a>
	<h3>method commit <span class="smalllinenumber">[line 222]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>void commit(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		End a transaction (acknowledge the action) by executing a &quot;COMMIT&quot; query<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />


        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgenerateQuery"></a>
	<h3>method generateQuery <span class="smalllinenumber">[line 263]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>void generateQuery(
String
$type, String
$table, Array
$arrColumns, [Array
$arrWhere = array()])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		This function is defined here, because it generates a query (wow really?) and it's for now the<br /><br /><p>only place it is usefull from it must always be used in conjuction with the TableColmun class  withouth that class, this function has no use  This function generates a query based on the parameters in the call</p><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
  <tr>
    <td><b>see:</b>&nbsp;&nbsp;</td><td><a href="../database/TableColumn.html">TableColumn</a></td>
  </tr>
</table>
</div>
<br /><br />


        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">String&nbsp;&nbsp;</td>
        <td><b>$type</b>&nbsp;&nbsp;</td>
        <td>The type of query to be generated (for now only 'insert' or 'update')</td>
      </tr>
          <tr>
        <td class="type">String&nbsp;&nbsp;</td>
        <td><b>$table</b>&nbsp;&nbsp;</td>
        <td>A string containing the table to do the query upon</td>
      </tr>
          <tr>
        <td class="type">Array&nbsp;&nbsp;</td>
        <td><b>$arrColumns</b>&nbsp;&nbsp;</td>
        <td>An array of TableColumn objecten containing the to be update/save columns (and data)</td>
      </tr>
          <tr>
        <td class="type">Array&nbsp;&nbsp;</td>
        <td><b>$arrWhere</b>&nbsp;&nbsp;</td>
        <td>An array of TableColumn objecten containing the where part</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetFieldType"></a>
	<h3>method getFieldType <span class="smalllinenumber">[line 128]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>void getFieldType(
Int
$fieldOffset, [mixed
$resultNr = 0], Int
$reslultNr)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get field type for the specified field/column<br /><br /><br /><br />


        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">Int&nbsp;&nbsp;</td>
        <td><b>$fieldOffset</b>&nbsp;&nbsp;</td>
        <td>The key of the field in the resultset</td>
      </tr>
          <tr>
        <td class="type">Int&nbsp;&nbsp;</td>
        <td><b>$reslultNr</b>&nbsp;&nbsp;</td>
        <td>The nr of the resultset (the place/index in the array)</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodgetNumRows"></a>
	<h3>method getNumRows <span class="smalllinenumber">[line 117]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>Int getNumRows(
[Int
$resultNr = 0])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Retrieve the number of rows affected by the last query<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>return:</b>&nbsp;&nbsp;</td><td>Nr of affected rows</td>
  </tr>
</table>
</div>
<br /><br />


        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">Int&nbsp;&nbsp;</td>
        <td><b>$resultNr</b>&nbsp;&nbsp;</td>
        <td>The nr of the resultset (the place/index in the array)</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodinsertId"></a>
	<h3>method insertId <span class="smalllinenumber">[line 196]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>Int insertId(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Get the id of the last inserted record<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>return:</b>&nbsp;&nbsp;</td><td>Id of the last inserted record</td>
  </tr>
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />


        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodquery"></a>
	<h3>method query <span class="smalllinenumber">[line 104]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>void query(
String
$query, [Int
$resultNr = 0])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Query the database with the query specified in the parameter, the query and resultset are both saved into an array  this way we make sure, that we have the abbility to get results from two different result sets<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />


        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">String&nbsp;&nbsp;</td>
        <td><b>$query</b>&nbsp;&nbsp;</td>
        <td>The query to be sent to the database</td>
      </tr>
          <tr>
        <td class="type">Int&nbsp;&nbsp;</td>
        <td><b>$resultNr</b>&nbsp;&nbsp;</td>
        <td>The nr of the resultset (the place/index in the array)</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodresult"></a>
	<h3>method result <span class="smalllinenumber">[line 140]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>void result(
[Int
$resultNr = 0], [mixed
$fetchType = FETCH_ARRAY])</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Retrieve found data through the specified (if parameter is set) resultset<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />


        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">Int&nbsp;&nbsp;</td>
        <td><b>$resultNr</b>&nbsp;&nbsp;</td>
        <td>resultNr    The nr of the resultset (the place/index in the array)</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodrollback"></a>
	<h3>method rollback <span class="smalllinenumber">[line 239]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>void rollback(
)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Rollback a transaction (undo the action) by executing a &quot;ROLLBACK&quot; query<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>access:</b>&nbsp;&nbsp;</td><td>public</td>
  </tr>
</table>
</div>
<br /><br />


        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
  <hr />
	<a name="methodselectDatabase"></a>
	<h3>method selectDatabase <span class="smalllinenumber">[line 89]</span></h3>
	<div class="function">
    <table width="90%" border="0" cellspacing="0" cellpadding="1"><tr><td class="code_border">
    <table width="100%" border="0" cellspacing="0" cellpadding="2"><tr><td class="code">
		<code>Bool selectDatabase(
String
$dbName)</code>
    </td></tr></table>
    </td></tr></table><br />
	
		Select the database to be used for the querying<br /><br /><br /><br />
<h4>Tags:</h4>
<div class="tags">
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><b>return:</b>&nbsp;&nbsp;</td><td>True/false depending on succes or failure</td>
  </tr>
</table>
</div>
<br /><br />


        <h4>Parameters:</h4>
    <div class="tags">
    <table border="0" cellspacing="0" cellpadding="0">
          <tr>
        <td class="type">String&nbsp;&nbsp;</td>
        <td><b>$dbName</b>&nbsp;&nbsp;</td>
        <td>Name of the database to be selected</td>
      </tr>
        </table>
    </div><br />
        <div class="top">[ <a href="#top">Top</a> ]</div>
  </div>
</div><br />


        <div class="credit">
		    <hr />
		    Documentation generated on Thu, 23 Jun 2005 17:46:20 +0200 by <a href="http://www.phpdoc.org">phpDocumentor 1.3.0RC3</a>
	      </div>
      </td></tr></table>
    </td>
  </tr>
</table>

</body>
</html>
Return current item: Table Data Management