PHP 인터페이스 iaInterfaceDbAdapter

all() 공개 메소드

Returns table rows as array

public all ( string $fields = self::ALL_COLUMNS_SELECTION, string $condition = '', integer $start, integer | null $limit = null, string | null $tableName = null ) : array
$fields	string	fields to be selected
$condition	string	condition for the selection
$start	integer	start position
$limit	integer | null	number of records to be returned
$tableName	string | null	table name to select records from, null uses current set table
리턴	array

assoc() 공개 메소드

Returns associative array of rows, first column of the query is used as a key

public assoc ( string $fields = self::ALL_COLUMNS_SELECTION, string $condition = '', string | null $tableName = null, integer $start, integer | null $limit = null ) : array
$fields	string	fields to be selected
$condition	string	condition for the selection
$tableName	string | null	table name to select records from, null uses current set table
$start	integer	start position
$limit	integer | null	number of records to be returned
리턴	array

bind() 공개 메소드

Ex: $sql = "SELECT * FROM users WHERE user = :user AND password = :password"; mysqli_bind($sql, array('user' => $user, 'password' => $password)); mysqli_query($sql);

public bind ( string &$sql, array $values ) : void
$sql	string	sql query to be processed
$values	array	real values key=>value array to be replaced in sql query
리턴	void

cascadeDelete() 공개 메소드

Accepts array of table names and deletes records in them

public cascadeDelete ( string | array $tbl, string $where = '' ) : boolean | integer
$tbl	string | array	table name(s)
$where	string	sql condition to perform deletion
리턴	boolean | integer

convertIds() 공개 정적인 메소드

Ex: $where = $iaCore->iaDb->convertIds('id', array('1', '3', '5', '6')); echo $where; // id = IN('1', '3', '5', '6')

public static convertIds ( array | string | integer $ids, string $columnName = 'id', boolean $equal = true ) : boolean | string
$ids	array | string | integer
$columnName	string	field name
$equal	boolean	operand type
리턴	boolean | string

delete() 공개 메소드

Deletes records in a table and returns number of affected rows by the query

public delete ( string $condition, string | null $tableName = null, array $values = [] ) : integer
$condition	string	condition to perform deletion
$tableName	string | null	table name where to perform deletion, null - deletes currently set table
$values	array	real values key=>value array to be replaced in condition
리턴	integer

describe() 공개 메소드

Provides information about the columns in a table

public describe ( null $tableName = null, boolean $addPrefix = true ) : array
$tableName	null	table name
$addPrefix	boolean	avoid prefix addition if false
리턴	array

exists() 공개 메소드

Returns true if at least 1 record exists

public exists ( string $where, array $values = [], null $tableName = null ) : boolean
$where	string	condition
$values	array
$tableName	null	table name
리턴	boolean

foundRows() 공개 메소드

Returns number of found rows of the previous query with SQL_CALC_FOUND_ROWS Note: this SQL function is MySQL specific

public foundRows ( ) : integer
리턴	integer

getAffected() 공개 메소드

Returns a number of affected rows in a previous INSERT operation

public getAffected ( ) : integer
리턴	integer

getAll() 공개 메소드

Returns table rows as array

public getAll ( string $sql, integer $start, integer $limit ) : array
$sql	string	sql query
$start	integer	start position
$limit	integer	number of rows to be returned
리턴	array

getAssoc() 공개 메소드

Returns associative array of rows, first column of the query is used as a key

public getAssoc ( string $sql, boolean $singleRow = false ) : array
$sql	string	sql query
$singleRow	boolean
리턴	array

getCount() 공개 메소드

Returns number of queries

public getCount ( ) : integer
리턴	integer

getEnumValues() 공개 메소드

Returns all ENUM and SET values for selected table and field

public getEnumValues ( string $table, string $field ) : array | boolean
$table	string	table name
$field	string	field name
리턴	array | boolean

getErrorNumber() 공개 메소드

Returns the numerical value of the error message from previous database operation

public getErrorNumber ( ) : integer
리턴	integer

getInsertId() 공개 메소드

Returns the ID generated in the last query

public getInsertId ( ) : integer
리턴	integer

getKeyValue() 공개 메소드

Returns key => value pair array of rows

public getKeyValue ( string $sql ) : array
$sql	string	sql query
리턴	array

getLastQuery() 공개 메소드

Returns last executed query

public getLastQuery ( ) : string
리턴	string

getMaxOrder() 공개 메소드

Returns max value for order column

public getMaxOrder ( string $table = null, array $condition = null ) : boolean | mixed
$table	string	table name
$condition	array	column name, value
리턴	boolean | mixed

getNumRows() 공개 메소드

Returns a number of rows in a result

public getNumRows ( resource $resource ) : integer
$resource	resource	query resource
리턴	integer

getOne() 공개 메소드

Returns field value of a row

public getOne ( string $sql ) : mixed
$sql	string	sql query
리턴	mixed

getPrefix() 공개 메소드

Returns table prefix value

public getPrefix ( ) : string
리턴	string

getQueriesList() 공개 메소드

Returns list of executed queries

public getQueriesList ( ) : array
리턴	array

getRow() 공개 메소드

Returns one table row as array

public getRow ( string $sql ) : array | boolean
$sql	string	sql query
리턴	array | boolean

insert() 공개 메소드

