Presents the results a database SQL query in a table.
将结果呈现在表中的数据库SQL查询中。
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].
[dbview名称=视图名称]。
Views can be created and edited in the dashboard.
可以在仪表板中创建和编辑视图。 p>
Shortcode examples
简码示例 h4>
Show the ‘world cities’ view with a page size of 50 rows.
以50行的页面大小显示“世界城市”视图。
[dbview name=’world cities’ pagesize=50]
[dbview name =“世界城市”的页面大小= 50] p>
Show the ‘world cities’ view initially sorted by column ‘city’ in ascending order.
显示最初按“城市”列升序排列的“世界城市”视图。
[dbview name=’world cities’ sort=city order=asc]
[dbview name =“世界城市” sort = city order = asc] p>
Show the ‘world cities’ view initially sorted by column ‘population’ in descending order.
显示“世界城市”视图,该视图最初按“人口”列降序排列。
[dbview name=’world cities’ sort=population order=desc]
[dbview名称=“世界城市”的sort =填充顺序= desc] p>
Show the ‘world cities’ view without any pagination.
无需分页即可显示“世界城市”视图。
[dbview name=’world cities’]
[dbview name =“世界城市”] p>
Show the ‘world cities’ in the US with a population of greater than 5 million.
显示人口超过500万的美国“世界城市”。
See FAQ on passing arguments.
请参阅有关传递参数的常见问题解答。
[dbview name=’world cities in country’ sort=city order=asc pagesize=10
[dbview名称=“国家/地区中的世界城市” sort = city order = asc pagesize = 10
arg1=’United States’ arg2=5000000]
arg1 =“美国” arg2 = 5000000] p>
End User Features
最终用户功能 h4>
ul>
Management Features
管理功能 h4>
ul>
Limitations
限制 h4>
ul>
Security
安全性 h4>
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.
必须授予具有其他角色的其他wp用户(需要创建/编辑视图) 。
/>
/>
Only a view that is explicitly checked as public will be visible to non administrators and the public.
非管理员和公众只能看到显式检查为公共的视图。 p>