Index

  1. Home
  2. Docs
  3. Index
  4. Shortcodes
  5. Shortcode wpdadiehard

Shortcode wpdadiehard

Use shortcode wpdadiehard to add data administration for a specific table or Data Projects page to a web page.

Shortcode wpdadiehard must be enabled:
Settings > WP Data Access > Plugin > Shortcode [ wpdadiehard ]

Data Projects shortcodes

Shortcode wpdadiehard can be used to add a Data Projects page to a web page. Supported shortcode parameters:

  • project_id (Data Projects -> Project ID)
  • page_id (Data Projects -> Page ID)
  • 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 Data Project

There’s no need to type in the shortcode. The shortcode can be copied from Data Projects to your clipboard and pasted into your page or post.

  • Start Data Projects
  • Edit your project
  • Click on link Shortcode(s)
  • Copy shortcode to clipboard
  • Edit your page or post
  • Paste shortcode into your page or post

Example

[wpdadiehard project_id="7" page_id="11"]

> Click here for a live example

User defined shortcodes

User defined shortcodes are still supported for backward compatibility, but no longer adviced. Please update your user defined shortcodes to Data Projects shortcodes, which are safer, easier to maintain and support more features.

Adding filters

Use parameters filter_field_name and filter_field_value to set a filter. For example:

[wpdadiehard project_id="1" page_id="1" filter_field_name="last_name" filter_field_value="Jones"]

This will show only customers with last_name = “Jones”.

Adding a filter on multiple columns:

[wpdadiehard project_id="1" page_id="1" filter_field_name="first_name,last_name" filter_field_value="Grace,Jones"]

This will show only customers with first_name = “Grace” and last_name = “Jones”.

More complex filters

Please use the WHERE clause of your project page to add more complex filters (see image below – click to enlarge)

Video tutorial

Styling

> Styling shortcode wpdadiehard

Know limitations

Short wpdadiehard has a number of limitation! Read more…

Notes

Although I recommend to perform data and database administration tasks with the free version from the WordPress dashboard, the plugin allows real data diehards to perform data administration tasks on web pages as well. The WordPress dashboard protects you from hackers, especially if you have taken the necessary precautions. Web pages do not have that kind of security by default. If you decide to offer data administration on your web pages you need to take the necessary steps to secure these pages. Please be aware that every user who visits your website can modify your table data if you give users anonymous access. This is your own responsibility!

Was this article helpful to you? Yes No

Leave a Reply

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

7 + one =