Class: ADODB_pdo

Source Location: /lodel/scripts/adodb/drivers/adodb-pdo.inc.php

Class ADODB_pdo

Class Overview

Connection object. For connecting to databases, and executing queries.

Located in /lodel/scripts/adodb/drivers/adodb-pdo.inc.php [line 102]

ADOConnection
   |
   --ADODB_pdo

Properties

Methods

[ Top ]

Descendants

Child Class	Description
ADODB_pdo_base	Connection object. For connecting to databases, and executing queries.

[ Top ]

Inherited Properties, Constants, and Methods

Inherited Properties

Inherited Methods

Inherited Constants

Inherited From ADOConnection

ADOConnection::$ansiOuter

ADOConnection::$arrayClass

ADOConnection::$autoCommit

ADOConnection::$autoRollback

ADOConnection::$blobEncodeType

ADOConnection::$cacheSecs

ADOConnection::$charSet

ADOConnection::$concat_operator

ADOConnection::$database

ADOConnection::$debug

ADOConnection::$emptyDate

ADOConnection::$emptyTimeStamp

ADOConnection::$false

ADOConnection::$fetchMode

ADOConnection::$fnCacheExecute

ADOConnection::$fnExecute

ADOConnection::$genID

ADOConnection::$hasGenID

ADOConnection::$hasInsertID

ADOConnection::$hasLimit

ADOConnection::$hasMoveFirst

ADOConnection::$hasTop

ADOConnection::$hasTransactions

ADOConnection::$host

ADOConnection::$isoDates

ADOConnection::$lastInsID

ADOConnection::$leftOuter

ADOConnection::$length

ADOConnection::$maxblobsize

ADOConnection::$memCache

ADOConnection::$memCacheCompress

ADOConnection::$memCacheHost

ADOConnection::$memCachePort

ADOConnection::$metaDatabasesSQL

ADOConnection::$metaTablesSQL

ADOConnection::$nameQuote

ADOConnection::$noNullStrings

ADOConnection::$null2null

ADOConnection::$numCacheHits

ADOConnection::$numCacheMisses

ADOConnection::$pageExecuteCountRows

ADOConnection::$password

ADOConnection::$poorAffectedRows

ADOConnection::$raiseErrorFn

ADOConnection::$random

ADOConnection::$readOnly

ADOConnection::$rightOuter

ADOConnection::$rsPrefix

ADOConnection::$substr

ADOConnection::$sysDate

ADOConnection::$sysTimeStamp

ADOConnection::$transCnt

ADOConnection::$transOff

ADOConnection::$true

ADOConnection::$uniqueOrderBy

ADOConnection::$uniqueSort

ADOConnection::$upperCase

ADOConnection::$user

ADOConnection::$_affected

ADOConnection::$_connectionID

ADOConnection::$_errorCode

ADOConnection::$_errorMsg

ADOConnection::$_evalAll

ADOConnection::$_isPersistentConnection

ADOConnection::$_logsql

ADOConnection::$_oldRaiseFn

ADOConnection::$_queryID

ADOConnection::$_transmode

ADOConnection::$_transOK

Inherited From ADOConnection

ADOConnection::ADOConnection()

Constructor

ADOConnection::addq()

Quotes a string, without prefixing nor appending quotes.

ADOConnection::Affected_Rows()

ADOConnection::AutoExecute()

ADOConnection::BeginTrans()

Begin a Transaction. Must be followed by CommitTrans() or RollbackTrans().

ADOConnection::BindDate()

ADOConnection::BindTimeStamp()

ADOConnection::BlobDecode()

ADOConnection::BlobEncode()

ADOConnection::CacheExecute()

Execute SQL, caching recordsets.

ADOConnection::CacheFlush()

Flush cached recordsets that match a particular $sql statement.

ADOConnection::CacheGetAll()

ADOConnection::CacheGetArray()

ADOConnection::CacheGetAssoc()

