Class: DB_odbtp

void DB_odbtp( )

This constructor calls $this->DB_common()

mixed affectedRows( )

Returns the affected rows of a query

mixed autoCommit( [boolean $onoff = false])

enable automatic Commit

Parameters:

mixed commit( )

Commit the current transaction.

int connect( array $dsninfo, [boolean $persistent = false])

Connect to a database via an ODBTP server

The format of the supplied DSN:

odbtp(dbsyntax)://username:password@odbtphost/database

or

odbtp://username:password@odbtpinterface/database

Examples:

odbtp(access)://myuid:mypwd@odbtp.somewhere.com/c:\mydb.mdb odbtp(mssql)://myuid:mypwd@odbtp.somewhere.com/mydb?server=mysqlsrv odbtp://myuid:mypwd@myinterface/mydb

Parameters:

int createSequence( string $seq_name)

Creates a new sequence

Parameters:

boolean disconnect( )

Disconnect from ODBTP server

int dropSequence( string $seq_name)

Deletes a sequence

Parameters:

string errorNative( )

Get the native error code of the last error (if any) that occured on the current connection.

boolean freeResult( resource $result)

Free the internal resources associated with $result.

Parameters:

mixed getConnectionId( )

Get ODBTP Connection Id string

string getSpecialQuery( string $type)

Returns the query needed to get some backend info

Parameters:

int nextId( string $seq_name, [boolean $ondemand = true])

Returns the next free id in a sequence

Parameters:

boolean nextResult( resource $result)

Move the internal odbtp result pointer to the next available result

Parameters:

mixed numCols( resource $result)

Returns the number of columns in a result

Parameters:

mixed numRows( resource $result)

Returns the number of rows in a result if row caching has been enabled.

Parameters:

object DB odbtpRaiseError( [integer $code = null])

Gather information about an error, then use that info to create a DB error object and finally return that object.

Parameters:

string quote( [ $str = null], string $string)

DEPRECATED: Quotes a string so it can be safely used in a query

Parameters:

string quoteIdentifier( string $str)

Quote a string so it can be safely used as a table / column name

Quoting style depends on the database syntax in use.

Parameters:

mixed rollback( )

Rollback the current transaction.

mixed simpleQuery( string $query)

Perform a SQL query.

Parameters:

array tableInfo( object|string $result, [int $mode = null])

Returns information about a table or a result set

The format of the resulting array depends on which $mode you select. The sample output below is based on this query:

    SELECT tblFoo.fldID, tblFoo.fldPhone, tblBar.fldId
    FROM tblFoo
    JOIN tblBar ON tblFoo.fldId = tblBar.fldId

• null (default)

     [0] => Array (
         [table] => tblFoo
         [name] => fldId
         [type] => int
         [len] => 11
         [flags] => primary_key not_null
     )
     [1] => Array (
         [table] => tblFoo
         [name] => fldPhone
         [type] => string
         [len] => 20
         [flags] =>
     )
     [2] => Array (
         [table] => tblBar
         [name] => fldId
         [type] => int
         [len] => 11
         [flags] => primary_key not_null
     )

• DB_TABLEINFO_ORDER <p>In addition to the information found in the default output, a notation of the number of columns is provided by the num_fields element while the order element provides an array with the column names as the keys and their location index number (corresponding to the keys in the the default output) as the values.</p> <p>If a result set has identical field names, the last one is used.</p>

     [num_fields] => 3
     [order] => Array (
         [fldId] => 2
         [fldTrans] => 1
     )

• DB_TABLEINFO_ORDERTABLE <p>Similar to DB_TABLEINFO_ORDER but adds more dimensions to the array in which the table names are keys and the field names are sub-keys. This is helpful for queries that join tables which have identical field names.</p>

     [num_fields] => 3
     [ordertable] => Array (
         [tblFoo] => Array (
             [fldId] => 0
             [fldPhone] => 1
         )
         [tblBar] => Array (
             [fldId] => 2
         )
     )

The flags element contains a space separated list of extra information about the field. This data is inconsistent between DBMS's due to the way each DBMS works.

• primary_key
• unique_key
• multiple_key
• not_null

Most DBMS's only provide the table and flags elements if $result is a table name. The following DBMS's provide full information from queries:

• fbsql
• mysql

If the 'portability' option has DB_PORTABILITY_LOWERCASE turned on, the names of tables and fields will be lowercased.

Parameters: