The following environment variables can be used in WP Data Access: $$USERID$$ Contains the WordPress user ID $$USER$$ Contains the WordPress user login $$EMAIL$$ Contains the WordPress user email Environment variables can be used: As default value in Project Templates In where clauses
Plugin
Repository backup and restore management
WP Data Access creates a backup of all your repository tables each time the plugin is updated (unless disabled). This mechanism was added to prevent plugin users losing their repository data during an update failure. It has now been extended to allow plugin users to make interactive backups, download backups and restore backups partially or […]
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 was optimized in version 4.2 and does no longer count all table rows on each request: For MyISAM tables the table row […]
Styling a Data Project
(1) Use the Code Manager to style your projects The Code Manager is the new way to style projects! Read more about the Code Manager… The table below demonstrates how the Code Manager can be used to style a project. Use the project layout panel to switch between stylesFind your favourite combination of styles Download […]
WP Data Access classes in your own PHP code
As a PHP programmer you can use the WP Data Access classes to add full CRUD table pages to your own dashboard menus. Read the example code below to learn how.
Generate API documentation
Generate API Documentation Start the command line interface Navigate to the plugin root folder Enter the following commands: composer require −−dev phpdocumentor/phpdocumentor dev-master php vendor/phpdocumentor/phpdocumentor/bin/phpdoc.php Navigate to subfolder docs Open file index.html in your favourite browser Remove API Documentation Start the command line interface Navigate to the plugin root folder Enter the following command: composer […]