PDO Class Reference

Inheritance diagram for PDO:

Collaboration diagram for PDO:

Public Member Functions
	select (\lib360\db\connection\IConnection $db, $query, array $values=NULL, $name=NULL)
	update (\lib360\db\connection\IConnection $db, $query, array $values=NULL)
	insert (\lib360\db\connection\IConnection $db, $query, array $values=NULL)
	delete (\lib360\db\connection\IConnection $db, $query, array $values=NULL)
	query (\lib360\db\connection\IConnection $db, $query, array $values=NULL)
	bindValues (\PDOStatement $sth, array $values=NULL)

Static Public Attributes
static	$typeMap

---

Detailed Description

PDO executor implementation

---

Member Function Documentation

bindValues	(	\PDOStatement	$sth,
		array	$values = NULL
	)

Binds values to PDOStatement.

Parameters:

\PDOStatement	$sth	PDO statement object to which values will be bound
array	$values	optional array of values ( or primitive types) for prepared statement

Here is the caller graph for this function:

delete	(	\lib360\db\connection\IConnection	$db,
			$query,
		array	$values = NULL
	)

Executes database delete.

Parameters:

\lib360\db\connection\IConnection	$db	database connection object
string	$query	prepared query statement
array	$values	optional array of values for prepared statement

Returns:

integer number of rows deleted

Exceptions:

PreparedQueryException

when database error occurs during query execution

Implements IExecutor.

Here is the call graph for this function:

insert	(	\lib360\db\connection\IConnection	$db,
			$query,
		array	$values = NULL
	)

Executes database insert.

Parameters:

\lib360\db\connection\IConnection	$db	object
string	$query	prepared query statement
array	$values	optional array of values for prepared statement

Returns:

integer number of rows inserted

Exceptions:

PreparedQueryException

when database error occurs during query execution

Implements IExecutor.

Here is the call graph for this function:

query	(	\lib360\db\connection\IConnection	$db,
			$query,
		array	$values = NULL
	)

Executes a generic database query.

Parameters:

\lib360\db\connection\IConnection	$db	database connection object
string	$query	prepared query statement
array	$values	optional array of values for prepared statement

Exceptions:

PreparedQueryException

when database error occurs during query execution

Implements IExecutor.

Here is the call graph for this function:

select	(	\lib360\db\connection\IConnection	$db,
			$query,
		array	$values = NULL,
			$name = NULL
	)

Executes database select.

Parameters:

\lib360\db\connection\IConnection	$db	database connection object
string	$query	prepared query statement
array	$values	optional array of values for prepared statement
string	$name	optional name to use for identifying records

Returns:

object

Exceptions:

\lib360\db\executor\PreparedQueryException

when database error occurs during query execution

Implements IExecutor.

Here is the call graph for this function:

update	(	\lib360\db\connection\IConnection	$db,
			$query,
		array	$values = NULL
	)

Executes database update.

Parameters:

\lib360\db\connection\IConnection	$db	database connection object
string	$query	prepared query statement
array	$values	optional array of values for prepared statement

Returns:

integer number of rows updated

Exceptions:

PreparedQueryException

when database error occurs during query execution

Implements IExecutor.

Here is the call graph for this function:

---

Field Documentation

$typeMap

static

Initial value:

 array(
        \lib360\db\value\Value::TYPE_BOOLEAN => \PDO::PARAM_BOOL,
        \lib360\db\value\Value::TYPE_NULL => \PDO::PARAM_NULL,
        \lib360\db\value\Value::TYPE_STRING => \PDO::PARAM_STR,
        \lib360\db\value\Value::TYPE_INTEGER => \PDO::PARAM_INT,
        \lib360\db\value\Value::TYPE_FLOAT => \PDO::PARAM_STR,
        \lib360\db\value\Value::TYPE_BINARY => \PDO::PARAM_LOB
    )

Maps types to PDO parameter types

---

The documentation for this class was generated from the following file:

• lib360/db/executor/PDO.php