MYSQL
MYSQL = 'MYSQL'
Constants for database types
Update class
$where : \Pop\Db\Sql\Where
WHERE predicate object
$db : \Pop\Db\Adapter\AbstractAdapter
Database object
where(mixed $where = null) : \Pop\Db\Sql\AbstractPredicateClause
Access the WHERE clause
| mixed | $where |
andWhere(mixed $where = null) : \Pop\Db\Sql\AbstractPredicateClause
Access the WHERE clause with AND
| mixed | $where |
orWhere(mixed $where = null) : \Pop\Db\Sql\AbstractPredicateClause
Access the WHERE clause with OR
| mixed | $where |
setTable(mixed $table) : \Pop\Db\Sql\AbstractSql
Set the table
| mixed | $table |
setAlias(string $alias) : \Pop\Db\Sql\AbstractSql
Set the alias
| string | $alias |
setValues(array $values) : \Pop\Db\Sql\AbstractSql
Set the values
| array | $values |
addValue(mixed $value) : \Pop\Db\Sql\AbstractSql
Add a value
| mixed | $value |
addNamedValue(string $name, mixed $value) : \Pop\Db\Sql\AbstractSql
Add a named value
| string | $name | |
| mixed | $value |
__construct(\Pop\Db\Adapter\AbstractAdapter $db)
Constructor
Instantiate the SQL object
| \Pop\Db\Adapter\AbstractAdapter | $db |
db() : \Pop\Db\Adapter\AbstractAdapter
Get the current database adapter object (alias method)
getDb() : \Pop\Db\Adapter\AbstractAdapter
Get the current database adapter object
setIdQuoteType(string $type = self::NO_QUOTE) : \Pop\Db\Sql\AbstractSql
Set the quote ID type
| string | $type |
setPlaceholder(string $placeholder) : \Pop\Db\Sql\AbstractSql
Set the placeholder
| string | $placeholder |
set(string $name, mixed $value) : \Pop\Db\Sql\Update
Set a value
| string | $name | |
| mixed | $value |
values(array $values) : \Pop\Db\Sql\Update
Set a value
| array | $values |