| uses |
\Pix_Table_Db_Adapter |
| package |
Table |
| copyright |
2003-2012 PIXNET Digital Media Corporation |
| license |
BSD License |
Methods
__construct()
__construct($options)
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
column_quote 把 $a 字串加上 quote
column_quote(string $a, \Pix_Table $table) : 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()
dropTable($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() |
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
getLastInsertId()
getLastInsertId($table)
getSQLConditionByTerm()
getSQLConditionByTerm(Pix_Table_Search_Term $term, $table)
getSupportFeatures()
getSupportFeatures()
get all tables in this 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
quoteWithColumn()
quoteWithColumn($table, $value, $column_name)
Parameters
$table
$value
$column_name
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