john ackers

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.
<h4>Shortcode examples</h4>
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]
<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>
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 <a href="https://codex.wordpress.org/Roles_and_Capabilities" rel="nofollow ugc">must be granted that capability</a>. 
Only a view that is explicitly checked as public will be visible to non administrators and the public.

dbview

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

Bill Erickson

CultivateWP

Display Posts allows you easily list content from all across your website. Start by adding this shortcode in the content editor to display a list of your most recent posts:
<pre><code>[display-posts]
</code></pre>
Filter by Category
To only show posts within a certain category, use the category parameter:
<pre><code>[display-posts category="news"]
</code></pre>
Display as Post Grid
You can create a great looking, column-based grid of posts with a bit of styling. <a href="https://displayposts.com/2019/01/04/post-grid-styling/" rel="nofollow ugc">Here’s how!</a>
List Popular Posts 
You can highlight your popular content in multiple ways. If you want to feature the posts with the most comments, use:
<pre><code>[display-posts orderby="comment_count"]
</code></pre>
You can also list <a href="https://displayposts.com/2019/01/04/most-popular-posts-by-social-shares/" rel="nofollow ugc">most popular posts by social shares</a>.
Include thumbnails, excerpts, and more 
The <a href="https://displayposts.com/docs/parameters/#display-parameters" rel="nofollow ugc">display parameters</a> let you control what information is displayed for each post. To include an image and summary, use:
<pre><code>[display-posts include_excerpt="true" image_size="thumbnail"]
</code></pre>
You can use any image size added by WordPress (thumbnail, medium, medium_large, large) OR any custom image size added by your theme or other plugins.
Sort the list however you like 
By default the listing will list the newest content first, but you can order by title, menu order, relevance, content type, metadata, and more.
List upcoming events 
You can easily list upcoming events from any event calendar. Each plugin will require slightly different code.
Here are <a href="https://displayposts.com/tag/events/" rel="nofollow ugc">tutorials for popular event calendar plugins</a>. If your plugin is not listed here, submit a support request and I’ll add it!
Tutorials 
<a href="https://displayposts.com/tutorials/" rel="nofollow ugc">Our tutorials</a> cover common customization requests, and are updated often.
Full Documentation
<ul>
<li><a href="https://displayposts.com/docs/parameters/#query-parameters" rel="nofollow ugc">Query parameters</a> for customizing which posts are listed (filter by category, tag, date…)</li>
<li><a href="https://displayposts.com/docs/parameters/#display-parameters" rel="nofollow ugc">Display parameters</a> determine how the posts appear (title, excerpt, image…)</li>
<li><a href="https://displayposts.com/2019/01/04/use-template-parts-to-match-your-themes-styling/" rel="nofollow ugc">Template parts</a> for Display Posts to perfectly match your theme’s post listings</li>
<li><a href="https://displayposts.com/docs/the-output-filter/" rel="nofollow ugc">Output filter</a> for complete control over how the listing looks on your site</li>
<li><a href="https://displayposts.com/docs/parameters/#display-parameters" rel="nofollow ugc">Filters</a> for even more powerful customizations for developers</li>
</ul>
Extensions
<ul>
<li><a href="https://github.com/billerickson/Display-Posts-Pagination" rel="nofollow ugc">Display Posts – Pagination</a> – Allow results of Display Posts to be paginated</li>
<li><a href="https://wordpress.org/plugins/display-posts-date-view/" rel="ugc">Display Posts – Date View</a> – Lets you break your content down by month or year.</li>
<li><a href="https://github.com/billerickson/Display-Posts-Alpha-View" rel="nofollow ugc">Display Posts – Alpha View</a> – Display an alphabetical listing of your content, broken down by letter</li>
<li><a href="https://github.com/billerickson/Display-Posts-Transient-Cache" rel="nofollow ugc">Display Posts – Transient Cache</a> – Cache the output using transients</li>
<li><a href="https://github.com/billerickson/dps-coauthor-addon" rel="nofollow ugc">Co-Authors Plus Addon</a> – multiple authors on posts</li>
<li><a href="https://github.com/billerickson/dps-columns-extension" rel="nofollow ugc">Columns Extension</a> – display posts in columns</li>
<li><a href="https://github.com/billerickson/DPS-Exclude-Sticky" rel="nofollow ugc">DPS Exclude Sticky</a> – exclude sticky posts unless specifically requested</li>
<li><a href="https://github.com/shazahm1/Display-Posts-Shortcode-Pinch-Zoomer" rel="nofollow ugc">DPS Pinch Zoomer</a> – adds support pinch zooming post images on mobile devices and mouse wheel zooming on desktops</li>
<li><a href="https://github.com/shazahm1/Display-Posts-Shortcode-Remote" rel="nofollow ugc">Display Posts Shortcode Remote</a> – display posts from a remote WordPress site utilizing the WP REST API.</li>
</ul>

Display Posts – Easy lists, grids, navigation, and more

I have hardly any page that does not use this plugin to display information extracted from posts. By using its hooks, I am able to generate carousels, accordions, and lists of posts for alerts, news, faqs, fundraisers, booking calendar, events, testimonials, and so on.

Swissknife for posts


nothing shows, or incompatible with woocommerce. no idea why, but i replaced this plugin by simple php snippets. much easier.


does not work at all


Any plugin coming from Bill Erickson can be trusted as an excellent coded tool!



And this Display Posts plugin doesn't disappoint.



If you're looking for an easy way to add posts anywhere you want without hacking theme files, the Display Posts plugin is the one you want to install! Lightweight and highly customisable.



Thanks Bill!  


Excellent

Add a listing of content on your website using a simple shortcode. Filter the results by category, author, and more.

dbview vs Display Posts – Easy lists, grids, navigation, and more