Location: PHPKode > scripts > XS PHP Library > xs-php-library/doc/elementindex_db.html
<!DOCTYPE HTML PUBLIC '-//W3C//DTD HTML 4.0 Frameset//EN''http://www.w3.org/TR/REC-html40/frameset.dtd'>
<!--NewPage-->
<HTML>
<HEAD>
	<!-- Generated by PhpDoc date: 'Mon, 11 Nov 2002 23:45:39 +0100' -->
	<TITLE>Package db Element Index</TITLE>
<LINK REL ='stylesheet' TYPE='text/css' HREF='stylesheet.css' TITLE='Style'>
</HEAD>
<BODY BGCOLOR='white'>



<!-- Start of Class Data -->
<a name="{letter}">&nbsp; </a>
<H2>
	Element Index, Package db
</H2>
<a name="top">&nbsp; </a>
<b>Index of all elements:</b><br>
<a href="elementindex.html">Element Index</a><br>
<b>Indexes by package:</b><br>

<a href="elementindex_core.html">core</a><br>

<a href="elementindex_io.html">io</a><br>

<a href="elementindex_net.html">net</a><br>

<a href="elementindex_sess.html">sess</a><br>

<br>
<br>
<a href="#c">c</a> <a href="#d">d</a> <a href="#e">e</a> <a href="#f">f</a> <a href="#g">g</a> <a href="#i">i</a> <a href="#o">o</a> <a href="#q">q</a> <a href="#r">r</a> <a href="#s">s</a> <a href="#t">t</a> <a href="#_">_</a> <br>

<TABLE BORDER='1' CELLPADDING='3' CELLSPACING='0' WIDTH='100%'>
	<TR BGCOLOR="#FF6633" CLASS='TableHeadingColor' bordercolor=".">
		<TD>
			<FONT SIZE='+2'>Package db</FONT>
		</TD>
	</TR>
</TABLE>
<table border="0" width="100%">

<tr><td colspan = "2"><a name="_">&nbsp; </a>
<a href="#top">top</a><br>

<TABLE BORDER='1' CELLPADDING='3' CELLSPACING='0' WIDTH='100%'>
	<TR BGCOLOR='#CCCCFF' CLASS='TableHeadingColor'>
		<TD>
			<FONT SIZE='+2'><B>_</B></FONT>
		</TD>
	</TR>
</TABLE>
</td></tr>
	
	<tr><td><b>$_handle</b></td><td width="100%" align="left" valign="top">in file dbmysql.inc.php, variable <a href="db/DBBroker.html#$_handle">DBBroker::$_handle</a><br>&nbsp;&nbsp;&nbsp;&nbsp;Database connection handle.</td></tr>
	
	<tr><td><b>$_handle</b></td><td width="100%" align="left" valign="top">in file dbmysql.inc.php, variable <a href="db/DBQuery.html#$_handle">DBQuery::$_handle</a><br>&nbsp;&nbsp;&nbsp;&nbsp;The cursor handle.</td></tr>
	
	<tr><td><b>$_number</b></td><td width="100%" align="left" valign="top">in file dbmysql.inc.php, variable <a href="db/DBQuery.html#$_number">DBQuery::$_number</a><br>&nbsp;&nbsp;&nbsp;&nbsp;The current cursor position.</td></tr>
	
	<tr><td><b>$_params</b></td><td width="100%" align="left" valign="top">in file dbmysql.inc.php, variable <a href="db/DBBroker.html#$_params">DBBroker::$_params</a><br>&nbsp;&nbsp;&nbsp;&nbsp;Database connection params.</td></tr>
	
	<tr><td><b>$_params</b></td><td width="100%" align="left" valign="top">in file dbmysql.inc.php, variable <a href="db/DBQuery.html#$_params">DBQuery::$_params</a><br>&nbsp;&nbsp;&nbsp;&nbsp;SQL statement param orginal values.</td></tr>
	
	<tr><td><b>$_query</b></td><td width="100%" align="left" valign="top">in file dbmysql.inc.php, variable <a href="db/DBQuery.html#$_query">DBQuery::$_query</a><br>&nbsp;&nbsp;&nbsp;&nbsp;The SQL statement.</td></tr>
	
	<tr><td><b>$_values</b></td><td width="100%" align="left" valign="top">in file dbmysql.inc.php, variable <a href="db/DBQuery.html#$_values">DBQuery::$_values</a><br>&nbsp;&nbsp;&nbsp;&nbsp;SQL statement param prepared for parse.</td></tr>
	

<tr><td colspan = "2"><a name="c">&nbsp; </a>
<a href="#top">top</a><br>

