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, WordPress media library integration and using estimated row counts instead of real row counts to support large tables.
Data Explorer – Data and database administration
The Data Explorer allows plugin users to perform data and database related tasks directly from the WordPress dashboard. Tables, columns, indexes and foreign keys can be viewed inline. Common DDL actions, SQL and CSV imports, as well as table and row exports in several formats are available on mouse click. Table data can be viewed and managed from list tables and user friendly data entry forms. Many settings can be managed from the Data Explorer to customize table and view management.
More complex features are available for experienced developers, like remote database access and executing SQL scripts. Remote database access is supported by all features.
Data Publisher – Create responsive tables
The Data Publisher allows plugin users to create responsive tables from local and remote databases. Publications can be created with just a few mouse clicks. Customizable styles are available for download for free. Demos and videos are available to help new and experienced users getting their publications up and running. The Data Publisher supports client side processing for small tables and server side processing for large tables (several use cases with over two million rows). Advanced options and javscript support is available for more experienced developers.
Geolocation – Search within location range (premium)
With geolocation your users can search places stored in a database table. The users position or a fixed position can be used to search within a range. An interactive map allows your users to change the range from a dropdown list. The plugin needs a Google Maps API to retrieve the geolocation information and stores this information in a database table for fast access.
Data Projects – Write your own WordPress apps
Manage your local and remote data with Data Projects. Supports many features like parent-child relationships, lookups, autocomplete, many customizable options and access rights per page supporting WordPress roles. Projects can be executed from the dashboard or a web page using a shortcode. Data Forms is a premium feature which allows plugin users to turn their Data Projects into fully responsive AngularJS apps without the need to make any modifications to their projects. Data Projects is optimized to work with large tables.
Project Templates – Customize your Data Projects
Project Templates are used to customize Data Projects pages. Without a template the plugin uses the default values for all page items. A template contains five sections to customize table layout and behaviour. Each section can be managed individually.
Every project template contains a template set name. This set name is used to define which template set is used for a specific Data Projects page. The plugin allows to create multiple templates for a table to manage the layout and behaviour of each Data Projects page separately.
When a set name is added to a Data Projects page (see image below – click to enlarge) the page will use that template set name for all tables shown on that page. The set name is also used for tables in relationships, allowing plugin users to customize parent and child tables individually as well.
Data Forms – Turn your Data Project into an AngularJS app
Data Forms turns your Data Projects into state of the art responsive data apps. It uses jQuery DataTable with server side processing to handle large amounts of data. Data entry forms are generated using AngularJS. Existing Data Projects can be executed as Data Forms apps without the need to make any changes to projects.
Query Builder – Execute SQL commands
The Query Builder allows plugin users to execute any SQL command (DCL, DDL and DML) from the WordPress dashboard, as long as the user has the necessary credentials. The tool is available for admin users only and restricts access to WordPress tables. Multiple queries can be edited simultaneously. Queries can be stored per WordPress user account and can be reused at a later time. Output can be exported to CSV, JSON and XML. The Query Builder lets a plugin user access local as well as remote databases. The raw server response can be examined for further research.
Data Designer – Create tables and indexes
Use the Data Designer to create your own tables and indexes. Or load existing tables into the Data Designer with reverse engineering. Works with local and remote databases (make sure you have to necessary credentials). Use the Data Explorer to execute your own sql scripts (button Import data/Execute script(s)) if you are an experience database developer.
Plugin Settings – Manage behaviour, style and security
WP Data Access is highly customizable. An extensive settings page allows plugin users to change the look and feel of back-end and front-end features. Many settings can be defined on global, table and view level, acting like a layer between the database and plugin tools. These settings are available for local as well as remote databases.
Hi there,
as you probably know support for AngularJS will be deprecated on December 31. 2021.
Do you have plans to replace the AngularJS parts of the application?
Best regards
Jorg
Hi Jorg,
Good point! Data Forms consist of two parts: (1) tables using jQuery DataTables and (2) data entry forms using AngularJS. With a team of developers I’m working on a React solution. This solution will help to replace the AngularJS part of Data Forms and will become available as a stand-alone product as well. For now I hope the extended long term support available until 2026 will help to cover security fixes.
Best regards,
Peter
Hi,
Can we create SQL functions using WP Data Access?
Hi Sean,
The Query Builder is in fact a kind of SQL command line interface running in a browser. It supports any SQL command the connected user is authorized to execute. If you are allowed to create functions, you can use the Query Builder for that purpose. Please keep in mind that many ISP’s do not support functions, triggers, remote connections and other great features. Features not supported by your ISP are not available within the Query Builder.
Hope this helps,
Peter
I don’t see how I can share a query to another user or role in the Free version. Is this a Premium feature? Did I miss it?
Hi Ken,
Queries are stored in the usermeta table and therefor onlt accessible to the login user. It is currently not possible to share a query with other users. This feature is planned as a future update and will be available in the free version.
Best regards,
Peter
Hi Peter,
I want to use the Data Access plugin on both Windows10 and LinuxMint (20.3). On Linux the plugin is working OK but on Windows I can’t import (under Data Explorer) the 4 SQL files of the SAS application. On Linux the import was running OK.
There are no messages in the logs; it just does nothing. Any idea ?
Specs: PHP 8.0.12, MariaDB 10.4.21, Apache 2.4.51.
I hope you can help me.
Regards Cees
Hi Cees,
Are the tables crated when you open file wpda_sas_create_tables.sql with an editor and copy the content into the Query Builder? Please make sure to change to ; into / to allow the Query Builder to process multiple commands.
Best regards,
Peter
Hi Peter,
I’m not using the Query Builder. On the Data Explorer page I click on the “Import SQL files” tab, then I click “Select files”, select wpda_sas_create_tables.SQL, and at last I click on the button “Import files/Execute script”. On Linux this is working fine, on Windows nothing happens.
Sorry. Not the correct answer. I used Query Builder and copied the statements for wpda_sas-class. Table created now.
Using all statements and replacing ; by / produced lots of error messages.
Hi Cees,
Can you please check two things for me:
– When you open the Data Explorer, enter wpda_sas in the search field and press enter: do you any results?
– When you open wpda_sas_create_tables.sql and copy the first create table statement into your Query Builder without the ; can you send me the error message you see?
Thanks,
Peter
Hi Peter,
I used the “Import/Execute SQL files” tab again.
– When you open the Data Explorer, enter wpda_sas in the search field and press enter: do you any results?
No results.
– When you open wpda_sas_create_tables.sql and copy the first create table statement into your Query Builder without
the ; can you send me the error message you see?
Query OK, 0 rows affected
Raw output:
show_errors: false,
suppress_errors: true,
last_error: “”,
num_queries: 36,
num_rows: 0,
rows_affected: 0,
insert_id: 0,
last_query: “–
— Create table `wpda_sas_class`
—
CREATE TABLE `wpda_sas_class` (
`course_id` int(11) NOT NULL,
`student_id` int(11) NOT NULL,
PRIMARY KEY (`course_id`,`student_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8”,
last_result: [],
queries: null,
prefix: “wp_”,
base_prefix: “wp_”,
ready: true,
blogid: 0,
siteid: 0,
tables: [10 items],
old_tables: [3 items],
global_tables: [2 items],
ms_global_tables: [7 items],
comments: “wp_comments”,
commentmeta: “wp_commentmeta”,
links: “wp_links”,
options: “wp_options”,
postmeta: “wp_postmeta”,
posts: “wp_posts”,
terms: “wp_terms”,
term_relationships: “wp_term_relationships”,
term_taxonomy: “wp_term_taxonomy”,
termmeta: “wp_termmeta”,
usermeta: “wp_usermeta”,
users: “wp_users”,
blogs: null,
blogmeta: null,
registration_log: null,
signups: null,
site: null,
sitecategories: null,
sitemeta: null,
field_types: {34 items},
charset: “utf8mb4”,
collate: “utf8mb4_unicode_ci”,
func_call: “$db->query(\”–
— Create table `wpda_sas_class`
—
CREATE TABLE `wpda_sas_class` (
`course_id` int(11) NOT NULL,
`student_id` int(11) NOT NULL,
PRIMARY KEY (`course_id`,`student_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8\”)”,
is_mysql: true,
time_start: null,
error: null,
categories: “wp_categories”,
post2cat: “wp_post2cat”,
link2cat: “wp_link2cat”
Hope that’s not too much info
Regards, Cees
Hi Peter,
I forgot: table wpda_sas_class has been created.
Cees
we inherited a wordpress web site that are struggling to get it to access data in our corporate MYSQL database. that database has key info on users like address, phone numbers etc. our web master is a plugin only guy and is using plugins like Ultimate membership for login and directory operations. he had to create an intermediate data source in WP and I find this disturbing . we now have key data in 2 places where directly accessing the corporate DB would be a much cleaner and maintainable solution. I am a ASP.NET dev and used to having everything accessible directly from a DB. Hoping that your tool can help us.
Thanks
Hi John,
WP Data Access allows you to remote connect to your MySQL database. Once connected you can access your remote database just like your WordPress database to create queries, publication, projects and charts. The following page explain how to connect to a remote MySQL database:
https://wpdataaccess.com/docs/documentation/remote-database-connections/mysql-mariadb/
Hope this helps,
Peter
Hi – I am trying to create a site where customers log in and go through a series of forms entering information. As they go through these forms earlier answers need to appear so they can add new information. Finally I need to create a report based on their answers which they can print. I think two tables, one for customer information and one for their answers would be sufficient; can WP Data Access help me to create this site?
Thanks
Pete Martin
Hi Pete,
Your question is hard to answer. It depends on your work flow. WP Data Access supports parent child pages which you can use to build the necessary relationship. Pages are based on CRUD principals. If your work flow can be supported with CRUD pages, it should work. If you require specific handling during specific phases it might not be possible. Just give it a try with the free version.
Hope this helps,
Peter