Provides shortcodes to retrieve a value from any table in the WordPress database.
Author: | Paul Harvey, SEO, harvest316 (profile at wordpress.org) |
WordPress version required: | 3.0 |
WordPress version tested: | |
Plugin version: | 0.1 |
Added to WordPress repository: | 19-08-2014 |
Last updated: | 19-08-2014
Warning! This plugin has not been updated in over 2 years. It may no longer be maintained or supported and may have compatibility issues when used with more recent versions of WordPress.
|
Rating, %: | 100 |
Rated by: | 1 |
Plugin URI: | http://wordpress.org/extend/plugins/sql-table... |
Total downloads: | 1 320 |
Active installs: | 10+ |
Click to start download |
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.