0 Day Analytics – Table Module Developer Documentation

The Table Viewer Module provides a full-featured database table browser and editor within the WordPress admin. It allows administrators to inspect, search, edit, insert, and delete rows in any database table — including WordPress core tables and custom tables created by plugins or themes.

Key Capabilities

• Browse all database tables with a searchable dropdown selector
• View row details in a modal overlay via REST API
• Add new rows with type-aware, auto-generated form fields
• Edit existing rows with pre-filled values and column-type detection
• Delete individual rows or use bulk delete
• Full-text search across all columns using SQL LIKE matching
• Sort by any column (ascending/descending)
• CSV export with progress bar and cancellation support
• Table information modal (structure, indexes, foreign keys, health)
• Table optimization (reclaim fragmented space)
• Truncate and drop non-core tables with confirmation
• WordPress core table protection (truncate/drop blocked)
• Object cache detection and warning
• Multisite-aware table operations

Technology Stack

• PHP 7.4+ (strict types)
• WordPress WP_List_Table API (via Abstract_List)
• WordPress REST API for row detail retrieval, truncate, and drop
• wp-api-fetch for client-side REST calls
• jQuery for modal, clipboard, and share interactions
• Custom CSV export with batch processing via AJAX

advanced-analytics/
├── classes/
│   └── vendor/
│       ├── lists/
│       │   ├── class-table-list.php          — WP_List_Table for table data
│       │   ├── views/
│       │   │   └── class-table-view.php      — Page rendering, forms & action handlers
│       │   └── entity/
│       │       └── class-common-table.php    — Database operations & table utilities
│       ├── controllers/
│       │   └── class-endpoints.php           — REST API route registration
│       └── settings/
│           └── settings-options/
│               └── table-list.php            — Module settings fields
└── js/
    └── admin-export-csv.js                   — CSV export with progress & cancellation

UI Components

• “Add New” button in page header (nonce-protected)
• Searchable table dropdown – filters tables in real time, core tables marked with WordPress icon
• “Info” button – opens table information modal (structure, indexes, foreign keys, health)
• “CSV Export” button – exports table data with progress bar and cancel option
• Search box – searches across all columns using LIKE %term%
• Sortable columns – all columns sortable, default sort by primary key DESC
• Row actions – View (modal) | Edit | Delete
• Bulk actions – Delete selected rows
• View modal – full row detail with copy-to-clipboard and share
• Object cache notice – displays warning when external object cache detected

┌──────────────────────────────────────────────────────────────┐
│  Table: wp_options (🔵)                       [Add New]       │
│──────────────────────────────────────────────────────────────│
│  [Table Dropdown ▼] [Info]  [CSV Export]       [🔍 Search]    │
│──────────────────────────────────────────────────────────────│
│  ☐ option_id ↕ | option_name     | option_value  | autoload  │
│     bigint(20)  | varchar(191)    | longtext      | varchar  │
│  ☐ 1           | siteurl          | https://...   | yes      │
│     View | Edit | Delete                                     │
│  ☐ 2           | home             | https://...   | yes      │
│     View | Edit | Delete                                     │
│──────────────────────────────────────────────────────────────│
│  Bulk Actions [▼] [Apply]                    ‹ 1 of 50 ›     │
└──────────────────────────────────────────────────────────────┘

Form Generation

The form is dynamically generated by iterating over Common_Table::get_columns_info(). Auto-increment columns are automatically skipped. Each column’s MySQL type is inspected via regex to render the appropriate HTML input type.

Uses the same form field generation as Add New. Pre-fills values from Common_Table::load_row_data(). Displays a serialization warning notice before the form.

Available Settings

Extends Abstract_List (which extends WP_List_Table). Handles the table data admin list rendering, column management, sorting, searching, pagination, bulk operations, CSV export, and table information modals.

Constants

<?php
public const PAGE_SLUG            = '{ADVAN_INNER_SLUG}_page_advan_table';
public const SWITCH_ACTION        = 'switch_advan_table';
public const SCREEN_OPTIONS_SLUG  = 'advanced_analytics_table_list';
public const SEARCH_INPUT         = 's';
public const TABLE_MENU_SLUG      = 'advan_table';
public const UPDATE_ACTION        = 'advan_table_update';
public const INSERT_ACTION        = 'advan_table_insert';
public const NONCE_NAME           = 'advana_table_manager';

Constructor

<?php
public function __construct( string $table_name )

Accepts a table name, initializes Common_Table with it, and calls the parent constructor with plural/singular labels set to the table name.

Key Methods

Column Rendering

• Primary key column: Shows raw value + row actions (View, Edit, Delete)
• Other columns: Values wrapped in <code> tags, truncated to 100 characters with […] indicator

