Get WordPress SQL query details
When I debug WordPress, getting SQL query details is useful in some situations.
In the WordPress plugin repo, we can find some nice debug plugins to get query details. Also, we can use default WordPress options to get query details.
First, we need to add a definition in our wp-config.php
.
define('SAVEQUERIES', true);
The SAVEQUERIES definition saves the database queries to an array and we can use that array to analyze those queries.
The array is stored in the global $wpdb->queries
.
Print last SQL query string
$wpdb->last_query
Print last SQL query result
$wpdb->last_result
Print last SQL query Error
$wpdb->last_error
Recent Posts
- Automating Release Generation with GitHub Actions
- WP CLI Commands to Bulk Delete Entries in WordPress Database
- Split a Single CSV File into Multiple Files Using the Split Command - Bash
- Migrating code repo from BitBucket to GitHub
- Streamlining Development - Our Journey with Git, Bitbucket, and Jira
Your Questions / Comments
If you found this article interesting, found errors, or just want to discuss about it, please get in touch.