Presents the results a database SQL query in a table. The query can be saved as a
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.
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]
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.
There are no configurable options.
Ten or more predefined views that navigate wp_posts, wp_postmeta, wp_options,
wp_users and wp_usermeta are loaded and reloaded each time the plugin is activated.
These views can be modified and deleted.
screenshot-1.png - the admin screen showing initial 'views' which can be modified or deleted. Reactivate the plugin if these aren't visible.
screenshot-2.png - the admin screen showing an arbitrary view 'signatures so far'.
screenshot-3.png - the admin screen showing one view containing links to other views.
There are no configurable options.
Ten or more predefined views that navigate wp_posts, wp_postmeta, wp_options,
wp_users and wp_usermeta are loaded and reloaded each time the plugin is activated.
These views can be modified and deleted.
A Yes. Use arg1 and arg2 to pass the arguments.
For example, to embed the results of this query:
select * from cities where country=%s and population > %d
use:
[dbview name='world cities in country' sort=city order=asc pagesize=10 arg1='United States' arg2=5000000]
By using a link
my link
An easier way is to insert a PHP snippet in a column in the first table:
return DBView::link($value, “name-of-dbview”, optional-arg1, optional-arg2);
The loaded table replaces the existing table.
By invoking some PHP using another plugin such as ‘Post Snippets’ to load dbview and pass the appropriate argument.
For example to get the current user and display a table that shows that users information.
$u=wp_get_current_user();
echo do_shortcode(“[dbview name=’show user’ arg1=$u->ID]”);
The corresponding SQL stored in ‘show user’ is:
select ID, user_login, user_email, user_registered, user_status
from wp_users where ID=%d
Assuming the image URL and the link URL are in separate columns in the table, it’s necessary to concatenate the two URLs so as to not create an extra column in the view that is not wanted.
For example this SQL concatenates two URLs:
select id, concat('https://www.google.co.uk/images/srpr/logo11w.png', ',','http://www.google.com') as link from wp_posts limit 2
And this PHP snippet extracts the two URLs from the single column ‘link’:
$a = explode(",",$value); return "<a href='".$a[1]."'><img src='".$a[0]."' /></a>";
Include the file (or the contents of) dbview.css into your theme.
At present, there is no way to hide columns.
Because the properties of each dbview are stored in the wp_options table which is cached for each session.