Create and save SQL Reports in your WP Admin and place them on pages and posts with a shortcode. Keep your database safe with automatic backups.
Start Creating and Saving Reports.
Just use the shortcode SQLREPORT like this [SQLREPORT name="My Report" style="border: 2px solid #CCCCCC; padding: 6px;" /] but be sure the name attribute matches the exact name of a report you have already created.
Note: This < does not display properly on web pages so I used the HTML code < in this example, > works...
SELECT display_name FROM wp_users WHERE ID = '<?php $current_user->ID ?>' (There are other ways to get the display name in WordPress, this is just a simple example to illustrate the proper syntax.)
SELECT * FROM wp_users WHERE user_registered > '<?php $_GET[thedate] ?>' (note: this example assumes you are going to pass 'thedate' as a GET variable in the query string and, as this example shows, don't use quotes inside the PHP brackets.)
Requires: 2.6 or higher
Compatible up to: 3.9.1
Last Updated: 2014-5-6
3 of 3 support threads in the last two months have been resolved.
Got something to say? Need help?