Delete Records:
$this->ModelName->deleteAll(
array(
"ModelName.id" => 10
)
);
Update Records:
$this->ModelName->updateAll(
/* UPDATE FIELD */
array(
"ModelName.is_active" => 0,
),
/* CONDITIONS */
array(
"ModelName.id" => 20,
"ModelName.name LIKE" => '%SEARCH_TEXT%',
"ModelName.name <>" => 'NOT_EQUAL_VALUE',
'ModelName.integer_field > ' => 50, [Can use operand here]
'TIMESTAMPDIFF(DAY, ModelName.date, NOW())' => 22 [number of day]
)
);
$this->ModelName->deleteAll(
array(
"ModelName.id" => 10
)
);
Update Records:
$this->ModelName->updateAll(
/* UPDATE FIELD */
array(
"ModelName.is_active" => 0,
),
/* CONDITIONS */
array(
"ModelName.id" => 20,
"ModelName.name LIKE" => '%SEARCH_TEXT%',
"ModelName.name <>" => 'NOT_EQUAL_VALUE',
'ModelName.integer_field > ' => 50, [Can use operand here]
'TIMESTAMPDIFF(DAY, ModelName.date, NOW())' => 22 [number of day]
)
);
No comments:
Post a Comment