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!