<TABLE BORDER='1' CELLPADDING='3' CELLSPACING='0' WIDTH='100%'>
	<TR BGCOLOR='#CCCCFF' CLASS='TableHeadingColor'>
		<TD>
			<FONT SIZE='+2'><B>c</B></FONT>
		</TD>
	</TR>
</TABLE>
</td></tr>
	
	<tr><td><b>close</b></td><td width="100%" align="left" valign="top">in file dbmysql.inc.php, method <a href="db/DBQuery.html#close">DBQuery::close()</a><br>&nbsp;&nbsp;&nbsp;&nbsp;Closes cursor.</td></tr>
	
	<tr><td><b>close</b></td><td width="100%" align="left" valign="top">in file dbmysql.inc.php, method <a href="db/DBBroker.html#close">DBBroker::close()</a><br>&nbsp;&nbsp;&nbsp;&nbsp;Closes database connection.</td></tr>
	

<tr><td colspan = "2"><a name="d">&nbsp; </a>
<a href="#top">top</a><br>

<TABLE BORDER='1' CELLPADDING='3' CELLSPACING='0' WIDTH='100%'>
	<TR BGCOLOR='#CCCCFF' CLASS='TableHeadingColor'>
		<TD>
			<FONT SIZE='+2'><B>d</B></FONT>
		</TD>
	</TR>
</TABLE>
</td></tr>
	
	<tr><td><b>DBBroker</b></td><td width="100%" align="left" valign="top">in file dbmysql.inc.php, method <a href="db/DBBroker.html#DBBroker">DBBroker::DBBroker()</a><br>&nbsp;&nbsp;&nbsp;&nbsp;DBBroker class constructor.</td></tr>
	
	<tr><td><b>DBBroker</b></td><td width="100%" align="left" valign="top">in file dbmysql.inc.php, class <a href="db/DBBroker.html">DBBroker</a><br>&nbsp;&nbsp;&nbsp;&nbsp;Database broker class for MySQL database.</td></tr>
	
	<tr><td><b>DBError</b></td><td width="100%" align="left" valign="top">in file dbmysql.inc.php, method <a href="db/DBError.html#DBError">DBError::DBError()</a><br>&nbsp;&nbsp;&nbsp;&nbsp;Error class constructor.</td></tr>
	
	<tr><td><b>DBError</b></td><td width="100%" align="left" valign="top">in file dbmysql.inc.php, class <a href="db/DBError.html">DBError</a><br>&nbsp;&nbsp;&nbsp;&nbsp;DBError implements a class for reporting database error messages.</td></tr>
	
	<tr><td><b>dbmysql.inc.php</b></td><td width="100%" align="left" valign="top">procedural page <a href="db/_dbmysql_inc_php.html">dbmysql.inc.php</a></td></tr>
	
	<tr><td><b>DBQuery</b></td><td width="100%" align="left" valign="top">in file dbmysql.inc.php, method <a href="db/DBQuery.html#DBQuery">DBQuery::DBQuery()</a><br>&nbsp;&nbsp;&nbsp;&nbsp;DBQuery class constructor.</td></tr>
	
	<tr><td><b>DBQuery</b></td><td width="100%" align="left" valign="top">in file dbmysql.inc.php, class <a href="db/DBQuery.html">DBQuery</a><br>&nbsp;&nbsp;&nbsp;&nbsp;Advanced database query class.</td></tr>
	

<tr><td colspan = "2"><a name="e">&nbsp; </a>
<a href="#top">top</a><br>

<TABLE BORDER='1' CELLPADDING='3' CELLSPACING='0' WIDTH='100%'>
	<TR BGCOLOR='#CCCCFF' CLASS='TableHeadingColor'>
		<TD>
			<FONT SIZE='+2'><B>e</B></FONT>
		</TD>
	</TR>
</TABLE>
</td></tr>
	
	<tr><td><b>execute</b></td><td width="100%" align="left" valign="top">in file dbmysql.inc.php, method <a href="db/DBQuery.html#execute">DBQuery::execute()</a><br>&nbsp;&nbsp;&nbsp;&nbsp;Executes the query.</td></tr>
	

<tr><td colspan = "2"><a name="f">&nbsp; </a>
<a href="#top">top</a><br>

<TABLE BORDER='1' CELLPADDING='3' CELLSPACING='0' WIDTH='100%'>
	<TR BGCOLOR='#CCCCFF' CLASS='TableHeadingColor'>
		<TD>
			<FONT SIZE='+2'><B>f</B></FONT>
		</TD>
	</TR>
