Filters/Search in PDOCrud Advance filter options

Apart from column based search, you can add the advance filter options in PDOCrud. You can specify different filter and connect to different columns of table. You can also specify type of filter and how it should work. Currently it support three types of controls - dropdown, radio button and textbox. More options will be available in future versions.

  
                            $pdocrud = new PDOCrud();
                            //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", "", "", "", "");

                            echo $pdocrud->dbTable("products")->render();
                            
Clear All
Product Category
Product Line
Vendor

Products

Showing 1 to 10 of 103 entries

# Product id Product name Product line ProductScale ProductVendor Product description Product image Product url Qty available Product price Product sell price Tax Product discount Added date Product cat Actions
1 S12_1099 1968 Ford Mustang Classic Cars 1:12 Autoart Studio Design Hood, doors and trunk all open to reveal highly detailed interior features. Steering wheel actually turns the front wheels. Color dark green. http://displays2go.com.au/slir/w144-h144/images/product_images/1384248587.jpg https://codecanyon.net/item/wordpress-awesome-import-export-plugin/12896266 68 95.34 194.57 0 0 2016-12-20 Electronics
2 S12_1108 2001 Ferrari Enzo Classic Cars 1:12 Second Gear Diecast Turnable front wheels; steering function; detailed interior; detailed engine; opening hood; opening trunk; opening doors; and detailed chassis. http://displays2go.com.au/slir/w144-h144/images/product_images/1392593620.jpeg https://codecanyon.net/user/ddeveloper/portfolio?ref=ddeveloper 3619 95.59 207.80 0 0 2016-12-02 Fashion
3 S12_1666 1958 Setra Bus Trucks and Buses 1:12 Welly Diecast Productions Model features 30 windows, skylights & glare resistant glass, working steering system, original logos http://displays2go.com.au/slir/w144-h144/images/product_images/1369181990.jpg https://codecanyon.net/user/ddeveloper/portfolio?ref=ddeveloper 1579 77.90 136.67 0 0 2016-12-20 Electronics
4 S12_2823 2002 Suzuki XREO Motorcycles 1:12 Unimax Art Galleries Official logos and insignias, saddle bags located on side of motorcycle, detailed engine, working steering, working suspension, two leather seats, luggage rack, dual exhaust pipes, small saddle bag located on handle bars, two-tone paint with chrome accents, superior die-cast detail , rotating wheels , working kick stand, diecast metal with plastic parts and baked enamel finish. http://displays2go.com.au/slir/w144-h144/images/product_images/1392609013.jpg https://codecanyon.net/user/ddeveloper/portfolio?ref=ddeveloper 9997 66.27 150.62 0 0 2016-12-20 Electronics
5 S12_3148 1969 Corvair Monza Classic Cars 1:18 Welly Diecast Productions 1:18 scale die-cast about 10" long doors open, hood opens, trunk opens and wheels roll http://displays2go.com.au/images/product_images/1392665476.gif https://codecanyon.net/user/ddeveloper/portfolio?ref=ddeveloper 6906 89.14 151.08 0 0 2016-12-20 Electronics
6 S12_3380 1968 Dodge Charger Classic Cars 1:12 Welly Diecast Productions 1:12 scale model of a 1968 Dodge Charger. Hood, doors and trunk all open to reveal highly detailed interior features. Steering wheel actually turns the front wheels. Color black http://displays2go.com.au/slir/w144-h144/images/product_images/1384248587.jpg http://demo.digitaldreamstech.com/wp-awesome-import-export-documentation 9123 75.16 117.44 0 0 2016-12-20 Electronics
7 S12_3891 1969 Ford Falcon Classic Cars 1:12 Second Gear Diecast Turnable front wheels; steering function; detailed interior; detailed engine; opening hood; opening trunk; opening doors; and detailed chassis. http://displays2go.com.au/slir/w144-h144/images/product_images/1384248587.jpg https://codecanyon.net/user/ddeveloper/portfolio?ref=ddeveloper 1049 83.05 173.02 0 0 2016-12-20 Electronics
8 S12_3990 1970 Plymouth Hemi Cuda Classic Cars 1:12 Studio M Art Models Very detailed 1970 Plymouth Cuda model in 1:12 scale. The Cuda is generally accepted as one of the fastest original muscle cars from the 1970s. This model is a reproduction of one of the orginal 652 cars built in 1970. Red color. http://displays2go.com.au/slir/w144-h144/images/product_images/1384248587.jpg https://codecanyon.net/user/ddeveloper/portfolio?ref=ddeveloper 5663 31.92 79.80 0 0 2016-12-20 Fashion
9 S12_4473 1957 Chevy Pickup Trucks and Buses 1:12 Exoto Designs 1:12 scale die-cast about 20" long Hood opens, Rubber wheels http://displays2go.com.au/slir/w144-h144/images/product_images/1384248587.jpg https://codecanyon.net/user/ddeveloper/portfolio?ref=ddeveloper 6125 55.70 118.50 0 0 2016-12-20 Fashion
10 S12_4675 1969 Dodge Charger Classic Cars 1:12 Welly Diecast Productions Detailed model of the 1969 Dodge Charger. This model includes finely detailed interior and exterior features. Painted in red and white. http://displays2go.com.au/slir/w144-h144/images/product_images/1384248587.jpg https://codecanyon.net/user/ddeveloper/portfolio?ref=ddeveloper 7323 58.73 115.16 0 0 2016-12-20 Electronics
# Product id Product name Product line ProductScale ProductVendor Product description Product image Product url Qty available Product price Product sell price Tax Product discount Added date Product cat Actions