| package |
Table |
| copyright |
2003-2012 PIXNET Digital Media Corporation |
Methods
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() |
Parameters
$keys
array
$values_list
array
$options
array
checkTable()
checkTable($table)
column_quote 把 $a 字串加上 quote
column_quote(string $a) : string
Parameters
$a
string
Returns
string
createTable 將 $table 建立進資料庫內
createTable(\Pix_Table $table) : void
deleteOne 從 db 上刪除一個 Row
deleteOne(\Pix_Table_Row $row) : void
Inherited
| access |
public |
| inherited_from |
\Pix_Table_Db_Adapter_SQL::deleteOne() |
Parameters
dropTable 從資料庫內移除 $table 這個 Table
dropTable(\Pix_Table $table) : void
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() |
Parameters
$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() |
Parameters
$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() |
Parameters
$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() |
Parameters
$column
string
Returns
int
getSQLConditionByTerm()
getSQLConditionByTerm(Pix_Table_Search_Term $term, $table)
Inherited
| inherited_from |
\Pix_Table_Db_Adapter_SQL::getSQLConditionByTerm() |
Parameters
$term
$table
getSupportFeatures()
getSupportFeatures()
Inherited
| inherited_from |
\Pix_Table_Db_Adapter_Abstract::getSupportFeatures() |
| inherited_from |
\Pix_Table_Db_Adapter_SQL::getSupportFeatures() |
get Pix_Table object from db schema
getTableFromDb($db_table_name, string $pix_table_name) : \Pix_Table
Parameters
$db_table_name
$pix_table_name
string
Returns
get table list on db
getTables() : array
insertOne 從 db 上增加一筆資料
insertOne(\Pix_Table $table, array | string $keys_values) : void
Inherited
| access |
public |
| inherited_from |
\Pix_Table_Db_Adapter_SQL::insertOne() |
Parameters
$keys_values
arraystring
quote 將 $str 字串內容 quote 起來。
quoteWithColumn($table, $value, $column_name) : string
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() |
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() |
Parameters
$data
arraystring