Use shortcode wpdadiehard to add data administration for a specific table or data project page to your web page.
Although I recommend to perform data and database administration tasks 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!
You need to explicitly grant access to tables you want to show on your web pages. Tables will not be shown on your web pages without this step. Follow these steps to grant access to a table or view you allow users to add it’s content to your website:
- From the menu click “WP Data Access” > “Manage Plugin”
- Click on tab “Front-End Settings”
- Click on the table or view your want to grant access to (multiple selections possible)
- Save your front-end settings
You can use shortcode parameters in the following ways:
- Use parameters project_id and page_id to show a Data Projects page
- 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)
- For example: [
wpdadiehard project_id="7" page_id="11"]
- Where do I find the project_id and page_id of my page?
- Use the following parameters to create a user defined data administration page
- schema_name (use this to access tables located outside the WordPress database, default = “”)
- table_name (name of the table on which you want to perform data administration tasks)
- title (title for list table, not shown on data entry form)
- subtitle (title for list table, not shown on data entry form)
- show_view_link (“true” or “false”, default “true”)
- allow_insert (“true” or “false”, default “false”)
- allow_update (“true” or “false”, default “false”)
- allow_delete (“true” or “false”, default “false”)
- allow_import (“true” or “false”, default “false”)
- bulk_actions_enabled (“true” or “false”, default “false”)
- search_box_enabled (“true” or “false”, default “false”)
- bulk_export_enabled (“true” or “false”, default “false”)
- filter_field_name (table column name)
- filter_field_value (table column value)
- For example: [
Use parameters filter_field_name and filter_field_value to set a filter. For example:
[wpdadiehard table_name="customers" 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)
- Data entry forms will return a 404 error for column names that interfere with WordPress, theme or other plugin parameters (like ‘id’, ‘name’, ‘search’, ‘s’, ‘page’, ‘action’, ?). Solution: rename your column. For example: rename column ‘name’ to ‘person_name’.
- Media items are not (yet) supported in data entry forms.
- You cannot use shortcode ‘wpdadiehard’ if you have permalinks set to plain.
- Shortcode ‘wpdadiehard’ cannot be used in a post.