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.
Remote database connections are supported for MariaDB, MySQL, SQL Server, MS Access, PostgreSQL and Oracle. Remote connects other than MariaDB and MySQL require additional configuration...
Data Tables #
Use Data Tables to create professional read-only data tables for back-end and front-end usage in just minutes. Data tables are very easy to create and highly customizable. Read more…
Data Apps #
Create WordPress apps for back-end and front-end with Data Projects. Projects can be customized using Project Templates. Data Forms is available for premium users to generate fully responsive apps without the need to make any changes to a Data Project at all. Read more…
Data Explorer #
Access and manage local and remote databases straight from the WordPress dashboard using the intuitive WordPress look and feel. The Data Explorer is your starting point for searching, sorting, importing, exporting, data entry and much more. Read more…
Business Intelligence #
Share customizable dashboards and widgets on your WordPress dashboard, web pages (using shortcodes) and external websites (using longcodes). Read more…
SQL #
The Query Builder supports SQL query execution from the WordPress dashboard. Queries can be saved and reused. A tabbed user interface allows working on multiple queries simultaneously. Read more…
Charts #
Charts are created from SQL queries. Queries can originate from any local or remote database and can be display on the back-end, web pages and even external websites. Read more…
Geolocation Support #
WP Data Access lets you create searchable geolocation maps from a database table using Google Maps. This feature can be used intergrated with data tables. Read more…
Table Design #
The Data Designer helps users with no or little SQL knowledge to create database tables and indexes (supporting reverse engineering). Experienced users can use the Query Builder to execute custom SQL. Read more…
Hi Peter,
Glad I found your WP Data Access project. Looks great!
Jan
Thank you for your compliment Jan! 🙂 Great to see you on my website! 🙂
Warm regards,
Peter
Hello , I followed your tutorial but when I try to display the table, it only shows me the columns ! how could i fix it ?
Yani
Which tutorial do you mean Yani?
Thanks, Peter
Peter, WP Data Access is a FABULOUS piece of work! Thank you!
I’ve been searching through the doc for help on using the SQL SUM function to show, of course, the SUM of a column, but I haven’t found any reference to SUM.
Can you help, please?
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/remote-databases/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
Hi, if I activate an annual billing and after one year I cancel the billing, will I have still the Premium version without updates and support?
Hi Jopo,
You’re right. 🙂 You will still be able to use the premium version of the plugin. Only the premium data service requires an active license.
What are the premium data services that requires an active license?
Hi Edward,
This is a service that allows you to connect to foreign databases like SQL Server or ProgreSQL. You can find the documentation here: https://wpdataaccess.com/docs/premium-data-services/remote-connection-wizard/
Hope this helps,
Peter