Documentation TYPO3 par Ameos |
Public Member Functions | |
| _insertid () | |
| ADODB_db2 () | |
| _connect ($argDSN, $argUsername, $argPassword, $argDatabasename) | |
| _pconnect ($argDSN, $argUsername, $argPassword, $argDatabasename) | |
| DBTimeStamp ($ts) | |
| SQLDate ($fmt, $col=false) | |
| ServerInfo () | |
| CreateSequence ($seqname='adodbseq', $start=1) | |
| DropSequence ($seqname) | |
| GenID ($seq='adodbseq', $start=1) | |
| ErrorMsg () | |
| ErrorNo () | |
| BeginTrans () | |
| CommitTrans ($ok=true) | |
| RollbackTrans () | |
| MetaPrimaryKeys ($table) | |
| MetaForeignKeys ($table, $owner=FALSE, $upper=FALSE, $asociative=FALSE) | |
| & | MetaTables ($ttype=false, $schema=false) |
| DB2Types ($t) | |
| & | MetaColumns ($table) |
| Prepare ($sql) | |
| _query ($sql, $inputarr=false) | |
| UpdateBlob ($table, $column, $val, $where, $blobtype='BLOB') | |
| _close () | |
| _affectedrows () | |
Public Attributes | |
| $databaseType = "db2" | |
| $fmtDate = "'Y-m-d'" | |
| uppercase function | |
| $concat_operator = '||' | |
| maximum size of blobs or large text fields (262144 = 256K)-- some db's die otherwise like foxpro | |
| $sysTime = 'CURRENT TIME' | |
| $sysDate = 'CURRENT DATE' | |
| Use 'true' to store the item compressed (uses zlib). | |
| $sysTimeStamp = 'CURRENT TIMESTAMP' | |
| name of function that returns the current date | |
| $fmtTimeStamp = "'Y-m-d-H.i.s'" | |
| used by DBDate() as the default date format used by the database | |
| $replaceQuote = "''" | |
| string that represents FALSE for a database | |
| $dataProvider = "db2" | |
| $hasAffectedRows = true | |
| supports autoincrement ID? | |
| $binmode = DB2_BINARY | |
| $useFetchArray = false | |
| $_bindInputArray = false | |
| A boolean variable to state whether its a persistent connection or normal connection. */. | |
| $_genIDSQL = "VALUES NEXTVAL FOR %s" | |
| $_genSeqSQL = "CREATE SEQUENCE %s START WITH 1 NO MAXVALUE NO CYCLE" | |
| $_dropSeqSQL = "DROP SEQUENCE %s" | |
| $_autocommit = true | |
| $_haserrorfunctions = true | |
| $_lastAffectedRows = 0 | |
| $uCaseTables = true | |
| $hasInsertID = true | |
Definition at line 27 of file adodb-db2.inc.php.
| ADODB_db2::DBTimeStamp | ( | $ | ts | ) |
Converts a timestamp "ts" to a string that the database can understand.
| ts | a timestamp in Unix date time format. |
Reimplemented from ADOConnection.
Definition at line 124 of file adodb-db2.inc.php.
References ADORecordSet::UnixTimeStamp().
| ADODB_db2::ServerInfo | ( | ) |
Get server version info...
Reimplemented from ADOConnection.
Definition at line 198 of file adodb-db2.inc.php.
References ADOConnection::ServerInfo().
| ADODB_db2::GenID | ( | $ | seq = 'adodbseq', |
|
| $ | start = 1 | |||
| ) |
Generates a sequence id and stores it in $this->genID; GenID is only available if $this->hasGenID = true;
| seqname | name of sequence to use | |
| startID | if sequence does not exist, start at this ID |
Reimplemented from ADOConnection.
Definition at line 248 of file adodb-db2.inc.php.
References ADOConnection::GetOne().
| ADODB_db2::ErrorMsg | ( | ) |
Reimplemented from ADOConnection.
Definition at line 257 of file adodb-db2.inc.php.
References ADOConnection::ErrorMsg().
| ADODB_db2::ErrorNo | ( | ) |
Reimplemented from ADOConnection.
Definition at line 266 of file adodb-db2.inc.php.
References ADOConnection::ErrorNo().
| ADODB_db2::BeginTrans | ( | ) |
Begin a Transaction. Must be followed by CommitTrans() or RollbackTrans().
Reimplemented from ADOConnection.
Definition at line 287 of file adodb-db2.inc.php.
| ADODB_db2::CommitTrans | ( | $ | ok = true |
) |
If database does not support transactions, always return true as data always commited
| $ok | set to false to rollback transaction, true to commit |
Reimplemented from ADOConnection.
Definition at line 296 of file adodb-db2.inc.php.
References RollbackTrans().
| ADODB_db2::RollbackTrans | ( | ) |
If database does not support transactions, rollbacks always fail, so return false
Reimplemented from ADOConnection.
Definition at line 307 of file adodb-db2.inc.php.
Referenced by CommitTrans().
| ADODB_db2::Prepare | ( | $ | sql | ) |
Should prepare the sql statement and return the stmt resource. For databases that do not support this, we return the $sql. To ensure compatibility with databases that do not support prepare:
$stmt = $db->Prepare("insert into table (id, name) values (?,?)"); $db->Execute($stmt,array(1,'Jill')) or die('insert failed'); $db->Execute($stmt,array(2,'Joe')) or die('insert failed');
| sql | SQL to send to database |
Reimplemented from ADOConnection.
Definition at line 594 of file adodb-db2.inc.php.
| ADODB_db2::UpdateBlob | ( | $ | table, | |
| $ | column, | |||
| $ | val, | |||
| $ | where, | |||
| $ | blobtype = 'BLOB' | |||
| ) |
Update a blob column, given a where clause. There are more sophisticated blob handling functions that we could have implemented, but all require a very complex API. Instead we have chosen something that is extremely simple to understand and use.
Note: $blobtype supports 'BLOB' and 'CLOB', default is BLOB of course.
Usage to update a $blobvalue which has a primary key blob_id=1 into a field blobtable.blobcolumn:
UpdateBlob('blobtable', 'blobcolumn', $blobvalue, 'blob_id=1');
Insert example:
$conn->Execute('INSERT INTO blobtable (id, blobcol) VALUES (1, null)'); $conn->UpdateBlob('blobtable','blobcol',$blob,'id=1');
Reimplemented from ADOConnection.
Definition at line 678 of file adodb-db2.inc.php.
References ADOConnection::Execute().
1.4.6