phpMyAdmin Bulk Table Row Deleter

WHAT IT DOES

phpMyAdmin Bulk Table Row Deleter lets you delete multiple database rows in a single operation. Instead of clicking each row's delete button individually and confirming each deletion — repeating this for every single row — this tool provides a unified checklist of all rows on the current table browse page. You can filter rows by content to quickly find the ones you want to remove. Select any number of rows using checkboxes and click the delete button. The tool then automatically processes each selected row — triggering phpMyAdmin's delete action and handling the confirmation dialog. This turns what could be dozens of manual operations into a single batch action, making database cleanup significantly faster. The tool includes a double-confirmation safety mechanism to prevent accidental data loss.

WHERE IT RUNS

This script runs exclusively on the phpMyAdmin web application in your browser. It activates on the table browse page (the standard view for viewing and editing table data). It requires the BotGentz extension to inject and execute the script. The tool does not work on other database management interfaces or phpMyAdmin's query execution pages — only the table browse interface. It specifically targets pages under any domain path containing /phpmyadmin/ with the sql.php or tbl_browse parameters.

HOW TO USE

After installing the script via BotGentz, navigate to any table browse page in phpMyAdmin (clicking "Browse" on a table). The tool automatically detects the table data and displays a floating panel on the right side. The panel shows all rows on the current page, with checkboxes next to each row entry. Each row displays a preview of its cell data and the primary key value if available. Use the search box to filter by content to narrow down your selection. Check the boxes for every row you want to delete. Click the red "Delete Selected" button. The tool will first ask for confirmation, then ask a second time for safety, and finally process each selected row one by one. A status message appears when the operation completes, showing how many rows were successfully deleted.

THE ACTUAL MECHANISM — WHY IT WORKS

phpMyAdmin's table browse interface uses a traditional server-rendered HTML structure with JavaScript-enhanced interactions. The table data is rendered as an HTML table with each row containing a checkbox for row selection, hidden input fields for primary key values, and individual delete links or buttons. This tool scans the DOM for the main data table and iterates through the table rows, extracting the checkbox elements, primary key values, and delete action elements. When processing deletions, the tool triggers a click event on the row's delete button or link, which opens phpMyAdmin's confirmation dialog. The tool then detects the confirmation dialog and clicks the OK/Confirm button to complete the deletion. This approach works without making direct SQL queries, which would require knowledge of the database schema and authentication credentials. By using the existing UI, the tool works within phpMyAdmin's own security and permission system, and respects all database constraints and triggers. The tool is designed for the default phpMyAdmin interface and may need updates if the interface changes significantly.

THE PANEL

The floating panel is fully draggable — click and drag the header to reposition it anywhere on the page. The panel's position is saved per site in localStorage, so it reappears exactly where you left it when you return to phpMyAdmin. Double-click the header to snap the panel to the nearest edge (left or right). A collapse button minimizes the panel to a small tab showing a warning emoji badge, keeping it out of the way while still accessible. The row list inside the panel is scrollable and resizes vertically based on the number of rows. Pressing Escape while the panel is focused closes it completely; reopening is done via a small button injected near the page toolbar. All panel interactions are non-blocking — phpMyAdmin's main UI remains fully responsive while the panel is open, and the panel updates automatically when you navigate between tables or pages.

PLEASE NOTE

This script requires the BotGentz extension (free) to run user scripts on phpMyAdmin. phpMyAdmin interfaces can vary significantly by version and installation configuration; if the tool stops working, check for an updated version within BotGentz's script repository. This tool does not store, transmit, or log any table data or row content — all operations occur locally in your browser with no external network requests except those made by phpMyAdmin itself. Deletions are applied through phpMyAdmin's own UI event system, so all changes respect your database permissions and foreign key constraints. The tool does not bypass phpMyAdmin's security or permission system; it simply automates the clicks you would otherwise perform manually. For tables with a large number of rows, the tool may take several minutes to complete the operation, as each row is processed sequentially with delays to avoid overwhelming the server. The double-confirmation safety mechanism is designed to prevent accidental deletions — always verify your selections carefully before proceeding. The tool only affects rows visible on the current page; to delete all rows, use phpMyAdmin's built-in pagination controls or adjust your view to show all relevant rows. This tool is designed for batch deletions — removing multiple rows with the same operation. It is strongly recommended to backup your database before performing bulk deletion operations.