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 | |
|---|---|---|---|---|---|
| 1 | 3243434 | 3434545 | 30.05.2025 00:00:00 | 233333333 | View Edit Remove |
| 2 | 3453453 | 43534535 | 29.06.2025 21:48:40 | 34543535 | View Edit Remove |
| 3 | 12322 | 121221 | 13.11.2025 00:00:00 | 2.122121212221212e16 | View Edit Remove |
| 4 | 23232 | 232323 | 09.01.2026 00:00:00 | 222222 | View Edit Remove |
| 5 | 322423 | 234 | 234234 | View Edit Remove | |
| 6 | 1234445344 | 34-4324534 | 18.03.2026 00:00:00 | 434234.34234 | View Edit Remove |