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 DateAmountTest1
Actions
12147483647323232322.11.2024 00:00:0023323232233232233232 View Edit Remove
253535fdhhdh30.01.2025 15:00:00353535fgjgjg View Edit Remove
353535fdhhdh30.01.2025 15:00:00353535fgjgjg View Edit Remove
454654654sddsd654564564654 View Edit Remove
52147483647ewrewrewrewrew09.02.2025 00:00:00324324324324werewrwerwe View Edit Remove
60'2.2222222222222222e4922222222222222222222222222222222222222222 View Edit Remove
Search