Plugin Directory

ELI's SQL Admin Reports with shortcode

This plugin allows you to create reports simply by entering in the SQL.

What do I do after I activate the Plugin?

Start Creating and Saving Reports.

How do I get one of my reports onto a Page or Post?

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.

How do I use a global variable in one of my reports SQL?

SELECT display_name FROM wp_users WHERE ID = 'ID ?>' (I know 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 > '' (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.5.1
Last Updated: 2013-3-25
Downloads: 1,694

Ratings

5 stars
5 out of 5 stars

Support

4 of 4 support threads in the last two months have been resolved.

Got something to say? Need help?

Compatibility

+
=
Not enough data

1 person says it works.
0 people say it's broken.

100,1,1 100,1,1 100,1,1
100,1,1 100,1,1 100,1,1
100,1,1 100,3,3
100,2,2 100,2,2 100,1,1
100,1,1 100,2,2 100,2,2 100,1,1 100,1,1
100,1,1 100,2,2 100,3,3 100,1,1 100,1,1
100,1,1 100,3,3 100,1,1 100,1,1
100,1,1 100,1,1 100,1,1
100,1,1 100,1,1 100,1,1 100,1,1