• Главная
• Pop
• Db
• Record

PHP Класс Pop\Db\Record

Показать файл Открыть проект Примеры использования класса

Открытые свойства

Свойство	Тип	Описание
$db	array	Database connection(s)
$rows	array	Rows of multiple return results from a database query in an ArrayObject format.

Защищенные свойства (Protected)

Свойство	Тип	Описание
$auto	boolean	Property that determines whether or not the primary ID is auto-increment or not
$columns	array	Column names of the database table
$interface	Pop\Db\Record\AbstractRecord	Record interface
$prefix	string	Table prefix
$primaryId	string | array	Primary ID column name of the database table
$tableName	string	Table name of the database table
$usePrepared	boolean	Flag on whether or not to use prepared statements

Открытые методы

Метод	Описание
__construct ( array $columns = null, Db $db = null ) : Record	Constructor
__get ( string $name ) : mixed	Get method to return the value of columns[$name].
__isset ( string $name ) : boolean	Return the isset value of columns[$name].
__set ( string $name, mixed $value ) : void	Set method to set the property to the value of columns[$name].
__unset ( string $name ) : void	Unset columns[$name].
count ( ) : integer	Method to return the current number of records.
delete ( array $columns = null ) : void	Delete the database record.
escape ( string $value ) : string	Return the escaped string value.
execute ( string $sql, array $params = null ) : Record	Execute a custom prepared SQL query.
findAll ( string $order = null, array $columns = null, integer $limit = null, integer $offset = null ) : Record	Find all of the database rows by the column passed through the method argument.
findBy ( array $columns, string $order = null, integer $limit = null, integer $offset = null ) : Record	Find a database row by the column passed through the method argument.
findById ( mixed $id, integer $limit = null, integer $offset = null ) : Record	Find a database row by the primary ID passed through the method argument.
getCount ( array $columns = null ) : mixed	Get total count of records
getDb ( ) : Db	Get DB connection
getFullTableName ( ) : string	Get the full table name, with the prefix
getId ( ) : mixed	Get the table primary ID
getPrefix ( ) : string	Get the table prefix
getSql ( ) : Sql	Get the SQL object.
getTableInfo ( ) : array	Get table info anf return as an array.
getTableName ( ) : string	Get the abbreviated table name, without the prefix
getValues ( ) : array	Get all the table column values at once as an associative array.
isAuto ( ) : boolean	Get if the table is an autoincrement table
isPrepared ( ) : boolean	Get if the record interface is prepared or not
lastId ( ) : integer	Return the auto-increment ID of the last query.
numFields ( ) : integer	Return the number of fields in the result.
numRows ( ) : integer	Return the number of rows in the result.
query ( string $sql ) : Record	Execute a custom SQL query.
save ( integer $type = Record::INSERT ) : void	Save the database record.
setDb ( Db $db, boolean $isDefault = false ) : void	Set DB connection
setValues ( array $columns = null ) : Record	Set all the table column values at once.
update ( ) : void	Update (save) the existing database record.

Защищенные методы

Метод	Описание
camelCaseToUnderscore ( string $string ) : string	Method to convert a camelCase string to an under_score string
setResults ( array $result ) : void	Set the query results.

Описание методов

Описание свойств