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 values in...
Docs
Posts under the "Docs" category
WordPress user ID in SQL
WP Data Access 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 enterThis...
Supported Data Types
Table and column definitions are used to generate list tables and data entry forms. Constraints are handled internally by the plugin. Additional constraints can be added using database triggers. Make sure to handle errors correctly in your database triggers. This...
Style Manager
The Style Manager is a premium feature that allows plugin users to interactively style data tables. The Style Manager can be reached from the icon on the Data Tables main page or from the Data Tables configuration form and does not require any technical skills.The...
Import file too large
PROBLEMThe message "ERROR: File upload failed" usually means that you are trying to import a file which is too large. Although the plugin checks the file size against your "upload_max_size" settings there are other settings which might cause problemsEASY SOLUTIONSThe...
InnoDB #rows estimation
If you start the Data Explorer from the WP Data Access menu, you'll see the list of tables in your WordPress database. The column #Rows shows the number of rows in the corresponding table. This number is a rough estimate of the number of rows (records) for InnoDB...
Column selection buttons
Column selection buttons are standard button that can be added from the Extension Manager.
Print & copy buttons
Print and copy buttons are standard button that can be added from the Extension Manager.
Remote database access
The WP Data Access API can be used to connect to local and remote databases. Here is a basic example which shows how to connect, perform a query and dump the query results on the screen.This code works similar for local and remote databases. A database must be...
CRUD Example
The following PHP code creates a fully functional CRUD page for table employees stored in a remote database named rdb:classicmodels. The page is added to the WordPress dashboard menu.To use a table stored in the WordPress database, just remove the wpdaschema_name...
Recent Comments