\PDOStatement_mysql

Class PDOStatement_mysql This class is used from class PDO_mysql to manage a MySQL database.

Look at PDO.clas.php file comments to know more about MySQL connection.

Summary

Methods

Properties

Constants

PDOStatement_mysql()
bindParam()
columnCount()
errorCode()
errorInfo()
execute()
fetch()
fetchAll()
fetchSingle()
fetchColumn()
rowCount()
getAttribute()
setAttribute()
setFetchMode()
bindColumn()
__setErrors()
__uquery()

$__connection
$__dbinfo
$__persistent
$__query
$__result
$__fetchmode
$__errorCode
$__errorInfo
$__boundParams

No constants found

No protected methods found

No protected properties found

N/A

No private methods found

No private properties found

N/A

File: framework/library/pdo/PDOStatement_mysql.class.php
Package: Default
Class hierarchy: \PDOStatement_mysql

Tags

Compatibility	= PHP 4
Dependencies	PDO.class.php PDO_mysql.class.php
Author	Andrea Giammarchi
Site	http://www.devpro.it/
Mail	andrea [ at ] 3site [ dot ] it
Date	2005/10/13
LastModified	2006/01/29 09:30 [fixed execute bug]
Version	0.1b - tested

Properties

$__connection

$__connection :

'Private' variables: __connection:Resource Database connection __dbinfo:Array Array with 4 elements used to manage connection __persistent:Boolean Connection mode, is true on persistent, false on normal (deafult) connection __query:String Last query used __result:Resource Last result from last query __fetchmode:Integer constant PDO_FETCH_* result mode __errorCode:String Last error string code __errorInfo:Array Last error informations, code, number, details __boundParams:Array Stored bindParam

Type

$__dbinfo

$__dbinfo :

Type

$__persistent

$__persistent :

Type

$__query

$__query :

Type

$__result

$__result :

Type

$__fetchmode

$__fetchmode :

Type

$__errorCode

$__errorCode :

Type

$__errorInfo

$__errorInfo :

Type

$__boundParams

$__boundParams :

Type

Methods

PDOStatement_mysql()

PDOStatement_mysql(  $__query,   $__connection,   $__dbinfo)

Public constructor: Called from PDO to create a PDOStatement for this database new PDOStatement_sqlite( &$__query:String, &$__connection:Resource, $__dbinfo:Array )

Parameters

	$__query
	$__connection
	$__dbinfo

Inherited from: \PDOStatement_mysql

Tags

Param

String query to prepare

Resource database connection

Array 4 elements array to manage connection

bindParam()

bindParam(  $mixed,   $variable,   $type = null,   $lenght = null)

Public method: Replace ? or :named values to execute prepared query this->bindParam( $mixed:Mixed, &$variable:Mixed, $type:Integer, $lenght:Integer ):Void

Parameters

	$mixed
	$variable
	$type
	$lenght

Inherited from: \PDOStatement_mysql

Tags

Param

Mixed Integer or String to replace prepared value

Mixed variable to replace

Integer this variable is not used but respects PDO original accepted parameters

columnCount()

columnCount()

Public method: Checks if query was valid and returns how may fields returns this->columnCount( void ):Void

errorCode()

errorCode()

Public method: Returns a code rappresentation of an error this->errorCode( void ):String

Inherited from: \PDOStatement_mysql

Tags

Return	String String rappresentation of the error

errorInfo()

errorInfo()

Public method: Returns an array with error informations this->errorInfo( void ):Array

Inherited from: \PDOStatement_mysql

Tags

Return	Array Array with 3 keys: 0 => error code 1 => error number 2 => error string

execute()

execute(  $array = array())

Public method: Excecutes a query and returns true on success or false.

this->exec( $array:Array ):Boolean

Parameters

$array

Inherited from: \PDOStatement_mysql

Tags

Param	Array If present, it should contain all replacements for prepared query
Return	Boolean true if query has been done without errors, false otherwise

fetch()

fetch(  $mode = PDO_FETCH_ASSOC,   $cursor = null,   $offset = null)

Public method: Returns, if present, next row of executed query or false.

this->fetch( $mode:Integer, $cursor:Integer, $offset:Integer ):Mixed

Parameters

	$mode
	$cursor
	$offset

Inherited from: \PDOStatement_mysql

Tags

Param

Integer PDOFETCH* constant to know how to read next row, default PDO_FETCH_BOTH NOTE: if $mode is omitted is used default setted mode, PDO_FETCH_BOTH

Integer this variable is not used but respects PDO original accepted parameters

Return

Mixed Next row of executed query or false if there is nomore.

fetchAll()

fetchAll(  $mode = PDO_FETCH_ASSOC)

Public method: Returns an array with all rows of executed query.

this->fetchAll( $mode:Integer ):Array

Parameters

$mode

Inherited from: \PDOStatement_mysql

Tags

Param	Integer PDOFETCH* constant to know how to read all rows, default PDO_FETCH_BOTH NOTE: this doesn't work as fetch method, then it will use always PDO_FETCH_BOTH if this param is omitted
Return	Array An array with all fetched rows

fetchSingle()

fetchSingle()

Public method: Returns, if present, first column of next row of executed query this->fetchSingle( void ):Mixed

Inherited from: \PDOStatement_mysql

Tags

Return	Mixed Null or next row's first column

fetchColumn()

fetchColumn(  $column)

Parameters

$column

rowCount()

rowCount()

Public method: Returns number of last affected database rows this->rowCount( void ):Integer

Inherited from: \PDOStatement_mysql

Tags

Return	Integer number of last affected rows NOTE: works with INSERT, UPDATE and DELETE query type

getAttribute()

getAttribute(  $attribute)

Public method: Quotes correctly a string for this database this->getAttribute( $attribute:Integer ):Mixed

Parameters

$attribute

Inherited from: \PDOStatement_mysql

Tags

Param	Integer a constant [ PDO_ATTR_SERVER_INFO, PDO_ATTR_SERVER_VERSION, PDO_ATTR_CLIENT_VERSION, PDO_ATTR_PERSISTENT ]
Return	Mixed correct information or false

setAttribute()

setAttribute(  $attribute,   $mixed)

Public method: Sets database attributes, in this version only connection mode.

this->setAttribute( $attribute:Integer, $mixed:Mixed ):Boolean

Parameters

	$attribute
	$mixed

Inherited from: \PDOStatement_mysql

Tags

Param

Integer PDO_* constant, in this case only PDO_ATTR_PERSISTENT

Mixed value for PDO_* constant, in this case a Boolean value true for permanent connection, false for default not permament connection

Return

Boolean true on change, false otherwise

setFetchMode()

setFetchMode(  $mode)

Public method: Sets default fetch mode to use with this->fetch() method.

this->setFetchMode( $mode:Integer ):Boolean

Parameters

$mode

Inherited from: \PDOStatement_mysql

Tags

Param	Integer PDOFETCH* constant to use while reading an execute query with fetch() method. NOTE: PDO_FETCH_LAZY and PDO_FETCH_BOUND are not supported
Return	Boolean true on change, false otherwise

bindColumn()

bindColumn(  $mixewd,   $param,   $type = null,   $max_length = null,   $driver_option = null)

Parameters

	$mixewd
	$param
	$type
	$max_length
	$driver_option

__setErrors()

__setErrors(  $er)

Parameters

$er

__uquery()

__uquery(  $query)

Parameters

$query