DEMO SITE v1.7.24

Advanced Filter - Demo1 NEW Bootstrap 4.5 theme

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 
177848877737328.07.2020 00:00:0010000000 View Edit Remove
2110QWNNNNNN13.03.2023 00:00:001222300 View Edit Remove
Search