Advanced Filter - Demo1 NEW Bootstrap 4.5 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 | 141144146 | IN446258 | 25.03.2005 00:00:00 | 66071.55 | View Edit Remove |
2 | 141 | JE105477PAUL | 18.03.2005 00:00:00 | 120166.58 | View Edit Remove |
3 | 141 | JN355280 | 26.10.2003 00:00:00 | 49539.37 | View Edit Remove |
4 | 141 | JN722010 | 25.02.2003 00:00:00 | 40206.2 | View Edit Remove |
5 | 141 | MF629602 | 16.08.2004 00:00:00 | 20009.53 | View Edit Remove |
6 | 141 | NU627706 | 17.05.2004 00:00:00 | 26155.91 | View Edit Remove |
7 | 144 | IR846303 | 12.12.2004 00:00:00 | 36005.71 | View Edit Remove |
8 | 144 | LA685678 | 09.04.2003 00:00:00 | 7674.94 | View Edit Remove |
9 | 145 | CN328545 | 03.07.2004 00:00:00 | 4710.73 | View Edit Remove |
10 | 145 | ED39322MARK | 26.04.2004 00:00:00 | 28211.7 | View Edit Remove |