ADDOBE数据库通用接口之ibase TITLE> <META content="text/html; charset=gb2312" http-equiv=Content-Type> <META content="linux php mysql html oso open source 开放源代码网页设计主页空间" name=Keyword> <META content="" name=Author> <SCRIPT language=JavaScript src="ADDOBE数据库通用接口之ibase.files/x.js"></SCRIPT> <LINK href="ADDOBE数据库通用接口之ibase.files/style.css" rel=STYLESHEET type=text/css> <META content="MSHTML 5.00.2920.0" name=GENERATOR></HEAD> <BODY bgColor=#ffffff leftMargin=0 topMargin=5> <TABLE align=center bgColor=#000000 border=0 cellPadding=0 cellSpacing=0 height=1 width=750> <TBODY> <TR> <TD></TD></TR></TBODY></TABLE> <TABLE align=center border=0 cellPadding=0 cellSpacing=0 class=body_br width=750> <TBODY> <TR> <TD vAlign=top> <TABLE align=center border=0 cellPadding=0 cellSpacing=0 width=680> <TBODY> <TR> <TD align=middle><BR> <H1 align="center">ADDOBE数据库通用接口之ibase</H1> <B> </B></TD> </TR></TBODY></TABLE> <TABLE align=center border=0 cellPadding=10 cellSpacing=0 width=680> <TBODY> <TR> <TD class=mid> <CODE><FONT color=#000000><FONT color=#0000bb><?php <BR> </FONT><FONT color=#ff8000>/* <BR>V0.94 04 Feb 2001 (c) 2000, 2001 John Lim (jlim@natsoft.com.my). All rights reserved. Released under Lesser GPL library license. See License.txt. <BR><BR> Latest version is available at http://php.weblogs.com/ <BR> <BR> Interbase data driver. Requires interbase client. Works on Windows and Unix. <BR><BR> 3 Jan 2001 -- suggestions by Hans-Peter Oeri <kampfcaspar75@oeri.ch> <BR> changed transaction handling and added experimental blob stuff <BR> <BR> Docs to interbase at the website <BR> http://www.synectics.co.za/php3/tutorial/IB_PHP3_API.html <BR>*/ <BR><BR></FONT><FONT color=#007700>class </FONT><FONT color=#0000bb>ADODB_ibase </FONT><FONT color=#007700>extends </FONT><FONT color=#0000bb>ADODBConnection </FONT><FONT color=#007700>{ <BR> var </FONT><FONT color=#0000bb>$databaseType </FONT><FONT color=#007700>= </FONT><FONT color=#dd0000>"ibase"</FONT><FONT color=#007700>; <BR> var </FONT><FONT color=#0000bb>$replaceQuote </FONT><FONT color=#007700>= </FONT><FONT color=#dd0000>"'"</FONT><FONT color=#007700>; </FONT><FONT color=#ff8000>// string to use to replace quotes <BR> </FONT><FONT color=#007700>var </FONT><FONT color=#0000bb>$fmtDate </FONT><FONT color=#007700>= </FONT><FONT color=#dd0000>"'Y-m-d'"</FONT><FONT color=#007700>; <BR> var </FONT><FONT color=#0000bb>$fmtTimeStamp </FONT><FONT color=#007700>= </FONT><FONT color=#dd0000>"'Y-m-d, h:i:sA'"</FONT><FONT color=#007700>; <BR> var </FONT><FONT color=#0000bb>$concat_operator</FONT><FONT color=#007700>=</FONT><FONT color=#dd0000>'||'</FONT><FONT color=#007700>; <BR> var </FONT><FONT color=#0000bb>$_transactionID</FONT><FONT color=#007700>; <BR> var </FONT><FONT color=#0000bb>$metaTablesSQL </FONT><FONT color=#007700>= </FONT><FONT color=#dd0000>"select rdb$relation_name from rdb$relations where rdb$relation_name not like 'RDB</FONT><FONT color=#007700>$</FONT><FONT color=#dd0000>%'"</FONT><FONT color=#007700>; <BR> var </FONT><FONT color=#0000bb>$metaColumnsSQL </FONT><FONT color=#007700>= </FONT><FONT color=#dd0000>"select a.rdb$field_name,b.rdb$field_type,b.rdb$field_length from rdb$relation_fields a join rdb$fields b on a.rdb$field_source=b.rdb$field_name where rdb$relation_name ='%s'"</FONT><FONT color=#007700>; <BR> var </FONT><FONT color=#0000bb>$ibasetrans </FONT><FONT color=#007700>= </FONT><FONT color=#0000bb>IBASE_DEFAULT</FONT><FONT color=#007700>; <BR><BR> <BR> function </FONT><FONT color=#0000bb>ADODB_ibase</FONT><FONT color=#007700>() { <BR> </FONT><FONT color=#0000bb>ibase_timefmt</FONT><FONT color=#007700>(</FONT><FONT color=#dd0000>'%Y-%m-%d'</FONT><FONT color=#007700>); <BR> } <BR><BR> function </FONT><FONT color=#0000bb>BeginTrans</FONT><FONT color=#007700>() <BR> { <BR> </FONT><FONT color=#ff8000>//return false; // currently not working properly <BR> <BR> </FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>autoCommit </FONT><FONT color=#007700>= </FONT><FONT color=#0000bb>false</FONT><FONT color=#007700>; <BR> </FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>_transactionID </FONT><FONT color=#007700>= </FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>_connectionID</FONT><FONT color=#007700>;</FONT><FONT color=#ff8000>//ibase_trans($this->ibasetrans, $this->_connectionID); <BR> </FONT><FONT color=#007700>return </FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>_transactionID</FONT><FONT color=#007700>; <BR> } <BR> <BR> function </FONT><FONT color=#0000bb>CommitTrans</FONT><FONT color=#007700>() <BR> { <BR> </FONT><FONT color=#0000bb>$ret </FONT><FONT color=#007700>= </FONT><FONT color=#0000bb>false</FONT><FONT color=#007700>; <BR> </FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>autoCommit </FONT><FONT color=#007700>= </FONT><FONT color=#0000bb>true</FONT><FONT color=#007700>; <BR> if (</FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>_transactionID</FONT><FONT color=#007700>) { <BR> </FONT><FONT color=#ff8000>//print ' commit '; <BR> </FONT><FONT color=#0000bb>$ret </FONT><FONT color=#007700>= </FONT><FONT color=#0000bb>ibase_commit</FONT><FONT color=#007700>(</FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>_transactionID</FONT><FONT color=#007700>); <BR> } <BR> </FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>_transactionID </FONT><FONT color=#007700>= </FONT><FONT color=#0000bb>false</FONT><FONT color=#007700>; <BR> return </FONT><FONT color=#0000bb>$ret</FONT><FONT color=#007700>; <BR> } <BR> <BR> function </FONT><FONT color=#0000bb>RollbackTrans</FONT><FONT color=#007700>() <BR> { <BR> </FONT><FONT color=#0000bb>$ret </FONT><FONT color=#007700>= </FONT><FONT color=#0000bb>false</FONT><FONT color=#007700>; <BR> </FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>autoCommit </FONT><FONT color=#007700>= </FONT><FONT color=#0000bb>true</FONT><FONT color=#007700>; <BR> if (</FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>_transactionID</FONT><FONT color=#007700>) <BR> </FONT><FONT color=#0000bb>$ret </FONT><FONT color=#007700>= </FONT><FONT color=#0000bb>ibase_rollback</FONT><FONT color=#007700>(</FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>_transactionID</FONT><FONT color=#007700>); <BR> </FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>_transactionID </FONT><FONT color=#007700>= </FONT><FONT color=#0000bb>false</FONT><FONT color=#007700>; <BR> <BR> return </FONT><FONT color=#0000bb>$ret</FONT><FONT color=#007700>; <BR> } <BR><BR> function </FONT><FONT color=#0000bb>SelectDB</FONT><FONT color=#007700>(</FONT><FONT color=#0000bb>$dbName</FONT><FONT color=#007700>) { <BR> return </FONT><FONT color=#0000bb>false</FONT><FONT color=#007700>; <BR> } <BR><BR> function </FONT><FONT color=#0000bb>_handleerror</FONT><FONT color=#007700>() <BR> { <BR> </FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>_errorMsg </FONT><FONT color=#007700>= </FONT><FONT color=#0000bb>ibase_errmsg</FONT><FONT color=#007700>(</FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>_connectionID</FONT><FONT color=#007700>); <BR> } <BR><BR> function </FONT><FONT color=#0000bb>ErrorNo</FONT><FONT color=#007700>() { <BR> if (</FONT><FONT color=#0000bb>preg_match</FONT><FONT color=#007700>(</FONT><FONT color=#dd0000>'/error code = ([-0-9]*)/i'</FONT><FONT color=#007700>, </FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>_errorMsg</FONT><FONT color=#007700>,</FONT><FONT color=#0000bb>$arr</FONT><FONT color=#007700>)) return (integer) </FONT><FONT color=#0000bb>$arr</FONT><FONT color=#007700>[</FONT><FONT color=#0000bb>1</FONT><FONT color=#007700>]; <BR> else return </FONT><FONT color=#0000bb>0</FONT><FONT color=#007700>; <BR> } <BR> <BR> function </FONT><FONT color=#0000bb>ErrorMsg</FONT><FONT color=#007700>() { <BR> return </FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>_errorMsg</FONT><FONT color=#007700>; <BR> } <BR> <BR> </FONT><FONT color=#ff8000>// returns true or false <BR> </FONT><FONT color=#007700>function </FONT><FONT color=#0000bb>_connect</FONT><FONT color=#007700>(</FONT><FONT color=#0000bb>$argHostname</FONT><FONT color=#007700>, </FONT><FONT color=#0000bb>$argUsername</FONT><FONT color=#007700>, </FONT><FONT color=#0000bb>$argPassword</FONT><FONT color=#007700>, </FONT><FONT color=#0000bb>$argDatabasename</FONT><FONT color=#007700>) <BR> { <BR> if (</FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>charSet</FONT><FONT color=#007700>) <BR> </FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>_connectionID </FONT><FONT color=#007700>= </FONT><FONT color=#0000bb>ibase_connect</FONT><FONT color=#007700>(</FONT><FONT color=#0000bb>$argHostname</FONT><FONT color=#007700>,</FONT><FONT color=#0000bb>$argUsername</FONT><FONT color=#007700>,</FONT><FONT color=#0000bb>$argPassword</FONT><FONT color=#007700>,</FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>charSet</FONT><FONT color=#007700>); <BR> else <BR> </FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>_connectionID </FONT><FONT color=#007700>= </FONT><FONT color=#0000bb>ibase_connect</FONT><FONT color=#007700>(</FONT><FONT color=#0000bb>$argHostname</FONT><FONT color=#007700>,</FONT><FONT color=#0000bb>$argUsername</FONT><FONT color=#007700>,</FONT><FONT color=#0000bb>$argPassword</FONT><FONT color=#007700>); <BR> <BR> if (</FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>_connectionID </FONT><FONT color=#007700>=== </FONT><FONT color=#0000bb>false</FONT><FONT color=#007700>) { <BR> </FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>_handleerror</FONT><FONT color=#007700>(); <BR> return </FONT><FONT color=#0000bb>false</FONT><FONT color=#007700>; <BR> } <BR> <BR> return </FONT><FONT color=#0000bb>true</FONT><FONT color=#007700>; <BR> } <BR> </FONT><FONT color=#ff8000>// returns true or false <BR> </FONT><FONT color=#007700>function </FONT><FONT color=#0000bb>_pconnect</FONT><FONT color=#007700>(</FONT><FONT color=#0000bb>$argHostname</FONT><FONT color=#007700>, </FONT><FONT color=#0000bb>$argUsername</FONT><FONT color=#007700>, </FONT><FONT color=#0000bb>$argPassword</FONT><FONT color=#007700>, </FONT><FONT color=#0000bb>$argDatabasename</FONT><FONT color=#007700>) <BR> { <BR> if (</FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>charSet</FONT><FONT color=#007700>) <BR> </FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>_connectionID </FONT><FONT color=#007700>= </FONT><FONT color=#0000bb>ibase_pconnect</FONT><FONT color=#007700>(</FONT><FONT color=#0000bb>$argHostname</FONT><FONT color=#007700>,</FONT><FONT color=#0000bb>$argUsername</FONT><FONT color=#007700>,</FONT><FONT color=#0000bb>$argPassword</FONT><FONT color=#007700>,</FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>charSet</FONT><FONT color=#007700>); <BR> else <BR> </FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>_connectionID </FONT><FONT color=#007700>= </FONT><FONT color=#0000bb>ibase_pconnect</FONT><FONT color=#007700>(</FONT><FONT color=#0000bb>$argHostname</FONT><FONT color=#007700>,</FONT><FONT color=#0000bb>$argUsername</FONT><FONT color=#007700>,</FONT><FONT color=#0000bb>$argPassword</FONT><FONT color=#007700>); <BR> <BR> if (</FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>_connectionID </FONT><FONT color=#007700>=== </FONT><FONT color=#0000bb>false</FONT><FONT color=#007700>) { <BR> </FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>_handleerror</FONT><FONT color=#007700>(); <BR> return </FONT><FONT color=#0000bb>false</FONT><FONT color=#007700>; <BR> } <BR> <BR> return </FONT><FONT color=#0000bb>true</FONT><FONT color=#007700>; <BR> } <BR><BR> </FONT><FONT color=#ff8000>// returns query ID if successful, otherwise false <BR> </FONT><FONT color=#007700>function </FONT><FONT color=#0000bb>_query</FONT><FONT color=#007700>(</FONT><FONT color=#0000bb>$sql</FONT><FONT color=#007700>,</FONT><FONT color=#0000bb>$inputarr</FONT><FONT color=#007700>) <BR> { <BR> if (!</FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>autoCommit </FONT><FONT color=#007700>&& </FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>_transactionID</FONT><FONT color=#007700>) { <BR> </FONT><FONT color=#0000bb>$ret </FONT><FONT color=#007700>= </FONT><FONT color=#0000bb>ibase_query</FONT><FONT color=#007700>(</FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>_transactionID</FONT><FONT color=#007700>,</FONT><FONT color=#0000bb>$sql</FONT><FONT color=#007700>); <BR> } else { <BR> </FONT><FONT color=#0000bb>$ret </FONT><FONT color=#007700>= </FONT><FONT color=#0000bb>ibase_query</FONT><FONT color=#007700>(</FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>_connectionID</FONT><FONT color=#007700>,</FONT><FONT color=#0000bb>$sql</FONT><FONT color=#007700>); <BR> if (</FONT><FONT color=#0000bb>$ret </FONT><FONT color=#007700>=== </FONT><FONT color=#0000bb>true</FONT><FONT color=#007700>) </FONT><FONT color=#0000bb>ibase_commit</FONT><FONT color=#007700>(</FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>_connectionID</FONT><FONT color=#007700>); <BR> } <BR> </FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>_handleerror</FONT><FONT color=#007700>(); <BR> return </FONT><FONT color=#0000bb>$ret</FONT><FONT color=#007700>; <BR> } <BR><BR> </FONT><FONT color=#ff8000>// returns true or false <BR> </FONT><FONT color=#007700>function </FONT><FONT color=#0000bb>_close</FONT><FONT color=#007700>() <BR> { <BR> if (</FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>autoCommit</FONT><FONT color=#007700>) </FONT><FONT color=#0000bb>ibase_commit</FONT><FONT color=#007700>(</FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>_connectionID</FONT><FONT color=#007700>); <BR> else </FONT><FONT color=#0000bb>ibase_rollback</FONT><FONT color=#007700>(</FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>_connectionID</FONT><FONT color=#007700>); <BR> <BR> return @</FONT><FONT color=#0000bb>ibase_close</FONT><FONT color=#007700>(</FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>_connectionID</FONT><FONT color=#007700>); <BR> } <BR> <BR> </FONT><FONT color=#ff8000>// returns array of ADODBFieldObjects for current table <BR> </FONT><FONT color=#007700>function &</FONT><FONT color=#0000bb>MetaColumns</FONT><FONT color=#007700>(</FONT><FONT color=#0000bb>$table</FONT><FONT color=#007700>) <BR> { <BR> <BR> if (</FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>metaColumnsSQL</FONT><FONT color=#007700>) { <BR> <BR> </FONT><FONT color=#0000bb>$rs </FONT><FONT color=#007700>= </FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>Execute</FONT><FONT color=#007700>(</FONT><FONT color=#0000bb>sprintf</FONT><FONT color=#007700>(</FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>metaColumnsSQL</FONT><FONT color=#007700>,</FONT><FONT color=#0000bb>strtoupper</FONT><FONT color=#007700>(</FONT><FONT color=#0000bb>$table</FONT><FONT color=#007700>))); <BR> if (</FONT><FONT color=#0000bb>$rs </FONT><FONT color=#007700>=== </FONT><FONT color=#0000bb>false</FONT><FONT color=#007700>) return </FONT><FONT color=#0000bb>false</FONT><FONT color=#007700>; <BR><BR> </FONT><FONT color=#0000bb>$retarr </FONT><FONT color=#007700>= array(); <BR> while (!</FONT><FONT color=#0000bb>$rs</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>EOF</FONT><FONT color=#007700>) { </FONT><FONT color=#ff8000>//print_r($rs->fields); <BR> </FONT><FONT color=#0000bb>$fld </FONT><FONT color=#007700>= new </FONT><FONT color=#0000bb>ADODBFieldObject</FONT><FONT color=#007700>(); <BR> </FONT><FONT color=#0000bb>$fld</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>name </FONT><FONT color=#007700>= </FONT><FONT color=#0000bb>$rs</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>fields</FONT><FONT color=#007700>[</FONT><FONT color=#0000bb>0</FONT><FONT color=#007700>]; <BR> </FONT><FONT color=#0000bb>$tt </FONT><FONT color=#007700>= </FONT><FONT color=#0000bb>$rs</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>fields</FONT><FONT color=#007700>[</FONT><FONT color=#0000bb>1</FONT><FONT color=#007700>]; <BR> switch(</FONT><FONT color=#0000bb>$tt</FONT><FONT color=#007700>) <BR> { <BR> case </FONT><FONT color=#0000bb>7</FONT><FONT color=#007700>: <BR> case </FONT><FONT color=#0000bb>8</FONT><FONT color=#007700>: <BR> case </FONT><FONT color=#0000bb>9</FONT><FONT color=#007700>:</FONT><FONT color=#0000bb>$tt </FONT><FONT color=#007700>= </FONT><FONT color=#dd0000>'INTEGER'</FONT><FONT color=#007700>; break; <BR> case </FONT><FONT color=#0000bb>10</FONT><FONT color=#007700>: <BR> case </FONT><FONT color=#0000bb>27</FONT><FONT color=#007700>: <BR> case </FONT><FONT color=#0000bb>11</FONT><FONT color=#007700>:</FONT><FONT color=#0000bb>$tt </FONT><FONT color=#007700>= </FONT><FONT color=#dd0000>'FLOAT'</FONT><FONT color=#007700>; break; <BR> default: <BR> case </FONT><FONT color=#0000bb>40</FONT><FONT color=#007700>: <BR> case </FONT><FONT color=#0000bb>14</FONT><FONT color=#007700>:</FONT><FONT color=#0000bb>$tt </FONT><FONT color=#007700>= </FONT><FONT color=#dd0000>'CHAR'</FONT><FONT color=#007700>; break; <BR> case </FONT><FONT color=#0000bb>35</FONT><FONT color=#007700>:</FONT><FONT color=#0000bb>$tt </FONT><FONT color=#007700>= </FONT><FONT color=#dd0000>'DATE'</FONT><FONT color=#007700>; break; <BR> case </FONT><FONT color=#0000bb>37</FONT><FONT color=#007700>:</FONT><FONT color=#0000bb>$tt </FONT><FONT color=#007700>= </FONT><FONT color=#dd0000>'VARCHAR'</FONT><FONT color=#007700>; break; <BR> case </FONT><FONT color=#0000bb>261</FONT><FONT color=#007700>:</FONT><FONT color=#0000bb>$tt </FONT><FONT color=#007700>= </FONT><FONT color=#dd0000>'BLOB'</FONT><FONT color=#007700>; break; <BR> case </FONT><FONT color=#0000bb>13</FONT><FONT color=#007700>: <BR> case </FONT><FONT color=#0000bb>35</FONT><FONT color=#007700>:</FONT><FONT color=#0000bb>$tt </FONT><FONT color=#007700>= </FONT><FONT color=#dd0000>'TIMESTAMP'</FONT><FONT color=#007700>; break; <BR> } <BR> </FONT><FONT color=#0000bb>$fld</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>type </FONT><FONT color=#007700>= </FONT><FONT color=#0000bb>$tt</FONT><FONT color=#007700>; <BR> </FONT><FONT color=#0000bb>$fld</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>max_length </FONT><FONT color=#007700>= </FONT><FONT color=#0000bb>$rs</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>fields</FONT><FONT color=#007700>[</FONT><FONT color=#0000bb>2</FONT><FONT color=#007700>]; <BR> </FONT><FONT color=#0000bb>$retarr</FONT><FONT color=#007700>[</FONT><FONT color=#0000bb>strtoupper</FONT><FONT color=#007700>(</FONT><FONT color=#0000bb>$fld</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>name</FONT><FONT color=#007700>)] = </FONT><FONT color=#0000bb>$fld</FONT><FONT color=#007700>; <BR> <BR> </FONT><FONT color=#0000bb>$rs</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>MoveNext</FONT><FONT color=#007700>(); <BR> } <BR> </FONT><FONT color=#0000bb>$rs</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>Close</FONT><FONT color=#007700>(); <BR> return </FONT><FONT color=#0000bb>$retarr</FONT><FONT color=#007700>; <BR> } <BR> return </FONT><FONT color=#0000bb>false</FONT><FONT color=#007700>; <BR> } <BR> <BR> </FONT><FONT color=#ff8000>// warning - this code is experimental and might not be available in the future <BR> </FONT><FONT color=#007700>function &</FONT><FONT color=#0000bb>BlobEncode</FONT><FONT color=#007700>( &</FONT><FONT color=#0000bb>$blob </FONT><FONT color=#007700>) <BR> { <BR> </FONT><FONT color=#0000bb>$blobid </FONT><FONT color=#007700>= </FONT><FONT color=#0000bb>ibase_blob_create</FONT><FONT color=#007700>( </FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>_connectionID</FONT><FONT color=#007700>); <BR> </FONT><FONT color=#0000bb>ibase_blob_add</FONT><FONT color=#007700>( </FONT><FONT color=#0000bb>$blobid</FONT><FONT color=#007700>, </FONT><FONT color=#0000bb>$blob </FONT><FONT color=#007700>); <BR> </FONT><FONT color=#0000bb>$blobidstr </FONT><FONT color=#007700>= </FONT><FONT color=#0000bb>ibase_blob_close</FONT><FONT color=#007700>( </FONT><FONT color=#0000bb>$blobid </FONT><FONT color=#007700>); <BR><BR> return( </FONT><FONT color=#0000bb>$blobidstr </FONT><FONT color=#007700>); <BR> } <BR> <BR> </FONT><FONT color=#ff8000>// warning - this code is experimental and might not be available in the future <BR> </FONT><FONT color=#007700>function &</FONT><FONT color=#0000bb>BlobDecode</FONT><FONT color=#007700>( &</FONT><FONT color=#0000bb>$blob </FONT><FONT color=#007700>) <BR> { <BR> </FONT><FONT color=#0000bb>$blobid </FONT><FONT color=#007700>= </FONT><FONT color=#0000bb>ibase_blob_open</FONT><FONT color=#007700>( </FONT><FONT color=#0000bb>$blob </FONT><FONT color=#007700>); <BR> </FONT><FONT color=#0000bb>$realblob </FONT><FONT color=#007700>= </FONT><FONT color=#0000bb>ibase_blob_get</FONT><FONT color=#007700>( </FONT><FONT color=#0000bb>$blobid </FONT><FONT color=#007700>); <BR> </FONT><FONT color=#0000bb>ibase_blob_close</FONT><FONT color=#007700>( </FONT><FONT color=#0000bb>$blobid </FONT><FONT color=#007700>); <BR><BR> return( </FONT><FONT color=#0000bb>$realblob </FONT><FONT color=#007700>); <BR> } <BR>} <BR><BR></FONT><FONT color=#ff8000>/*-------------------------------------------------------------------------------------- <BR> Class Name: Recordset <BR>--------------------------------------------------------------------------------------*/ <BR><BR></FONT><FONT color=#007700>class </FONT><FONT color=#0000bb>ADORecordset_ibase </FONT><FONT color=#007700>extends </FONT><FONT color=#0000bb>ADORecordSet <BR></FONT><FONT color=#007700>{ <BR><BR> var </FONT><FONT color=#0000bb>$databaseType </FONT><FONT color=#007700>= </FONT><FONT color=#dd0000>"ibase"</FONT><FONT color=#007700>; <BR> var </FONT><FONT color=#0000bb>$bind</FONT><FONT color=#007700>=</FONT><FONT color=#0000bb>false</FONT><FONT color=#007700>; <BR> <BR> function </FONT><FONT color=#0000bb>ADORecordset_ibase</FONT><FONT color=#007700>(</FONT><FONT color=#0000bb>$id</FONT><FONT color=#007700>) <BR> { <BR> return </FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>ADORecordSet</FONT><FONT color=#007700>(</FONT><FONT color=#0000bb>$id</FONT><FONT color=#007700>); <BR> } <BR><BR> </FONT><FONT color=#ff8000>/* Returns: an object containing field information. <BR> Get column information in the Recordset object. fetchField() can be used in order to obtain information about <BR> fields in a certain query result. If the field offset isn't specified, the next field that wasn't yet retrieved by <BR> fetchField() is retrieved. */ <BR><BR> </FONT><FONT color=#007700>function </FONT><FONT color=#0000bb>FetchField</FONT><FONT color=#007700>(</FONT><FONT color=#0000bb>$fieldOffset </FONT><FONT color=#007700>= -</FONT><FONT color=#0000bb>1</FONT><FONT color=#007700>) <BR> { <BR> </FONT><FONT color=#0000bb>$fld </FONT><FONT color=#007700>= new </FONT><FONT color=#0000bb>ADODBFieldObject</FONT><FONT color=#007700>; <BR> </FONT><FONT color=#0000bb>$ibf </FONT><FONT color=#007700>= </FONT><FONT color=#0000bb>ibase_field_info</FONT><FONT color=#007700>(</FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>_queryID</FONT><FONT color=#007700>,</FONT><FONT color=#0000bb>$fieldOffset</FONT><FONT color=#007700>); <BR> </FONT><FONT color=#0000bb>$fld</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>name </FONT><FONT color=#007700>= </FONT><FONT color=#0000bb>$ibf</FONT><FONT color=#007700>[</FONT><FONT color=#dd0000>'name'</FONT><FONT color=#007700>]; <BR> </FONT><FONT color=#0000bb>$fld</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>type </FONT><FONT color=#007700>= </FONT><FONT color=#0000bb>$ibf</FONT><FONT color=#007700>[</FONT><FONT color=#dd0000>'type'</FONT><FONT color=#007700>]; <BR> </FONT><FONT color=#0000bb>$fld</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>max_length </FONT><FONT color=#007700>= </FONT><FONT color=#0000bb>$ibf</FONT><FONT color=#007700>[</FONT><FONT color=#dd0000>'length'</FONT><FONT color=#007700>]; <BR> if (</FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>debug</FONT><FONT color=#007700>) </FONT><FONT color=#0000bb>print_r</FONT><FONT color=#007700>(</FONT><FONT color=#0000bb>$fld</FONT><FONT color=#007700>); <BR> return </FONT><FONT color=#0000bb>$fld</FONT><FONT color=#007700>; <BR> } <BR><BR> function </FONT><FONT color=#0000bb>_initrs</FONT><FONT color=#007700>() <BR> { <BR> </FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>_numOfRows </FONT><FONT color=#007700>= -</FONT><FONT color=#0000bb>1</FONT><FONT color=#007700>; <BR> </FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>_numOfFields </FONT><FONT color=#007700>= @</FONT><FONT color=#0000bb>ibase_num_fields</FONT><FONT color=#007700>(</FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>_queryID</FONT><FONT color=#007700>); <BR> } <BR><BR> function </FONT><FONT color=#0000bb>_seek</FONT><FONT color=#007700>(</FONT><FONT color=#0000bb>$row</FONT><FONT color=#007700>) <BR> { <BR> return </FONT><FONT color=#0000bb>false</FONT><FONT color=#007700>; <BR> } <BR><BR> function </FONT><FONT color=#0000bb>_fetch</FONT><FONT color=#007700>(</FONT><FONT color=#0000bb>$ignore_fields</FONT><FONT color=#007700>=</FONT><FONT color=#0000bb>false</FONT><FONT color=#007700>) { <BR><BR> </FONT><FONT color=#0000bb>$f </FONT><FONT color=#007700>= </FONT><FONT color=#0000bb>ibase_fetch_row</FONT><FONT color=#007700>(</FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>_queryID</FONT><FONT color=#007700>); <BR> if (</FONT><FONT color=#0000bb>$f </FONT><FONT color=#007700>=== </FONT><FONT color=#0000bb>false</FONT><FONT color=#007700>) return </FONT><FONT color=#0000bb>false</FONT><FONT color=#007700>; <BR> </FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>fields </FONT><FONT color=#007700>= </FONT><FONT color=#0000bb>$f</FONT><FONT color=#007700>; <BR> return </FONT><FONT color=#0000bb>true</FONT><FONT color=#007700>; <BR> } <BR><BR> </FONT><FONT color=#ff8000>/* Use associative array to get fields array */ <BR> </FONT><FONT color=#007700>function </FONT><FONT color=#0000bb>Fields</FONT><FONT color=#007700>(</FONT><FONT color=#0000bb>$colname</FONT><FONT color=#007700>) <BR> { <BR> if (!</FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>bind</FONT><FONT color=#007700>) { <BR> </FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>bind </FONT><FONT color=#007700>= array(); <BR> for (</FONT><FONT color=#0000bb>$i</FONT><FONT color=#007700>=</FONT><FONT color=#0000bb>0</FONT><FONT color=#007700>; </FONT><FONT color=#0000bb>$i </FONT><FONT color=#007700>< </FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>_numOfFields</FONT><FONT color=#007700>; </FONT><FONT color=#0000bb>$i</FONT><FONT color=#007700>++) { <BR> </FONT><FONT color=#0000bb>$o </FONT><FONT color=#007700>= </FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>FetchField</FONT><FONT color=#007700>(</FONT><FONT color=#0000bb>$i</FONT><FONT color=#007700>); <BR> </FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>bind</FONT><FONT color=#007700>[</FONT><FONT color=#0000bb>strtoupper</FONT><FONT color=#007700>(</FONT><FONT color=#0000bb>$o</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>name</FONT><FONT color=#007700>)] = </FONT><FONT color=#0000bb>$i</FONT><FONT color=#007700>; <BR> } <BR> } <BR> <BR> return </FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>fields</FONT><FONT color=#007700>[</FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>bind</FONT><FONT color=#007700>[</FONT><FONT color=#0000bb>strtoupper</FONT><FONT color=#007700>(</FONT><FONT color=#0000bb>$colname</FONT><FONT color=#007700>)]]; <BR> <BR> } <BR> <BR> </FONT><FONT color=#ff8000>/* close() only needs to be called if you are worried about using too much memory while your script <BR> is running. All associated result memory for the specified result identifier will automatically be freed. */ <BR><BR> </FONT><FONT color=#007700>function </FONT><FONT color=#0000bb>_close</FONT><FONT color=#007700>() { <BR> return @</FONT><FONT color=#0000bb>ibase_free_result</FONT><FONT color=#007700>(</FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>_queryID</FONT><FONT color=#007700>); <BR> } <BR><BR> function </FONT><FONT color=#0000bb>MetaType</FONT><FONT color=#007700>(</FONT><FONT color=#0000bb>$t</FONT><FONT color=#007700>,</FONT><FONT color=#0000bb>$len</FONT><FONT color=#007700>=-</FONT><FONT color=#0000bb>1</FONT><FONT color=#007700>) <BR> { <BR> <BR> switch (</FONT><FONT color=#0000bb>strtoupper</FONT><FONT color=#007700>(</FONT><FONT color=#0000bb>$t</FONT><FONT color=#007700>)) { <BR> case </FONT><FONT color=#dd0000>'CHAR'</FONT><FONT color=#007700>: <BR> return </FONT><FONT color=#dd0000>'C'</FONT><FONT color=#007700>; <BR> <BR> case </FONT><FONT color=#dd0000>'BLOB'</FONT><FONT color=#007700>: <BR> case </FONT><FONT color=#dd0000>'TEXT'</FONT><FONT color=#007700>: <BR> case </FONT><FONT color=#dd0000>'VARCHAR'</FONT><FONT color=#007700>: <BR> case </FONT><FONT color=#dd0000>'VARYING'</FONT><FONT color=#007700>: <BR> if (</FONT><FONT color=#0000bb>$len </FONT><FONT color=#007700><= </FONT><FONT color=#0000bb>$this</FONT><FONT color=#007700>-></FONT><FONT color=#0000bb>blobSize</FONT><FONT color=#007700>) return </FONT><FONT color=#dd0000>'C'</FONT><FONT color=#007700>; <BR> return </FONT><FONT color=#dd0000>'B'</FONT><FONT color=#007700>; <BR> <BR> case </FONT><FONT color=#dd0000>'TIMESTAMP'</FONT><FONT color=#007700>: <BR> case </FONT><FONT color=#dd0000>'DATE'</FONT><FONT color=#007700>: return </FONT><FONT color=#dd0000>'D'</FONT><FONT color=#007700>; <BR> <BR> </FONT><FONT color=#ff8000>//case 'T': return 'T'; <BR><BR> //case 'L': return 'L'; <BR> </FONT><FONT color=#007700>case </FONT><FONT color=#dd0000>'INT'</FONT><FONT color=#007700>: <BR> case </FONT><FONT color=#dd0000>'SHORT'</FONT><FONT color=#007700>: <BR> case </FONT><FONT color=#dd0000>'INTEGER'</FONT><FONT color=#007700>: return </FONT><FONT color=#dd0000>'I'</FONT><FONT color=#007700>; <BR> default: return </FONT><FONT color=#dd0000>'N'</FONT><FONT color=#007700>; <BR> } <BR> } <BR>} <BR></FONT><FONT color=#0000bb>?></FONT> </FONT></CODE></TD></TR></TBODY></TABLE><BR> <BR> </TD></TR></TBODY></TABLE> </BODY></HTML>