DEMO SITE v1.7.24

Advanced Filter - Demo2 NEW Minimal 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 NumberChecknumberPayment DateAmountTest1 
1124ET6439616.04.2005 00:00:0083598.04 View Edit Remove
2124HI36647427.12.2004 00:00:0047142.7 View Edit Remove
3124HR8657802.11.2004 00:00:0055639.66 View Edit Remove
4124LF21729926.03.2004 00:00:0043369.3 View Edit Remove
5124NT14174825.11.2003 00:00:0045084.38 View Edit Remove
6128DI92511828.01.2003 00:00:0010549.01 View Edit Remove
7128FA46548218.10.2003 00:00:0024101.81 View Edit Remove
8128FH66823024.03.2004 00:00:0033820.62 View Edit Remove
9128IP38390118.11.2004 00:00:007466.32 View Edit Remove
10129DM82614008.12.2004 00:00:0026248.78 View Edit Remove
Add Export into CSV Print Search