leetsombrero

<p>Jot allows non-technical WordPress administrators to modify MySQL<br />
tables with a lightweight, user-friendly interface.  This plugin currently supports MySQL only.</p>
<h3>Features</h3>
<ul>
<li>Create menus directly in the WordPress administration page to view and interact with tables</li>
<li>Quickly add and edit single entries to the data table</li>
<li>Associate table entries with images, which are uploaded and managed using the Jot interface</li>
<li>Rearrange table entries or split entries into multiple tables</li>
</ul>
<h3>Usage</h3>
<h4>Creating a menu</h4>
<ul>
<li>To create a menu, navigate to the “Settings”>”Jot Settings”</li>
<li>Ensure “Create New” is selected under “Menu Selection”</li>
<li>Fill in your database information and click Update</li>
<li>Choose the table that you want to create a menu for</li>
<li>Fill in the remaining form and click “Add New”</li>
</ul>
<h4>Modifying a menu</h4>
<ul>
<li>To edit a menu, navigate to the “Settings”>”Jot Settings”</li>
<li>Choose a menu to edit under “Menu Selection”</li>
<li>Modify the settings to your liking and click “Save Changes” at the bottom of the page</li>
</ul>
<h4>Deleting a menu</h4>
<ul>
<li>To delete a menu, navigate to the “Settings”>”Jot Settings”</li>
<li>Choose a menu to edit under “Menu Selection”</li>
<li>Click “Delete Menu” at the bottom of the page</li>
</ul>
<h4>Regarding image association</h4>
<ul>
<li>Tables you wish to associate with images must have a dedicated image source column (ex. <code>imgsrc</code>)
<ul>
<li>The image source column will contain the image FILENAME</li>
<li>The image directory will be defined during setup</li>
</ul>
</li>
<li>To use your own default image (used when no association is made),<br />
   simply add a “blank-profile-picture.jpg” to your image directory</li>
</ul>


Jot Data Manager

Jot allows non-technical WordPress administrators to modify MySQL

hypertextranch

<p>Depending on the MySQL server setup the SSL certs used may not be in the trusted store, if that’s the case <code>mysqli_ssl_set()</code> needs to be called to set custom keys and certs before connect. This Plugin adds a custom DB class that allows these settings to be configured via custom constants.</p>
<p>This plugin will also add a custom item on the “At a Glance” section of the Dashboard to show if the <code>$wpdb</code> connection is secure or not.</p>
<p>Also find me on <a href="https://github.com/xyu/secure-db-connection" rel="nofollow ugc">GitHub</a>.</p>


Secure DB Connection


The plugin has not been updated for a long time, but it still works!


Still working in 2023

Sets SSL keys and certs for encrypted MySQL database connections.

Jot Data Manager vs Secure DB Connection