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

PHP Класс Pop\Db\Sql

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

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

Свойство	Тип	Описание
$alias	string	Alias name for sub-queries
$clause	mixed	SQL clause object
$db	Db	Database object
$dbType	integer	Database type
$quoteIdType	integer	ID quote type
$sql	string	SQL statement
$table	string	Current table

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

Метод	Описание
__construct ( Db $db, mixed $table = null, string $alias = null ) : Sql	Constructor
__toString ( ) : string	Method to return the SQL as a string
adapter ( ) : AbstractAdapter	Get the current database object's adapter.
delete ( ) : Update	Create a delete statement
factory ( Db $db, mixed $table = null, string $alias = null ) : Sql	Static method to instantiate the SQL object and return itself to facilitate chaining methods together.
getAlias ( ) : string	Get the alias name.
getDb ( ) : Db	Get the current database object.
getDbType ( ) : integer	Get the current database type.
getQuoteId ( ) : integer	Get the quote ID type
getSql ( ) : string	Get the current SQL statement string.
getTable ( ) : string	Get the current table.
hasAlias ( ) : boolean	Determine if the Sql object has an alias name
hasTable ( ) : boolean	Determine if the Sql object has a table set
insert ( array $columns = null ) : Insert	Create a insert statement
quote ( string $value ) : string	Quote the value with single quotes
quoteId ( string $id ) : string	Quote the value with the quoted identifier
render ( boolean $ret = false ) : mixed	Render SQL string
select ( mixed $columns = null ) : Select	Create a select statement
setAlias ( string $alias = null ) : Sql	Set alias name
setDb ( Db $db ) : Sql	Set the database object
setQuoteId ( integer $type = Pop\Db\Sql::NO_QUOTE ) : Sql	Set the quote ID type
setTable ( mixed $table = null ) : Sql	Set current table to operate on.
update ( array $columns = null ) : Update	Create a update statement

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

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