Alberto Cocchiara

<h3>DB Tables Import/Export</h3>
<p>If you are looking for a plugin to import and export data from or into your database, DB Tables Import/Export is for you.</p>
<p>Once installed and activated the plugin, two new menus will appear in the “Tools” with the pages for the import and export of tables in your database, without entering data connection or special settings.</p>
<p>The export can be done in CSV format file to JSON, while the import can be done via CSV file.</p>
<h4>This is stable version 1.0.1 and is compatible up to 4.3.1</h4>
<h3>Updates</h3>
<p>The basic structure of this plugin was cloned from the <a href="https://github.com/tommcfarlin/WordPress-Plugin-Boilerplate" rel="nofollow ugc">WordPress-Plugin-Boilerplate</a> project.</p>


DB Tables Import/Export

Best tables import export plugin

DB Tables Import/Export by AlterTech allow to import/export tables data from your database.

primisdigital

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


Table Manager

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

DB Tables Import/Export vs Table Manager