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.

Olar Marius

Justin Watt

Instead of needing a tool like <a href="http://www.phpmyadmin.net/home_page/index.php" rel="nofollow ugc">phpMyAdmin</a> 
or the mysql command line client to view and modify your WordPress database, 
the SQL Executioner allows you to run arbitrary SQL queries against your 
WordPress database from within the Admin. In many cases this allows you to bypass 
the inherent limitations of the WordPress Admin interface, and use the full expressive 
power of SQL to analyze and update your blog’s database.
To use simply install and visit the Tools > SQL Executioner page.
If you’re interested in contributing to the code behind this plugin, it’s also hosted on GitHub: 
https://github.com/justincwatt/wp-sql-executioner

SQL Executioner

This plugin seems to me simple but very useful.

Simple and efficient

I use this plugin on a daily basis to run quick queries in the database while developing. Very very helpful!!!

Amazing Tool

Execute arbitrary SQL queries against your WordPress database from the Admin.

Display Posts – Easy lists, grids, navigation, and more vs SQL Executioner