WP Data Access

Description

WP Data Access helps you to manage your WordPress data and database (WordPress dashboard) and to publish table data on your website using shortcodes (uses jQuery DataTables).

Features

WordPress Dashboard

Perform database administration tasks like create, drop, rename, copy, truncate, insert, update, delete, export and import directly from your WordPress dashboard.

Generate list tables based on the WP_List_Table class to support standard WordPress list table layout and interaction. Or write your own code from WP Data Access classes.
Menus for generated list tables can be added to your WordPress dashboard, plugin or theme with or without coding.

Create your own WordPress data app using the Data Projects tool. Add your own menu to your WordPress dashboard and add your own database tables.
Supports standard CRUD forms as well as parent-child forms and static pages to inform your app users.

Data Explorer

  • Explore tables and views
  • Edit table data through data entry forms generated on the fly
  • View table, view and index structures
  • Rename tables and views
  • Copy tables
  • Delete table data (selections)
  • Truncate tables
  • Drop tables, views and indexes
  • Export tables and table data selections
  • Import tables and table data selections

Data Designer

  • Design tables and indexes
  • Create tables and indexes from design

Data Projects (NEW in V2)

  • Create WordPress data apps running in the WordPress dashboard
  • Create WordPress dashboard menu and menu-items
  • Add tables and data entry forms to your data app
  • Add master-detail forms to your data app
  • Add posts to your data app as static pages
  • Configure and style table lists, data entry forms and master-detail forms

Data Menus

  • Add list tables and data entry forms to your own WordPress dashboard menu

Manage Plugin

  • Manage plugin behaviour, style and security

Website HTML tables

Publish table data on your website. Add shortcode or wizard based HTML tables to your website. Tables are dynamically build using jQuery DataTables. Multiple layouts supported. Allows styling with CSS. Provides pagination, searching and sorting functionality.

Plugin Links

Documentation

Documentation was moved to the plugin and can now be accessed directly from the plugins menu (WP Data Access > Plugin Help).

Developers who are interested in using the plugins PHP classes can generate the API documentation as follows:
1) Start your command line interface
2) Move to the plugins root directory
3) Enter: composer update (this will install phpdocumentor and all its necessary dependencies)
4) Enter: php vendor/phpdocumentor/phpdocumentor/bin/phpdoc.php (this will generate the plugins API documentation in subfolder named docs)
5) Move to the docs subfolder and open the file index.html in your browser

Note
The documentation is currently not up to date. Sorry! I have to get to that. I just like programming more… 😉

Screenshots

Installation

(1) Upload the WP Data Access plugin to your blog, (2) activate it and (3) navigate to the WP Data Access menu.
1, 2, 3 and you’re done!

Reviews

Read all 1 review

Contributors & Developers

“WP Data Access” is open source software. The following people have contributed to this plugin.

Contributors

Translate “WP Data Access” into your language.

Interested in development?

Browse the code, check out the SVN repository, or subscribe to the development log by RSS.