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

Grégory Viguier

<p>The plugin adds a new tab in your admin bar with simple but useful indications and tools.</p>
<ul>
<li>Displays the number of queries in your page and the amount of time to generate the page.</li>
<li>Displays the php memory usage and php memory limits (constants <code>WP_MEMORY_LIMIT</code> and <code>WP_MAX_MEMORY_LIMIT</code>).</li>
<li>displays the php version and WP version.</li>
<li>Displays <code>WP_DEBUG</code>, <code>SCRIPT_DEBUG</code>, <code>WP_DEBUG_LOG</code>, <code>WP_DEBUG_DISPLAY</code>, and error reporting values.</li>
</ul>
<p><strong>In your site front-end:</strong></p>
<ul>
<li>Lists the template and all template parts used in the current page (template parts added with <code>get_template_part()</code>). Compatible with WooCommerce’s templates.</li>
<li><code>$wp_query</code>: this will open a lightbox displaying the content of <code>$wp_query</code>. Click the lightbox title to reload the value, click outside the lightbox to close it.</li>
</ul>
<p><strong>In your site administration:</strong></p>
<ul>
<li>Admin hooks: lists some oftenly used hooks (like <code>admin_init</code>). The indicator to the right of the line tells you how many times the hook has been triggered by a callback. A “P” means the hook has a parameter: hover it for more details. Click a hook (on its text) to auto-select its code, for example: click <em>admin_init</em> to select <code>add_action( 'admin_init', '' );</code>.</li>
<li><code>$current_screen</code>: displays the value of 4 properties of this object: <code>id</code>, <code>base</code>, <code>parent_base</code>, <code>parent_file</code>.</li>
<li><code>$...now</code>: displays the value of the well-known variables <code>$pagenow</code>, <code>$typenow</code>, and <code>$taxnow</code>.</li>
<li>On a user profile page, <code>$userdata</code>: : this will open a lightbox displaying the user’s data.</li>
</ul>
<p>You can decide who’s gonna use this plugin (go to your profile page for all the settings). This way, the plugin’s items won’t show up to other users (your client for example).<br />
Also, a new menu item <code>Code Tester</code> will appear. There you are able to do some tests with your code.</p>


Admin Bar Tools

I'm using this wonderfull tool in all my project and ask my studients to use it when they dev for WordPress.

Make a great job

In all my dev sites

This is one of those plugins I use on every WordPress project. The UI/UX is excellent, it's always there in the admin bar, you don't need to load anything. 

It's just a pity it's not updated to the latest WordPress versions. I sure hope this is not abandoned.

Thanks for sharing your work, @greglone.

So useful. Too bad it's not updated

Adds some small development tools to the admin bar.

dbview vs Admin Bar Tools