WordPress.org

Ready to get started?Download WordPress

Plugin Directory

ELI's SQL Admin Reports Shortcode and DB Backup

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.

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 PHP variable in one of my SQL queries?

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.2
Last Updated: 2014-5-6
Downloads: 5,631

Ratings

5 stars
5 out of 5 stars

Support

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

Got something to say? Need help?

Compatibility

+
=
Not enough data

0 people say 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 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
100,1,1
100,1,1
100,1,1
100,1,1
100,1,1 100,1,1
100,2,2