WordPress.org

Ready to get started?Download WordPress

Plugin Directory

dbview

Presents the results of a database query in a table. The query can be saved as a view which can then be embedded in any post using a shortcode. Views

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.
  • Column sorting. Table navigation/paging supported e.g. [dbview name=addressBook pagesize=20].
  • 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(s) cannot be edited.

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.

Requires: 3.0.1 or higher
Compatible up to: 3.3.2
Last Updated: 2012-6-26
Downloads: 2,649

Ratings

2 stars
2.5 out of 5 stars

Support

0 of 1 support threads in the last two months have been resolved.

Got something to say? Need help?

Compatibility

+
=
Not enough data

0 people say it works.
0 people say it's broken.

100,1,1 50,2,1 100,1,1