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

Tubal

<p>A really simple and lightweight plugin (73 lines of code – comments included) to sort posts on-the-fly without making a new query to the database (improves performance).</p>
<h4>Features:</h4>
<ul>
<li>Supports <strong>all <code>order_by</code> and <code>order</code> values of the <a href="https://codex.wordpress.org/Function_Reference/query_posts#Orderby_Parameters" rel="nofollow ugc">query_posts function</a></strong> except <code>meta_value</code> and <code>meta_value_num</code> (which require a database query).</li>
<li>Supports <strong>changing the order of all types of posts</strong>, including custom post type posts and custom post type “archive” posts.</li>
</ul>
<h4>Documentation</h4>
<p>This plugin adds the function <code>sort_query_posts_by(string $order_by [, string $order])</code> to the global context.<br />
The second <code>$order</code> parameter is optional. Its default value is <code>asc</code> (ascending order).</p>
<p><strong>Call this function before <a href="https://codex.wordpress.org/The_Loop" rel="nofollow ugc">the loop</a> to change how posts are ordered.</strong><br />
After calling this function you can show the posts as you normally would.</p>
<p>You can sort posts by:</p>
<ul>
<li>author</li>
<li>comment_count</li>
<li>date</li>
<li>id</li>
<li>menu_order</li>
<li>modified</li>
<li>parent</li>
<li>title</li>
</ul>
<p>This is specially useful in two cases:</p>
<ul>
<li>When you need to reorder the posts returned by the query that WordPress creates from your given URL. Custom post type “archive” posts are a great example of this case.</li>
<li>When you need the posts returned by your customized query (e.g. <code>query_posts()</code>) to be shown more than once on the same page and ordered differently.</li>
</ul>
<p><strong>Examples:</strong></p>
<pre><code><?php sort_query_posts_by('title', 'desc'); ?>
</code></pre>
<p>The example above will sort posts by their title in descending order without making a new query to the database.<br />
This way sorting is performance friendly.</p>
<pre><code><?php sort_query_posts_by('ID'); ?>
</code></pre>
<p>The example above will sort posts by their ID in ascending order.</p>
<pre><code><?php sort_query_posts_by('rand'); ?>
</code></pre>
<p>The example above will sort posts randomly. When sorting randomly <code>$order</code> is ignored.</p>
<p>Plugin developed by Túbal Martín at <a href="http://www.margenn.com" rel="nofollow ugc">www.margenn.com</a>.</p>


Sort Query Posts

Sort posts on-the-fly without making a new SQL query

dbview vs Sort Query Posts