Skip to main content

Model::whereClose

Add close bracket on Where query

Description

public self Model::whereClose()

Example

Controller
$model = new Model(false, array(
'table' => 'cms_news',
'id' => 'news_id',
'visible' => 'visible',
));

//
$model->where('news_id = ?', array(1));
$model->whereOpen();
$model->where('title = ?', array('foo'));
$model->where('created_at <= ?', array('2021-01-01'), 'OR');
$model->whereClose();

// SELECT *
// FROM cms_news
// WHERE
// news_id = 1
// AND (
// title = 'foo'
// OR created_at <= '2021-01-01'
// )
$records = $model->find();