Dotclear 2.24
|
Public Member Functions | |
statement () | |
delete () | |
run () | |
![]() | |
__construct () | |
__get (string $property) | |
__set (string $property, $value) | |
__isset (string $property) | |
__unset (string $property) | |
__invoke () | |
statement () | |
columns ($c, bool $reset=false) | |
fields ($c, bool $reset=false) | |
column ($c, bool $reset=false) | |
field ($c, bool $reset=false) | |
from ($c, bool $reset=false, bool $first=false) | |
where ($c, bool $reset=false) | |
on ($c, bool $reset=false) | |
cond ($c, bool $reset=false) | |
and ($c, bool $reset=false) | |
andGroup ($c) | |
or ($c, bool $reset=false) | |
orGroup ($c) | |
sql ($c, bool $reset=false) | |
escape (string $value) | |
quote ($value, bool $escape=true) | |
alias (string $name, string $alias) | |
as (string $name, string $alias) | |
in ($list, string $cast='') | |
inSelect (string $field, dcSelectStatement $sql) | |
dateFormat (string $field, string $pattern) | |
like (string $field, string $pattern) | |
regexp (string $value) | |
unique (string $field) | |
count (string $field, ?string $as=null, bool $unique=false) | |
avg (string $field, ?string $as=null) | |
max (string $field, ?string $as=null) | |
min (string $field, ?string $as=null) | |
sum (string $field, ?string $as=null) | |
isNull (string $field) | |
isNotNull (string $field) | |
isSame (string $local, string $external) | |
compare (string $external, bool $trigger_error=false, bool $dump=false, bool $print=false) | |
Additional Inherited Members | |
![]() | |
const | VERBOSE_SQL_ALIAS = false |
$con | |
$syntax | |
$_AS = ' ' | |
$columns = [] | |
$from = [] | |
$where = [] | |
$cond = [] | |
$sql = [] | |
Delete Statement : small utility to build delete queries
statement | ( | ) |
Returns the delete statement
Reimplemented from dcSqlStatement.
References dcCore\app(), dcSqlStatement\cond(), dcSqlStatement\count(), dcSqlStatement\from(), dcSqlStatement\sql(), and dcSqlStatement\where().
Referenced by delete().
delete | ( | ) |
Run the SQL select query and return result
References dcSqlStatement\$sql, and statement().
run | ( | ) |
delete() alias