Dbview Wordpress Plugin is used by 10 websites. Among 10, 0 site is within top 10,000 and 0 site is within top 100,000 websites.

Wordpress Plugin Information of

Plugin Meta Name Plugin Meta Information
Plugin Name
Plugin Description 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
Detail Plugin Description

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 dashboard.

Shortcode examples

Show the 'world cities' view with a page size of 50 rows.

[dbview name='world cities' pagesize=50]

Show the 'world cities' view initially sorted by column 'city' in ascending order.

[dbview name='world cities' sort=city order=asc]

Show the 'world cities' view initially sorted by column 'population' in descending order.

[dbview name='world cities' sort=population order=desc]

Show the 'world cities' view without any pagination.

[dbview name='world cities']

Show the 'world cities' in the US with a population of greater than 5 million. See FAQ on passing arguments.

[dbview name='world cities in country' sort=city order=asc pagesize=10 
 arg1='United States' arg2=5000000]

End User Features

  • Column sorting on table header. Columns are enabled on each column.
  • Page navigation is on the table footer (from 0.5.3).
  • Tables are loaded using AJAX.

Management Features

  • Each view can be created/edited/deleted and tested under dbview/Settings in the dashboard.
  • Easy view consists of one SQL statement plus an optional PHP snippet associated wthe each column.
  • Sorting on each column can be enabled and disabled.
  • Each column can be manipulated using a PHP snippet. This functionality allows the introduction of permalinks, images and other customisations.
  • Each view is stored in a single serialized object in the wp_options table.

Limitations

  • Tables are not styled; this is left to the theme.
  • 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.

More Information Wordpress Official Plugin Repository
Google

Top 10 Websites built with Wordpress plugin

Xplore Sydney - Xplore Sydney
30,000,000 favicon of DOBRANUTA.NET DOBRANUTA.NET
Grota solna | solno jodowa grota inhalacyjna, fryzjer, solarium, stylizacja paznokci
30,000,000 favicon of GARCINIAEXTRA.COM GARCINIAEXTRA.COM
Garcinia Cambogia Extra Weight Loss
Hike Norfolk Ramblers
30,000,000 favicon of CAPSIPLEX.COM CAPSIPLEX.COM
Home - Capsiplex
30,000,000 favicon of AUSRELIEF.ORG AUSRELIEF.ORG
AusRelief
Zzp, freelance of interim? Doe mee aan de FOTY Awards!
30,000,000 favicon of HKD50.COM HKD50.COM
50蚊工作室 - 香港創意服務交易平台
30,000,000 favicon of JOBSOURD.FR JOBSOURD.FR
Information - Jobsourd
30,000,000 favicon of AUTOBAY.LK AUTOBAY.LK
Buy, Sell, Vehicles, Cars, Vans, Motorbikes, Autos, Sri Lanka, Autobay.lk