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

Bill Erickson

<p>This plugin extends <a href="https://wordpress.org/plugins/display-posts-shortcode" rel="ugc">Display Posts</a> by letting you break your content down by month or year. You can use all of the <a href="https://displayposts.com/docs/parameters/" rel="nofollow ugc">Display Posts parameters</a> to customize the query.</p>
<p><strong>Month Listing</strong></p>
<pre><code>[display-posts display_by_month="true" posts_per_page="999" title="Posts by Month"]
</code></pre>
<p>Use the <code>display_by_month</code> parameter to break it down by month. To list all your content, use a high <code>posts_per_page</code>, like 999. You can also add an optional <code>title</code> to appear above the listing.</p>
<p><strong>Year Listing</strong></p>
<pre><code>[display-posts display_by_year="true" posts_per_page="999" title"Posts by Year"]
</code></pre>
<p>Use the <code>display_by_month</code> parameter to break it down by year. To list all your content, use a high <code>posts_per_page</code>, like 999. You can also add an optional <code>title</code> to appear above the listing.</p>
<p><strong>Filters</strong></p>
<p>If you’re a developer, you can use the following filters to customize the markup:</p>
<ul>
<li><code>display_posts_date_view_heading_tag</code> – The heading tag used for date headings. Default is h4.</li>
<li><code>display_posts_date_view_heading_class</code> – The class added to the heading tag. Default is .display-posts-date.</li>
<li><code>display_posts_date_view_month_format</code> – The date format used for month headings. Default is ‘F Y’.</li>
<li><code>display_posts_date_view_year_format</code> – The date format used for year headings. Default is ‘Y’.</li>
</ul>


Display Posts – Date View

List your content broken down by month or year. This is an extension of the Display Posts plugin.

dbview vs Display Posts – Date View