jelenacvijic

Looking for the easiest way to manage your data? 
We are here to help. 😉 
And our AI Assistant!
Black-Desk is a comprehensive WordPress plugin that helps you create and manage custom database tables and data directly from your WordPress dashboard.
The plugin provides an intuitive interface that lets you create, update, and query your data in the simplest way possible, without requiring deep technical knowledge.
* Creating tables just became even more simple with the help of our AI Assistant!
Save queries and reuse them quickly.
Black-Desk plugin shortcodes let you display selected data on your WordPress pages or posts, as well as easily create input forms directly connected to your tables.
Key Features:
<ul>
<li>Create custom tables with various column types</li>
<li>Create tables using natural language with the help of the AI Assistant</li>
<li>Manage table data with an easy-to-use interface</li>
<li>View and edit table data</li>
<li>Create and save custom queries, including joins (across multiple related tables)</li>
<li>Soft delete support with trash management</li>
<li>Shortcodes for data display</li>
<li>Shortcodes for input form generation</li>
</ul>
<h3>Usage</h3>
After installation, look for the ‘Tables’ menu item in your WordPress dashboard/admin panel.
<h4>Creating Tables</h4>
Using our AI Assistant: 
0. Set up AI in Black-Desk “Settings” 
1. Select “AI Assistant” 
2. Choose “Create table assistant” 
3. Enter table name and description in natural language 
4. You can add another column manually or just 
5. Preview and save your table structure
Or manually: 
1. Go to Tables > Add Table 
2. Enter table name and description 
3. Add columns with their respective names, types and properties 
4. Preview and save your table structure
Available Column Types:
<ul>
<li>Short text – varchar(255)</li>
<li>Number – int(11)</li>
<li>Big number – bigint(20)</li>
<li>Currency – decimal(15,2)</li>
<li>Date time – datetime</li>
<li>Yes no – bit(1)</li>
<li>Lookup – varchar(100)</li>
<li>Rich text – mediumtext</li>
<li>Long text – longtext</li>
<li>Attachment – longblob</li>
<li>Hyperlink – varchar(1024)</li>
<li>ENUM – ENUM (your list of options)</li>
</ul>
<h4>Managing Data</h4>
<ol>
<li>Navigate to Tables > All Tables</li>
<li>Click on a table to view/edit its data or its structure</li>
<li>Add, edit, or delete records (edit by clicking the field itself)</li>
<li>Use bulk actions for multiple records</li>
<li>Restore deleted records from trash</li>
<li>Display data in your WordPress page or post using shortcodes</li>
</ol>
<h4>Creating Queries</h4>
<ol>
<li>Go to Tables > All Queries > Select</li>
<li>Choose tables and fields to include</li>
<li>Add conditions and aliases</li>
<li>Preview and save your query</li>
<li>Display the query results in your WordPress page or post using shortcodes</li>
</ol>
If you want to view data from related, joined tables you can create and save a query by setting one of its conditions so that the value from the first table column is equal to the second table column/field (effectively indicating a foreign key column and pointing it to another table’s primary key).
Example of such query condition: 
[<code>review.product_id</code>] [equal to] [FIELD] [<code>product.id</code>]
<h4>View Query Results</h4>
<ol>
<li>Go to Tables > All Queries</li>
<li>View specific query</li>
</ol>
<h4>Deleting Data</h4>
There are three options for deleting data:
<ol>
<li>Deleting rows while viewing a table, one by one or in bulk; soft delete, reversible</li>
<li>Truncate – delete all data in a table; irreversible</li>
<li>Delete the whole table; irreversible</li>
</ol>
<h4>Shortcodes</h4>
Shortcodes are a powerful feature of Black-Desk that let you seamlessly connect your data tables to any of your WordPress pages or posts, in one of the two directions:
<ul>
<li>Display data from your tables directly on your page or post;</li>
<li>Create custom data entry forms to store user input directly into your data tables.</li>
</ul>
Using shortcodes, you can easily:
<ul>
<li>Display data from your table or query result – <code>[bdds-view-table]</code></li>
<li>Display specific field – <code>[bdds-view-field]</code></li>
<li>Display specific field data for each row of your table or query result – <code>[bdds-view-repeat]</code></li>
<li>Create an input form using shortcodes: 
- <code>[bdds-form-start]</code> – to start a form 
- <code>[bdds-form-field]</code> – to add form field 
- <code>[bdds-form-stop]</code> – to end a form</li>
</ul>
Detailed shortcodes usage instructions are provided in dashboard > Tables > Shortcodes.
<h4>AI Assistant</h4>
To enable the use of AI Assistant features, you need to first set up your preferred AI Service Provider and securely store your corresponding API key* in Black-Desk “Settings”.
* Your API key will be stored on your own server. While we take reasonable precautions to store it securely, we have no control over your hosting environment and cannot be held liable for any loss, exposure, or misuse resulting from a server breach or other unforeseen event.

Black-Desk

WordPress plugin for easier data management.

primisdigital

The “Table Manager” plugin for WordPress allows users to create, manage and display tables easily using a shortcode. It enables creating tables, adding and updating columns, and managing data (insert, update, delete). Each table generates a unique shortcode for displaying content on posts or pages. The plugin also provides secure form handling, an easy-to-use admin interface, and custom CSS/JS for table display on the front end.
<h3>Features</h3>
Create and manage custom tables from the WordPress admin panel. 
Add, delete, and update table columns dynamically. 
Insert and update table data through an easy-to-use interface. 
The Display tables using a simple shortcode. 
The Secure and optimized queries using WordPress best practices.
<h3>Admin Installer via search:</h3>
Visit the Add New plugin screen and search for “Table Manager”. 
Click the “Install Now” button. 
Activate the plugin.
<h3>Admin Installer via zip:</h3>
Download the Plugin. 
Extract the ZIP file and upload. 
Activate the plugin through the “Plugins” menu in WordPress.
<h3>Usage</h3>
<ol>
<li>Creating a New Table</li>
</ol>
Navigate to Table Manager in the WordPress admin panel. 
Click on “Create Table” and enter the table name. 
Add columns as needed and save the table.
<ol>
<li>Managing Table Data</li>
</ol>
Select a table from the dropdown menu. 
Insert new records using the input form. 
Delete or update records directly from the interface.
<ol>
<li>Displaying Tables on the Frontend</li>
</ol>
Use the following shortcode in posts or pages to display a table: 
[display_table name=”your_table_name”]
<h3>Security Best Practices</h3>
Admin Capability Check: Access is restricted to administrators using manage_options capability. 
SQL Injection Prevention: Queries are secured with WordPress $wpdb->prepare() where applicable. 
Input Sanitization: All user inputs are sanitized before being inserted into the database.
<h3>Code Example</h3>
Registering Admin Menu:
function form_datamenu() { 
 add_menu_page( 
 ‘Table Manager’, ‘Table Manager’, ‘manage_options’, 
 ‘form_datamenu’, ‘form_data_adminpage’, 
 ‘dashicons-database’, 20 
 ); 
} 
add_action(‘admin_menu’, ‘form_datamenu’);

Table Manager

Table Manager plugin helps to create table from wordpress posts, page.

Black-Desk vs Table Manager