WordPress.org

Plugin Directory

Test out the new Plugin Directory and let us know what you think.

EZ SQL Reports Shortcode Widget 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.

4.11.37

  • Fixed two vulnerabilities that could be exploited by site admins, thanks to Felipe Molina for discovering these bugs.

4.11.33

  • Upgraded Widget Class for compatibility with WordPress 4.3 changes.

4.11.15

  • Fixed some minor styles in the admin pages.
  • Added a feature to hide all the reports from the main admin menu.

4.11.13

  • Fixed some minor bugs and improved the handling of multiple queries.
  • Added a call to do_shortcode to the query results so that shortcodes rendered in a report can be evaluated.

4.1.76

  • Made minor layout changes and enhancements to the Edit Reports page.
  • Fixed the Delete Report button to work even when the queries fails.
  • moved to the global wpdb object for full compatibility with WP 3.9 on MySQL 5.5.

3.10.19

  • Fixed table header row that contains column names.
  • Added an SQL Reports widget for the sidebar and footer area.
  • Added support for multiple queries on one report.

3.08.03

  • Improved the compatibility and reliability of the restore process.

3.06.29

  • Add ability to place reports on the dashboard for a given Role.

3.06.24

  • Created a second method for backups that uses the command line mysql.
  • Made compression optional and backup location changable.
  • Made restore function able to connect to external an DB.
  • Fixed shortcode to work with sanitize_title.

3.06.14

  • Added a WP cron scheduler for hourly and daily backups.
  • Upgraded the Backup process to ZIP and email all backups.
  • Added a shortcode for wpdb::get_var

1.3.03.24

  • Fixed the Backup process to capture VIEW definitions properly.

1.3.03.02

  • Added database backup feature.
  • Fixed Report name issue when using apostrophes.

1.3.02.12

  • Added Menu Placement and sorting options.
  • Expanded eval function to take multiple global variables.

1.3.01.28

  • Added eval function to take PHP code in the SQL Statement.

1.2.09.23

  • Added css classes to the Table and TRs for better style control.

1.2.04.16

  • Added error message to the Edit Report Page if SQL statement fails.

1.2.04.06

  • Added shortcode support so you can put your reports onto Pages and Posts.

1.1.12.16

  • Added styled DIV around Reports with ID tag so that you can customize the style.

Requires: 2.6 or higher
Compatible up to: 4.3.6
Last Updated: 1 year ago
Active Installs: 1,000+

Ratings

4.9 out of 5 stars

Support

2 of 3 support threads in the last two months have been marked 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
100,1,1
100,1,1
100,1,1
100,1,1
100,1,1 100,1,1
100,1,1