Child Class	Description
OTS_DB_PostgreSQL	PostgreSQL connection interface.
OTS_DB_ODBC	ODBC connection interface.
OTS_DB_MySQL	MySQL connection interface.
OTS_DB_SQLite	SQLite connection interface.

[ Top ]

Inherited Properties, Constants, and Methods

Inherited Properties	Inherited Methods	Inherited Constants
	Inherited From PDO (Internal Class) constructor __construct ( $dsn, $username, $passwd, [$options = ] ) beginTransaction ( ) commit ( ) errorCode ( ) errorInfo ( ) exec ( $query ) getAttribute ( $attribute ) getAvailableDrivers ( ) lastInsertId ( [$seqname = ] ) prepare ( $statment, [$options = ] ) query ( ) quote ( $string, [$paramtype = ] ) rollBack ( ) setAttribute ( $attribute, $value ) __sleep ( ) __wakeup ( )	Inherited From PDO (Internal Class) ATTR_AUTOCOMMIT = 0 ATTR_CASE = 8 ATTR_CLIENT_VERSION = 5 ATTR_CONNECTION_STATUS = 7 ATTR_CURSOR = 10 ATTR_CURSOR_NAME = 9 ATTR_DEFAULT_FETCH_MODE = 19 ATTR_DRIVER_NAME = 16 ATTR_EMULATE_PREPARES = 20 ATTR_ERRMODE = 3 ATTR_FETCH_CATALOG_NAMES = 15 ATTR_FETCH_TABLE_NAMES = 14 ATTR_MAX_COLUMN_LEN = 18 ATTR_ORACLE_NULLS = 11 ATTR_PERSISTENT = 12 ATTR_PREFETCH = 1 ATTR_SERVER_INFO = 6 ATTR_SERVER_VERSION = 4 ATTR_STATEMENT_CLASS = 13 ATTR_STRINGIFY_FETCHES = 17 ATTR_TIMEOUT = 2 CASE_LOWER = 2 CASE_NATURAL = 0 CASE_UPPER = 1 CURSOR_FWDONLY = 0 CURSOR_SCROLL = 1 ERRMODE_EXCEPTION = 2 ERRMODE_SILENT = 0 ERRMODE_WARNING = 1 ERR_NONE = '00000' FETCH_ASSOC = 2 FETCH_BOTH = 4 FETCH_BOUND = 6 FETCH_CLASS = 8 FETCH_CLASSTYPE = 262144 FETCH_COLUMN = 7 FETCH_FUNC = 10 FETCH_GROUP = 65536 FETCH_INTO = 9 FETCH_KEY_PAIR = 12 FETCH_LAZY = 1 FETCH_NAMED = 11 FETCH_NUM = 3 FETCH_OBJ = 5 FETCH_ORI_ABS = 4 FETCH_ORI_FIRST = 2 FETCH_ORI_LAST = 3 FETCH_ORI_NEXT = 0 FETCH_ORI_PRIOR = 1 FETCH_ORI_REL = 5 FETCH_PROPS_LATE = 1048576 FETCH_SERIALIZE = 524288 FETCH_UNIQUE = 196608 MYSQL_ATTR_DIRECT_QUERY = 1006 MYSQL_ATTR_INIT_COMMAND = 1002 MYSQL_ATTR_LOCAL_INFILE = 1001 MYSQL_ATTR_MAX_BUFFER_SIZE = 1005 MYSQL_ATTR_READ_DEFAULT_FILE = 1003 MYSQL_ATTR_READ_DEFAULT_GROUP = 1004 MYSQL_ATTR_USE_BUFFERED_QUERY = 1000 NULL_EMPTY_STRING = 1 NULL_NATURAL = 0 NULL_TO_STRING = 2 PARAM_BOOL = 5 PARAM_EVT_ALLOC = 0 PARAM_EVT_EXEC_POST = 3 PARAM_EVT_EXEC_PRE = 2 PARAM_EVT_FETCH_POST = 5 PARAM_EVT_FETCH_PRE = 4 PARAM_EVT_FREE = 1 PARAM_EVT_NORMALIZE = 6 PARAM_INPUT_OUTPUT = 2147483648 PARAM_INT = 1 PARAM_LOB = 3 PARAM_NULL = 0 PARAM_STMT = 4 PARAM_STR = 2

Inherited Properties

Inherited Methods

Inherited Constants

Inherited From PDO (Internal Class)

constructor __construct ( $dsn, $username, $passwd, [$options = ] )

beginTransaction ( )

commit ( )

errorCode ( )

errorInfo ( )

exec ( $query )

getAttribute ( $attribute )

getAvailableDrivers ( )

lastInsertId ( [$seqname = ] )

prepare ( $statment, [$options = ] )

query ( )

quote ( $string, [$paramtype = ] )

rollBack ( )

setAttribute ( $attribute, $value )

__sleep ( )

__wakeup ( )

Inherited From PDO (Internal Class)

ATTR_AUTOCOMMIT = 0

ATTR_CASE = 8

ATTR_CLIENT_VERSION = 5

ATTR_CONNECTION_STATUS = 7

ATTR_CURSOR = 10

ATTR_CURSOR_NAME = 9

ATTR_DEFAULT_FETCH_MODE = 19

ATTR_DRIVER_NAME = 16

