WP Data Access
  • Download
  • Support
  • Features
  • Pricing
  • Documentation
Select Page
Popular Search importsqlformqueryexport

WP Data Access

  • Getting started
  • Installation
  • What’s new?
  • Patches
  • Known limitations
  • FAQ

Data Tables

  • Getting Started
  • Creating and publishing
  • Responsive data tables
  • SEO friendly data tables
  • Adding hyperlinks
  • Extension Manager
  • Style Manager
  • Language settings
Styling
  • Style Manager
  • Premium styling
  • Global styling
  • Code Manager Styling
  • Manual styling
  • Styling issues
Filters
  • Static filters
  • Interactive filters
    • URL parameters
    • Search Panes
    • Search Builder
    • Search form
    • Advanced search
    • Geolocation search
Export & other buttons
  • Export to PDF, CSV, Excel, SQL
  • Print & copy buttons
  • Column selection buttons
  • Custom buttons
Advanced features
  • Advanced settings
  • Large tables & performance
  • Progressively SHOW MORE
  • Custom queries
  • Custom Post Types
  • Row grouping
  • Responsive master-detail
  • Master-detail tables
  • Non admin user access
Demos & tutorials
  • Demos
  • Tutorials

Data Apps

  • Data Projects
  • Projects and templates
  • Supported Data Types
  • One-To-Many relationships
  • Many-To-Many relationships
  • Registration page
  • Manage table options
  • Shortcode usage
Project Templates
  • Project Templates
  • Creating templates
  • Table Settings
  • Relationships
  • List Table
  • Data Entry
  • Reconcile
Data Forms
  • Data Forms
  • Overview
  • Project Demo
  • Page Demo
Advanced features
  • Adding filters
  • Custom validation
  • Add less/more button
  • User roles
  • Managing roles and users
  • Advanced table options
  • Advanced lookups
  • Front-end toolbar
  • Transfer to other WP site
Demos & tutorials
  • Demos
  • Tutorials

Data Explorer

  • Getting started
  • Navigation
  • Explore tables & views
  • Manage tables & views
  • Naming conventions
Manage Actions
  • Actions
Manage Settings
  • Settings
  • Search Settings
  • Geolocation Settings
  • Table Settings
  • Column Settings
  • Dynamic Hyperlinks
  • Dashboard Menus
Data Management
  • Import CSV & SQL files
  • Run SQL script files
  • Data Backup
Problems & solutions
  • InnoDB #rows estimation
  • Import file too large
  • Transfer to other WP DB

Remote Databases

  • MySQL | MariaDB
Other DBMS
  • Heterogeneous Connections
  • Using ODBC | JDBC
  • Connect to SQL Server
Premium Data Services
  • Remote wizard
  • START HERE
  • Errors and messages
  • Limitations
  • Tutorials
  • Remote Databases
    • Remote databases
    • SQL Server
    • PostgreSQL
    • Oracle
    • MariaDB | MySQL
    Remote Data Files
    • Remote data files
    • CSV files
    • JSON files
    • MS Access
    • XML files
    • Public URL
    • Synchronization
    Advanced features
    • Performance
    • Indexes

SQL

  • Getting Started
  • Tutorials
  • Visual Query Builder
  • Writing queries
  • Data exchange
  • Stored procedures
  • Database triggers
  • Scheduled queries

Business Intelligence

  • Getting started
  • Dashboards
  • Sharing dashboards
Dashboards Widgets
  • Dashboard Widgets
  • Publication Widget
  • Project Widget
  • Chart Widget
  • Custom Code Widget
  • Database Widget
  • Sharing Widgets

Table Design

  • Getting started
  • Introduction
  • Basic mode

Plugin Settings

  • Getting started
  • Plugin
  • Back-end
  • Front-end
  • Dashboard
  • Data Forms
  • Data Tables
  • Data Backup
  • Uninstall
  • Manage Repository
  • Manage Roles
  • System Info

Code

Shortcodes
  • Overview
  • wpdataaccess
  • wpdadataproject
  • wpdadataforms
  • wpdadiehard
  • wpdageomap
  • wpdawidget
