Advanced Filter - Demo1 NEW Bootstrap theme
Simple Advanced filter
HIDE CODE
<?php $xcrud = Xcrud::get_instance(); $xcrud->table("payments"); $xcrud->label("customerNumber","Customer Number"); $xcrud->label("paymentDate","Payment Date"); //1st Param: whether to show or hide advanced search button //2nd Param: Position to show advanced panel. Can be top, bottom, right or left //3rd Param: Makes the advanced panel either opened or closed on window load $xcrud->advanced_search_active(true,'left',true); //1st Param: Sequence of field arrangement. Start with 1 //2nd Param: Field Name //3rd Param: Operator can be "<",">","=","IN","LIKE" //4th Param: Search Column Title $xcrud->advanced_filter(1,"amount",">","Amount Greater Than"); $xcrud->advanced_filter(2,"amount","<","Amount Less Than"); $xcrud->advanced_filter(3,"paymentDate",">", "Payment date greater than "); $xcrud->advanced_filter(4,"checkNumber","LIKE", "Check Number Like "); echo $xcrud->render(); ?>
Payments
# | Customer Number | Checknumber | Payment Date | Amount | |
---|---|---|---|---|---|
1 | 209 | PH785937 | 04.05.2004 00:00:00 | 36069.26 | View Edit Remove |
2 | 211 | BJ535230 | 09.12.2003 00:00:00 | 45480.79 | View Edit Remove |
3 | 216 | MM342086 | 14.12.2003 00:00:00 | 40473.86 | View Edit Remove |
4 | 219 | BN17870 | 02.03.2005 00:00:00 | 3452.75 | View Edit Remove |
5 | 219 | BR941480 | 18.10.2003 00:00:00 | 4465.85 | View Edit Remove |
6 | 227 | MQ413968 | 31.10.2003 00:00:00 | 36164.46 | View Edit Remove |
7 | 227 | NU21326 | 02.11.2004 00:00:00 | 53745.34 | View Edit Remove |
8 | 233 | II180006 | 01.07.2004 00:00:00 | 22997.45 | View Edit Remove |
9 | 239 | NQ865547 | 15.03.2004 00:00:00 | 80375.24 | View Edit Remove |
10 | 240 | IF245157 | 16.11.2004 00:00:00 | 46788.14 | View Edit Remove |