[Zend_Db] element index

Package indexes

All elements
a b c d e f g h i j k l m n o p q r s t u v w z _
_
top
Variable $_caseFolding
Specifies the case of column names retrieved in queries
Variable $_chainedException
Variable $_config
User-provided configuration.
Variable $_config
User-provided configuration
Variable $_config
User-provided configuration.
Variable $_connection
Database connection
Variable $_execute_mode
Execution mode
Variable $_execute_mode
Variable $_fetchMode
Fetch mode
Variable $_lastInsertTable
Table name of the last accessed table for an insert operation This is a DB2-Adapter-specific member variable with the utmost probability you might not find it in other adapters...
Variable $_pdoType
PDO type
Variable $_pdoType
PDO type.
Variable $_pdoType
PDO type.
Variable $_pdoType
PDO type.
Variable $_pdoType
PDO type.
Variable $_profiler
Query profiler
Method _beginTransaction
Begin a transaction.
Method _beginTransaction
Begin a transaction.
Method _beginTransaction
Begin a transaction.
Method _beginTransaction
Begin a transaction.
Method _beginTransaction
Leave autocommit mode and begin a transaction.
Method _checkRequiredOptions
Check for config options that are mandatory.
Method _checkRequiredOptions
Check for config options that are mandatory.
Method _commit
Commit a transaction.
Method _commit
Commit a transaction.
Method _commit
Commit a transaction.
Method _commit
Commit a transaction.
Method _commit
Commit a transaction and return to autocommit mode.
Method _connect
Method _connect
Creates a connection resource.
Method _connect
Special configuration for SQLite behavior: make sure that result sets contain keys like 'column' instead of 'table.column'.
Method _connect
Creates a connection to the database.
Method _connect
Creates a connection to the database.
Method _connect
Creates a connection resource.
Method _connect
Creates a PDO object and connects to the database.
Method _dsn
DSN builder
Method _dsn
Creates a PDO DSN for the adapter from $this->_config settings.
Method _dsn
Creates a PDO DSN for the adapter from $this->_config settings.
Method _dsn
Creates a PDO DSN for the adapter from $this->_config settings.
Method _getExecuteMode
Method _getExecuteMode
Gets the execution mode
Method _quote
Quote a raw string.
Method _quote
Quote a raw string.
Method _quote
Quote a raw string.
Method _quote
Quote a raw string.
Method _quote
Quote a raw string.
Method _quote
Quote a raw string.
Method _quoteIdentifier
Quote an identifier.
Method _quoteIdentifier
Quote an identifier.
Method _quoteIdentifierAs
Quote an identifier and an optional alias.
Method _rollBack
Roll-back a transaction.
Method _rollBack
Roll-back a transaction.
Method _rollBack
Roll back a transaction and return to autocommit mode.
Method _rollBack
Rollback a transaction.
Method _rollBack
Roll-back a transaction.
Method _setExecuteMode
Method _whereExpr
Convert an array, string, or Zend_Db_Expr object into a string to put in a WHERE clause.
Method __construct
Constructor.
Method __construct
Method __construct
Constructor.
Method __construct
Method __construct
Variable $_expression
Storage for the SQL expression.
Method __construct
Instantiate an expression, which is just a string stored as an instance member variable.
Method __toString
Variable $_enabled
Stores enabled state of the profiler. If set to False, calls to queryStart() will simply be ignored.
Variable $_endedMicrotime
Unix timestamp with microseconds when self::queryEnd() was called.
Variable $_filterElapsedSecs
Stores the number of seconds to filter. NULL if filtering by time is disabled. If an integer is stored here, profiles whose elapsed time is less than this value in seconds will be unset from the self::$_queryProfiles array.
Variable $_filterTypes
Logical OR of any of the filter constants. NULL if filtering by query
Variable $_query
SQL query string or user comment, set by $query argument in constructor.
Variable $_queryProfiles
Array of Zend_Db_Profiler_Query objects.
Variable $_queryType
One of the Zend_Db_Profiler constants for query type, set by $queryType argument in constructor.
Variable $_startedMicrotime
Unix timestamp with microseconds when instantiated.
Method __construct
Class constructor. A query is about to be started, save the query text ($query) and its type (one of the Zend_Db_Profiler::* constants).
Method __construct
Class constructor. The profiler is disabled by default unless it is specifically enabled by passing in $enabled here or calling setEnabled().
Variable $_adapter
Zend_Db_Adapter_Abstract object.
Variable $_parts
The component parts of a SELECT statement.
Variable $_partsInit
The initial values for the $_parts array.
Variable $_tableCols
Tracks which columns are being select from each table and join.
Method _join
Populate the $_parts 'join' key
Method _tableCols
Adds to the internal table-to-column mapping array.
Method __construct
Class constructor
Method __toString
Converts this object to an SQL SELECT string.
Variable $_adapter
Variable $_attribute
Attributes.
Variable $_bindColumn
Column result bindings.
Variable $_bindParam
Query parameter bindings; covers bindParam() and bindValue().
Variable $_fetchMode
The current fetch mode.
Variable $_fetchMode
Variable $_keys
Column names.
Variable $_keys
Column names.
Variable $_keys
Column names.
Variable $_sqlParam
Parameter placeholders in the SQL string by position in the split array.
Variable $_sqlSplit
SQL string split into an array at placeholders.
Variable $_stmt
The mysqli_stmt object.
Variable $_stmt
The connection_stmt object.
Variable $_stmt
The mysqli_stmt object.
Variable $_stmt
Statement resource handle.
Variable $_values
Fetched result values.
Variable $_values
Fetched result values.
Variable $_values
Fetched result values.
Method _joinSql
Joins SQL text and bound params into a string.
Method _normalizeBindParam
Check sanity of bind parameters. Throw exceptions if params are not valid.
Method _prepSql
Splits SQL into text and params, sets up $this->_bindParam for replacements.
Method _prepSql
Prepare a string SQL statement and create a statement object.
Method _prepSql
Prepare a statement handle.
Method _prepSql
Prepares statement handle
Method _prepSql
Method __construct
Constructor for a statement.
Method __construct
Constructor for a statement.
Method __construct
Method __construct
Variable $_cleanData
This is set to a copy of $_data when the data is fetched from a database, specified as a new tuple in the constructor, or when dirty data is posted to the database with save().
Variable $_cols
The table column names derived from Zend_Db_Adapter_Abstract::describeTable().
Variable $_connected
Connected is true if we have a reference to a live Zend_Db_Table_Abstract object.
Variable $_connected
Connected is true if we have a reference to a live Zend_Db_Table_Abstract object.
Variable $_count
How many data rows there are.
Variable $_data
The data for each column in the row (column_name => value).
Variable $_data
The original data for each row.
Variable $_db
Zend_Db_Adapter_Abstract object.
Variable $_defaultDb
Default Zend_Db_Adapter_Abstract object.
Variable $_defaultMetadataCache
Default cache for information provided by the adapter's describeTable() method.
Variable $_dependentTables
Simple array of class names of tables that are "children" of the current table, in other words tables that contain a foreign key to this one.
Variable $_identity
If your primary key is a compound key, and one of the columns uses an auto-increment or sequence-generated value, set _identity to the ordinal index in the $_primary array for that column.
Variable $_metadata
Information provided by the adapter's describeTable() method.
Variable $_metadataCache
Cache for information provided by the adapter's describeTable() method.
Variable $_name
The table name.
Variable $_pointer
Iterator pointer.
Variable $_primary
The primary key column or columns.
Variable $_primary
Primary row key(s).
Variable $_referenceMap
Associative array map of declarative referential integrity rules.
Variable $_rowClass
Classname for row
Variable $_rowClass
Zend_Db_Table_Row_Abstract class name.
Variable $_rows
Collection of instantiated Zend_Db_Table_Row objects.
Variable $_rowsetClass
Classname for rowset
Variable $_schema
The schema name (default null means current schema)
Variable $_sequence
Define the logic for new values in the primary key.
Variable $_stored
Variable $_table
Zend_Db_Table_Abstract object.
Variable $_table
Zend_Db_Table_Abstract parent class or instance.
Variable $_tableClass
Name of the class of the Zend_Db_Table_Abstract object.
Variable $_tableClass
Zend_Db_Table_Abstract class name.
Method _cascadeDelete
Called by parent table's class during delete() method.
Method _cascadeUpdate
Called by a row object for the parent table's class during save() method.
Method _delete
Allows pre-delete logic to be applied to row.
Method _doInsert
Method _doUpdate
Method _fetch
Support method for fetching rows.
Method _getPrimaryKey
Retrieves an associative array of primary keys.
Method _getReferenceMapNormalized
Returns a normalized version of the reference map
Method _getTable
Retrieves an instance of the parent table.
Method _getWhereQuery
Constructs where statement for retrieving row(s).
Method _insert
Allows pre-insert logic to be applied to row.
Method _postDelete
Allows post-delete logic to be applied to row.
Method _postInsert
Allows post-insert logic to be applied to row.
Method _postUpdate
Allows post-update logic to be applied to row.
Method _prepareReference
Prepares a table reference for lookup.
Method _refresh
Refreshes properties from the database.
Method _setAdapter
Method _setMetadataCache
Sets the metadata cache for information returned by Zend_Db_Adapter_Abstract::describeTable().
Method _setSequence
Sets the sequence member, which defines the behavior for generating primary key values in new rows.
Method _setup
Turnkey for initialization of a table object.
Method _setupAdapter
Method _setupDatabaseAdapter
Initialize database adapter.
Method _setupMetadata
Initializes metadata.
Method _setupMetadataCache
Method _setupPrimaryKey
Initialize primary key from metadata.
Method _setupTableName
Initialize table and schema names.
Method _transformColumn
Transform a column name from the user-specified form to the physical form used in the database.
Method _update
Allows pre-update logic to be applied to row.
Method __call
Turn magic function calls into non-magic function calls to the above methods.
Method __construct
Constructor.
Method __construct
Constructor.
Method __construct
Constructor.
Method __get
Retrieve row field value
Method __isset
Test existence of row field
Method __set
Set row field value
Method __sleep
Store data, class names, and state in serialized object
Method __sleep
Store table, primary key and data in serialized object
Method __wakeup
Setup to do on wakeup.
Method __wakeup
Setup to do on wakeup.
a
top
Class Constant ATTR_AUTOCOMMIT
PDO constant values discovered by this script result:
Class Constant ATTR_CASE
Class Constant ATTR_CLIENT_VERSION
Class Constant ATTR_CONNECTION_STATUS
Class Constant ATTR_CURSOR
Class Constant ATTR_CURSOR_NAME
Class Constant ATTR_DRIVER_NAME
Class Constant ATTR_ERRMODE
Class Constant ATTR_FETCH_CATALOG_NAMES
Class Constant ATTR_FETCH_TABLE_NAMES
Class Constant ATTR_MAX_COLUMN_LEN
Class Constant ATTR_ORACLE_NULLS
Class Constant ATTR_PERSISTENT
Class Constant ATTR_PREFETCH
Class Constant ATTR_SERVER_INFO
Class Constant ATTR_SERVER_VERSION
Class Constant ATTR_STATEMENT_CLASS
Class Constant ATTR_STRINGIFY_FETCHES
Class Constant ATTR_TIMEOUT
Page Abstract.php
Abstract.php in Abstract.php
Page Abstract.php
Abstract.php in Abstract.php
Class Constant ADAPTER
Page Abstract.php
Abstract.php in Abstract.php
Page Abstract.php
Abstract.php in Abstract.php
Page Abstract.php
Abstract.php in Abstract.php
b
top
Method beginTransaction
Leave autocommit mode and begin a transaction.
Method bindColumn
Bind a column of the statement result set to a PHP variable.
Method bindColumn
Bind a column of the statement result set to a PHP variable.
Method bindColumn
Bind a column of the statement result set to a PHP variable.
Method bindParam
Binds a parameter to the specified variable name.
Method bindParam
Binds a parameter to the specified variable name.
Method bindParam
Binds a parameter to the specified variable name.
Method bindParam
Binds a parameter to the specified variable name.
Method bindParam
Binds a parameter to the specified variable name.
Method bindValue
Binds a value to a parameter.
Method bindValue
Binds a value to a parameter.
Method bindValue
Binds a value to a parameter.
c
top
Class Constant CASE_FOLDING
Class Constant CASE_LOWER
Class Constant CASE_NATURAL
Class Constant CASE_UPPER
Class Constant CURSOR_FWDONLY
Class Constant CURSOR_SCROLL
Variable $code
Variable $code
Method closeConnection
Force the connection to close.
Method closeConnection
Force the connection to close.
Method closeConnection
Force the connection to close.
Method closeConnection
Force the connection to close.
Method closeConnection
Force the connection to close.
Method commit
Commit a transaction and return to autocommit mode.
Method camelize
Convert underscore_words to camelCaps.
Method clear
Clears the history of any past query profiles. This is relentless and will even clear queries that were started and may not have been marked as ended.
Class Constant CONNECT
A connection operation or selecting a database.
Class Constant COLUMNS
Class Constant CROSS_JOIN
Variable $code
Variable $code
Method closeCursor
Closes the cursor, allowing the statement to be executed again.
Method closeCursor
Closes the cursor, allowing the statement to be executed again.
Method closeCursor
Closes the cursor, allowing the statement to be executed again.
Method closeCursor
Closes the cursor, allowing the statement to be executed again.
Method closeCursor
Closes the cursor, allowing the statement to be executed again.
Method columnCount
Returns the number of columns in the result set.
Method columnCount
Returns the number of columns in the result set.
Method columnCount
Returns the number of columns in the result set.
Method columnCount
Returns the number of columns in the result set.
Method columnCount
Returns the number of columns in the result set.
Class Constant CASCADE
Class Constant COLS
Class Constant COLUMNS
Method count
Returns the number of elements in the collection.
Method createRow
Fetches a new blank row (not from the database).
Method current
Return the current element.
d
top
Page Db.php
Db.php in Db.php
Page Db2.php
Db2.php in Db2.php
Method delete
Deletes table rows based on a WHERE clause.
Method describeTable
Returns the column descriptions for a table.
Method describeTable
Returns the column descriptions for a table.
Method describeTable
Returns the column descriptions for a table.
Method describeTable
Returns the column descriptions for a table.
Method describeTable
Returns the column descriptions for a table.
Method describeTable
Returns the column descriptions for a table.
Method describeTable
Returns the column descriptions for a table.
Method describeTable
Returns the column descriptions for a table.
Method describeTable
Returns the column descriptions for a table.
Class Constant DELETE
Zend_Db_Profiler::DELETE in Profiler.php
An operation related to deleting data in the database, such as SQL's DELETE.
Method distinct
Makes the query SELECT DISTINCT.
Class Constant DISTINCT
Page Db2.php
Db2.php in Db2.php
Method delete
Deletes existing rows.
Method delete
Deletes existing rows.
Class Constant DEPENDENT_TABLES
e
top
Page Exception.php
Exception.php in Exception.php
Class Constant ERRMODE_EXCEPTION
Class Constant ERRMODE_SILENT
Class Constant ERRMODE_WARNING
Class Constant ERR_ALREADY_EXISTS
Class Constant ERR_CANT_MAP
Class Constant ERR_CONSTRAINT
Class Constant ERR_DISCONNECTED
Class Constant ERR_MISMATCH
Class Constant ERR_NONE
Class Constant ERR_NOT_FOUND
Class Constant ERR_NOT_IMPLEMENTED
Class Constant ERR_NO_PERM
Class Constant ERR_SYNTAX
Class Constant ERR_TRUNCATED
Page Exception.php
Exception.php in Exception.php
Page Exception.php
Exception.php in Exception.php
Page Exception.php
Exception.php in Exception.php
Page Exception.php
Exception.php in Exception.php
Page Expr.php
Expr.php in Expr.php
Page Exception.php
Exception.php in Exception.php
Method end
Ends the query and records the time so that the elapsed time can be determined later.
Page Exception.php
Exception.php in Exception.php
Page Exception.php
Exception.php in Exception.php
Page Exception.php
Exception.php in Exception.php
Page Exception.php
Exception.php in Exception.php
Page Exception.php
Exception.php in Exception.php
Method errorCode
Retrieves the error code, if any, associated with the last operation on the statement handle.
Method errorCode
Retrieves the error code, if any, associated with the last operation on the statement handle.
Method errorCode
Retrieves the error code, if any, associated with the last operation on the statement handle.
Method errorCode
Retrieves the error code, if any, associated with the last operation on the statement handle.
Method errorCode
Retrieves the error code, if any, associated with the last operation on the statement handle.
Method errorInfo
Retrieves an array of error information, if any, associated with the last operation on the statement handle.
Method errorInfo
Retrieves an array of error information, if any, associated with the last operation on the statement handle.
Method errorInfo
Retrieves an array of error information, if any, associated with the last operation on the statement handle.
Method errorInfo
Retrieves an array of error information, if any, associated with the last operation on the statement handle.
Method errorInfo
Retrieves an array of error information, if any, associated with the last operation on the statement handle.
Method execute
Executes a prepared statement.
Method execute
Executes a prepared statement.
Method execute
Executes a prepared statement.
Method execute
Executes a prepared statement.
Method execute
Executes a prepared statement.
Page Exception.php
Exception.php in Exception.php
Page Exception.php
Exception.php in Exception.php
Method exists
Returns true if and only if count($this) > 0.
f
top
Method factory
Factory for Zend_Db_Adapter_Abstract classes.
Class Constant FETCH_ASSOC
Class Constant FETCH_BOTH
Class Constant FETCH_BOUND
Class Constant FETCH_CLASS
Class Constant FETCH_CLASSTYPE
Class Constant FETCH_COLUMN
Class Constant FETCH_FUNC
Class Constant FETCH_GROUP
Class Constant FETCH_INTO
Class Constant FETCH_LAZY
Class Constant FETCH_NAMED
Class Constant FETCH_NUM
Class Constant FETCH_OBJ
Class Constant FETCH_ORI_ABS
Class Constant FETCH_ORI_FIRST
Class Constant FETCH_ORI_LAST
Class Constant FETCH_ORI_NEXT
Class Constant FETCH_ORI_PRIOR
Class Constant FETCH_ORI_REL
Class Constant FETCH_SERIALIZE
Class Constant FETCH_UNIQUE
Method fetchAll
Fetches all SQL result rows as a sequential array.
Method fetchAssoc
Fetches all SQL result rows as an associative array.
Method fetchCol
Fetches the first column of all SQL result rows as an array.
Method fetchOne
Fetches the first column of the first row of the SQL result.
Method fetchPairs
Fetches all SQL result rows as an array of key-value pairs.
Method fetchRow
Fetches the first row of the SQL result.
Method foldCase
Helper method to change the case of the strings used when returning result sets in FETCH_ASSOC and FETCH_BOTH modes.
Method forUpdate
Makes the query SELECT FOR UPDATE.
Class Constant FOR_UPDATE
Class Constant FROM
Zend_Db_Select::FROM in Select.php
Method from
Adds a FROM table and optional columns to the query.
Class Constant FULL_JOIN
Method fetch
Fetches a row from the result set.
Method fetch
Fetches a row from the result set.
Method fetch
Fetches a row from the result set.
Method fetch
Fetches a row from the result set.
Method fetch
Fetches a row from the result set.
Method fetchAll
Returns an array containing all of the result set rows.
Method fetchAll
Returns an array containing all of the result set rows.
Method fetchAll
Returns an array containing all of the result set rows.
Method fetchAll
Returns an array containing all of the result set rows.
Method fetchAll
Returns an array containing all of the result set rows.
Method fetchColumn
Returns a single column from the next row of a result set.
Method fetchColumn
Returns a single column from the next row of a result set.
Method fetchColumn
Returns a single column from the next row of a result set.
Method fetchColumn
Returns a single column from the next row of a result set.
Method fetchObject
Fetches the next row and returns it as an object.
Method fetchObject
Fetches the next row and returns it as an object.
Method fetchObject
Fetches the next row and returns it as an object.
Method fetchObject
Fetches the next row and returns it as an object.
Method fetchObject
Fetches the next row and returns it as an object.
Method fetchAll
Fetches all rows.
Method fetchNew
Fetches a new blank row (not from the database).
Method fetchRow
Fetches one row in an object of type Zend_Db_Table_Row_Abstract, or returns Boolean false if no row matches the specified criteria.
Method find
Fetches rows by primary key.
Method findDependentRowset
Query a dependent table to retrieve rows matching the current row.
Method findManyToManyRowset
Method findParentRow
Query a parent table to retrieve the single row matching the current row.
g
top
Method getChainedException
Method getConnection
Returns the underlying database connection object or resource.
Method getFetchMode
Get the fetch mode.
Method getProfiler
Returns the profiler for this adapter.
Method getQuoteIdentifierSymbol
Method getQuoteIdentifierSymbol
Returns the symbol the adapter uses for delimiting identifiers.
Method getQuoteIdentifierSymbol
Returns the symbol the adapter uses for delimited identifiers.
Method getQuoteIdentifierSymbol
Method getElapsedSecs
Get the elapsed time (in seconds) that the query ran.
Method getEnabled
Get the current state of enable. If True is returned, the profiler is enabled.
Method getFilterElapsedSecs
Returns the minimum number of seconds for saving query profiles, or null if query profiles are saved regardless of elapsed time.
Method getFilterQueryType
Returns the types of query profiles saved, or null if queries are saved regardless of their types.
Method getLastQueryProfile
Get the Zend_Db_Profiler_Query object for the last query that was run, regardless if it has ended or not. If the query has not ended, its end time will be null. If no queries have been profiled, false is returned.
Method getQuery
Get the original SQL text of the query.
Method getQueryProfile
Get a profile for a query. Pass it the same handle that was returned by queryStart() and it will return a Zend_Db_Profiler_Query object.
Method getQueryProfiles
Get an array of query profiles (Zend_Db_Profiler_Query objects). If $queryType
Method getQueryType
Get the type of this query (one of the Zend_Db_Profiler::* constants)
Method getTotalElapsedSecs
Get the total elapsed time (in seconds) of all of the profiled queries.
Method getTotalNumQueries
Get the total number of queries that have been profiled. Only queries that have ended will be counted. If $queryType is set to one of the Zend_Db_Profiler::* constants, only queries of that type will be counted.
Method getPart
Get part of the structured information for the currect query.
Class Constant GROUP
Zend_Db_Select::GROUP in Select.php
Method group
Adds grouping to the query.
Method getAttribute
Retrieve a statement attribute.
Method getAttribute
Retrieve a statement attribute.
Method getAttribute
Retrieve a statement attribute.
Method getColumnMeta
Returns metadata for a column in a result set.
Method getAdapter
Gets the Zend_Db_Adapter_Abstract for this particular Zend_Db_Table object.
Method getDefaultAdapter
Gets the default Zend_Db_Adapter_Abstract for all Zend_Db_Table objects.
Method getDefaultMetadataCache
Gets the default metadata cache for information returned by Zend_Db_Adapter_Abstract::describeTable().
Method getDependentTables
Method getMetadataCache
Gets the metadata cache for information returned by Zend_Db_Adapter_Abstract::describeTable().
Method getReference
Method getRowClass
Method getRowsetClass
Method getTable
Returns the table object, or null if this is disconnected row
Method getTable
Returns the table object, or null if this is disconnected rowset
Method getTableClass
Query the class name of the Table object for which this Row was created.
Method getTableClass
Query the class name of the Table object for which this Rowset was created.
h
top
Method hasEnded
Returns true if and only if the query has ended.
Method having
Adds a HAVING condition to the query by AND.
Class Constant HAVING
i
top
Method insert
Inserts a table row with specified data.
Method insert
Inserts a table row with specified data.
Page Inflector.php
Inflector.php in Inflector.php
Class Constant INSERT
Zend_Db_Profiler::INSERT in Profiler.php
Adding new data to the database, such as SQL's INSERT.
Class Constant INNER_JOIN
Page Interface.php
Interface.php in Interface.php
Method info
Returns table information.
Method insert
Inserts a new row.
j
top
Method join
Adds a JOIN table and columns to the query.
Method joinCross
Add a CROSS JOIN table and colums to the query.
Method joinFull
Add a FULL OUTER JOIN table and colums to the query.
Method joinInner
Add an INNER JOIN table and colums to the query
Method joinLeft
Add a LEFT OUTER JOIN table and colums to the query
Method joinNatural
Add a NATURAL JOIN table and colums to the query.
Method joinRight
Add a RIGHT OUTER JOIN table and colums to the query.
k
top
Method key
Return the identifying key of the current element.
l
top
Method lastInsertId
Gets the last ID generated automatically by an IDENTITY/AUTOINCREMENT column.
Method lastInsertId
Gets the last ID generated automatically by an IDENTITY/AUTOINCREMENT column.
Method lastInsertId
Gets the last ID generated automatically by an IDENTITY/AUTOINCREMENT column.
Method lastInsertId
Gets the last ID generated automatically by an IDENTITY/AUTOINCREMENT column.
Method lastInsertId
Gets the last ID generated automatically by an IDENTITY/AUTOINCREMENT column.
Method lastInsertId
Gets the last ID generated automatically by an IDENTITY/AUTOINCREMENT column.
Method lastInsertId
Gets the last ID generated automatically by an IDENTITY/AUTOINCREMENT column.
Method lastInsertId
Gets the last ID generated automatically by an IDENTITY/AUTOINCREMENT column.
Method lastSequenceId
Return the most recent value from the specified sequence in the database.
Method lastSequenceId
Return the most recent value from the specified sequence in the database.
Method lastSequenceId
Return the most recent value from the specified sequence in the database.
Method lastSequenceId
Return the most recent value from the specified sequence in the database.
Method lastSequenceId
Return the most recent value from the specified sequence in the database.
Method limit
Adds an adapter-specific LIMIT clause to the SELECT statement.
Method limit
Adds an adapter-specific LIMIT clause to the SELECT statement.
Method limit
Adds an adapter-specific LIMIT clause to the SELECT statement.
Method limit
Adds an adapter-specific LIMIT clause to the SELECT statement.
Method limit
Adds an adapter-specific LIMIT clause to the SELECT statement.
Method limit
Adds an adapter-specific LIMIT clause to the SELECT statement.
Method limit
Adds an adapter-specific LIMIT clause to the SELECT statement.
Method limit
Adds an adapter-specific LIMIT clause to the SELECT statement.
Method limit
Adds an adapter-specific LIMIT clause to the SELECT statement.
Method listTables
Returns a list of the tables in the database.
Method listTables
Returns a list of the tables in the database.
Method listTables
Returns a list of the tables in the database.
Method listTables
Returns a list of the tables in the database.
Method listTables
Returns a list of the tables in the database.
Method listTables
Returns a list of the tables in the database.
Method listTables
Returns a list of the tables in the database.
Method listTables
Returns a list of the tables in the database.
Method listTables
Returns a list of the tables in the database.
Class Constant LEFT_JOIN
Method limit
Sets a limit count and offset to the query.
Method limitPage
Sets the limit and count by page number.
Class Constant LIMIT_COUNT
Class Constant LIMIT_OFFSET
m
top
Variable $message
Variable $message
Page Mysqli.php
Mysqli.php in Mysqli.php
Page Mssql.php
Mssql.php in Mssql.php
Page Mysql.php
Mysql.php in Mysql.php
Variable $message
Variable $message
Page Mysqli.php
Mysqli.php in Mysqli.php
Class Constant METADATA
Class Constant METADATA_CACHE
n
top
Class Constant NULL_EMPTY_STRING
Class Constant NULL_NATURAL
Class Constant NULL_TO_STRING
Method nextSequenceId
Generate a new value from the specified sequence in the database, and return it.
Method nextSequenceId
Generate a new value from the specified sequence in the database, and return it.
Method nextSequenceId
Generate a new value from the specified sequence in the database, and return it.
Method nextSequenceId
Generate a new value from the specified sequence in the database, and return it.
Method nextSequenceId
Generate a new value from the specified sequence in the database, and return it.
Class Constant NATURAL_JOIN
Method nextRowset
Retrieves the next rowset (result set) for a SQL statement that has multiple result sets. An example is a stored procedure that returns the results of multiple queries.
Method nextRowset
Retrieves the next rowset (result set) for a SQL statement that has multiple result sets. An example is a stored procedure that returns the results of multiple queries.
Method nextRowset
Retrieves the next rowset (result set) for a SQL statement that has multiple result sets. An example is a stored procedure that returns the results of multiple queries.
Method nextRowset
Retrieves the next rowset (result set) for a SQL statement that has multiple result sets. An example is a stored procedure that returns the results of multiple queries.
Method nextRowset
Retrieves the next rowset (result set) for a SQL statement that has multiple result sets. An example is a stored procedure that returns the results of multiple queries.
Class Constant NAME
Method next
Move forward to next element.
o
top
Page Oracle.php
Oracle.php in Oracle.php
Page Oci.php
Oci.php in Oci.php
Method order
Adds a row order to the query.
Class Constant ORDER
Zend_Db_Select::ORDER in Select.php
Method orHaving
Adds a HAVING condition to the query by OR.
Method orWhere
Adds a WHERE condition to the query by OR.
Page Oracle.php
Oracle.php in Oracle.php
Class Constant ON_DELETE
Class Constant ON_UPDATE
p
top
Class Constant PARAM_BOOL
Class Constant PARAM_INPUT_OUTPUT
Class Constant PARAM_INT
Class Constant PARAM_LOB
Class Constant PARAM_NULL
Class Constant PARAM_STMT
Class Constant PARAM_STR
Page Pgsql.php
Pgsql.php in Pgsql.php
Method prepare
Returns an SQL statement for preparation.
Method prepare
Prepare a statement and return a PDOStatement-like object.
Method prepare
Returns an SQL statement for preparation.
Method prepare
Prepares an SQL statement.
Method prepare
Prepare a statement and return a PDOStatement-like object.
Method plural
Pluralize a name.
Page Profiler.php
Profiler.php in Profiler.php
Page Pdo.php
Pdo.php in Pdo.php
Class Constant PRIMARY
q
top
Method query
Prepares and executes an SQL statement with bound data.
Method query
Special handling for PDO query().
Method quote
Safely quotes a value for an SQL statement.
Method quoteColumnAs
Quote a column identifier and alias.
Method quoteIdentifier
Quotes an identifier.
Method quoteInto
Quotes a value and places into a piece of text at a placeholder.
Method quoteTableAs
Quote a table identifier and alias.
Method quoteTableAs
Quote a table identifier and alias.
Method quoteTableAs
Quote a table identifier and alias.
Page Query.php
Query.php in Query.php
Class Constant QUERY
Zend_Db_Profiler::QUERY in Profiler.php
Any general database query that does not fit into the other constants.
Method queryEnd
Ends a query. Pass it the handle that was returned by queryStart().
Method queryStart
Starts a query. Creates a new query profile object (Zend_Db_Profiler_Query)
Method query
r
top
Method rollBack
Roll back a transaction and return to autocommit mode.
Method reset
Clear parts of the Select object, or an individual part.
Class Constant RIGHT_JOIN
Method rowCount
Returns the number of rows affected by the execution of the last INSERT, DELETE, or UPDATE statement executed by this statement object.
Method rowCount
Returns the number of rows affected by the execution of the last INSERT, DELETE, or UPDATE statement executed by this statement object.
Method rowCount
Returns the number of rows affected by the execution of the last INSERT, DELETE, or UPDATE statement executed by this statement object.
Method rowCount
Returns the number of rows affected by the execution of the last INSERT, DELETE, or UPDATE statement executed by this statement object.
Method rowCount
Returns the number of rows affected by the execution of the last INSERT, DELETE, or UPDATE statement executed by this statement object.
Page Row.php
Row.php in Row.php
Page Rowset.php
Rowset.php in Rowset.php
Class Constant REFERENCE_MAP
Class Constant REF_COLUMNS
Class Constant REF_TABLE_CLASS
Class Constant RESTRICT
Method rewind
Rewind the Iterator to the first element.
Class Constant ROWSET_CLASS
Class Constant ROW_CLASS
s
top
Page Sqlite.php
Sqlite.php in Sqlite.php
Method select
Creates and returns a new Zend_Db_Select object for this adapter.
Method setFetchMode
Set the fetch mode.
Method setFetchMode
Set the fetch mode.
Method setFetchMode
Set the fetch mode.
Method setFetchMode
Set the fetch mode.
Method setFetchMode
Set the PDO fetch mode.
Method singular
Singularize a name.
Class Constant SELECT
Zend_Db_Profiler::SELECT in Profiler.php
Retrieving information from the database, such as SQL's SELECT.
Method setEnabled
Enable or disable the profiler. If $enable is false, the profiler is disabled and will not log any queries sent to it.
Method setFilterElapsedSecs
Sets a minimum number of seconds for saving query profiles. If this is set, only those queries whose elapsed time is equal or greater than $minimumSeconds will be saved. To save all queries regardless of elapsed time, set $minimumSeconds to null.
Method setFilterQueryType
Sets the types of query profiles to save. Set $queryType to one of the Zend_Db_Profiler::* constants to only save profiles for that type of query. To save more than one type, logical OR them together. To save all queries regardless of type, set $queryType to null.
Page Select.php
Select.php in Select.php
Page Statement.php
Statement.php in Statement.php
Method setAttribute
Set a statement attribute.
Method setAttribute
Set a statement attribute.
Method setAttribute
Set a statement attribute.
Method setFetchMode
Set the default fetch mode for this statement.
Method setFetchMode
Set the default fetch mode for this statement.
Method setFetchMode
Set the default fetch mode for this statement.
Method save
Saves the properties to the database.
Class Constant SCHEMA
Class Constant SEQUENCE
Method setDefaultAdapter
Sets the default Zend_Db_Adapter_Abstract for all Zend_Db_Table objects.
Method setDefaultMetadataCache
Sets the default metadata cache for information returned by Zend_Db_Adapter_Abstract::describeTable().
Method setDependentTables
Method setFromArray
Sets all data in the row from an array.
Method setReferences
Method setRowClass
Method setRowsetClass
Method setTable
Set the table object, to re-establish a live connection to the database for a Row that has been de-serialized.
Method setTable
Set the table object, to re-establish a live connection to the database for a Rowset that has been de-serialized.
Class Constant SET_NULL
t
top
Class Constant TRANSACTION
Transactional operation, such as start transaction, commit, or rollback.
Page Table.php
Table.php in Table.php
Method toArray
Returns the column/value data as an array.
Method toArray
Returns all data as an array.
u
top
Method update
Updates table rows with specified data based on a WHERE clause.
Method update
Updates table rows with specified data based on a WHERE clause.
Method underscore
Convert camelCaps to underscore_words.
Class Constant UPDATE
Zend_Db_Profiler::UPDATE in Profiler.php
Updating existing information in the database, such as SQL's UPDATE.
Method update
Updates existing rows.
v
top
Method valid
Check if there is a current element after calls to rewind() or next().
w
top
Class Constant WHERE
Zend_Db_Select::WHERE in Select.php
Method where
Adds a WHERE condition to the query by AND.
z
top
Class Zend_Db
Zend_Db in Db.php
Class for connecting to SQL databases and performing common operations.
Class Zend_Db_Exception
Zend_Db_Exception in Exception.php
Class Zend_Db_Adapter_Abstract
Zend_Db_Adapter_Abstract in Abstract.php
Class for connecting to SQL databases and performing common operations.
Class Zend_Db_Adapter_Db2
Class Zend_Db_Adapter_Db2_Exception
Zend_Db_Adapter_Db2_Exception
Class Zend_Db_Adapter_Exception
Zend_Db_Adapter_Exception in Exception.php
Class Zend_Db_Adapter_Mysqli
Class Zend_Db_Adapter_Mysqli_Exception
Zend_Db_Adapter_Mysqli_Exception
Class Zend_Db_Adapter_Oracle
Class Zend_Db_Adapter_Oracle_Exception
Zend_Db_Adapter_Oracle_Exception
Class Zend_Db_Adapter_Pdo_Abstract
Class for connecting to SQL databases and performing common operations using PDO.
Class Zend_Db_Adapter_Pdo_Mssql
Class for connecting to Microsoft SQL Server databases and performing common operations.
Class Zend_Db_Adapter_Pdo_Mysql
Class for connecting to MySQL databases and performing common operations.
Class Zend_Db_Adapter_Pdo_Oci
Class for connecting to Oracle databases and performing common operations.
Class Zend_Db_Adapter_Pdo_Pgsql
Class for connecting to PostgreSQL databases and performing common operations.
Class Zend_Db_Adapter_Pdo_Sqlite
Class for connecting to SQLite2 and SQLite3 databases and performing common operations.
Class Zend_Db_Expr
Zend_Db_Expr in Expr.php
Class for SQL SELECT fragments.
Class Zend_Db_Inflector
Zend_Db_Inflector in Inflector.php
Class for name inflections.
Class Zend_Db_Profiler
Zend_Db_Profiler in Profiler.php
Class Zend_Db_Profiler_Exception
Class Zend_Db_Profiler_Query
Class Zend_Db_Select
Zend_Db_Select in Select.php
Class for SQL SELECT generation and results.
Class Zend_Db_Select_Exception
Zend_Db_Select_Exception in Exception.php
Class Zend_Db_Statement
Zend_Db_Statement in Statement.php
Abstract class to emulate a PDOStatement for native database adapters.
Class Zend_Db_Statement_Db2
Extends for DB2 native adapter.
Class Zend_Db_Statement_Db2_Exception
Class Zend_Db_Statement_Exception
Zend_Db_Statement_Exception
Class Zend_Db_Statement_Interface
Emulates a PDOStatement for native database adapters.
Class Zend_Db_Statement_Mysqli
Extends for Mysqli
Class Zend_Db_Statement_Mysqli_Exception
Class Zend_Db_Statement_Oracle
Extends for Oracle.
Class Zend_Db_Statement_Oracle_Exception
Class Zend_Db_Statement_Pdo
Proxy class to wrap a PDOStatement object.
Class Zend_Db_Table
Zend_Db_Table in Table.php
Class for SQL table interface.
Class Zend_Db_Table_Abstract
Zend_Db_Table_Abstract in Abstract.php
Class for SQL table interface.
Class Zend_Db_Table_Exception
Zend_Db_Table_Exception in Exception.php
Class Zend_Db_Table_Row
Reference concrete class that extends Zend_Db_Table_Row_Abstract.
Class Zend_Db_Table_Rowset
Zend_Db_Table_Rowset in Rowset.php
Reference concrete class that extends Zend_Db_Table_Rowset_Abstract.
Class Zend_Db_Table_Rowset_Abstract
Class Zend_Db_Table_Row_Abstract
Class Zend_Db_Table_Row_Exception
a b c d e f g h i j k l m n o p q r s t u v w z _