ADODB_pdo_mysql Class Reference

Inheritance diagram for ADODB_pdo_mysql:

Public Member Functions
	_init ($parentDriver)
	OffsetDate ($dayFraction, $date=false)
	Concat ()
	ServerInfo ()
	MetaTables ($ttype=false, $showSchema=false, $mask=false)
	SetTransactionMode ($transaction_mode)
	MetaColumns ($table, $normalize=true)
	SelectDB ($dbName)
	SelectLimit ($sql, $nrows=-1, $offset=-1, $inputarr=false, $secs=0)
	SQLDate ($fmt, $col=false)
Public Member Functions inherited from ADODB_pdo
	__construct ()
	_UpdatePDO ()
	Time ()
	_connect ($argDSN, $argUsername, $argPassword, $argDatabasename, $persist=false)
	Concat ()
	_pconnect ($argDSN, $argUsername, $argPassword, $argDatabasename)
	SelectLimit ($sql, $nrows=-1, $offset=-1, $inputarr=false, $secs2cache=0)
	ServerInfo ()
	MetaTables ($ttype=false, $showSchema=false, $mask=false)
	MetaColumns ($table, $normalize=true)
	InParameter (&$stmt, &$var, $name, $maxLen=4000, $type=false)
	OffsetDate ($dayFraction, $date=false)
	ErrorMsg ()
	ErrorNo ()
	SetTransactionMode ($transaction_mode)
	BeginTrans ()
	CommitTrans ($ok=true)
	RollbackTrans ()
	Prepare ($sql)
	PrepareStmt ($sql)
	CreateSequence ($seqname='adodbseq', $startID=1)
	DropSequence ($seqname='adodbseq')
	GenID ($seqname='adodbseq', $startID=1)
	_query ($sql, $inputarr=false)
	_close ()
	_affectedrows ()
	_insertid ()

Public Attributes
	$metaTablesSQL
	$metaColumnsSQL = "SHOW COLUMNS FROM `%s`"
	$sysDate = 'CURDATE()'
	$sysTimeStamp = 'NOW()'
	$hasGenID = true
	$_genIDSQL = "update %s set id=LAST_INSERT_ID(id+1);"
	$_dropSeqSQL = "drop table %s"
	$fmtTimeStamp = "'Y-m-d, H:i:s'"
	$nameQuote = '`'
Public Attributes inherited from ADODB_pdo
	$databaseType = "pdo"
	$dataProvider = "pdo"
	$fmtDate = "'Y-m-d'"
	$fmtTimeStamp = "'Y-m-d, h:i:sA'"
	$replaceQuote = "''"
	$hasAffectedRows = true
	$_bindInputArray = true
	$_genIDSQL
	$_genSeqSQL = "create table %s (id integer)"
	$_dropSeqSQL
	$_autocommit = true
	$_haserrorfunctions = true
	$_lastAffectedRows = 0
	$_errormsg = false
	$_errorno = false
	$dsnType = ''
	$stmt = false
	$_driver

Detailed Description

Definition at line 13 of file adodb-pdo_mysql.inc.php.

Member Function Documentation

_init()

ADODB_pdo_mysql::_init

(

$parentDriver

)

Definition at line 29 of file adodb-pdo_mysql.inc.php.

Concat()

ADODB_pdo_mysql::Concat

(

)

Definition at line 49 of file adodb-pdo_mysql.inc.php.

MetaColumns()

ADODB_pdo_mysql::MetaColumns	(		$table,
			$normalize = true
	)

Definition at line 99 of file adodb-pdo_mysql.inc.php.

References $database, $rs, and SelectDB().

MetaTables()

ADODB_pdo_mysql::MetaTables	(		$ttype = false,
			$showSchema = false,
			$mask = false
	)

Definition at line 69 of file adodb-pdo_mysql.inc.php.

References $metaTablesSQL.

OffsetDate()

ADODB_pdo_mysql::OffsetDate	(		$dayFraction,
			$date = false
	)

Definition at line 38 of file adodb-pdo_mysql.inc.php.

References $sysDate.

SelectDB()

ADODB_pdo_mysql::SelectDB

(

$dbName

)

Definition at line 182 of file adodb-pdo_mysql.inc.php.

Referenced by MetaColumns().

SelectLimit()

ADODB_pdo_mysql::SelectLimit	(		$sql,
			$nrows = -1,
			$offset = -1,
			$inputarr = false,
			$secs = 0
	)

Definition at line 191 of file adodb-pdo_mysql.inc.php.

References $rs, and $sql.

ServerInfo()

ADODB_pdo_mysql::ServerInfo

(

)

Definition at line 62 of file adodb-pdo_mysql.inc.php.

SetTransactionMode()

ADODB_pdo_mysql::SetTransactionMode

(

$transaction_mode

)

Definition at line 86 of file adodb-pdo_mysql.inc.php.

SQLDate()

ADODB_pdo_mysql::SQLDate	(		$fmt,
			$col = false
	)

Definition at line 207 of file adodb-pdo_mysql.inc.php.

References $sysTimeStamp.

Member Data Documentation

$_dropSeqSQL

ADODB_pdo_mysql::$_dropSeqSQL = "drop table %s"

Definition at line 25 of file adodb-pdo_mysql.inc.php.

$_genIDSQL

ADODB_pdo_mysql::$_genIDSQL = "update %s set id=LAST_INSERT_ID(id+1);"

Definition at line 24 of file adodb-pdo_mysql.inc.php.

$fmtTimeStamp

ADODB_pdo_mysql::$fmtTimeStamp = "'Y-m-d, H:i:s'"

Definition at line 26 of file adodb-pdo_mysql.inc.php.

$hasGenID

ADODB_pdo_mysql::$hasGenID = true

Definition at line 23 of file adodb-pdo_mysql.inc.php.

$metaColumnsSQL

ADODB_pdo_mysql::$metaColumnsSQL = "SHOW COLUMNS FROM `%s`"

Definition at line 20 of file adodb-pdo_mysql.inc.php.

$metaTablesSQL

ADODB_pdo_mysql::$metaTablesSQL

Initial value:

= "SELECT
            TABLE_NAME,
            CASE WHEN TABLE_TYPE = 'VIEW' THEN 'V' ELSE 'T' END
        FROM INFORMATION_SCHEMA.TABLES
        WHERE TABLE_SCHEMA="

Definition at line 15 of file adodb-pdo_mysql.inc.php.

Referenced by MetaTables().

$nameQuote

ADODB_pdo_mysql::$nameQuote = '`'

Definition at line 27 of file adodb-pdo_mysql.inc.php.

$sysDate

ADODB_pdo_mysql::$sysDate = 'CURDATE()'

Definition at line 21 of file adodb-pdo_mysql.inc.php.

Referenced by OffsetDate().

$sysTimeStamp

ADODB_pdo_mysql::$sysTimeStamp = 'NOW()'

Definition at line 22 of file adodb-pdo_mysql.inc.php.

Referenced by SQLDate().