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

WPExperts.io

ExpressTech Systems

Sayan Datta

<p>A WordPress Plugin that adds a custom tag to your recent post like Must Read, Featured, Hot, Top News, Popular etc. It helps you to attract the visitors to your Recent post in the best way possible.</p>
<span class="embed-youtube" style="text-align:center; display: block;"><iframe loading="lazy" class="youtube-player" width="750" height="422" src="https://www.youtube.com/embed/6C5RQ3rF_OI?version=3&rel=1&showsearch=0&showinfo=1&iv_load_policy=1&fs=1&hl=en-US&autohide=2&wmode=transparent" allowfullscreen="true" style="border:0;" sandbox="allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox"></iframe></span>
<h3>Other Blocks From Gutena</h3>
<p>If you like this plugin, consider exploring our other block plugins:</p>
<p><a href="https://wordpress.org/plugins/gutena-tabs/" rel="ugc">Gutena Tabs</a> – A simple and easy-to-use WordPress plugin which allows you to create beautiful tabs in your posts and pages.</p>
<p><a href="https://wordpress.org/plugins/newsletter-block-by-gutena/" rel="ugc">Gutena Newsletter</a> – Easily and instantly add Newsletter Block to your Gutenberg Editor.</p>
<p><a href="https://wordpress.org/plugins/gutena-forms/" rel="ugc">Gutena Forms</a> – Easily and instantly add Forms Block to your Gutenberg Editor. Gutena Forms is a native form block for Gutenberg. Built for Look, Speed and Functionality.</p>
<p><a href="https://wordpress.org/plugins/gutena-accordion/" rel="ugc">Gutena Accordion</a> – Easily and instantly add Accordion Block to your Gutenberg Editor.</p>
<p><a href="https://wordpress.org/plugins/gutena-lightbox/" rel="ugc">Gutena Video Lightbox</a> – Easily and instantly add Lightbox Video Popup Block to your Gutenberg Editor.</p>
<p><a href="https://wordpress.org/plugins/photofeed-block-by-gutena/" rel="ugc">Gutena PhotoFeed</a> – Display Instagram Photos from your Instagram accounts, either in the same single feed or in multiple different ones.</p>
<h3>Our Products</h3>
<p>If you like this plugin, consider exploring our other themes and plugins:</p>
<p><a href="https://wordpress.org/themes/gutena/" rel="ugc">Gutena</a> – A full site editing (block) theme for WordPress with ready made full page templates. Elegant and functional – follows all the best practices by WP, and yeah, no jQuery!</p>
<p><a href="https://wordpress.org/plugins/quiz-master-next/" rel="ugc">Quiz and Survey Master</a> – Best WordPress Quiz Plugin to create engaging quizzes, surveys, & exams using WordPress and convert your website into a lead generation machine.</p>
<p><a href="https://wordpress.org/plugins/responsive-menu/" rel="ugc">Responsive Menu</a> – Best WordPress Menu Builder Plugin to create awesome and interactive mobile & desktop menus for WordPress websites.</p>
<p><a href="https://wordpress.org/plugins/projectopia-core/" rel="ugc">Projectopia</a> – Project Management & Invoicing plugin for WordPress. Generate invoices, send quotes, generate leads, manage clients, provide support – all inside your WordPress website.</p>
<p><a href="https://wordpress.org/plugins/booking-ultra-pro/" rel="ugc">Booking Ultra</a> – Appointment Booking plugin for WordPress – Show a quick form to accept bookings for your services with pre-set booking slots. Ideal for salons, medical professionals, lawyers, consultants, etc.</p>
<p><a href="https://instawp.com/" rel="nofollow ugc">InstaWP</a> – Launch a quick WordPress site with this sandbox service. Create New WordPress instance within a second.</p>


Gutena Recent Post Custom Tag

A WordPress Plugin that adds a custom tag to your recent post like Must Read, Featured, Hot, Top News, Popular etc. It helps you to attract the visito …

dbview vs Gutena Recent Post Custom Tag