Table Manager

Description

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.

Features

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.

Admin Installer via search:

Visit the Add New plugin screen and search for “Table Manager”.
Click the “Install Now” button.
Activate the plugin.

Admin Installer via zip:

Download the Plugin.
Extract the ZIP file and upload.
Activate the plugin through the “Plugins” menu in WordPress.

Usage

1. Creating a New Table

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.

1. Managing Table Data

Select a table from the dropdown menu.
Insert new records using the input form.
Delete or update records directly from the interface.

1. Displaying Tables on the Frontend

Use the following shortcode in posts or pages to display a table:
[display_table name=”your_table_name”]

Security Best Practices

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.

Code Example

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’);