Advanced Filter - Demo1 NEW
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 "); $xcrud->where("amount>130000"); echo $xcrud->render(); ?>
Payments
# | Customer Number | Checknumber | Payment Date | Amount | Test1 | |
---|---|---|---|---|---|---|
1 | 2147483647 | 3232323 | 22.11.2024 00:00:00 | 2332323223 | 3232233232 | View Edit Remove |
2 | 53535 | fdhhdh | 30.01.2025 15:00:00 | 353535 | fgjgjg | View Edit Remove |
3 | 53535 | fdhhdh | 30.01.2025 15:00:00 | 353535 | fgjgjg | View Edit Remove |
4 | 54654654 | sddsd | 654564 | 564654 | View Edit Remove | |
5 | 2147483647 | ewrewrewrewrew | 09.02.2025 00:00:00 | 324324324324 | werewrwerwe | View Edit Remove |
6 | 0 | ' | 2.2222222222222222e49 | 22222222222222222222222222222222222222222 | View Edit Remove |