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 108 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 Actions
1 S10_1678 1969 Harley Davidson Ultimate Chopper Motorcycles 1:10 Min Lin Diecast This replica features working kickstand, front suspension, gear-shift lever, footbrake lever, drive chain, wheels and steering. All parts are particularly delicate due to their precise scale and require special care and attention. http://findicons.com/files/icons/590/motorola/128/razr_product_red.png http://pdocrud.com/demo/pages 7933 48.81 95.70 20 5 2016-12-20
2 S10_1949 1952 Alpine Renault 1300 Classic Cars 1:10 Classic Metal Creations Turnable front wheels; steering function; detailed interior; detailed engine; opening hood; opening trunk; opening doors; and detailed chassis. http://findicons.com/files/icons/1673/diagram_part_2/96/diagram_v2_17.png http://demo.digitaldreamstech.com/formdoid/script/documentation/formdoid/ 7305 50.00 214.30 0 4 2016-12-20
3 S10_2016 1996 Moto Guzzi 1100i Motorcycles 1:10 Highway 66 Mini Classics Official Moto Guzzi 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://findicons.com/files/icons/53/cats/128/drive_product_red_usb.png https://codecanyon.net/user/ddeveloper/portfolio?ref=ddeveloper 6625 68.99 118.94 0 0 2016-12-20
4 S10_4698 2003 Harley-Davidson Eagle Drag Bike Motorcycles 1:10 Red Start Diecast Model features, official Harley Davidson logos and insignias, detachable rear wheelie bar, heavy diecast metal with resin parts, authentic multi-color tampo-printed graphics, separate engine drive belts, free-turning front fork, rotating tires and rear racing slick, certificate of authenticity, detailed engine, display stand , precision diecast replica, baked enamel finish, 1:10 scale model, removable fender, seat and tank cover piece for displaying the superior detail of the v-twin engine http://findicons.com/files/icons/2738/pretty_office_icon_set_part_9/128/product_documentation.png http://demo.digitaldreamstech.com/SimplifiedDB/documentation/PDO/pdo-transactions.php 5582 91.02 193.66 0 0 2016-12-20
5 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 0 0 2016-12-20
6 S10_4962 1962 LanciaA 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 6791 103.42 147.74 0 0 2016-12-20
7 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
8 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-20
9 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
10 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
# 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 Actions