Settings
// Advanced Filter
// add Filter ("unique-filter-name", "Filter display name", "column name to be matched","type of filter")
$pdocrud->addFilter("product_cat_filter", "Product Category", "product_cat", "radio");
// set data for filter ("unique-filter-name",array of data or table,key (if source=db),value (if source=db), "source_type")
$pdocrud->setFilterSource("product_cat_filter", array("Electronic" => "Electronic", "Fashion" => "Fashion"), "", "", "array");
$pdocrud->addFilter("ProductLineFilter", "Product Line", "product_line", "dropdown");
$pdocrud->setFilterSource("ProductLineFilter", "products", "product_line", "product_line as pl", "db");
$pdocrud->addFilter("ProductVendorFilter", "Vendor", "ProductVendor", "text");
$pdocrud->setFilterSource("ProductVendorFilter", "", "", "", "");
//
$pdocrud->where("order_date", "2015-09-08", ">");
$pdocrud->setSearchCols(array("id","first_name"));
$pdocrud->setSearchColumnDataType("order_date", "date-range");// other options are time-range, datetime-range
$pdocrud = new PDOCrud(false, "", "", array("autoSuggestion" => true, "showAllSearch" => false));