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

Tangible

<p><strong><a href="https://www.facebook.com/groups/loopsandlogic" rel="nofollow ugc">Facebook group</a> | <a href="https://loopsandlogic.com/" rel="nofollow ugc">homepage</a>| <a href="https://docs.loopsandlogic.com/" rel="nofollow ugc">docs</a> |<a href="https://tangibletalk.com/" rel="nofollow ugc">official support forum</a></strong></p>
<p><iframe loading="lazy" title="We reinvented HTML for WordPress: Introducing Loops & Logic" width="750" height="422" src="https://www.youtube.com/embed/-ObJkmhJ3qU?feature=oembed" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" referrerpolicy="strict-origin-when-cross-origin" allowfullscreen></iframe></p>
<p><strong>Loops & Logic</strong> is a toolset that allows you to have extensive control over the display of WordPress content & data on your site’s frontend for when your theme or builder doesn’t have the options you need. This plugin gives you the power of custom PHP theme & builder module development using a simplified HTML-like syntax that will be familiar to any frontend developer.</p>
<h3>Support</h3>
<ul>
<li>Please see the <a href="https://loopsandlogic.com/" rel="nofollow ugc">official plugin site</a> and <a href="https://docs.loopsandlogic.com/" rel="nofollow ugc">the documentation</a> for a complete description of plugin features.</li>
<li>Support & discussions can be found on <a href="https://tangibletalk.com/" rel="nofollow ugc">our forum located here</a>.</li>
</ul>
<h3>Key Features</h3>
<ul>
<li>Use HTML templates with dynamic tags like Loop, Field, and If</li>
<li>Use theme location rules to apply <strong>custom templates</strong> to post types, taxonomies & more (similar to Beaver Themer or Elementor Theme Builder)</li>
<li>Easily <strong>enqueue</strong> your CSS stylesheets and Javascript anywhere using a visual location rule builder</li>
<li>Seamlessly write your CSS directly in <strong>SASS</strong> without worrying about compilation</li>
<li>Create query <strong>loops</strong> of any content type, such as: posts, pages, custom post types, attachments, users, taxonomies and terms</li>
<li>Display built-in and custom <strong>fields</strong></li>
<li>Build <strong>logic</strong> to display things based on certain conditions, for example: creating a menu, with some links only for logged-in users, or by user role</li>
<li>Create custom shortcodes to display anything from a custom field to an entire dynamic-data driven web page</li>
</ul>
<h3>Example Usage</h3>
<p>At the core of L&L is the ability to quickly and elegantly loop through WordPress data like in this example of displaying a list of links to the three most recent posts</p>
<pre><code><ul>
  <Loop type=post count=3 orderby=date order=desc>
    <li>
      <a href="{Field url}"><Field title /></a>
    </li>
  </Loop>
</ul>
</code></pre>
<p>Accomplishing the same thing in PHP is a little more complex:</p>
<pre><code><?php
$args = array(
    'post_type' => 'post',
    'posts_per_page' => 3,
    'orderby' => 'date',
    'order' => 'DESC',
);
$query = new WP_Query( '$args' ); ?>
<?php if ( $query->have_posts() ) : ?>
  <ul>
    <?php while ( $query->have_posts() ) : $query->the_post(); ?>

      <li>
        <a href="<?php the_permalink(); ?>">
          <?php the_title(); ?>
        </a>
      </li>

    <?php endwhile; ?>
  </ul>
<?php endif; ?>
</code></pre>
<p>It can be difficult to add PHP to your site if you’re not a backend developer, but L&L is a breeze to include, even in a page builder layout.</p>
<p>Page builders like Gutenberg, Elementor, and Beaver Builder often have gaps in their capabilities that would normally require you to either develop a custom add-on or purchase a bloated add-on pack just to get the one element you need. L&L adds a template editor module directly to each builder so that you can simply describe what you want to display in L&L code and place it using the builder interface. You can even copy-paste your L&L code between page builders if you work with more than one! It’s like having your own page builder addon factory.</p>
<h3>Plugin & Theme Support</h3>
<h4>Plugin Support:</h4>
<p>Loops & Logic works with the post types and custom fields added by most plugins, but plugins with special data structures like a custom tables or fields with data formats that need parsing require us to program explicit support.</p>
<h4>Bundled integrations:</h4>
<p><strong>✅ Advanced Custom Fields (ACF)</strong></p>
<p>L&L supports Advanced Custom Fields (ACF) field types in the core, allowing you to work with most of their field types out of the box! We also plan to support other WordPress custom field plugins such as Pods & Metabox in the future.</p>
<pre><code><Loop acf_flexible=field_name>
  <If field=layout value=layout_1>

    Layout 1
    <img src="{Field acf_image=field_name field=url}" />
    <Field acf_editor=field_name />

  <Else if field=layout value=layout_2 />

    Layout 2
    <Field acf_editor=field_name />
    <img src="{Field acf_image=field_name field=url}" />

  </If>
</Loop>
</code></pre>
<p><strong>✅ Elementor</strong></p>
<p>Loops & Logic provides an Elementor widget that allows you to either write L&L code directly in the page builder widget or select from a pre-existing saved template.</p>
<p><strong>✅ Gutenberg</strong></p>
<p>Loops & Logic provides a Gutenberg block that allows you to either write L&L code directly in the block builder block or select from a pre-existing saved template.</p>
<p><strong>✅ Beaver Builder</strong></p>
<p>Loops & Logic provides a Beaver Builder module that allows you to either write L&L code directly in the page builder module or select from a pre-existing saved template.</p>
<p><strong>✅ WP Grid Builder</strong></p>
<p>Loops & Logic provides a WP Grid Builder block that allows you to select from a pre-existing saved template to load in WP Grid Builder.</p>
<p><strong>✅ WP Fusion</strong></p>
<p>The freely-included WP Fusion integration allows you to use conditional logic to protect or display different content based on a user’s tags.</p>
<pre><code><If user_field=wp_fusion_tags includes value="123">
  User has tag ID 123
<Else />
  User does not have tag.
</If>
</code></pre>
<p>We’ll be rolling out premium addons for popular plugins in the coming months, so check out our website to see what’s available!</p>
<h4>Premium addons coming soon:</h4>
<ul>
<li>WooCommerce</li>
<li>Easy Digital Downloads</li>
<li>Modern Tribe Events Calendar</li>
<li>Gravity Forms</li>
<li>LearnDash</li>
<li>LifterLMS</li>
</ul>
<h4>Theme Support:</h4>
<p>Everything will work with themes built according to WordPress standards.</p>


Loops & Logic

As a WordPresser who slings HTML + Tailwind CSS, this plugin has been an absolute godsend. I can do complex queries in the front end, and can go further than any 'Posts Module/Block/Widget' UI could ever hope for.

The fact that there’s only ~700 downloads at the time of this review is borderline criminal, but hey, I like to adopt the good stuff early :)

Dave Bloom

Just brilliant. Great support too.


Quite a nifty and powerful plugin for lowcode templating :) Saves a ton of development time.


Excellent lowcode templating


This is no exaggeration. L&L has been a lifesaver to me and saved hundreds of hours of extra work in template building. Really well done, Tangible. "This is the way!"


Lifesaver


Thanks for this plugin, it's great for its simplicity and concept, I love the ACF support.



Great documentation!


Amazing and seamless

Loops & Logic is a template system with content loops and conditions.

dbview vs Loops & Logic