ADOConnection::CacheGetCol()

ADOConnection::CacheGetOne()

ADOConnection::CacheGetRow()

ADOConnection::CachePageExecute()

Will select the supplied $page number from a recordset, given that it is paginated in pages of $nrows rows per page. It also saves two boolean values saying if the given page is the first and/or last one of the recordset. Added by Iván Oliva to provide recordset pagination.

ADOConnection::CacheSelectLimit()

Will select, getting rows from $offset (1-based), for $nrows.

ADOConnection::Close()

Close Connection

ADOConnection::CommitLock()

ADOConnection::CommitTrans()

If database does not support transactions, always return true as data always commited

ADOConnection::CompleteTrans()

ADOConnection::Concat()

Different SQL databases used different methods to combine strings together.

ADOConnection::Connect()

Connect to database

ADOConnection::CreateSequence()

ADOConnection::DBDate()

Converts a date "d" to a string that the database can understand.

ADOConnection::DBTimeStamp()

Converts a timestamp "ts" to a string that the database can understand.

ADOConnection::Disconnect()

PEAR DB Compat - do not use internally

ADOConnection::DropSequence()

ADOConnection::ErrorMsg()

ADOConnection::ErrorNative()

PEAR DB Compat - do not use internally.

ADOConnection::ErrorNo()

ADOConnection::escape()

ADOConnection::Execute()

Execute SQL

ADOConnection::FailTrans()

ADOConnection::GenID()

Generates a sequence id and stores it in $this->genID; GenID is only available if $this->hasGenID = true;

ADOConnection::GetActiveRecords()

ADOConnection::GetActiveRecordsClass()

ADOConnection::GetAll()

ADOConnection::GetArray()

ADOConnection::GetAssoc()

ADOConnection::GetCharSet()

ADOConnection::GetCol()

ADOConnection::GetInsertSQL()

Generates an Insert Query based on an existing recordset.

ADOConnection::GetOne()

Return first element of first row of sql statement. Recordset is disposed for you.

ADOConnection::GetRow()

Return one row of sql statement. Recordset is disposed for you.

ADOConnection::GetUpdateSQL()

Generates an Update Query based on an existing recordset.

ADOConnection::HasFailedTrans()

ADOConnection::IfNull()

ADOConnection::IgnoreErrors()

ADOConnection::InParameter()

ADOConnection::Insert_ID()

ADOConnection::IsConnected()

ADOConnection::LimitQuery()

PEAR DB Compat - do not use internally

ADOConnection::LogSQL()

ADOConnection::MetaColumnNames()

List columns names in a table as an array.

ADOConnection::MetaColumns()

List columns in a database as an array of ADOFieldObjects.

ADOConnection::MetaDatabases()

return the databases that the driver can connect to.

ADOConnection::MetaError()

ADOConnection::MetaErrorMsg()

ADOConnection::MetaForeignKeys()

ADOConnection::MetaIndexes()

List indexes on a table as an array.

ADOConnection::MetaPrimaryKeys()

ADOConnection::MetaTables()

ADOConnection::MetaTransaction()

ADOConnection::MetaType()

ADOConnection::NConnect()

Always force a new connection to database - currently only works with oracle

ADOConnection::nextId()

PEAR DB Compat - do not use internally.

ADOConnection::OffsetDate()

ADOConnection::outp()

All error messages go through this bottleneck function.

ADOConnection::OutParameter()

ADOConnection::PageExecute()

Will select the supplied $page number from a recordset, given that it is paginated in pages of $nrows rows per page. It also saves two boolean values saying if the given page is the first and/or last one of the recordset. Added by Iván Oliva to provide recordset pagination.

ADOConnection::Param()

ADOConnection::Parameter()

ADOConnection::PConnect()

Establish persistent connect to database

ADOConnection::PO_Insert_ID()

Portable Insert ID. Pablo Roca <pabloroca#mvps.org>

ADOConnection::Prepare()

