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 98 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_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
2 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
3 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
4 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
5 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
6 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
7 S18_1097 1940 Ford Pickup Truck Trucks and Buses 1:18 Studio M Art Models This model features soft rubber tires, working steering, rubber mud guards, authentic Ford logos, detailed undercarriage, opening doors and hood, removable split rear gate, full size spare mounted in bed, detailed interior with opening glove box http://displays2go.com.au/slir/w144-h144/images/product_images/1384248587.jpg https://codecanyon.net/user/ddeveloper/portfolio?ref=ddeveloper 2613 58.33 116.67 0 0 2016-12-20 Electronics
8 S18_1129 1993 Mazda RX-7 Classic Cars 1:18 Highway 66 Mini Classics This model features, opening hood, opening doors, detailed engine, rear spoiler, opening trunk, working steering, tinted windows, baked enamel finish. Color red. http://displays2go.com.au/slir/w144-h144/images/product_images/1384248587.jpg http://demo.digitaldreamstech.com/formdoid/ 3975 83.51 141.54 0 0 2016-12-20 Electronics
9 S18_1342 1937 Lincoln Berline Vintage Cars 1:18 Motor City Art Classics Features opening engine cover, doors, trunk, and fuel filler cap. Color black http://displays2go.com.au/slir/w144-h144/images/product_images/1384248587.jpg https://codecanyon.net/user/ddeveloper/portfolio?ref=ddeveloper 8693 60.62 102.74 0 0 2016-12-20 Electronics
10 S18_1367 1936 Mercedes-Benz 500K Special Roadster Vintage Cars 1:18 Studio M Art Models This 1:18 scale replica is constructed of heavy die-cast metal and has all the features of the original: working doors and rumble seat, independent spring suspension, detailed interior, working steering system, and a bifold hood that reveals an engine so accurate that it even includes the wiring. All this is topped off with a baked enamel finish. Color white. http://displays2go.com.au/slir/w144-h144/images/product_images/1384248587.jpg https://codecanyon.net/user/ddeveloper/portfolio?ref=ddeveloper 8635 24.26 53.91 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