Dizzy Docs
logo logo
  • Home
  • Documents
    • API

      All API Documentation

    • Chatty

      Chat App

    • PDO

      Everything PDO

    • Vici

      Tutorials & Courses

    • Coding

      Everything Coding

    • Tech Stuff

      Geek Out

    • Random

      Docs with no Home

    • Business Workflows

      Everything we need to know for work

  • Notes
  • Manual
logo logo
Free Trail


Doc Navigation

  • Getting Started
  • briefcaseDizzyDoc Samples
  • briefcasePDO Crud
    • Forms
    • Filter and Search
    • Settings
    • Action Buttons
    • Filter Samples
    • Customizations
    • PHP Codes
    • Graphs / Charts
    • Misc
    • Plugins
    • Useless Right Now
    • References / Notes
  • PDO
    • Table
      • Table View
      • Table Formatting
    • Forms
      • Form View
      • Form Formatting
  • briefcaseLinks
    • Tools
    • References
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));

			    
			  

© 2020 All Rights Reserved by KbDoc

Video Playback Not Supported