Hooks & filters
  • Overview
  • Hooks
    • Overview
    • wpda_add_search_actions
    • wpda_add_search_filter
    • wpda_before_list_table
    • wpda_after_list_table
    • wpda_wpdataaccess_prepare
    Filters
    • Overview
    • wpda_column_default
    • wpda_before_simple_form
    • wpda_after_simple_form
    • wpda_construct_where_clause
API
  • WP Data Access API
  • Remote database access
  • CRUD Example
  • Extensions
    • Alternative search algorithm
    • Alternative buttons extension
Code Manager
  • Overview
  • Write code
  • Share(d) code

Getting started

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…

Share This Article :
  • Facebook
  • Twitter
  • LinkedIn
  • Pinterest
Still stuck? How can we help?

How can we help?

Updated on 2023-01-13
Installation

26 Comments

  1. Jan Kampherbeek
    Jan Kampherbeek on 2020-07-26 at 7:39 pm

    Hi Peter,
    Glad I found your WP Data Access project. Looks great!
    Jan

    Reply
    • Peter Schulz
      Peter Schulz on 2020-07-27 at 2:59 pm

      Thank you for your compliment Jan! 🙂 Great to see you on my website! 🙂

      Warm regards,
      Peter

      Reply
  2. Yamoun
    Yamoun on 2020-09-21 at 9:22 am

    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

    Reply
    • Peter Schulz
      Peter Schulz on 2020-09-21 at 11:56 am

      Which tutorial do you mean Yani?
      Thanks, Peter

      Reply
  3. Michael A Krause
    Michael A Krause on 2021-05-04 at 2:25 pm

    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?

    Reply
  4. Jörg Hartgen
    Jörg Hartgen on 2021-12-04 at 8:14 pm

    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

    Reply
  5. Peter Schulz
    Peter Schulz on 2021-12-06 at 3:36 pm

    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

    Reply
  6. Sean B
    Sean B on 2021-12-18 at 6:17 am

    Hi,

    Can we create SQL functions using WP Data Access?

    Reply
    • Peter Schulz
      Peter Schulz on 2021-12-18 at 10:10 am

      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

      Reply
  7. Ken Lyle
    Ken Lyle on 2021-12-25 at 5:18 pm

    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?

    Reply
    • Peter Schulz
      Peter Schulz on 2021-12-27 at 7:41 pm

      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

      Reply
  8. Cees
    Cees on 2022-03-16 at 3:05 pm

    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

    Reply
    • Peter Schulz
      Peter Schulz on 2022-03-17 at 10:14 am

      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

      Reply
  9. Cees
    Cees on 2022-03-19 at 4:14 pm

    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.

    Reply
  10. Cees
    Cees on 2022-03-19 at 5:08 pm

    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.

    Reply
    • Peter Schulz
      Peter Schulz on 2022-03-20 at 8:34 am

      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

      Reply
  11. Cees
    Cees on 2022-03-20 at 1:18 pm

    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

    Reply
  12. Cees
    Cees on 2022-03-20 at 1:20 pm

    Hi Peter,

    I forgot: table wpda_sas_class has been created.

    Cees

    Reply
  13. john mcfetridge
    john mcfetridge on 2022-03-24 at 2:55 pm

    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

    Reply
    • Peter Schulz
      Peter Schulz on 2022-03-24 at 4:03 pm

      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

      Reply
  14. Pete Martin
    Pete Martin on 2022-03-26 at 7:07 am

    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

    Reply
    • Peter Schulz
      Peter Schulz on 2022-03-26 at 8:05 am

      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

      Reply
  15. Jopo
    Jopo on 2022-10-14 at 10:36 am

    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?

    Reply
    • Kim Leong
      Kim Leong on 2022-10-17 at 3:01 pm

      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.

      Reply
  16. Edward
    Edward on 2022-10-26 at 5:00 am

    What are the premium data services that requires an active license?

    Reply
    • Peter Schulz
      Peter Schulz on 2022-10-26 at 12:02 pm

      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

      Reply

Submit a Comment Cancel reply

Your email address will not be published. Required fields are marked *

Links

Blogs
Tutorials
Demos

Socials

LinkedIn
Twitter

Get in touch

Premium support
Free support forum
Contact us

Resources

WordPress plugin directory
YouTube tutorials

Passionate Programmers B.V. © 2017 - 2023 All rights reserved