Add a Delete Button to Each Row in a PHPRunner Grid

PHPRunner normally provides Delete selected for removing one or more records from a List page. In some applications, it is more convenient to place a Delete action directly on each row next to the standard View, Edit or Copy actions.

This tutorial shows how to add a row-level Delete button, ask for confirmation, delete the correct record and reload the List page afterward.

Before you add the button

Place the custom button inside the grid row. This is important because the button needs access to the current record so the server-side code can determine which row should be deleted.

You will also need to know the table name and the key field used to identify each record. In the example below, the table is categories and the key field is CategoryID. Replace those values with the corresponding names from your project.

Security note: a custom button that calls DB::Delete() does not automatically inherit all of the behavior of PHPRunner’s standard Delete action. Make sure the button is only available to users who are allowed to delete the corresponding records, and add any additional permission checks your application requires.

1. Add the button to the grid

Open the List page in Page Designer and insert a button. Move the button into one of the grid columns so it becomes part of each record row.

Choose a button style that matches the other row actions, such as View or Edit. Select an appropriate delete or trash icon from the icons available in your current PHPRunner version.

2. Ask for confirmation

Open the button code and add the following to the ClientBefore event.

if (confirm("Do you want to delete this record?")) {
    return true;
}

return false;

Returning false prevents the server-side part of the button from running when the user cancels the confirmation.

3. Delete the current record

In the Server event, use getCurrentRecord() to get the record associated with the row where the button was clicked.

PHP

$record = $button->getCurrentRecord();

$data = array();
$data["CategoryID"] = $record["CategoryID"];

DB::Delete("categories", $data);

The $record array contains the current row data. We copy the key value into $data and pass it to DB::Delete().

Replace categories with your table name and CategoryID with your actual key field.

If your table uses a composite key, include all key fields in the array:

$record = $button->getCurrentRecord();

$data = array();
$data["OrderID"] = $record["OrderID"];
$data["ProductID"] = $record["ProductID"];

DB::Delete("order_details", $data);

C#

XVar record = button.getCurrentRecord();

dynamic data = XVar.Array();
data["CategoryID"] = record["CategoryID"];

DB.Delete("categories", data);

4. Reload the List page

After the server-side delete finishes, reload the page so the removed record disappears from the grid.

Add the following code to the Client After event:

location.reload();

How the button works

The complete flow is simple: the user clicks the Delete button, confirms the action, the button reads the current record, the server deletes that record using its key value, and the browser reloads the List page.

Using getCurrentRecord() is what makes this technique suitable for a button placed inside a grid row. The same button code runs for every row, but PHPRunner provides the data for the specific record where the user clicked.

For straightforward applications, this produces a convenient row-level Delete action without requiring users to select a checkbox first and then use Delete selected.