內容簡介
Black-Desk 是一款全方位的 WordPress 資料庫管理外掛，讓你直接在控制台中建立與管理自訂資料表，透過直覺化介面進行資料的新增、編輯與查詢，並可利用短代碼將資料呈現於前台頁面或建立輸入表單。
【主要功能】
• 建立自訂資料表，支援多種欄位類型
• 直覺化介面管理資料的新增、編輯與刪除
• 建立並儲存自訂查詢，支援跨表 JOIN
• 軟刪除機制，可從回收桶還原資料
• 短代碼於頁面或文章中顯示資料表內容
• 短代碼產生輸入表單，直接寫入資料表
外掛標籤
開發者團隊
原文外掛簡介
Looking for the easiest way to manage your data?
We are here to help. 😉
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.
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:
Create custom tables with various column types
Manage table data with an easy-to-use interface
View and edit table data
Create and save custom queries, including joins (across multiple related tables)
Soft delete support with trash management
Shortcodes for data display
Shortcodes for input form generation
Usage
After installation, look for the ‘Tables’ menu item in your WordPress dashboard/admin panel.
Creating Tables
Go to Tables > Add Table
Enter table name and description
Add columns with their respective names, types and properties
Preview and save your table structure
Available Column Types:
Short text – varchar(255)
Number – int(11)
Big number – bigint(20)
Currency – decimal(15,2)
Date time – datetime
Yes no – bit(1)
Lookup – varchar(100)
Rich text – mediumtext
Long text – longtext
Attachment – longblob
Hyperlink – varchar(1024)
ENUM – ENUM (your list of options)
Managing Data
Navigate to Tables > All Tables
Click on a table to view/edit its data or its structure
Add, edit, or delete records (edit by clicking the field itself)
Use bulk actions for multiple records
Restore deleted records from trash
Display data in your WordPress page or post using shortcodes
Creating Queries
Go to Tables > All Queries > Select
Choose tables and fields to include
Add conditions and aliases
Preview and save your query
Display the query results in your WordPress page or post using shortcodes
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:
[review.product_id] [equal to] [FIELD] [product.id]
View Query Results
Go to Tables > All Queries
View specific query
Deleting Data
There are three options for deleting data:
Deleting rows while viewing a table, one by one or in bulk; soft delete, reversible
Truncate – delete all data in a table; irreversible
Delete the whole table; irreversible
Shortcodes
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:
Display data from your tables directly on your page or post;
Create custom data entry forms to store user input directly into your data tables.
Using shortcodes, you can easily:
Display data from your table or query result – [bdds-view-table]
Display specific field – [bdds-view-field]
Display specific field data for each row of your table or query result – [bdds-view-repeat]
Create an input form using shortcodes:
- [bdds-form-start] – to start a form
- [bdds-form-field] – to add form field
- [bdds-form-stop] – to end a form
Detailed shortcodes usage instructions are provided in dashboard > Tables > Shortcodes.
