PHP 클래스 PDOWrapper

저자: xuanyan ([email protected])

상속: extends DatabaseAbstract, implements DatabaseWrapper

파일 보기 프로젝트 열기: mikehenrty/thin-pdo-wrapper 1 사용 예제들

공개 프로퍼티들

프로퍼티	타입	설명
$LOG_ERRORS	boolean	Write all errors to error log
$TIMESTAMP_WRITES	boolean	Automatically add/update created/updated fields

보호된 프로퍼티들

프로퍼티	타입	설명
$config_master		Dynamic master config creds
$config_slaves		Dynamic slave config creds
$instance	PDOWrapper	A reference to the singleton instance
$pdo_exception		We will cache any PDO errors in case we want to get out them externally
$pdo_master		The PDO objects for the master connection
$pdo_slave		The PDO objects for the slave connection

공개 메소드들

메소드	설명
__destruct ( )	Destructor.
configMaster ( $host, $name, $user, $password, $port = null, $driver = 'mysql' )	method configMaster - configure connection credentials to the master db server
configSlave ( $host, $name, $user, $password, $port = null, $driver = 'mysql' )	method configSlave - configure a connection to a slave (can be called multiple times)
delete ( $table, $params = [] ) : boolean	method delete.
execute ( string $query, $params = [] ) : mixed	method execute.
getErrorMessage ( )	method getErrorMessage.
getPDOException ( )	method getError.
insert ( string $table, array $params = [], boolean $timestamp_this = null ) : mixed	method insert.
insertMultiple ( string $table, array $columns = [], $rows = [], boolean $timestamp_these = null ) : mixed	method insertMultiple.
instance ( ) : -	method instance.
query ( string $query, array $params = [], boolean $use_master = false ) : mixed	method query.
queryFirst ( string $query, array $params = [], boolean $use_master = false ) : mixed	method queryFirst.
select ( string $table, array $params = null, integer $limit = null, integer $start = null, array $order_by = null, boolean $use_master = false ) : mixed	method select.
selectFirst ( $table, $params = [], array $order_by = null ) : mixed	method selectFirst.
selectFirstMaster ( $table, $params = [], array $order_by = null ) : mixed	method selectFirstMaster.
selectMaster ( $table, $params = [], integer $limit = null, integer $start = null, array $order_by = null ) : mixed	method selectMaster.
update ( string $table, array $params, array $wheres = [], boolean $timestamp_this = null ) : integer \| boolean	method update.

보호된 메소드들

메소드	설명
__construct ( )	Constructor.
createConnection ( $driver, $host, $name, $user, $password, $port = null ) : PDO	method createConnection.
getMaster ( )	method getMaster.
getSlave ( )	method getSlave.

비공개 메소드들

메소드	설명
validateDriver ( string $driver ) : boolean	Validate the database in question is supported by your installation of PHP.

메소드 상세

__construct() 보호된 메소드

- make protected so only subclasses and self can create this object (singleton)

protected __construct ( )

__destruct() 공개 메소드

- release the PDO db connections

public __destruct ( )

configMaster() 공개 메소드

method configMaster - configure connection credentials to the master db server

public configMaster ( $host, $name, $user, $password, $port = null, $driver = 'mysql' )

configSlave() 공개 메소드

method configSlave - configure a connection to a slave (can be called multiple times)

public configSlave ( $host, $name, $user, $password, $port = null, $driver = 'mysql' )

createConnection() 보호된 메소드

- create a PDO connection using the credentials provided

protected createConnection ( $driver, $host, $name, $user, $password, $port = null ) : PDO
리턴	PDO	object with a connection to the database specified

delete() 공개 메소드

- deletes rows from a table based on the parameters

public delete ( $table, $params = [] ) : boolean
리턴	boolean	- associate representing the fetched table row, false on failure

execute() 공개 메소드

- executes a query that modifies the database

public execute ( string $query, $params = [] ) : mixed
$query	string	- the SQL query we are executing
리턴	mixed	- the affected rows, false on failure

getErrorMessage() 공개 메소드

- returns the last error message caught

public getErrorMessage ( )

getMaster() 보호된 메소드

- grab the PDO connection to the master DB

protected getMaster ( )

getPDOException() 공개 메소드

- returns the actual PDO exception

public getPDOException ( )

getSlave() 보호된 메소드

- grab the PDO connection to the slave DB, create it if not there

protected getSlave ( )

insert() 공개 메소드

- adds a row to the specified table

