WP Data Access is a powerful tool for data administration, publication, and development, enabling you to perform database-related tasks directly from your WordPress dashboard. It offers multiple tools to access both local and remote databases, allowing you to create interactive tables, forms, and charts with ease.
App Builder #
The WP Data Access App Builder provides an intuitive Table Builder, a highly customizable Form Builder, and interactive Chart support. Apps can run on both the back-end and front-end, with simple authorization management based on WordPress user roles. The App Builder also supports 35 languages, making localization seamless.
Builders & Wizards #
The App Builder simplifies app creation with the App Wizard while offering advanced customization through Builders, Managers, and Wizards. These tools provide administrators with full control over app layouts and behavior in real time, on both the back-end and front-end.
Remote Database Access #
WP Data Access allows remote database connections for MariaDB, MySQL, SQL Server, MS Access, PostgreSQL, and Oracle. Non-MariaDB/MySQL connections require additional configuration.
Hooks for Advanced Customization #
While most features can be configured using intuitive builders and wizards, hooks allow developers to extend functionality with custom code, unlocking unlimited possibilities. Hooks are currently available for tables, with support for forms coming soon.
Legacy Tools #
The App Builder replaces the legacy tools, which are still available for maintaining existing solutions. However, for new projects, we strongly recommend using the App Builder for a more efficient and modern development experience.
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