DEMO SITE v1.7.20

Advanced Filter - Demo2 NEW Bootstrap 4.5 theme

Simple Advanced filter - Hidden Panel

	$xcrud = Xcrud::get_instance();	
	$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

	//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();	



#Customer NumberChecknumberPayment DateAmount 
1209PH78593704.05.2004 00:00:0036069.26 View Edit Remove
2211BJ53523009.12.2003 00:00:0045480.79 View Edit Remove
3216MM34208614.12.2003 00:00:0040473.86 View Edit Remove
4219BN1787002.03.2005 00:00:003452.75 View Edit Remove
5219BR94148018.10.2003 00:00:004465.85 View Edit Remove
6227MQ41396831.10.2003 00:00:0036164.46 View Edit Remove
7227NU2132602.11.2004 00:00:0053745.34 View Edit Remove
8233II18000601.07.2004 00:00:0022997.45 View Edit Remove
9239NQ86554715.03.2004 00:00:0080375.24 View Edit Remove
10240IF24515716.11.2004 00:00:0046788.14 View Edit Remove