StudipPDO Class Reference

Inheritance diagram for StudipPDO:

Collaboration diagram for StudipPDO:

Public Member Functions
	quote ($value, $type=NULL)
	exec ($statement)
	query ($statement, $mode=NULL, $arg1=NULL, $arg2=NULL)
	prepare ($statement, $driver_options=array())
	prepareStatement ($statement, $driver_options=array())

Data Fields
const	PARAM_ARRAY = 100
const	PARAM_COLUMN = 101

Protected Member Functions
	verify ($statement)

Static Protected Member Functions
static	replaceStrings ($statement)

Detailed Description

This is a special variant of the standard PDO class that does not allow multiple statement execution.

Member Function Documentation

exec()

exec

(

$statement

)

Executes an SQL statement and returns the number of affected rows.

Parameters

string

SQL statement

Returns

int number of affected rows

Here is the call graph for this function:

prepare()

prepare	(		$statement,
			$driver_options = array()
	)

Prepares a statement for execution and returns a statement object.

Parameters

string

SQL statement

Returns

object PDOStatement object

Here is the call graph for this function:

prepareStatement()

prepareStatement	(		$statement,
			$driver_options = array()
	)

This method is intended only for use by the StudipPDOStatement class.

Parameters

string

SQL statement

Returns

object PDOStatement object

query()

query	(		$statement,
			$mode = NULL,
			$arg1 = NULL,
			$arg2 = NULL
	)

Executes an SQL statement, returning a result set as a statement object.

Parameters

string	SQL statement
int	fetch mode (optional)
mixed	fetch mode parameter (see PDOStatement::setFetchMode)
mixed	fetch mode parameter (see PDOStatement::setFetchMode)

Returns

object PDOStatement object

Here is the call graph for this function:

Here is the caller graph for this function:

quote()

quote	(		$value,
			$type = NULL
	)

Quotes the given value in a form appropriate for the type. If no explicit type is given, the value's PHP type is used.

Parameters

string	PHP value to quote
int	parameter type (e.g. PDO::PARAM_STR)

Returns

string quoted SQL string

replaceStrings()

static replaceStrings (   $statement )

staticprotected

Replaces all string literals in the statement with placeholders.

Parameters

string

SQL statement

Returns

string modified SQL statement

verify()

verify (   $statement )

protected

Verifies that the given SQL query only contains a single statement.

Parameters

string

SQL statement to check

Exceptions

PDOException

when the query contains multiple statements

Here is the caller graph for this function:

Field Documentation

PARAM_ARRAY

const PARAM_ARRAY = 100

PARAM_COLUMN

const PARAM_COLUMN = 101

---

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

• lib/classes/StudipPDO.class.php