SQL Table Lookup wordpress plugin resources analysis
| Download This Plugin | |
| Download Elegant Themes | |
| Name | SQL Table Lookup |
| Version | 0.1 |
| Author | Paul Harvey, SEO, harvest316 |
| Rating | 100 |
| Last updated | 2014-08-19 04:13:00 |
| Downloads |
158
|
| Download Plugins Speed Test plugin for Wordpress | |
Home page
Delta: 0%
Post page
Delta: 0%
Home page PageSpeed score has been degraded by 0%, while Post page PageSpeed score has been degraded by 0%
SQL Table Lookup plugin added 6 bytes of resources to the Home page and 8 bytes of resources to the sample Post page.
SQL Table Lookup plugin added 0 new host(s) to the Home page and 0 new host(s) to the sample Post page.
Great! SQL Table Lookup plugin ads no tables to your Wordpress blog database.You can use these SQL lookup shortcodes to extract data from any table in your WordPress database:
[sql query="SELECT a FROM b WHERE c='d';"]
[sql]SELECT a FROM b WHERE c='d';[/sql]
[sql table="b" unique_lookup_field="c" lookup_value="d" return_field="a"]
If a table or column name has a space or other unusual character in it, wrap it in `backticks`. If a value contains a space or other unusual characters, wrap it in 'single quotes'.
While I've taken considerable effort to prevent SQL injection attacks by escaping all other dangerous characters with esc_sql (which uses mysql_real_escape_string/mysqli_real_escape_string and addslashes), I would advise against using this plugin on a site that accepts any kind of posts or comments from untrusted sources.
