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

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
  • Table Settings
  • Column Settings
  • Search Settings
  • Geolocation 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

Plugin

Table of Contents
  • Plugin menu
  • Panel cookies
  • Secret key and IV
  • Remote database connections
  • Shortcode wpdataaccess
  • Shortcode wpdadiehard
  • Shortcodes wpdadataforms and wpdadataprojects
  • Debug mode
  • Date format
  • Time format
  • Date/time test
  • Set format
WP Data Access Settings - Plugin

Plugin menu #

Enable checkbox Hide plugin menu in admin panel to the plugin menu. All plugin features remain available. This is for developers who want to use WP Data Access features without using the plugin menu.

Panel cookies #

Panel cookies are used to save settings like your currently selected database and search criteria. Panel cookies are cleared after one hour.

When set to Clear when switching panels, the plugin clears these cookies every time the user switches to another page. When set to Keep when switching panels, cookies are preserved when the user switches to another page.

Secret key and IV #

Enter any prase to secure your remote database connection information. When set, all current remote database connections will be converted immediately.

Remote database connections #

Edit or delete remote database connections.

  • More info about remote database connection management…

Shortcode wpdataaccess #

Grant access to shortcode for posts and/or pages.

Shortcode wpdadiehard #

Grant access to shortcode for posts and/or pages.

WP Data Access Settings

Shortcodes wpdadataforms and wpdadataprojects #

Grant access to shortcode for posts and/or pages.

Debug mode #

With debug enabled:

  • Data Forms displays debug messages in the browser console
  • Query information is added to Data Tables responses
  • A button is added to the Data Projects main page to check project settings

Date format #

Output format cannot be changed here. Please use the WordPress settings (Settings > General) page to change the output format.

Select a predefined input format or enter a custom one and adjust the placeholder.

Time format #

Output format cannot be changed here. Please use the WordPress settings (Settings > General) page to change the output format.

Select a predefined input format or enter a custom one and adjust the placeholder.

Date/time test #

Click on the button to test if your setting work before you save!

Set format #

List format for data type set only

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

How can we help?

Updated on 2022-12-20
Getting startedBack-end

