[ Index ]
 

Code source de Mantis 1.1.0rc3

Accédez au Source d'autres logiciels libres

Classes | Fonctions | Variables | Constantes | Tables

title

Body

[fermer]

/core/adodb/docs/ -> docs-adodb.htm (sommaire)

(pas de description)

Poids: 3606 lignes (243 kb)
Inclus ou requis:0 fois
Référencé: 0 fois
Nécessite: 2 fichiers
 core/adodb/adodb-exceptions.inc.php
 core/adodb/adodb.inc.php

Définit 7 fonctions

  to()
  to()
  unless()
  CountExecs()
  CountCachedExecs()
  is()
  is()

Fonctions
Fonctions qui ne font pas partie d'une Classe:

to(property is set to true when end-of-file is reached. If an error occurs in Execute()   X-Ref
Pas de description

to(and ''Y-m-d'' for MySQL.</font></p><p><font><b>fmtTimeStamp: </b>The format used by the <b><a href="function to send timestamps to the database. </font></p><p><font><b>true</b>: The value used to represent true.Eg. '.T.'. for Foxpro, '1' for Microsoft SQL.</font></p><p><font><b>false: </b> The value used to represent false. Eg. '.F.'. for Foxpro, '0' for Microsoft SQL.</font></p><p><font><b>replaceQuote</b>: The string used to escape quotes. Eg. double single-quotes for Microsoft SQL, and backslash-quote for MySQL. Used by <a href="<p><font><b>autoCommit</b>: indicates whether automatic commit is enabled. Default is true.</font></p><p><font><b>charSet</b>: set the default charset to use. Currently only interbase/firebird supports this.</font></p><p><font><b>dialect</b>: set the default sql dialect to use. Currently only interbase/firebird supports this.</font></p><p><font><b>role</b>: set the role. Currently only interbase/firebird supports this.</font></p><p><font><b>metaTablesSQL</b>: SQL statement to return a list of available tables. Eg. <i>SHOW TABLES</i> in MySQL.</font></p><p><font><b>genID</b>: The latest id generated by GenID()   X-Ref
Pas de description

unless(<p><font><b>IgnoreErrors<a name="ignoreerrors"></a>($saveErrHandlers)   X-Ref
Pas de description

CountExecs($db, $sql, $inputarray)   X-Ref
Pas de description

CountCachedExecs($db, $secs2cache, $sql, $inputarray)   X-Ref
Pas de description

is(The function parameters match the Execute and CacheExecute functions respectively, except that $this (the connection object)   X-Ref
Pas de description

is(<p><font>_<b>connect</b>: Low level implementation of Connect.Returns true or false. Should set the _<b>connectionID</b>.</font></p><p><font>_<b>pconnect:</b> Low level implemention of PConnect.Returns true or false. Should set the _<b>connectionID</b>.</font></p><p><font>_<b>query</b>: Execute a query. Returns the queryID,or false.</font></p><p><font>_<b>close: </b>Close the connection -- PHP should cleanup all recordsets. </font></p><p><font><b>ErrorMsg</b>: Stores the error message in the privatevariable _errorMsg. </font></p><p><font><b>ADOConnection Fields to Set</b></font></p><p><font>_<b>bindInputArray</b>: Set to true if binding of parametersfor SQL inserts and updates is allowed using ?, eg. as with ODBC.</font></p><p><font><b>fmtDate</b></font></p><p><font><b>fmtTimeStamp</b></font></p><p><font><b>true</b></font></p><p><font><b>false</b></font></p><p><font><b>concat_operator</b></font></p><p><font><b>replaceQuote</b></font></p><p><font><b>hasLimit</b> support SELECT * FROM TABLE LIMIT 10of MySQL.</font></p><p><font><b>hasTop</b> support Microsoft style SELECT TOP 10* FROM TABLE.</font></p><p><font><b>ADORecordSet Functions to Override</b></font></p><p><font>You will need to define a constructor for your ADORecordSetderived class that calls the parent class constructor.</font></p><p><font><b>FetchField: </b> as documented above in ADORecordSet</font></p><p><font>_<b>initrs</b>: low level initialization of the recordset:setup the _<b>numOfRows</b> and _<b>numOfFields</b> fields -- called by theconstructor.</font></p><p><font>_<b>seek</b>: seek to a particular row. Do not loadthe data into the fields array. This is done by _fetch. Returns true or false.Note that some implementations such as Interbase do not support seek. SetcanSeek to false.</font></p><p><font>_<b>fetch</b>: fetch a row using the database extensionfunction and then move to the next row. Sets the <b>fields</b> array. Ifthe parameter $ignore_fields is true then there is no need to populate the <b>fields</b> array,just move to the next row. then Returns true or false.</font></p><p><font>_<b>close</b>: close the recordset</font></p><p><font><b>Fields</b>: If the array row returned by the PHPextension is not an associative one, you will have to override this. Seeadodb-odbc.inc.php for an example. For databases such as MySQL and MSSQLwhere an associative array is returned, there is no need to override thisfunction.</font></p><p><font><b>ADOConnection Fields to Set</b></font></p><p><font>canSeek: Set to true if the _seek function works.</font></p><h2><font>Optimizing PHP</font></h2>For info on tuning PHP, read this article on <a href="http:PHP</a>. </font></p><h2><font>Change Log<a name="Changes"></a><a name="changes"></a><a name="changelog"></a></font></h2><p><a name="4.96"></a><b>4.96/5.02 ? ? 2007</b><p>Fix adodb count optimisation. Preg_match did not work properly.<p>SelectLimit for oci8 not optimal for large recordsets when offset=0. Changed $nrows check.<p>Rewrote the ORDER BY stripping code in _adodb_getcount()   X-Ref
Pas de description



Généré le : Thu Nov 29 09:42:17 2007 par Balluche grâce à PHPXref 0.7
  Clicky Web Analytics