Plugin Name

This plugin allows you to embed SQL shortcodes on your WordPress posts and pages. This plugin allows you to embed SQL shortcodes on your WordPress pages. Put your SQL query inside shortcode [sql]...[sql] to print result as an HTML table. Put your SQL query inside shortcode [sqlvar]...[/sqlvar] to print result as a single value (e.g. total number of users). STYLING THE OUTPUT Style the output by adding any of the following shortcode attributes: cellpadding, cellspacing, border, style, tr_style, th_style, td_style. CONNECTING TO A NON-WORDPRESS DATABASE By default the query will be run again the WordPress database. If you need to connect to another database, add all of the following shortcode attributes: user, pass, host, db. If any of those attributes are not provided, the plugin will use the WordPress database. ADVANCE OUTPUT TRANSFORMATION (XSL) The [sql]...[sql] shortcode can have an optional nested shortcode [xsl]...[xsl]. Use the nested shortcode only if you wish to apply an additional XSL transformation to the TABLE output, e.g. if you need to introduce additional formatting not supported by the [sql] shortcode attributes, e.g. convert URLs into hyperlinks, etc.

Use the standard installation and activation procedure.

1. Unzip the plugin to the /wp-content/plugins/ directory
2. Activate the plugin through the 'Plugins' menu in WordPress
3. Go to "Settings" and then to "Customize Admin Interface" to set up the plugin.

1.0

• First stable version of the plugin.