This plugin hasn’t been tested with the latest 3 major releases of WordPress. It may no longer be maintained or supported and may have compatibility issues when used with more recent versions of WordPress.

SQL Table Lookup

Description

You can use these SQL lookup shortcodes to extract data from any table in your WordPress database:

</p>

<p>[sql]SELECT a FROM b WHERE c='d';

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.

Reviews

There are no reviews for this plugin.

Contributors & Developers

“SQL Table Lookup” adalah perisian sumber terbuka. Orang-orang berikut telah menyumbang kepada pemalam ini.

Penyumbang