public function getCount()
{
$this->builder->columns(QueryBuilder::raw('COUNT(*) AS cnt'));
$this->prepareAndExecute();
$result = $this->stmt->fetchObject();
return is_object($result) ? $result->cnt : 0;
}
public static function getMaxSortorder($ref_model)
{
$sort_join_on = static::$sort_join_on;
$mqb = self::select(function ($qb) use($sort_join_on, $ref_model) {
$qb->columns(QueryBuilder::raw("MAX(sortorder) AS max_sortorder"));
if ($sort_join_on !== null) {
$qb->where($sort_join_on, '=', $ref_model->{$sort_join_on});
}
});
return $mqb->fetchSingleField('max_sortorder');
}
<pre>
<?php
require '../vendor/autoload.php';
use QueryBuilder\QueryBuilder as QB;
QB::setAdapter(new QueryBuilder\MySqlAdapter());
$result = QB::update('user')->set(['username' => 'new_username', 'firstname' => 'New firstname'])->where('id', '=', 2)->toSql();
var_dump($result['sql'], $result['params']);
$result = QB::update('user')->set(['firstname' => QB::raw('REPLACE(firstname, ?, ?)', array('Doe', 'Eod'))])->where('firstname', 'LIKE', '%Doe%')->toSql();
var_dump($result['sql'], $result['params']);
?>
</pre>
<pre>
<?php
require '../vendor/autoload.php';
use QueryBuilder\QueryBuilder as QB;
QB::setAdapter(new QueryBuilder\MySqlAdapter());
$result = QB::select(['user', 'u'])->columns(['u.id', 'uname' => 'username'])->join(['user_permission', 'p'], QB::raw('p.user_id = u.id'))->limit(5, 0)->groupby(['u.id'])->orderby(['username ASC', 'firstname ASC'])->where('firstname', '=', 'Christoffer')->whereNot('u.id', 'IN', array(2))->toSql();
var_dump($result['sql'], $result['params']);
$result = QB::select('user')->orderby('id')->where(function ($qb) {
$qb->where('name', 'LIKE', '%chris%')->whereOr('username', 'LIKE', '%chris%');
})->where('active', '=', 1)->toSql();
var_dump($result['sql'], $result['params']);
$result = QB::select('user')->where(function ($qb) {
$qb->where('id', 'BETWEEN', array(2, 5))->whereOr('username', 'LIKE', '%chris%');
})->toSql();
var_dump($result['sql'], $result['params']);
$result = QB::select('user')->columns('id')->columns(['fname' => 'firstname'])->toSql();
var_dump($result['sql'], $result['params']);
?>
</pre>
