WP Data Access
  • Download
  • Support
  • Features
  • Pricing
  • Documentation
Select Page
Popular Search importsqlformqueryexport

WP Data Access

  • Getting started
  • Installation
  • What’s new?
  • Patches
  • Known limitations
  • FAQ

Data Tables

  • Getting Started
  • Creating and publishing
  • Responsive data tables
  • SEO friendly data tables
  • Adding hyperlinks
  • Extension Manager
  • Style Manager
  • Language settings
Styling
  • Style Manager
  • Premium styling
  • Global styling
  • Code Manager Styling
  • Manual styling
  • Styling issues
Filters
  • Static filters
  • Interactive filters
    • URL parameters
    • Search Panes
    • Search Builder
    • Search form
    • Advanced search
    • Geolocation search
Export & other buttons
  • Export to PDF, CSV, Excel, SQL
  • Print & copy buttons
  • Column selection buttons
  • Custom buttons
Advanced features
  • Advanced settings
  • Large tables & performance
  • Progressively SHOW MORE
  • Custom queries
  • Custom Post Types
  • Row grouping
  • Responsive master-detail
  • Master-detail tables
  • Non admin user access
Demos & tutorials
  • Demos
  • Tutorials

Data Apps

  • Data Projects
  • Projects and templates
  • Supported Data Types
  • One-To-Many relationships
  • Many-To-Many relationships
  • Registration page
  • Manage table options
  • Shortcode usage
Project Templates
  • Project Templates
  • Creating templates
  • Table Settings
  • Relationships
  • List Table
  • Data Entry
  • Reconcile
Data Forms
  • Data Forms
  • Overview
  • Project Demo
  • Page Demo
Advanced features
  • Adding filters
  • Custom validation
  • Add less/more button
  • User roles
  • Managing roles and users
  • Advanced table options
  • Advanced lookups
  • Front-end toolbar
  • Transfer to other WP site
Demos & tutorials
  • Demos
  • Tutorials

Data Explorer

  • Getting started
  • Navigation
  • Explore tables & views
  • Manage tables & views
  • Naming conventions
Manage Actions
  • Actions
Manage Settings
  • Settings
  • Search Settings
  • Geolocation Settings
  • Table Settings
  • Column Settings
  • Dynamic Hyperlinks
  • Dashboard Menus
Data Management
  • Import CSV & SQL files
  • Run SQL script files
  • Data Backup
Problems & solutions
  • InnoDB #rows estimation
  • Import file too large
  • Transfer to other WP DB

Remote Databases

  • MySQL | MariaDB
Other DBMS
  • Heterogeneous Connections
  • Using ODBC | JDBC
  • Connect to SQL Server
Premium Data Services
  • Remote wizard
  • START HERE
  • Errors and messages
  • Limitations
  • Tutorials
  • Remote Databases
    • Remote databases
    • SQL Server
    • PostgreSQL
    • Oracle
    • MariaDB | MySQL
    Remote Data Files
    • Remote data files
    • CSV files
    • JSON files
    • MS Access
    • XML files
    • Public URL
    • Synchronization
    Advanced features
    • Performance
    • Indexes

SQL

  • Getting Started
  • Tutorials
  • Visual Query Builder
  • Writing queries
  • Data exchange
  • Stored procedures
  • Database triggers
  • Scheduled queries

Business Intelligence

  • Getting started
  • Dashboards
  • Sharing dashboards
Dashboards Widgets
  • Dashboard Widgets
  • Publication Widget
  • Project Widget
  • Chart Widget
  • Custom Code Widget
  • Database Widget
  • Sharing Widgets

Table Design

  • Getting started
  • Introduction
  • Basic mode

Plugin Settings

  • Getting started
  • Plugin
  • Back-end
  • Front-end
  • Dashboard
  • Data Forms
  • Data Tables
  • Data Backup
  • Uninstall
  • Manage Repository
  • Manage Roles
  • System Info

Code

Shortcodes
  • Overview
  • wpdataaccess
  • wpdadataproject
  • wpdadataforms
  • wpdadiehard
  • wpdageomap
  • wpdawidget
Hooks & filters
  • Overview
  • Hooks
    • Overview
    • wpda_add_search_actions
    • wpda_add_search_filter
    • wpda_before_list_table
    • wpda_after_list_table
    • wpda_wpdataaccess_prepare
    Filters
    • Overview
    • wpda_column_default
    • wpda_before_simple_form
    • wpda_after_simple_form
    • wpda_construct_where_clause
API
  • WP Data Access API
  • Remote database access
  • CRUD Example
  • Extensions
    • Alternative search algorithm
    • Alternative buttons extension
Code Manager
  • Overview
  • Write code
  • Share(d) code

Supported Data Types

Table of Contents
  • One line text fields
    • Selectors
  • Multi line text areas
    • Selectors
  • Number fields
    • Selectors
  • Date and time fields
    • Selectors
  • Checkboxes
    • Selectors
  • Drop-down lists
    • Lookups
      • Selectors
    • Enum columns
      • Selectors
    • Set columns (supports multiple selections)
      • Selectors
  • Inline editing
  • WordPress media library integration
    • Inline demo