Should prepare the sql statement and return the stmt resource.

ADOConnection::PrepareSP()

Some databases, eg. mssql require a different function for preparing stored procedures. So we cannot use Prepare().

ADOConnection::q()

ADOConnection::QMagic()

ADOConnection::qstr()

Correctly quotes a string so that all strings are escaped. We prefix and append to the string single-quotes.

ADOConnection::Query()

PEAR DB Compat - do not use internally.

ADOConnection::Quote()

PEAR DB Compat

ADOConnection::Replace()

Insert or replace a single record. Note: this is not the same as MySQL's replace.

ADOConnection::RollbackLock()

ADOConnection::RollbackTrans()

If database does not support transactions, rollbacks always fail, so return false

ADOConnection::RowLock()

Lock a row, will escalate and lock the table if row locking not supported will normally free the lock at the end of the transaction

ADOConnection::SelectDB()

Choose a database to connect to. Many databases do not support this.

ADOConnection::SelectLimit()

Will select, getting rows from $offset (1-based), for $nrows.

ADOConnection::SerializableRS()

Create serializable recordset. Breaks rs link to connection.

ADOConnection::ServerInfo()

ADOConnection::SetCharSet()

ADOConnection::SetDateLocale()

Change the SQL connection locale to a specified locale.

ADOConnection::SetFetchMode()

PEAR DB Compat - do not use internally.

ADOConnection::SetTransactionMode()

ADOConnection::SQLDate()

ADOConnection::StartTrans()

ADOConnection::Time()

ADOConnection::Transpose()

ADOConnection::UnixDate()

Also in ADORecordSet.

ADOConnection::UnixTimeStamp()

Also in ADORecordSet.

ADOConnection::UpdateBlob()

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.

ADOConnection::UpdateBlobFile()

Usage: UpdateBlob('TABLE', 'COLUMN', '/path/to/file', 'ID=1');

ADOConnection::UpdateClob()

Usage: UpdateClob('TABLE', 'COLUMN', $var, 'ID=1', 'CLOB');

ADOConnection::UserDate()

Also in ADORecordSet.

ADOConnection::UserTimeStamp()

ADOConnection::Version()

ADOConnection::xCacheFlush()

ADOConnection::_dirFlush()

Private function to erase all of the files and subdirectories in a directory.

ADOConnection::_Execute()

ADOConnection::_findschema()

ADOConnection::_findvers()

ADOConnection::_gencachename()

Private function to generate filename for caching.

ADOConnection::_nconnect()

ADOConnection::_rs2rs()

Convert database recordset to an array recordset input recordset's cursor should be at beginning, and old $rs will be closed.

[ Top ]

Property Summary

mixed	$databaseType
mixed	$dataProvider
mixed	$dsnType
mixed	$fmtDate
mixed	$fmtTimeStamp
mixed	$hasAffectedRows
mixed	$replaceQuote
mixed	$stmt
mixed	$_autocommit
mixed	$_bindInputArray
mixed	$_errormsg
mixed	$_errorno
mixed	$_genSeqSQL
mixed	$_haserrorfunctions
mixed	$_lastAffectedRows

[ Top ]

Method Summary

ADODB_pdo	ADODB_pdo()
void	BeginTrans()
void	CommitTrans()
void	ErrorMsg()
void	ErrorNo()
void	InParameter()
void	MetaColumns()
void	MetaTables()
void	Prepare()
void	PrepareStmt()
void	RollbackTrans()
void	SelectLimit()
void	ServerInfo()
void	Time()
void	_affectedrows()
void	_close()
void	_connect()
void	_insertid()
void	_pconnect()
void	_query()
void	_UpdatePDO()

[ Top ]

Properties

mixed $databaseType = "pdo" [line 103]

Redefinition of:

ADOConnection::$databaseType

[ Top ]

mixed $dataProvider = "pdo" [line 104]

Redefinition of:

ADOConnection::$dataProvider

[ Top ]