Handles page rendering for all table screens (list, add, edit) and processes form submissions. All methods are static.

Public Static Methods

Modal View (Inline JavaScript)

The View action triggers a REST API call via wp.apiFetch() to retrieve full row data. The response HTML is injected into the modal overlay. The modal also supports:

• Copy to clipboard — copies raw HTML of row data via navigator.clipboard
• Share — uses the navigator.share Web Share API (falls back gracefully)

Central utility class for all database table operations. Handles table inspection, CRUD, schema analysis, health monitoring, and type-aware data normalization. All methods are static.

Constants

<?php
public const INT_TYPES = array(
    'TINYINT'   => 'TINYINT',
    'SMALLINT'  => 'SMALLINT',
    'MEDIUMINT' => 'MEDIUMINT',
    'INT'       => 'INT',
    'BIGINT'    => 'BIGINT',
    'BIT'       => 'BIT',
);

public const FLOAT_TYPES = array(
    'DECIMAL' => 'DECIMAL',
    'FLOAT'   => 'FLOAT',
    'DOUBLE'  => 'DOUBLE',
);

Properties

Initialization & Table Discovery

Column & Schema Inspection

CRUD Operations

Table Management

Table Health & Information

REST API Handlers

Utility Methods

Both the Add and Edit forms use regex-based column type detection to generate appropriate HTML input elements. The detection is performed inline in Table_View::analytics_table_page().

Type-to-Input Mapping

insert_row_record() Type Normalization

The insert_row_record() method performs comprehensive type normalization when writing data. It inspects each column’s type and converts values accordingly:

• Integer types — Cast to int, handle booleans as 0/1, use %d format
• Float types — Cast to float, use %f format
• Date/time types — Accept DateTime objects, Unix timestamps, or string dates; format to MySQL standard
• JSON — Encode arrays/objects to JSON string
• ENUM/SET — Validate against allowed values, reject invalid entries
• BINARY/BLOB — Store binary data as-is; encode complex structures to base64
• VARCHAR(n) — Enforce max length via mb_strcut() (UTF-8 safe)
• Text/default — Cast to string; arrays/objects JSON-encoded

All endpoints are registered under the 0-day/v1 namespace. Every endpoint requires manage_options capability.

View Row Data GET

Truncate Table DELETE

Drop Table DELETE

Admin Post Actions ACTION

WordPress Hooks Used ACTION

Settings are on the Tables Options tab within the main settings page.

<?php
// Check if the Table Viewer module is enabled
$enabled = Settings::get_option( 'tables_module_enabled' );

Settings Builder Usage

<?php
// How the settings are defined in table-list.php
Settings::build_option(
    array(
        'title' => esc_html__( 'Tables Options', '0-day-analytics' ),
        'id'    => 'options-settings-tab',
        'type'  => 'tab-title',
    )
);

Settings::build_option(
    array(
        'title' => esc_html__( 'Tables list options', '0-day-analytics' ),
        'id'    => 'table-settings-options',
        'type'  => 'header',
    )
);

Settings::build_option(
    array(
        'name'    => esc_html__( 'Enable tables module', '0-day-analytics' ),
        'id'      => 'tables_module_enabled',
        'type'    => 'checkbox',
        'hint'    => esc_html__( 'If you disable this, the entire plugin tables module will be disabled...', '0-day-analytics' ),
        'default' => Settings::get_option( 'tables_module_enabled' ),
    )
);

Columns

Columns are dynamically generated from the database schema of the selected table via Common_Table::get_column_names_admin(). Each column header displays the column name and its MySQL data type.

Search

The search box filters across all columns using LIKE %term% for each column (OR logic). Query parameter: s

Default Sort

By primary key column in DESC order. The primary key is auto-detected via SHOW KEYS WHERE Key_name = 'PRIMARY', falling back to any index, then the first column.

Pagination

Default items per page: 20. Configurable via Screen Options. Uses LIMIT/OFFSET SQL pagination.

Row Actions

Bulk Actions

Destructive Table Actions (Config Help Tab)

Capability Checks

• manage_options enforced on: page rendering, row edit/delete/insert, table dropdown switch, bulk operations, REST API endpoints
• Menu visibility optionally restricted by menu_admins_only setting

Nonce Verification

Input Validation

• Table names — validated with /^[A-Za-z0-9_]+$/ regex to prevent cross-database references and SQL injection via dots/backticks
• Order/orderby — allowlisted against actual column names; order restricted to ASC/DESC
• Search terms — escaped via $wpdb->esc_like() and parameterized with %s
• WHERE operators — restricted to allowlisted set: =, !=, >, <, LIKE, etc.
• Form data — all values processed through wp_unslash() and type-normalized by insert_row_record()

