I added a shortcode to my SQL Reports Plugin so you can put a report you’ve created into a Page or Post. Just use the shortcode “SQLREPORT” with the attribute “name” being the name or your desired report. Like this:
[SQLREPORT name="My Report" style="border: 2px solid #CCCCCC; padding: 6px;" /]
The below example is a Report that I make to see the effect that Google’s SSL Search has been having on my Keyword Data. I broke it down by Locale so that I could see the differences between the use of google.com as compared to the other country codes.
Impact of Google Blocking Keyword Data with SSL Search
| Domain | Total Visits Referred | Keywords Blocked by SSL | Percentage Blocked |
|---|---|---|---|
| www.google.com | 284 | 158 | 56% |
| www.google.co.in | 51 | 42 | 82% |
| www.google.co.uk | 43 | 40 | 93% |
| www.google.com.au | 20 | 9 | 45% |
Hi Eli… great script but I’m having a slight problem. I named one of my reports with an apostrophe ‘My Report’ and now I cannot delete the report. I assume the apostrophes are screwing up the SQL delete statement? I tried deactivating your plugin and deleting all files and reinstalling plugin, but the reports remain. Can I delete them directly from SQL using phpMyAdmin, and if so, where are these report names stored? Donation will follow should you reply … scouts honor!
Thanks for bringing this to my attention I will add a fix for the apostrophe issue in my next release. For now you can delete all your saved reports with this SQL:
DELETE FROM wp_options WHERE option_name LIKE ‘ELISQLREPORTS_reports_array’
If you are WP Serialize Savvy you hack up this option in phpMyAdmin to keep your other reports or just remove the apostrophe from the name but be sure to correct the value length markers or it won’t work at all.
Hi Eli:
I am looking for a plugin that will pull custom fields and return in a report format. Not a sql programmer so not sure this will work with your plugin. But, it seems if it is in mysql it should be able to be pulled.
Thanks
Joy
Where there’s SQL, there’s a way!
If you can give me a good idea of what you want your report to look like I can help you formulate an SQL query.