Advanced Filter - Demo2 NEW Bootstrap 4.5 theme
Simple Advanced filter - Hidden Panel
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',false); //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 | Test1 | |
---|---|---|---|---|---|---|
1 | 124 | AE215433 | 05.03.2005 00:00:00 | 101244.59 | View Edit Remove | |
2 | 124 | BG255406 | 28.08.2004 00:00:00 | 85410.87 | View Edit Remove | |
3 | 124 | CQ287967 | 11.04.2003 00:00:00 | 11044.3 | View Edit Remove | |
4 | 124 | ET64396 | 16.04.2005 00:00:00 | 83598.04 | View Edit Remove | |
5 | 124 | HI366474 | 27.12.2004 00:00:00 | 47142.7 | View Edit Remove | |
6 | 124 | HR86578 | 02.11.2004 00:00:00 | 55639.66 | View Edit Remove | |
7 | 124 | KI131716 | 15.08.2003 00:00:00 | 111654.4 | View Edit Remove | |
8 | 124 | LF217299 | 26.03.2004 00:00:00 | 43369.3 | View Edit Remove | |
9 | 124 | NT141748 | 25.11.2003 00:00:00 | 45084.38 | View Edit Remove | |
10 | 128 | DI925118 | 28.01.2003 00:00:00 | 10549.01 | View Edit Remove |