+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: CodeIgniter 4 (https://forum.codeigniter.com/forumdisplay.php?fid=28)
+--- Forum: CodeIgniter 4 Support (https://forum.codeigniter.com/forumdisplay.php?fid=30)
+--- Thread: Help me with pagination with query builder (/showthread.php?tid=75909)
Help me with pagination with query builder - seunex - 03-28-2020
Here is my model
PHP Code:
//* Get blog in admin
public function getActiveBlogsInAdmin()
{
$table = $this->db->table('zd_blogs');
$table->select('*');
$table->join('zd_main_cats', 'zd_main_cats.main_cat_id = zd_blogs.blog_main_cat', 'left');
$table->join('zd_users', 'zd_users.user_id = zd_blogs.blog_user', 'left');
$table->where('zd_blogs.blog_status', 1);
$table->where('zd_blogs.blog_deleted', 0);
$table->orderBy('zd_blogs.blog_id', 'DESC');
$query = $table->get();
if($table->countAllResults() > 0)
{
return $query->getResult();
}
else
{
return FALSE;
}
}
And here is my controller
PHP Code:
$blog = new BlogModel();
//* Retrieve blogs
$blogs = $blog->getActiveBlogsInAdmin();
//$pages = $pager->makeLinks($page, $perPage, $total);
return $this->smarty->view('blog/active.tpl', compact(
'blogs'
));
I have over and over again read docs it could not give sample for query builder am totaly confuse. please any help is appreciated.
RE: Help me with pagination with query builder - honghuy889 - 05-07-2021
PHP Code:
public function postPaginate($where, $perPage = null, $group = 'default', $page = null, $segment = 0){
$pager = Services::pager(null, null, false);
$query = $this->db->table('cms_property')
->select('cms_property.*')
->select('cms_property_category.name as c_name, cms_property_category.slug as c_slug')
->select('cms_property_type.name as t_name')
->select('cms_property_area.name as a_name')
->select('cms_property_direction.name as d_name')
->where($where)
->join('cms_property_category', 'cms_property_category.id = cms_property.typeofhouse', 'left')
->join('cms_property_type', 'cms_property_type.id = cms_property.p_type', 'left')
->join('cms_property_area', 'cms_property_area.id = cms_property.location_area', 'left')
->join('cms_property_direction', 'cms_property_direction.id = cms_property.direction', 'left');
if ($segment)
{
$pager->setSegment($segment);
}
$page = $page >= 1 ? $page : $pager->getCurrentPage($group);
$this->pager = $pager->store($group, $page, $perPage, $query->get()->getNumRows(), $segment);
$perPage = $this->pager->getPerPage($group);
$offset = ($page - 1) * $perPage;
return $this->limit($perPage, $offset)->get()->getResultArray();
}
This is my model function
)