<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.

Jacques Malgrange

<p>This lightweight plugin makes it easy to install the millions of GEONAMES Data on your WordPress site.<br />
It allows :</p>
<ul>
<li>Install data from one or more file (place & postal code) ;</li>
<li>Choose column to install to avoid excessive enlargement of the base ;</li>
<li>Choose type of data to install (city, park, road…) ;</li>
<li>Remove all the data.</li>
<li>Check data in the database.</li>
<li>Edit and change datas from Dashboard.</li>
<li>Display the places on OpenStreetMap.</li>
</ul>
<p>A shortcode is also available to create a city region and country taxonomy.</p>
<p>This plugin will give you plenty of ideas to improve the quality of your website.</p>
<p>Official <a href="http://www.geonames.org/" rel="nofollow ugc">GeoNames</a> website.</p>
<h3>1.9.1</h3>
<p>05/12/2024</p>
<ul>
<li>Fix XSS vulnerability in shortcode attributes</li>
<li>Fix translation issue with WP 6.7</li>
</ul>
<h4>1.9</h4>
<p>18/10/2024 – Fix XSS vulnerability on geoSearch field</p>
<h4>1.8</h4>
<p>08/02/2022</p>
<ul>
<li>Update Leaflet 1.7.1.</li>
<li>Update SumoSelect 3.4.2.</li>
<li>Split admin sidet in a specific file.</li>
</ul>
<h4>1.7</h4>
<p>21/03/2020</p>
<ul>
<li>Fix issue with very long line in Geoname DB.</li>
<li>Add nonce.</li>
<li>Braces style standardisation in the code.</li>
</ul>
<h4>1.6</h4>
<p>14/03/2019 – Add Postal code database.</p>
<h4>1.5.1</h4>
<p>27/01/2018 – Curl used by default if exists in place of File_Get_Content.</p>
<h4>1.5</h4>
<p>12/01/2018 – Add tab to edit and change datas.</p>
<h4>1.4</h4>
<p>24/06/2017</p>
<ul>
<li>Add Taxonomy.</li>
<li>Add shortcode to create taxonomy in the site.</li>
<li>Add template to customize the taxonomy form.</li>
<li>Ability to download multiple files in one click.</li>
<li>Check the database with a taxonomy form and display the place on OpenStreetMap.</li>
<li>Multisite.</li>
</ul>
<h4>1.3</h4>
<p>09/10/2015 – Fix “Fatal error: Out of memory (allocated xxx) (tried to allocate xxx bytes)”.</p>
<p>07/06/2016 – 1.3.1 – Fix error when reactivate (header already sent…).</p>
<h4>1.2</h4>
<p>06/08/2015 – Fix installation bug.</p>
<h4>1.1</h4>
<p>01/12/2014 – Add Ajax hook.</p>
<h4>1.0</h4>
<p>25/11/2014 – First stable version.</p>


WP GeoNames

Allows you to insert all or part of the global GeoNames database in your WordPress base.

EZ SQL Reports Shortcode Widget and DB Backup vs WP GeoNames