</TABLE>
</td></tr>
	
	<tr><td><b>fetchRow</b></td><td width="100%" align="left" valign="top">in file dbmysql.inc.php, method <a href="db/DBQuery.html#fetchRow">DBQuery::fetchRow()</a><br>&nbsp;&nbsp;&nbsp;&nbsp;Retrieves the specified row from the cursor.</td></tr>
	
	<tr><td><b>fieldCount</b></td><td width="100%" align="left" valign="top">in file dbmysql.inc.php, method <a href="db/DBQuery.html#fieldCount">DBQuery::fieldCount()</a><br>&nbsp;&nbsp;&nbsp;&nbsp;Retrieves the cursor field count.</td></tr>
	
	<tr><td><b>fieldNames</b></td><td width="100%" align="left" valign="top">in file dbmysql.inc.php, method <a href="db/DBQuery.html#fieldNames">DBQuery::fieldNames()</a><br>&nbsp;&nbsp;&nbsp;&nbsp;Retrieves the cursor field names.</td></tr>
	

<tr><td colspan = "2"><a name="g">&nbsp; </a>
<a href="#top">top</a><br>

<TABLE BORDER='1' CELLPADDING='3' CELLSPACING='0' WIDTH='100%'>
	<TR BGCOLOR='#CCCCFF' CLASS='TableHeadingColor'>
		<TD>
			<FONT SIZE='+2'><B>g</B></FONT>
		</TD>
	</TR>
</TABLE>
</td></tr>
	
	<tr><td><b>getHandle</b></td><td width="100%" align="left" valign="top">in file dbmysql.inc.php, method <a href="db/DBBroker.html#getHandle">DBBroker::getHandle()</a><br>&nbsp;&nbsp;&nbsp;&nbsp;Gets database connection handle.</td></tr>
	
	<tr><td><b>getHandle</b></td><td width="100%" align="left" valign="top">in file dbmysql.inc.php, method <a href="db/DBQuery.html#getHandle">DBQuery::getHandle()</a><br>&nbsp;&nbsp;&nbsp;&nbsp;Gets the cursor handle.</td></tr>
	
	<tr><td><b>getParam</b></td><td width="100%" align="left" valign="top">in file dbmysql.inc.php, method <a href="db/DBBroker.html#getParam">DBBroker::getParam()</a><br>&nbsp;&nbsp;&nbsp;&nbsp;Gets the database connection param.</td></tr>
	
	<tr><td><b>getParam</b></td><td width="100%" align="left" valign="top">in file dbmysql.inc.php, method <a href="db/DBQuery.html#getParam">DBQuery::getParam()</a><br>&nbsp;&nbsp;&nbsp;&nbsp;Gets the SQL statement variable.</td></tr>
	
	<tr><td><b>getQuery</b></td><td width="100%" align="left" valign="top">in file dbmysql.inc.php, method <a href="db/DBQuery.html#getQuery">DBQuery::getQuery()</a><br>&nbsp;&nbsp;&nbsp;&nbsp;Gets the SQL statement.</td></tr>
	

<tr><td colspan = "2"><a name="i">&nbsp; </a>
<a href="#top">top</a><br>

<TABLE BORDER='1' CELLPADDING='3' CELLSPACING='0' WIDTH='100%'>
	<TR BGCOLOR='#CCCCFF' CLASS='TableHeadingColor'>
		<TD>
			<FONT SIZE='+2'><B>i</B></FONT>
		</TD>
	</TR>
</TABLE>
</td></tr>
	
	<tr><td><b>isEmpty</b></td><td width="100%" align="left" valign="top">in file dbmysql.inc.php, method <a href="db/DBQuery.html#isEmpty">DBQuery::isEmpty()</a><br>&nbsp;&nbsp;&nbsp;&nbsp;Finds whether the last query returned or affected any rows.</td></tr>
	
	<tr><td><b>isOpened</b></td><td width="100%" align="left" valign="top">in file dbmysql.inc.php, method <a href="db/DBQuery.html#isOpened">DBQuery::isOpened()</a><br>&nbsp;&nbsp;&nbsp;&nbsp;Finds whether the cursor is opened.</td></tr>
	
	<tr><td><b>isOpened</b></td><td width="100%" align="left" valign="top">in file dbmysql.inc.php, method <a href="db/DBBroker.html#isOpened">DBBroker::isOpened()</a><br>&nbsp;&nbsp;&nbsp;&nbsp;Finds whether the database connection is opened.</td></tr>
	

<tr><td colspan = "2"><a name="o">&nbsp; </a>
<a href="#top">top</a><br>

<TABLE BORDER='1' CELLPADDING='3' CELLSPACING='0' WIDTH='100%'>
	<TR BGCOLOR='#CCCCFF' CLASS='TableHeadingColor'>
		<TD>
			<FONT SIZE='+2'><B>o</B></FONT>
		</TD>
	</TR>
