View Categories

wpdataaccess

Use shortcode wpdataaccess to bring database tables and views to your website and WordPress back-end. jQuery DataTables is used to provide dynamic read-only HTML tables supporting pagination, sorting and searching. Choose between flat scrollable and responsive tables.
Shortcode wpdataaccess must be enabled:
Plugin Settings > Plugin > Shortcode [ wpdataaccess ]

Data Table shortcodes #

Use Data Tables to create data tables. Every publication has a unique publication id (pub_id) and a unique publication name (pub_name) which can be used in shortcode wpdataaccess. Supported shortcode parameters:
  • pub_id (publication id)
  • pub_name (publication name)
  • filter_field_name (field name(s) to be filtered)
  • filter_field_value (field value(s) to filter, performs a LIKE and therefor allows wildcards)

Copy/paste shortcode from a publication #

There’s no need to type in the shortcode. The shortcode can be copied from Data Tables to your clipboard and pasted into your page or post:
  • Start Data Tables
  • Click on link Shortcode
  • Copy shortcode to clipboard
  • Edit your page or post
  • Paste shortcode into your page or post

Examples #

[wpdataaccess pub_id="17"]
[wpdataaccess pub_name="My Publication"]

Inline demo without styling #

FirstnameLastnameEmailPhone NoAddressZipcodeCityCountyCountry
FirstnameLastnameEmailPhone NoAddressZipcodeCityCountyCountry

Filter examples #

For security reasons shortcode parameter sql_where is no longer available. Please use parameters filter_field_name and filter_field_value to add a safe filter . The plugin still allows to add a safe where clause on Data Tables data entry page.

[wpdataaccess pub_id="6" filter_field_name="job,ename" filter_field_value="president,ford"]
[wpdataaccess pub_id="18" filter_field_name="lastname" filter_field_value="jose%"]
For filters containing multiple column names and values, use a comma seperated value and make sure the array size of filter_field_name and filter_field_value are the same. The filter allows to use % as a wildcard.

Styling #