Core Table Protections

• WordPress core tables (via $wpdb->tables('all')) cannot be truncated or dropped
• The “Drop Table” button is hidden for core tables in the Config help tab
• REST API endpoints return WP_Error with 400 status for core table truncate/drop attempts

Example 1: Check If a Table Exists

<?php
use ADVAN\Entities_Global\Common_Table;

$table_name = 'wp_custom_logs';

if ( Common_Table::check_table_exists( $table_name ) ) {
    echo 'Table exists!';
} else {
    echo 'Table does not exist.';
}

Example 2: Get All Database Tables

<?php
use ADVAN\Entities_Global\Common_Table;

$all_tables  = Common_Table::get_tables();
$core_tables = Common_Table::get_wp_core_tables();

foreach ( $all_tables as $table ) {
    $is_core = in_array( $table, $core_tables, true ) ? '(core)' : '(custom)';
    echo $table . ' ' . $is_core . "\n";
}

Example 3: Inspect Table Column Schema

<?php
use ADVAN\Entities_Global\Common_Table;

Common_Table::init( 'wp_options' );

$columns = Common_Table::get_columns_info();

foreach ( $columns as $col ) {
    printf(
        "Column: %s | Type: %s | Null: %s | Key: %s | Default: %s | Extra: %s\n",
        $col['Field'],
        $col['Type'],
        $col['Null'],
        $col['Key'],
        $col['Default'] ?? 'NULL',
        $col['Extra']
    );
}

Example 4: Load a Single Row

<?php
use ADVAN\Entities_Global\Common_Table;

Common_Table::init( 'wp_options' );

$row = Common_Table::load_row_data( 1 );

if ( ! is_wp_error( $row ) ) {
    echo 'Option name: ' . $row['option_name'];
    echo 'Option value: ' . $row['option_value'];
}

Example 5: Insert a Row with Type Normalization

<?php
use ADVAN\Entities_Global\Common_Table;

$result = Common_Table::insert_row_record(
    'wp_options',
    array(
        'option_name'  => 'my_custom_option',
        'option_value' => 'hello world',
        'autoload'     => 'yes',
    )
);

if ( is_wp_error( $result ) ) {
    echo 'Error: ' . $result->get_error_message();
} elseif ( is_int( $result ) ) {
    echo 'Inserted row with ID: ' . $result;
}

Example 6: Update a Row

<?php
use ADVAN\Entities_Global\Common_Table;

$result = Common_Table::insert_row_record(
    'wp_options',
    array(
        'option_value' => 'updated value',
    ),
    array(
        'option_id' => 42,  // WHERE clause
    )
);

if ( true === $result ) {
    echo 'Row updated successfully.';
}

Example 7: Delete a Row

<?php
use ADVAN\Entities_Global\Common_Table;

Common_Table::init( 'wp_custom_logs' );

$deleted = Common_Table::delete_by_id( 123 );

if ( $deleted ) {
    echo 'Row deleted.';
}

Example 8: Get Table Health Information

<?php
use ADVAN\Entities_Global\Common_Table;

$info = Common_Table::get_table_info( 'wp_posts' );

if ( ! is_wp_error( $info ) ) {
    echo 'Row count: ' . $info['health']['row_count'];
    echo 'Data size: ' . size_format( $info['health']['data_size'] );
    echo 'Index size: ' . size_format( $info['health']['index_size'] );
    echo 'Needs optimization: ' . ( $info['health']['needs_optimization'] ? 'Yes' : 'No' );

    echo "\nColumns:\n";
    foreach ( $info['structure'] as $col ) {
        echo '  ' . $col['Field'] . ' — ' . $col['Type'] . "\n";
    }

    echo "\nIndexes:\n";
    foreach ( $info['indexes'] as $idx ) {
        echo '  ' . $idx['Key_name'] . ' on ' . $idx['Column_name'] . "\n";
    }
}

Example 9: Optimize a Table

<?php
use ADVAN\Entities_Global\Common_Table;

$result = Common_Table::optimize_table( 'wp_postmeta' );

if ( is_wp_error( $result ) ) {
    echo 'Optimization failed: ' . $result->get_error_message();
} else {
    echo 'Status: ' . $result['status'];
    echo 'Message: ' . $result['message'];
}

Example 10: Back Up a Table Before Modifications

<?php
use ADVAN\Entities_Global\Common_Table;

Common_Table::init( 'wp_custom_data' );

// Creates a copy named wp_custom_data{YmdHis}
Common_Table::backup_table();

// Now safe to perform destructive operations
Common_Table::truncate_table( null, 'wp_custom_data' );