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 NumberChecknumberPayment DateAmount
Actions
13243434343454530.05.2025 00:00:00233333333 View Edit Remove
234534534353453529.06.2025 21:48:4034543535 View Edit Remove
31232212122113.11.2025 00:00:002.122121212221212e16 View Edit Remove
42323223232309.01.2026 00:00:00222222 View Edit Remove
5322423234234234 View Edit Remove
6123444534434-432453418.03.2026 00:00:00434234.34234 View Edit Remove
Search