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 ]
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 #
| Firstname | Lastname | Phone No | Address | Zipcode | City | County | Country | |
|---|---|---|---|---|---|---|---|---|
| Firstname | Lastname | Phone No | Address | Zipcode | City | County | Country |
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.
