<p>Just place some SQL on in the box and save it as a report. You can save multiple reports and they will be listed on the Admin Menu so you can quickly run them again anytime with just one click. You can place your reports on the User’s Dashboard based on Roles. You can also put a report on a Page or Post using a shortcode like [SQLREPORT name=”My Report” style=”padding: 6px;” /]</p>
<p>There is also an shortcode for the wpdb::get_var function that you can use to display a single value from your database. For example, this will display the number of users on your site:<br />
[sqlgetvar]SELECT COUNT(*) FROM wp_users[/sqlgetvar]<br />
Note: because of a known exploit in the WordPress shortcode functionality it is required that an admin user create an SQL Report with the exact query that will be used in the sqlgetvar shotcode, otherwise any subscriber could white their own shortcode query.</p>
<p>If you want to include an “Export to CSV” button on your page or post then use the additional shortcode [SQLEXPORTCSV] once on any page or post that contains a report you want visitors to be able to download. Thanks to @loristictok and @rob66bnu for posting the suggestion with the JavaScript that I used to make this new Shortcode.<br />
Note: Adding this shortcode to the just one time will insert the “Export to CSV” button at the top of every HTML Table on the page.</p>
<h4>Automatic Database Backups</h4>
<p>Your database can be automatically saved and archived every hour and/or every day, and backups can be emailed to the address you specify. You can also restore the data to your WP DB or an external DB, which makes copying your database to another server and easy task.</p>


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.

JPPreusDev

<p>Extremely simple way for developers to create new tables inside the existing WordPress database. Forget the annoying process of opening phpMyAdmin, logging in, then typing out the full SQL command for your new table. With this plugin, everything you need to do is located on one simple to use page, and you don’t have to type out any SQL queries! This plugin also allows you to manage your tables with view and delete functionality for any table you create. It is perfect for the developer who wants to quickly and easily add and manage new database tables in a quick and effective manner.</p>
<h4>Future Updates</h4>
<p>Updates in the near future will include features for database administration. It is also planned to add functionaily to modify created tables and a table row reference for the tables previously created. If there are any updates you would like to see, please send and email with your comments to [jpreusdev@gmail.com](mailto:jpreusdev@gmail.com “Send me your comments”).</p>


Create DB Tables

This plugin makes it extremely quick and easy to create & view new  and existing WordPress database tables. Its secure, lightweight doesn't slow my site down. Highly recommend to those who want to save time, not use phpMyAdmin, and handle your table creation and management directly inside the WordPress Admin Dashboard.



DB Table Management - Simple & Easy

Extremely simple way for developers to create and manage new database tables in a quick and efective manner.

EZ SQL Reports Shortcode Widget and DB Backup vs Create DB Tables