mixed $dsnType = '' [line 118]

[ Top ]

mixed $fmtDate = "'Y-m-d'" [line 105]

Redefinition of:

ADOConnection::$fmtDate

[ Top ]

mixed $fmtTimeStamp = "'Y-m-d, h:i:sA'" [line 106]

Redefinition of:

ADOConnection::$fmtTimeStamp

[ Top ]

mixed $hasAffectedRows = true [line 108]

Redefinition of:

ADOConnection::$hasAffectedRows

[ Top ]

mixed $replaceQuote = "''" [line 107]

Redefinition of:

ADOConnection::$replaceQuote

[ Top ]

mixed $stmt = false [line 119]

[ Top ]

mixed $_autocommit = true [line 111]

[ Top ]

mixed $_bindInputArray = true [line 109]

Redefinition of:

ADOConnection::$_bindInputArray

[ Top ]

mixed $_errormsg = false [line 115]

[ Top ]

mixed $_errorno = false [line 116]

[ Top ]

mixed $_genSeqSQL = "create table %s (id integer)" [line 110]

[ Top ]

mixed $_haserrorfunctions = true [line 112]

[ Top ]

mixed $_lastAffectedRows = 0 [line 113]

[ Top ]

Methods

Constructor ADODB_pdo [line 121]

ADODB_pdo ADODB_pdo(
)

[ Top ]

BeginTrans [line 283]

void BeginTrans(
)

Redefinition of:

ADOConnection::BeginTrans(): Begin a Transaction. Must be followed by CommitTrans() or RollbackTrans().

[ Top ]

CommitTrans [line 293]

void CommitTrans(
[
$ok = true] 
)

Parameters:

$ok:

Redefinition of:

ADOConnection::CommitTrans(): If database does not support transactions, always return true as data always commited

[ Top ]

ErrorMsg [line 252]

void ErrorMsg(
)

Redefinition of:

ADOConnection::ErrorMsg()

[ Top ]

ErrorNo [line 268]

void ErrorNo(
)

Redefinition of:

ADOConnection::ErrorNo()

[ Top ]

InParameter [line 244]

void InParameter(

&$stmt, 
&$var, 
$name, [
$maxLen = 4000], [
$type = false] 
)

Parameters:

	&$stmt:
	&$var:
	$name:
	$maxLen:
	$type:

Redefinition of:

ADOConnection::InParameter()

[ Top ]

MetaColumns [line 239]

void MetaColumns(

$table, [
$normalize = true] 
)

Parameters:

	$table:
	$normalize:

Redefinition of:

ADOConnection::MetaColumns(): List columns in a database as an array of ADOFieldObjects.

Redefined in descendants as:

ADODB_pdo_base::MetaColumns()

[ Top ]

MetaTables [line 234]

void MetaTables(
[
$ttype = false], [
$showSchema = false], [
$mask = false] 
)

Parameters:

	$ttype:
	$showSchema:
	$mask:

Redefinition of:

ADOConnection::MetaTables()

Redefined in descendants as:

ADODB_pdo_base::MetaTables()

[ Top ]

Prepare [line 318]

void Prepare(

$sql 
)

Parameters:

$sql:

Redefinition of:

ADOConnection::Prepare(): Should prepare the sql statement and return the stmt resource.

[ Top ]

PrepareStmt [line 326]

void PrepareStmt(

$sql 
)

Parameters:

$sql:

[ Top ]

RollbackTrans [line 306]

void RollbackTrans(
)

Redefinition of:

ADOConnection::RollbackTrans(): If database does not support transactions, rollbacks always fail, so return false

[ Top ]

SelectLimit [line 218]

void SelectLimit(

$sql, [
$nrows = -1], [
$offset = -1], [
$inputarr = false], [
$secs2cache = 0] 
)

Parameters:

	$sql:
	$nrows:
	$offset:
	$inputarr:

	default

[ class tree: default ] [ index: default ] [ all elements ]