Table and column definitions are used to generate list tables and data entry forms. Constraints are handled internally by the plugin. Additional constraints can be added using database triggers. Make sure to handle errors correctly in your database triggers. This allows the plugin to return usefull messages to your users. It is also possible to add custom validation to the front-end (read more…). Custom styles and events can be added using the selectors given for each data type below.

One line text fields #

All columns of data type varchar and char are displayed as a one line text field.

Text field

Selectors #

Data Forms input[type=text].wpdadataforms-control
Back-end input[type=text].wpda_data_type_string
wpdadiehard input[type=text].wpda_data_type_string

Multi line text areas #

All text columns (tinytext, text, mediumtext, longtext) are displayed as a multi-line text area.

Text area

Selectors #

Data Forms textarea.wpdadataforms-control
Back-end textarea.wpda_data_type_string
wpdadiehard textarea.wpda_data_type_string

Number fields #

All numeric columns are displayed as a one line numeric field. Decimal support is added automatically depending on the column data type.

Number field

Selectors #

Data Forms input[type=number].wpdadataforms-control
Back-end input[type=text].wpda_data_type_number
input[type=text].wpda_data_type_float
wpdadiehard input[type=text].wpda_data_type_number
input[type=text].wpda_data_type_float

Date and time fields #

Date and time support is automatically added to all date and time columns. Date and time format can be changed in Plugin Settings.

Date field

Selectors #

Data Forms input[type=date].wpdadataforms-control
Back-end input[type=text].wpda_data_type_date
wpdadiehard input[type=text].wpda_data_type_date

Checkboxes #

All columns of data type tinyint(1) are automatically shown as checkboxes to provides a natural enable/disable user interface. The column label is shown directly after the checkbox and can be used to toggle the checkbox.

Checkbox

Selectors #

Data Forms input[type=date].wpdadataforms-control
Back-end input[type=checkbox].wpda_data_type_checkbox
wpdadiehard input[type=checkbox].wpda_data_type_checkbox

Drop-down lists #

Three types of drop-down lists are supported:

  • Lookups
  • Enum columns
  • Set columns

Lookups #

A lookup of type listbox will automatically add a drop-down list. (read more…) Unline the enum and set data types, a lookup offers a dynamic solution which allows plugin users to maintain values in a database table.

Use autocomplete lookups for large lookup tables to improve performance!

Lookup

Selectors #

Data Forms select.wpdadataforms-control
Back-end table.wpda_simple_table select.wpda_data_type_checkbox
wpdadiehard table.wpda_simple_table select.wpda_data_type_checkbox

Enum columns #

A drop-down list is automatically created for columns of data type enum.

Enum

Selectors #

Data Forms select.wpdadataforms-control
Back-end table.wpda_simple_table select.wpda_data_type_checkbox
wpdadiehard table.wpda_simple_table select.wpda_data_type_checkbox

Set columns (supports multiple selections) #

Like enum the plugin automatically adds a dropdown list for columns of data type set. The difference is that a set column allows users to select multiple values, which an enum column does not.

Set

Selectors #

Data Forms select.wpdadataforms-control
Back-end table.wpda_simple_table select.wpda_data_type_checkbox
wpdadiehard table.wpda_simple_table select.wpda_data_type_checkbox

Inline editing #

Inline editing allows Excel like table editing and is supported for all data types on the back-end and shortcode wpdadiehard. Inline editing is not supported with Data Forms. Inline editing has to be enabled for each columns specifically.

WP Data Access premium - Inline editing demo

WordPress media library integration #

WordPress media library integration is supported for all media types. External resources are also supported through public links. This has to be enabled for each column specifically. Read more about WordPress media library integration and external resource support.

Inline demo #

BrandBrand TypeColorPhotoAttachmentsPriceLicence PlateCategoryFuel TypeMileageEngine CapacityNo Cylinders
BrandBrand TypeColorPhotoAttachmentsPriceLicence PlateCategoryFuel TypeMileageEngine CapacityNo Cylinders

Share This Article :
  • Facebook
  • Twitter
  • LinkedIn
  • Pinterest
Still stuck? How can we help?

How can we help?

Updated on 2022-12-30
Projects and templatesOne-To-Many relationships

Submit a Comment Cancel reply

Your email address will not be published. Required fields are marked *

Table of Contents
  • One line text fields
    • Selectors
  • Multi line text areas
    • Selectors
  • Number fields
    • Selectors
  • Date and time fields
    • Selectors
  • Checkboxes
    • Selectors
  • Drop-down lists
    • Lookups
      • Selectors
    • Enum columns
      • Selectors
    • Set columns (supports multiple selections)
      • Selectors
  • Inline editing
  • WordPress media library integration
    • Inline demo

Links

Blogs
Tutorials
Demos

Socials

LinkedIn
Twitter

Get in touch

Premium support
Free support forum
Contact us

Resources

WordPress plugin directory
YouTube tutorials

Passionate Programmers B.V. © 2017 - 2023 All rights reserved
We use cookies to ensure that we give you the best experience on our website. If you continue to use this site we will assume that you are happy with it.Ok