9 Comments

  1. Nickolai Ørskov Seehagen
    Nickolai Ørskov Seehagen on 2020-10-14 at 10:19 am

    I have been using your plugin with great joy!
    I have run into one issue I can’t seem to fix.

    In my database, dates are stored as a UNIX timestamp, and I was hoping to setup the table to show the date converted into something readable. Is this possible? I can for some reason not find it.

    A bonus question would be, can we do conditioned formating. Say if its a row has 1 in the database you display a checkmark picture or something 🙂

    Kind regards

    Reply
    • Peter Schulz
      Peter Schulz on 2020-10-14 at 10:33 am

      Hi Nickolai,

      >>> In my database, dates are stored as a UNIX timestamp
      Is this a MySQL date(time) column? Or is the date inserted into a varchar column? You cannot (re)format a date if it is stored in a varchar column. But you should be able to format your date field on the plugin settings page.

      Can you send me some screenshots? I’m interesed in your table structure and the layout of your data. You can use the contactform to send me your screenshots in private.

      Thanks,
      Peter

      Reply
  2. Cory
    Cory on 2020-11-25 at 11:35 pm

    Hi Peter,

    Your app is just about the perfect solution, however I was not able to find one solution.

    Is there a way to hook into your program to reformat the outputted data on the front-end table? For example, a price column is stored in my database as an int value of 10000, which means $100.00, and I would like it displayed like that. Is there a way to hook into your program, (PHP hook or JavaScript) so I can write a function with an input of 10000 from the DB returns $100.00 and displays that way in the front-end table? Thank you.

    Reply
    • Peter Schulz
      Peter Schulz on 2020-11-26 at 7:58 am

      Hi Cory,

      Yes, you can hook into the plugin! 🙂

      To reformat data with Data Tables, you can use function fnRowCallback in advanced settings. Here is an example:
      https://wpdataaccess.com/docs/data-tables-advanced-features/advanced-settings/

      To reformat data with Data Projects, you can use filter wpda_column_default. Here is the (minimal) documentation:
      https://wpdataaccess.com/docs/filters/wpda_column_default/

      Let me know if you need help!

      Best regards,
      Peter

      Reply
      • Cory
        Cory on 2020-12-02 at 11:06 pm

        Thank you very much Peter, I’m on the right path now! Here are the solutions I came up with both have good results but I need a little more help with Data Tables for the different views.

        For Data Tables, here is a solution, however I have to continually map the column number (in this example 3). If I change the column placement or more importantly change it to the responsive view, this breaks. Is there a way to map it by name of the column instead of the number, or change the output for all views? Not sure if it’s possible, but I’d prefer a PHP hook solution for Data Tables:

        { “fnRowCallback”: “function(row, data, index) { var amount = data[3] / 100; var dollar = ‘$’ + amount.toFixed(2).toString(); jQuery(row).find(‘td:eq(3)’).html(dollar); }” }

        For the Data Projects I copied your example function, and added a little bit to it. (Note: in the example function you have a “$this” parameter that throws an error, did you mean for that to be “$self”?). Anyway, this function works for me:

        function my_column_default(
        $value,
        $item,
        $column_name,
        $table_name,
        $schema_name,
        $wpda_list_columns,
        $list_number
        ) {
        if ( ” !== $value ) {
        return $value;
        }

        if ( ‘dutch’ === $column_name ) {
        return ‘NL-‘ . $item[ $column_name ];
        }

        if ( ‘transaction_amount’ === $column_name ) {
        return ‘$’.number_format(($item[ $column_name ] / 100), 2, ‘.’, ”);
        }
        }
        add_filter( ‘wpda_column_default’ , ‘my_column_default’ , 10 , 8 );

        This is perfect! I’m not sure if this is the correct way to do it but it gives the right output. I was initially trying to use $value but it appeared empty when I did the console.log($value) output. This works so I’m happy with it. Thank you for all your help!

        Reply
        • Peter Schulz
          Peter Schulz on 2020-12-03 at 11:45 am

          Hi Cory,

          You are right, parameter $this needs to be $self. Thank you for reporting! I updated the code.

          Data Tables uses the column sequence number, not the column name. Right again! 🙂 This has a number of advantages, but I understand your need to use the column name. I added your comment to my to do list.

          Thank you for sharing your solution! 🙂
          Peter

          Reply
          • Cory
            Cory on 2020-12-04 at 2:00 pm

            Thank you Peter, again great program, I’ll be looking forward to that update!

            Reply
  3. Mike Krause
    Mike Krause on 2021-12-15 at 12:04 am

    I’ve moved my site from GoDaddy to SiteGround. Since the move my WPDA publications aren’t working… I’m not connecting to my remote database. I see that the Settings/Plugin/Secret Key and IV are not populated but I don’t know if they were at GoDaddy.

    Please help.

    Reply
  4. Peter Schulz
    Peter Schulz on 2021-12-15 at 7:38 am

    Hi Mike,

    You can find your remote database connections in your options table, option name = wpda_remote_databases. Please be aware that these values are hashed. To make them available on your new server, you need to copy your old secret key and iv to your new server BEFORE you copy the wpda_remote_databases option. You can also just add the remote connection from the Data Explorer.

    Hope this helps,
    Peter

    Reply

Submit a Comment Cancel reply

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

Table of Contents
  • Plugin menu
  • Panel cookies
  • Secret key and IV
  • Remote database connections
  • Shortcode wpdataaccess
  • Shortcode wpdadiehard
  • Shortcodes wpdadataforms and wpdadataprojects
  • Debug mode
  • Date format
  • Time format
  • Date/time test
  • Set format

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