Class Auth_OpenID_DatabaseConnection
An empty base class intended to emulate PEAR connection
functionality in applications that supply their own database
abstraction mechanisms. See Auth_OpenID_SQLStore for more
information. You should subclass this class if you need to create
an SQL store that needs to access its database using an
application's database abstraction layer instead of a PEAR database
connection. Any subclass of Auth_OpenID_DatabaseConnection MUST
adhere to the interface specified here.
Methods summary
public
|
#
autoCommit( boolean $mode )
Sets auto-commit mode on this database connection.
Sets auto-commit mode on this database connection.
Parameters
- $mode
True if auto-commit is to be used; false if
not.
|
public
mixed
|
#
query( string $sql, array $params = array() )
Run an SQL query with the specified parameters, if any.
Run an SQL query with the specified parameters, if any.
Parameters
- $sql
An SQL string with placeholders. The
placeholders are assumed to be specific to the database engine
for this connection. - $params
An array of parameters to insert into the
SQL string using this connection's escaping mechanism. Returns
mixed $result The result of calling this connection's
internal query function. The type of result depends on the
underlying database engine. This method is usually used when
the result of a query is not important, like a DDL query.
|
public
|
#
begin( )
Starts a transaction on this connection, if supported.
Starts a transaction on this connection, if supported.
|
public
|
#
commit( )
Commits a transaction on this connection, if supported.
Commits a transaction on this connection, if supported.
|
public
|
#
rollback( )
Performs a rollback on this connection, if supported.
Performs a rollback on this connection, if supported.
|
public
mixed
|
#
getOne( string $sql, array $params = array() )
Run an SQL query and return the first column of the first row
of the result set, if any.
Run an SQL query and return the first column of the first row
of the result set, if any.
Parameters
- $sql
An SQL string with placeholders. The
placeholders are assumed to be specific to the database engine
for this connection. - $params
An array of parameters to insert into the
SQL string using this connection's escaping mechanism. Returns
mixed $result The value of the first column of the
first row of the result set. False if no such result was
found.
|
public
array
|
#
getRow( string $sql, array $params = array() )
Run an SQL query and return the first row of the result set, if
any.
Run an SQL query and return the first row of the result set, if
any.
Parameters
- $sql
An SQL string with placeholders. The
placeholders are assumed to be specific to the database engine
for this connection. - $params
An array of parameters to insert into the
SQL string using this connection's escaping mechanism. Returns
array $result The first row of the result set, if any,
keyed on column name. False if no such result was found.
|
public
array
|
#
getAll( string $sql, array $params = array() )
Run an SQL query with the specified parameters, if any.
Run an SQL query with the specified parameters, if any.
Parameters
- $sql
An SQL string with placeholders. The
placeholders are assumed to be specific to the database engine
for this connection. - $params
An array of parameters to insert into the
SQL string using this connection's escaping mechanism. Returns
array $result An array of arrays representing the
result of the query; each array is keyed on column name.
|