⚠ In case you've missed it we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This forum is read-only and soon will be archived. ⚠

Bootstrap Not filtering when Paginate with Where clause

bootstrap theme bootstrap v3 where clause where

  • Please log in to reply
No replies to this topic

#1 Neo Fethi Ch

Neo Fethi Ch


  • Members
  • Pip
  • 3 posts

Posted 20 May 2019 - 01:23 PM

Hi everyone, 

I purchased a bootstrap v3 Theme for grocery crud and apply it to my projet.

I have a probleme when i use Where condition on my table to get filtered data.


I explain it : For example i have to show Houses with certain conditions (a surface between 100 and 200), so i use PHP GET, and apply Where condition before getting the table.


For the first page of datatable list (bootstrap theme), it works. but when i click on pagination (page 2 3 4 etc), the filter is not considered, so the table shows all results without Filter.


It's very important for me because i used in big project for my customer. 

It will be very helpful if you can send me a solution for this. 


Here is the code : 

$crud = new grocery_CRUD();
			if(isset($_GET['admin']) && is_numeric($_GET['admin']) && (int)$_GET['admin']>0 ){
			$supmax = "";
			if(isset($_GET['supmin']) && is_numeric($_GET['supmin']) && (int)$_GET['supmin']>=0 ){
				$supmin = (int)$_GET['supmin'];
				$crud->where("superficie >=",$supmin);
			if(isset($_GET['supmax']) && is_numeric($_GET['supmax']) && (int)$_GET['supmax']>0 ){
				$supmax = (int)$_GET['supmax'];
				$crud->where("superficie <=",$supmax);

Also tagged with one or more of these keywords: bootstrap theme, bootstrap v3, where clause, where

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users