</TABLE>
</td></tr>
	
	<tr><td><b>open</b></td><td width="100%" align="left" valign="top">in file dbmysql.inc.php, method <a href="db/DBQuery.html#open">DBQuery::open()</a><br>&nbsp;&nbsp;&nbsp;&nbsp;Opens cursor.</td></tr>
	
	<tr><td><b>open</b></td><td width="100%" align="left" valign="top">in file dbmysql.inc.php, method <a href="db/DBBroker.html#open">DBBroker::open()</a><br>&nbsp;&nbsp;&nbsp;&nbsp;Opens database connection.</td></tr>
	

<tr><td colspan = "2"><a name="q">&nbsp; </a>
<a href="#top">top</a><br>

<TABLE BORDER='1' CELLPADDING='3' CELLSPACING='0' WIDTH='100%'>
	<TR BGCOLOR='#CCCCFF' CLASS='TableHeadingColor'>
		<TD>
			<FONT SIZE='+2'><B>q</B></FONT>
		</TD>
	</TR>
</TABLE>
</td></tr>
	
	<tr><td><b>query</b></td><td width="100%" align="left" valign="top">in file dbmysql.inc.php, method <a href="db/DBBroker.html#query">DBBroker::query()</a><br>&nbsp;&nbsp;&nbsp;&nbsp;Performs database query.</td></tr>
	

<tr><td colspan = "2"><a name="r">&nbsp; </a>
<a href="#top">top</a><br>

<TABLE BORDER='1' CELLPADDING='3' CELLSPACING='0' WIDTH='100%'>
	<TR BGCOLOR='#CCCCFF' CLASS='TableHeadingColor'>
		<TD>
			<FONT SIZE='+2'><B>r</B></FONT>
		</TD>
	</TR>
</TABLE>
</td></tr>
	
	<tr><td><b>rowCount</b></td><td width="100%" align="left" valign="top">in file dbmysql.inc.php, method <a href="db/DBQuery.html#rowCount">DBQuery::rowCount()</a><br>&nbsp;&nbsp;&nbsp;&nbsp;Retrieves the cursor row count.</td></tr>
	
	<tr><td><b>rowNumber</b></td><td width="100%" align="left" valign="top">in file dbmysql.inc.php, method <a href="db/DBQuery.html#rowNumber">DBQuery::rowNumber()</a><br>&nbsp;&nbsp;&nbsp;&nbsp;Retrieves the current cursor position.</td></tr>
	

<tr><td colspan = "2"><a name="s">&nbsp; </a>
<a href="#top">top</a><br>

<TABLE BORDER='1' CELLPADDING='3' CELLSPACING='0' WIDTH='100%'>
	<TR BGCOLOR='#CCCCFF' CLASS='TableHeadingColor'>
		<TD>
			<FONT SIZE='+2'><B>s</B></FONT>
		</TD>
	</TR>
</TABLE>
</td></tr>
	
	<tr><td><b>setParam</b></td><td width="100%" align="left" valign="top">in file dbmysql.inc.php, method <a href="db/DBBroker.html#setParam">DBBroker::setParam()</a><br>&nbsp;&nbsp;&nbsp;&nbsp;Sets the database connection param.</td></tr>
	
	<tr><td><b>setParam</b></td><td width="100%" align="left" valign="top">in file dbmysql.inc.php, method <a href="db/DBQuery.html#setParam">DBQuery::setParam()</a><br>&nbsp;&nbsp;&nbsp;&nbsp;Sets the SQL statement variable.</td></tr>
	
	<tr><td><b>setQuery</b></td><td width="100%" align="left" valign="top">in file dbmysql.inc.php, method <a href="db/DBQuery.html#setQuery">DBQuery::setQuery()</a><br>&nbsp;&nbsp;&nbsp;&nbsp;Sets the SQL statement.</td></tr>
	

<tr><td colspan = "2"><a name="t">&nbsp; </a>
<a href="#top">top</a><br>

<TABLE BORDER='1' CELLPADDING='3' CELLSPACING='0' WIDTH='100%'>
	<TR BGCOLOR='#CCCCFF' CLASS='TableHeadingColor'>
		<TD>
			<FONT SIZE='+2'><B>t</B></FONT>
		</TD>
	</TR>
</TABLE>
</td></tr>
	
	<tr><td><b>tableCount</b></td><td width="100%" align="left" valign="top">in file dbmysql.inc.php, method <a href="db/DBBroker.html#tableCount">DBBroker::tableCount()</a><br>&nbsp;&nbsp;&nbsp;&nbsp;Retrieves the table count in the database.</td></tr>
	
	<tr><td><b>tableNames</b></td><td width="100%" align="left" valign="top">in file dbmysql.inc.php, method <a href="db/DBBroker.html#tableNames">DBBroker::tableNames()</a><br>&nbsp;&nbsp;&nbsp;&nbsp;Retrieves the table names in the database.</td></tr>
	

</table>
</HTML>
Return current item: XS PHP Library