ATTR_EMULATE_PREPARES = 20

ATTR_ERRMODE = 3

ATTR_FETCH_CATALOG_NAMES = 15

ATTR_FETCH_TABLE_NAMES = 14

ATTR_MAX_COLUMN_LEN = 18

ATTR_ORACLE_NULLS = 11

ATTR_PERSISTENT = 12

ATTR_PREFETCH = 1

ATTR_SERVER_INFO = 6

ATTR_SERVER_VERSION = 4

ATTR_STATEMENT_CLASS = 13

ATTR_STRINGIFY_FETCHES = 17

ATTR_TIMEOUT = 2

CASE_LOWER = 2

CASE_NATURAL = 0

CASE_UPPER = 1

CURSOR_FWDONLY = 0

CURSOR_SCROLL = 1

ERRMODE_EXCEPTION = 2

ERRMODE_SILENT = 0

ERRMODE_WARNING = 1

ERR_NONE = '00000'

FETCH_ASSOC = 2

FETCH_BOTH = 4

FETCH_BOUND = 6

FETCH_CLASS = 8

FETCH_CLASSTYPE = 262144

FETCH_COLUMN = 7

FETCH_FUNC = 10

FETCH_GROUP = 65536

FETCH_INTO = 9

FETCH_KEY_PAIR = 12

FETCH_LAZY = 1

FETCH_NAMED = 11

FETCH_NUM = 3

FETCH_OBJ = 5

FETCH_ORI_ABS = 4

FETCH_ORI_FIRST = 2

FETCH_ORI_LAST = 3

FETCH_ORI_NEXT = 0

FETCH_ORI_PRIOR = 1

FETCH_ORI_REL = 5

FETCH_PROPS_LATE = 1048576

FETCH_SERIALIZE = 524288

FETCH_UNIQUE = 196608

MYSQL_ATTR_DIRECT_QUERY = 1006

MYSQL_ATTR_INIT_COMMAND = 1002

MYSQL_ATTR_LOCAL_INFILE = 1001

MYSQL_ATTR_MAX_BUFFER_SIZE = 1005

MYSQL_ATTR_READ_DEFAULT_FILE = 1003

MYSQL_ATTR_READ_DEFAULT_GROUP = 1004

MYSQL_ATTR_USE_BUFFERED_QUERY = 1000

NULL_EMPTY_STRING = 1

NULL_NATURAL = 0

NULL_TO_STRING = 2

PARAM_BOOL = 5

PARAM_EVT_ALLOC = 0

PARAM_EVT_EXEC_POST = 3

PARAM_EVT_EXEC_PRE = 2

PARAM_EVT_FETCH_POST = 5

PARAM_EVT_FETCH_PRE = 4

PARAM_EVT_FREE = 1

PARAM_EVT_NORMALIZE = 6

PARAM_INPUT_OUTPUT = 2147483648

PARAM_INT = 1

PARAM_LOB = 3

PARAM_NULL = 0

PARAM_STMT = 4

PARAM_STR = 2

[ Top ]

Method Summary

string	fieldName()	Query-quoted field name.
string	limit()	LIMIT/OFFSET clause for queries.
PDOStatement\|bool	SQLquery()
string	SQLquote()
string	tableName()	Query-quoted table name.

[ Top ]

Methods

fieldName [line 39]

string fieldName(
string
$name 
)

Query-quoted field name.

Query-quoted field name.

Parameters:

string

$name:

Field name.

API Tags:

Return:	Quoted name.
Access:	public

Information Tags:

Version:	0.1.3
Since:	0.1.3

Redefined in descendants as:

OTS_DB_MySQL::fieldName() : Query-quoted field name.

[ Top ]

limit [line 83]

string limit(
[int|bool
$limit = false], [int|bool
$offset = false] 
)

LIMIT/OFFSET clause for queries.

LIMIT/OFFSET clause for queries.

Parameters:

int\|bool	$limit:	Limit of rows to be affected by query (false if no limit).
int\|bool	$offset:	Number of rows to be skipped before applying query effects (false if no offset).

API Tags:

Return:	LIMIT/OFFSET SQL clause for query.
Access:	public

Information Tags:

Version:	0.1.3
Since:	0.1.3

Redefined in descendants as:

OTS_DB_MySQL::limit() : LIMIT/OFFSET clause for queries.

[ Top ]

SQLquery [line 71]

PDOStatement|bool SQLquery(
string
$query 
)

Parameters:

string

$query:

SQL query.

API Tags:

Return:	Query results.
Deprecated:	0.0.5 Use PDO::query().
Access:	public

Information Tags:

Version:	0.1.3
Since:	0.1.3

[ Top ]

SQLquote [line 61]

string SQLquote(
stirng
$string 
)

Parameters:

stirng

$string:

String to be quoted.

API Tags:

Return:	Quoted string.
Deprecated:	0.0.5 Use PDO::quote().
Access:	public

Information Tags:

Version:	0.0.7
Version:	0.1.3
Since:	0.1.3

[ Top ]

tableName [line 50]

string tableName(
string
$name 
)

Query-quoted table name.

Query-quoted table name.

Parameters:

string

$name:

Table name.

API Tags:

Return:	Quoted name.
Access:	public

Information Tags:

Version:	0.1.3
Since:	0.1.3

[ Top ]