WP Data Access

説明

WP Data Access is a powerful data administration, publication and development tool that allows you to perform database related tasks from your WordPress dashboard. An intuitive user interface helps to create fully responsive publications and data administration pages. No programming skills required!

For advanced users, the plugin support more complex features like remote database access, master-detail pages, lookups, WordPress role integration, WordPress user integration and a layer around your WordPress database which allows you to add database table and view specific functionality like dynamic hyperlinks and WordPress media library integration.

Data Explorer

Data and database administration

  • Manage local and remote databases
  • Database administration (rename, copy, drop, truncate…)
  • Data administration (search, insert, update, delete…)
  • Export to SQL, XML, JSON, CSV and Excel
  • Import SQL and CSV files
  • WordPress Media Library integration
  • Inline editing (PREMIUM)
  • Full-text search (PREMIUM)
  • Individual column search (PREMIUM)
  • Static hyperlinks
  • Dynamic hyperlinks

Query Builder

Execute SQL statements from your WordPress dashboard

  • Execute any SQL command (DCL, DDL, DML) – user must have the necessary privileges
  • Only available for admin users
  • Work on multiple SQL queries simultaneously (using tabs)
  • Allows to access local and remote databases
  • Queries can be saved and reused (saved per WordPress user account)
  • Protects WordPress table structures (no DROP, ALTER and TRUNCATE allowed – not configurable)
  • Protects WordPress table data (can be disabled for INSERT, UPDATE and DELETE)

Data Publisher

Publish responsive tables

  • Responsive HTML tables
  • Supports local and remote databases
  • WordPress Media Library integration
  • Static and dynamic hyperlink integration
  • Easy level: no coding skills required
  • Advanced level: JSON configuration
  • Expert level: add JavaScript functions
  • Export to CSV, Excel, PDF and SQL (PREMIUM)
  • Print publication (PREMIUM)
  • Copy publication to clipboard (PREMIUM)
  • Individual column search (PREMIUM)
  • Full-text search (PREMIUM)

Data Projects

Write your own WordPress apps

  • Supports local and remote databases
  • Auto generated CRUD pages
  • Auto generate parent-child pages
  • WordPress role integration
  • WordPress media library integration
  • Statis and dynamic hyperlink integration
  • Accessible from the WordPress dashboard
  • Add to webpage with shortcode wpdadiehard (FREE)
  • Add to webpage with shortcode wpdadataprojects (PREMIUM)
  • Add to webpage with shortcode wpdadataforms (PREMIUM)
  • Inline editing (PREMIUM)
  • Full-text search (PREMIUM)
  • Individual column search (PREMIUM)

Data Forms (PREMIUM)

State of the art responsive data apps

  • Turns a Data Project into a responsive data app
  • Uses jQuery DataTables to generate list tables
  • Uses AngularJS to generate data entry forms
  • Uses jQuery UI for styling

Geolocation (PREMIUM)

Turn your database table into searchable map

  • Use Google Maps key per table
  • Define map settings per table
  • Editing dynamic marker layout
  • Batch procedure to store latitude and longitude
  • Use static or user location
  • Shortcode to add map to web page (+parameters)
  • Search map within adjustable radius

Data Designer

Create tables and indexes

  • Create and alter tables and indexes
  • Supports reverse engineering and reconciliation

Plugin Settings

Manage plugin behaviour, style and security

  • Many detailed plugin settings
  • User access and permission
  • Integrated WordPress role management

Plugin Links

スクリーンショット

インストール

(1) Upload the WP Data Access plugin to your blog
(2) Activate it
(3) Navigate to the WP Data Access menu

1, 2, 3 and you’re done!

評価

2021年9月25日
This is the only plugin that allows access database and edit/delete table from the WordPress dashboard. Thanks to the developer.
2021年8月26日
This plugin has everything you need to manage tables (wp and your own) and publish them. It allows you to pre-publish data under user role control and then to make it available on your website in different formats using shortcodes. We use it to manage a data which changes on a weekly basis (pickleball ladder tournaments). It is ideal for this project. Truly an environment which allows you to create an application without having to worry about re-inventing the wheel. No hesitation in recommending it to anyone willing to experiment and learn.
2021年5月12日
A great plugin served by a hyperactive and sympathetic author who listens to your needs! Clean and rigorous documentation and tutorials. A real academic job! WP Data Access is the only serious solution I have found to meet my need to set up a data management application under WP without coding. To be tested and used without moderation!`
2021年5月11日
Works perfectly. It really helped me out with database edits since my client's phpMyAdmin was inaccessible. Thanks again for an amazing plugin!
2021年4月29日
Great for when people come to you with a wordpress problem but can't find their hosting logins.
45件のレビューをすべて表示

貢献者と開発者

WP Data Access はオープンソースソフトウェアです。以下の人々がこのプラグインに貢献しています。

貢献者

“WP Data Access” は1ロケールに翻訳されています。 翻訳者のみなさん、翻訳へのご協力ありがとうございます。

“WP Data Access” をあなたの言語に翻訳しましょう。

開発に興味がありますか ?

コードを閲覧するか、SVN リポジトリをチェックするか、開発ログRSS で購読してみてください。