Advanced Filter - Demo2 NEW Bootstrap 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();
?>
Warning: Undefined variable $bool in /home/mixcprassd/public_html/backendDemo/xcrud/xcrud.php on line 1165
Warning: Undefined variable $bool in /home/mixcprassd/public_html/backendDemo/xcrud/xcrud.php on line 1165
Payments
| # | Customernumber | Checknumber | Paymentdate | Amount | |
|---|---|---|---|---|---|
| 1 | 103 | HQ336336 | 29.10.2004 00:00:00 | 6074 | View Edit Remove |
| 2 | 103 | JM555205 | 05.06.2003 00:00:00 | 6074 | View Edit Remove |
| 3 | 103 | OM314933 | 18.12.2004 00:00:00 | 6074 | View Edit Remove |
| 4 | 112 | 86-4823245 | 17.12.2004 00:00:00 | 6074 | View Edit Remove |
| 5 | 112 | 55-0225454 | 06.06.2003 00:00:00 | 32641.98 | View Edit Remove |
| 6 | 112 | ND748579 | 20.08.2004 00:00:00 | 33347.88 | View Edit Remove |
| 7 | 114 | GG31455 | 16.05.2003 00:00:00 | 45864.03 | View Edit Remove |
| 8 | 114 | MA765515 | 15.12.2004 00:00:00 | 82261.22 | View Edit Remove |
| 9 | 114 | NP603840 | 31.05.2003 00:00:00 | 7565.08 | View Edit Remove |
| 10 | 114 | NR27552 | 10.03.2004 00:00:00 | 44894.25 | View Edit Remove |