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 94 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 S10_4757 1972 Alfa Romeo GTA Classic Cars 1:10 Motor City Art Classics Features include: Turnable front wheels; steering function; detailed interior; detailed engine; opening hood; opening trunk; opening doors; and detailed chassis. http://findicons.com/files/icons/2834/flatastic_part_2/128/product.png https://codecanyon.net/user/ddeveloper/portfolio?ref=ddeveloper 3252 85.68 136.00 10 25 2016-12-20 Fashion
2 S10_4962 1992 Lancia Delta 16V Classic Cars 1:10 Second Gear Diecast Features include: 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/1369184182.jpg https://codecanyon.net/user/ddeveloper/portfolio?ref=ddeveloper 2 50.00 147.74 0 0 2016-12-20 Electronics
3 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
4 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
5 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
6 S18_1589 1965 Aston Martin DB5 Classic Cars 1:18 Classic Metal Creations Die-cast model of the silver 1965 Aston Martin DB5 in silver. This model includes full wire wheels and doors that open with fully detailed passenger compartment. In 1:18 scale, this model measures approximately 10 inches/20 cm long. http://displays2go.com.au/slir/w144-h144/images/product_images/1384248587.jpg https://codecanyon.net/user/ddeveloper/portfolio?ref=ddeveloper 9042 65.96 124.44 0 0 2016-12-20 Fashion
7 S18_1662 1980s Black Hawk Helicopter Planes 1:18 Red Start Diecast 1:18 scale replica of actual Army's UH-60L BLACK HAWK Helicopter. 100% hand-assembled. Features rotating rotor blades, propeller blades and rubber wheels. http://displays2go.com.au/slir/w144-h144/images/product_images/1384248587.jpg https://codecanyon.net/user/ddeveloper/portfolio?ref=ddeveloper 5330 77.27 157.69 0 0 2016-12-20 Electronics
8 S18_1749 1917 Grand Touring Sedan Vintage Cars 1:18 Welly Diecast Productions This 1:18 scale replica of the 1917 Grand Touring car has all the features you would expect from museum quality reproductions: all four doors and bi-fold hood opening, detailed engine and instrument panel, chrome-look trim, and tufted upholstery, all topped off with a factory baked-enamel finish. http://displays2go.com.au/slir/w144-h144/images/product_images/1384248587.jpg https://codecanyon.net/item/pdomodel-database-abstraction-and-helper-php-class/15832775 2724 86.70 170.00 0 0 2016-12-20 Fashion
9 S18_1889 1948 Porsche 356-A Roadster Classic Cars 1:18 Gearbox Collectibles This precision die-cast replica features opening doors, superb detail and craftsmanship, working steering system, opening forward compartment, opening rear trunk with removable spare, 4 wheel independent spring suspension as well as factory baked enamel finish. http://displays2go.com.au/slir/w144-h144/images/product_images/1384248587.jpg https://codecanyon.net/user/ddeveloper/portfolio?ref=ddeveloper 8826 53.90 77.00 0 0 2016-12-20 Electronics
10 S18_1984 1995 Honda Civic Classic Cars 1:18 Min Lin Diecast This model features, opening hood, opening doors, detailed engine, rear spoiler, opening trunk, working steering, tinted windows, baked enamel finish. Color yellow. http://displays2go.com.au/slir/w144-h144/images/product_images/1384248587.jpg https://codecanyon.net/user/ddeveloper/portfolio?ref=ddeveloper 9772 93.89 142.25 0 0 2016-12-20 Fashion
# 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