Pix Framework
Back to top  

Pix_Table_Db_Adapter_Mysqli

uses \Pix_Table_Db_Adapter
package Table
copyright 2003-2012 PIXNET Digital Media Corporation
license BSD License

 Methods

__call 為了與 MySQLi 相容所加的 __call()

__call(mixed $name, mixed $args) : void

access public

Parameters

$name

mixed

$args

mixed

__construct() 

__construct($link) 

Parameters

$link

__get 為了與 MySQLi object 相容所加的 __get($name);

__get(mixed $name) : void

access public

Parameters

$name

mixed

bulk insert

bulkInsert(\Pix_Table $table, array $keys, array $values_list, array $options) : void
Inherited

access public
inherited_from \Pix_Table_Db_Adapter_SQL::bulkInsert()
inherited_from \Pix_Table_Db_Adapter_MysqlCommon::bulkInsert()

Parameters

$table

\Pix_Table

$keys

array

$values_list

array

$options

array

checkTable() 

checkTable($table) 
Inherited

inherited_from \Pix_Table_Db_Adapter_MysqlCommon::checkTable()

Parameters

$table

column_quote 把 $a 字串加上 quote

column_quote(string $a) : string
Inherited

access public
inherited_from \Pix_Table_Db_Adapter_MysqlCommon::column_quote()

Parameters

$a

string

Returns

string

createTable 將 $table 建立進資料庫內

createTable(\Pix_Table $table) : void
Inherited

access public
inherited_from \Pix_Table_Db_Adapter_MysqlCommon::createTable()

Parameters

$table

\Pix_Table

deleteOne 從 db 上刪除一個 Row

deleteOne(\Pix_Table_Row $row) : void
Inherited

access public
inherited_from \Pix_Table_Db_Adapter_SQL::deleteOne()
inherited_from \Pix_Table_Db_Adapter_MysqlCommon::deleteOne()

Parameters

$row

\Pix_Table_Row

dropTable 從資料庫內移除 $table 這個 Table

dropTable(\Pix_Table $table) : void
Inherited

access public
inherited_from \Pix_Table_Db_Adapter_MysqlCommon::dropTable()

Parameters

$table

\Pix_Table

fetch 從 $table 找出符合 $search 的所有 column

fetch(\Pix_Table $table, \Pix_Table_Search $search, string $select_columns) : array
Inherited

access public
inherited_from \Pix_Table_Db_Adapter_SQL::fetch()
inherited_from \Pix_Table_Db_Adapter_MysqlCommon::fetch()

Parameters

$table

\Pix_Table

$search

\Pix_Table_Search

$select_columns

string

Returns

array

fetchCount 從 $table 找出符合 $search 條件的數量

fetchCount(\Pix_Table $table, mixed $search) : int
Inherited

access public
inherited_from \Pix_Table_Db_Adapter_SQL::fetchCount()
inherited_from \Pix_Table_Db_Adapter_MysqlCommon::fetchCount()

Parameters

$table

\Pix_Table

$search

mixed

Returns

int

fetchOne 從 $table 找出符合 $primary_values 條件的一筆

fetchOne(\Pix_Table $table, array $primary_values, $select_columns) : array
Inherited

access public
inherited_from \Pix_Table_Db_Adapter_SQL::fetchOne()
inherited_from \Pix_Table_Db_Adapter_MysqlCommon::fetchOne()

Parameters

$table

\Pix_Table

$primary_values

array

$select_columns

Returns

arrayor null

fetchSum 從 $table 找出符合 $search 數量的 $column 總合

fetchSum(\Pix_Table $table, string $column, \Pix_Table_Search $search) : int
Inherited

access public
inherited_from \Pix_Table_Db_Adapter_SQL::fetchSum()
inherited_from \Pix_Table_Db_Adapter_MysqlCommon::fetchSum()

Parameters

$table

\Pix_Table

$column

string

$search

\Pix_Table_Search

Returns

int

getLastInsertId() 

getLastInsertId($table) 

Parameters

$table

getSQLConditionByTerm() 

getSQLConditionByTerm(Pix_Table_Search_Term $term, $table) 
Inherited

inherited_from \Pix_Table_Db_Adapter_SQL::getSQLConditionByTerm()
inherited_from \Pix_Table_Db_Adapter_MysqlCommon::getSQLConditionByTerm()

Parameters

$term

$table

getSupportFeatures() 

getSupportFeatures() 

get Pix_Table object from db schema

getTableFromDb($db_table_name, string $pix_table_name) : \Pix_Table
Inherited

access public
inherited_from \Pix_Table_Db_Adapter_MysqlCommon::getTableFromDb()

Parameters

$db_table_name

$pix_table_name

string

Returns

\Pix_Table

get table list on db

getTables() : array
Inherited

access public
inherited_from \Pix_Table_Db_Adapter_MysqlCommon::getTables()

Returns

array

insertOne 從 db 上增加一筆資料

insertOne(\Pix_Table $table, array | string $keys_values) : void
Inherited

access public
inherited_from \Pix_Table_Db_Adapter_SQL::insertOne()
inherited_from \Pix_Table_Db_Adapter_MysqlCommon::insertOne()

Parameters

$table

\Pix_Table

$keys_values

arraystring

query() 

query($sql) 
Inherited

inherited_from \Pix_Table_Db_Adapter_MysqlCommon::query()

Parameters

$sql

quote 將 $str 字串內容 quote 起來。

quoteWithColumn($table, $value, $column_name) : string

access public

Parameters

$table

$value

$column_name

Returns

string

support() 

support($id) 
Inherited

inherited_from \Pix_Table_Db_Adapter_Abstract::support()
inherited_from \Pix_Table_Db_Adapter_SQL::support()
inherited_from \Pix_Table_Db_Adapter_MysqlCommon::support()

Parameters

$id

updateOne 從 db 上更新一個 $row 的 data

updateOne(\Pix_Table_Row $row, array | string $data) : void
Inherited

access public
inherited_from \Pix_Table_Db_Adapter_SQL::updateOne()
inherited_from \Pix_Table_Db_Adapter_MysqlCommon::updateOne()

Parameters

$row

\Pix_Table_Row

$data

arraystring