Blog

Plugin news, guides and tips & tricks 🙂

Global Search & Replace

A new feature was added to perform global search and replace actions on multiple databases and tables. The new feature can be accessed from the new Search & Replace icon (see image below) in the menu bar of the Data Explorer and is available for all users (free...

WordPress user ID in SQL

WP Data Access version 5.2.3 adds a session variable containing the WordPress user ID to its database connections. This allows plugin users to access the WordPress user ID in SQL queries, database views, triggers, functions and procedures.Open the Query Builder and...

Copy/export large tables

When a table is copied or exported, the plugin needs to read and write all table rows. For large tables this might result in a fatal error:Fatal error: Allowed memory size of 268435456 bytes exhausted (tried to allocate 4096 bytes)One way to solve this issue is to...

Copy table to other DB

A new feature was added to the Data Explorer, which allows users to copy a table to another local or remote database. The current database is selected by default. It is still possible to copy the table with or without data.Copying large tablesThe query buffer size,...

Hide Data Explorer Manage link

Restrict table management is a new option available in plugin back-end settings. It allows organizations to remove the Manage link in the Data Explorer for specific admin users. See image below (click to enlarge).Many plugins require WordPress users to have the...

Data Tables CSS changed

Icon color greenThe Data Tables library file structure has changed in version 5.1.1. If you are using one of the Code Manager styles (or copied the styles into your WordPress theme), the responsive icons will be shown in its original green color instead of the color...

Added user location search

Version 5.1.0 adds support for user location search to geo maps. This adds a search box to a geo map that allows the user to select a location using Google location services and search within a range of the given location.Add parameter map_search to shortcode...

Environment variables

The following environment variables can be used in WP Data Access $$USERID$$ WordPress user id $$USER$$ WordPress user login $$EMAIL$$ WordPress user email $$NOW$$ Current date $$NOWDT$$ Current date + time Environment variables can be used: As default value in...

Improved performance for large tables

Tables are using pagination by default. Although pagination improves the user experience, it slows down performance, especially for large tables. Pagination requires counting: All table rows All matching table rows The pagination features were optimized in version 4.2...