WordPress.org

Presents the results a database SQL query in a table. The query can be saved as a named view which can then be embedded as a table in any post using the shortcode [dbview name=name-of-view]. Views can be created and edited in the admin pages.

Features

• Easy to deploy (assuming that you can write an SQL query!).
• The contents of each column can be manipulated using PHP snippets. This functionality allows the introduction of permalinks, images and other customisations.
• Results tables are AJAX loaded. Management interface is AJAX driven.
• Each view is stored in a single serialized object in the wp_options table.
• Tables are not styled; this is left to the theme.

Limitations

• The data in the results table cannot be edited.
• No paging/scrolling

Security

When the plugin is activated, administrators are given the capability to 'manage DB views'. Any other wp user with a different role that needs to create/edit views must be granted that capability. Only a view that is explicitly checked as public will be visible to non administrators and the public.