john ackers

<p>Presents the results a database SQL query in a table. The query can be saved as a<br />
named view which can then be embedded as a table in any post using the shortcode<br />
[dbview name=name-of-view]. Views can be created and edited in the dashboard.</p>
<h4>Shortcode examples</h4>
<p>Show the ‘world cities’ view with a page size of 50 rows.<br />
    [dbview name=’world cities’ pagesize=50]</p>
<p>Show the ‘world cities’ view initially sorted by column ‘city’ in ascending order.<br />
    [dbview name=’world cities’ sort=city order=asc]</p>
<p>Show the ‘world cities’ view initially sorted by column ‘population’ in descending order.<br />
    [dbview name=’world cities’ sort=population order=desc]</p>
<p>Show the ‘world cities’ view without any pagination.<br />
    [dbview name=’world cities’]</p>
<p>Show the ‘world cities’ in the US with a population of greater than 5 million. See FAQ on passing arguments.<br />
    [dbview name=’world cities in country’ sort=city order=asc pagesize=10<br />
     arg1=’United States’ arg2=5000000]</p>
<h4>End User Features</h4>
<ul>
<li>Column sorting on table header. Columns are enabled on each column.</li>
<li>Page navigation is on the table footer (from 0.5.3).  </li>
<li>Tables are loaded using AJAX.</li>
</ul>
<h4>Management Features</h4>
<ul>
<li>Each view can be created/edited/deleted and tested under dbview/Settings in the dashboard.</li>
<li>Easy view consists of one SQL statement plus an optional PHP snippet associated wthe each column.</li>
<li>Sorting on each column can be enabled and disabled.</li>
<li>Each column can be manipulated using a PHP snippet. This functionality allows the introduction of permalinks, images and other customisations. </li>
<li>Each view is stored in a single serialized object in the wp_options table.</li>
</ul>
<h4>Limitations</h4>
<ul>
<li>Tables are not styled; this is left to the theme. </li>
<li>The data in the results table(s) cannot be edited.</li>
</ul>
<h4>Security</h4>
<p>When the plugin is activated, administrators are given the capability to ‘manage DB views’.<br />
Any other wp user with a different role that needs to create/edit views <a href="https://codex.wordpress.org/Roles_and_Capabilities" rel="nofollow ugc">must be granted that capability</a>.<br />
Only a view that is explicitly checked as public will be visible to non administrators and the public.</p>


dbview

Presents the results a database SQL query in a table. The query can be saved as a

webvitaly

<ul>
<li><strong><a href="http://web-profile.net/wordpress/plugins/" title="WordPress Pro plugins" rel="nofollow ugc">WordPress Pro plugins</a></strong></li>
<li><strong><a href="http://web-profile.net/wordpress/plugins/info/" title="Info plugin page" rel="nofollow ugc">Info plugin</a></strong></li>
<li><strong><a href="http://web-profile.net/donate/" title="Support the development" rel="nofollow ugc">Donate</a></strong></li>
<li><strong><a href="https://github.com/webvitalii/info" title="Fork" rel="nofollow ugc">GitHub</a></strong></li>
</ul>
<p>Plugin shows in the admin bar:<br />
* the number of SQL queries during the WordPress execution<br />
* the amount of time in seconds to generate the page<br />
* memory load</p>
<p>Admin bar can be enabled in your profile: <code>"Users => Your Profile => Show Admin Bar"</code>.<br />
This information also added to the bottom of the source code as HTML comment.</p>
<h4>Useful:</h4>
<ul>
<li><a href="https://wordpress.org/plugins/page-list/" title="list of pages with shortcodes" rel="ugc">“Page-list” – show list of pages with shortcodes</a></li>
<li><a href="https://wordpress.org/plugins/iframe/" title="embed content" rel="ugc">“Iframe” – embed content</a></li>
<li><a href="http://web-profile.net/wordpress/plugins/" title="WordPress Pro plugins" rel="nofollow ugc">WordPress Pro plugins</a></li>
</ul>


info

Plugin shows in the admin bar the number of SQL queries, the amount of time in seconds and memory load.

dbview vs info