public insert ( string $table, array $params = [], boolean $timestamp_this = null ) : mixed
$table	string	- the name of the db table we are adding row to
$params	array	- associative array representing the columns and their respective values
$timestamp_this	boolean	(Optional), if true we set date_created and date_modified values to now
리턴	mixed	- new primary key of inserted table, false on failure

insertMultiple() 공개 메소드

- adds multiple rows to a table with a single query

public insertMultiple ( string $table, array $columns = [], $rows = [], boolean $timestamp_these = null ) : mixed
$table	string	- the name of the db table we are adding row to
$columns	array	- contains the column names
$timestamp_these	boolean	(Optional), if true we set date_created and date_modified values to NOW() for each row
리턴	mixed	- new primary key of inserted table, false on failure

instance() 공개 정적인 메소드

- static, for singleton, for creating a global instance of this object

public static instance ( ) : -
리턴	-

query() 공개 메소드

- returns data from a free form select query

public query ( string $query, array $params = [], boolean $use_master = false ) : mixed
$query	string	- the SQL query we are executing
$params	array	- a list of bind parameters
$use_master	boolean	(Optional) - whether or not to use the master connection
리턴	mixed	- the affected rows, false on failure

queryFirst() 공개 메소드

- returns the first record from a free form select query

public queryFirst ( string $query, array $params = [], boolean $use_master = false ) : mixed
$query	string	- the SQL query we are executing
$params	array	- a list of bind parameters
$use_master	boolean	(Optional) - whether or not to use the master connection
리턴	mixed	- the affected rows, false on failure

select() 공개 메소드

- retrieve information from the database, as an array

public select ( string $table, array $params = null, integer $limit = null, integer $start = null, array $order_by = null, boolean $use_master = false ) : mixed
$table	string	- the name of the db table we are retreiving the rows from
$params	array	- associative array representing the WHERE clause filters
$limit	integer	(optional) - the amount of rows to return
$start	integer	(optional) - the row to start on, indexed by zero
$order_by	array	(optional) - an array with order by clause
$use_master	boolean	(optional) - use the master db for this read
리턴	mixed	- associate representing the fetched table row, false on failure

selectFirst() 공개 메소드

- retrieve the first row returned from a select statement

public selectFirst ( $table, $params = [], array $order_by = null ) : mixed
$order_by	array	(optional) - an array with order by clause
리턴	mixed	- associate representing the fetched table row, false on failure

selectFirstMaster() 공개 메소드

- retrieve the first row returned from a select statement using the master database

public selectFirstMaster ( $table, $params = [], array $order_by = null ) : mixed
$order_by	array	(optional) - an array with order by clause
리턴	mixed	- associate representing the fetched table row, false on failure

selectMaster() 공개 메소드

- retrieve information from the master database, as an array

public selectMaster ( $table, $params = [], integer $limit = null, integer $start = null, array $order_by = null ) : mixed
$limit	integer	(optional) - the amount of rows to return
$start	integer	(optional) - the row to start on, indexed by zero
$order_by	array	(optional) - an array with order by clause
리턴	mixed	- associate representing the fetched table row, false on failure

update() 공개 메소드

- updates a row to the specified table

public update ( string $table, array $params, array $wheres = [], boolean $timestamp_this = null ) : integer \| boolean
$table	string	- the name of the db table we are adding row to
$params	array	- associative array representing the columns and their respective values to update
$wheres	array	(Optional) - the where clause of the query
$timestamp_this	boolean	(Optional) - if true we set date_created and date_modified values to now
리턴	integer \| boolean	- the amount of rows updated, false on failure

프로퍼티 상세

$LOG_ERRORS 공개적으로 정적으로 프로퍼티

Write all errors to error log

public static bool $LOG_ERRORS
리턴	boolean

$TIMESTAMP_WRITES 공개적으로 정적으로 프로퍼티

Automatically add/update created/updated fields

public static bool $TIMESTAMP_WRITES
리턴	boolean

$config_master 보호되어 있는 프로퍼티

Dynamic master config creds

protected $config_master

$config_slaves 보호되어 있는 프로퍼티

Dynamic slave config creds

protected $config_slaves

$instance 보호되어 있는 정적으로 프로퍼티

A reference to the singleton instance

protected static PDOWrapper $instance
리턴	PDOWrapper

$pdo_exception 보호되어 있는 프로퍼티

We will cache any PDO errors in case we want to get out them externally

protected $pdo_exception

$pdo_master 보호되어 있는 프로퍼티

The PDO objects for the master connection

protected $pdo_master

$pdo_slave 보호되어 있는 프로퍼티

The PDO objects for the slave connection

protected $pdo_slave