Ex: the code below inserts a new record in 'table_name' $iaCore->iaDb->insert(array('title' => 'My Row Title', 'text' => 'My Row Text'), array('date' => 'NOW()'), 'table_name'); generated sql code looks like: INSERT INTO prefix_table_name SET title = 'My Row Title', text = 'My Row Text', date = NOW();

public insert ( array $values, array | null $rawValues = null, string | null $tableName = null ) : integer
$values	array	key=>value array for the record
$rawValues	array | null	key=>value array for the record without sanitizing, commonly used for date insert
$tableName	string | null	table name to perform insertion, null uses current set table
리턴	integer

keyvalue() 공개 메소드

Returns key => value pair array of rows

public keyvalue ( string $fields = self::ALL_COLUMNS_SELECTION, string $condition = null, string | null $tableName = null, integer $start, integer | null $limit = null ) : array
$fields	string	fields to be selected
$condition	string	condition for the selection
$tableName	string | null	table name to select records from, null uses current set table
$start	integer	start position
$limit	integer | null	number of records to be returned
리턴	array

one() 공개 메소드

Returns field value of a row

public one ( string $field, string $condition = '', string | null $tableName = null, integer $start ) : boolean | mixed
$field	string	field to be selected
$condition	string	condition for the selection
$tableName	string | null	table name to select records from, null uses current set table
$start	integer	starting position
리턴	boolean | mixed

one_bind() 공개 메소드

Returns one field value on binding completion

public one_bind ( string $field, string $condition, array $values, null $tableName = null, integer $start ) : array
$field	string	field name value to be returned
$condition	string	condition to be used for the selection
$values	array	values key=>value array to be replaced in sql query
$tableName	null	table name to select a record from, null uses current set table
$start	integer	start position
리턴	array

onefield() 공개 메소드

Returns table column values as an array

public onefield ( string $field = self::ID_COLUMN_SELECTION, string $condition = null, integer $start, integer | null $limit = null, string | null $tableName = null ) : array
$field	string	field name column to be selected
$condition	string	condition for the selection
$start	integer	start position
$limit	integer | null	number of records to be returned
$tableName	string | null	table name to select records from, null uses current set table
리턴	array

orderByRand() 공개 메소드

Generates a faster way to select random records

public orderByRand ( integer | string $max, string $id_name = '`id`', integer $pieces = 12, integer $delimiter = 100 ) : mixed
$max	integer | string	max order or table name
$id_name	string	id column
$pieces	integer
$delimiter	integer
리턴	mixed

printf() 공개 정적인 메소드

Returns a formatted string according to replacements Does NOT sanitize any input (!)

public static printf ( string $pattern, array $replacements ) : string
$pattern	string	replacement pattern
$replacements	array	new values
리턴	string

query() 공개 메소드

Executes database query

public query ( string $sql ) : resource
$sql	string	sql query to be executed
리턴	resource

replace() 공개 메소드

Ex: the code below inserts a new record in 'table_name' $iaCore->iaDb->insert(array('title' => 'My Row Title', 'text' => 'My Row Text'), array('date' => 'NOW()'), 'table_name'); generated sql code looks like: REPLACE INTO prefix_table_name SET title = 'My Row Title', text = 'My Row Text', date = NOW();

public replace ( array $values, array | null $rawValues = null, string | null $tableName = null ) : integer
$values	array	key=>value array for the record
$rawValues	array | null	key=>value array for the record without sanitizing, commonly used for date insert
$tableName	string | null	table name to perform insertion, null uses current set table
리턴	integer

resetTable() 공개 메소드

Resets table name to the previous state

public resetTable ( ) : void
리턴	void

row() 공개 메소드

Returns one table row as array

public row ( string $fields = self::ALL_COLUMNS_SELECTION, string $condition = '', string | null $tableName = null, integer $start ) : array
$fields	string	fields to be selected
$condition	string	condition for the selection
$tableName	string | null	table name to select records from, null uses current set table
$start	integer	start position
리턴	array

row_bind() 공개 메소드

Returns single row array on binding completion

public row_bind ( string $fields, string $condition, array $values, null $tableName = null, integer $start ) : array
$fields	string	fields to be returned
$condition	string	condition to be used for the selection
$values	array	values key=>value array to be replaced in sql query
$tableName	null	table name to select a record from, null uses current set table
$start	integer	start position
리턴	array

setTable() 공개 메소드

Sets table to work with (in most cases resetTable should be called after calling this method)

public setTable ( string $tableName, boolean $addPrefix = true ) : void
$tableName	string	table name
$addPrefix	boolean	true - adds prefix for the table name
리턴	void

setTimezoneOffset() 공개 메소드

public setTimezoneOffset ( $offset )

truncate() 공개 메소드

Truncates table

public truncate ( null | string $table = null ) : boolean
$table	null | string	table name
리턴	boolean

update() 공개 메소드

Ex: the code below updates a record in 'table_name' $iaCore->iaDb->update(array('id' => '50', 'title' => 'My Row Title', 'text' => 'My Row Text'), null, array('date' => 'NOW()'), 'table_name'); generated sql code looks like: UPDATE prefix_table_name SET title = 'My Row Title', text = 'My Row Text', date = NOW() WHERE id = '50';

public update ( array $values, string $condition = null, array | null $rawValues = null, string | null $tableName = null ) : boolean | integer
$values	array	fields key=>value array to be updated
$condition	string	condition used for the update query, if empty tries to update using id field from $fields array
$rawValues	array | null	key=>value array for the record without sanitizing, commonly used for date insert
$tableName	string | null	table name to perform update, null uses current set table
리턴	boolean | integer