Edit Single Cell Excel like editing of table cell on click (Added in version 3.7)

If you want to edit a single cell value directly similar to spreadsheet editing, you can easily do by enabling "tableCellEdit". On click on table rows, it shows the value inside the input text box. You can edit the value inside the input type text. You need to press enter to save the value. You can click on any table cell to edit the value directly.
Limitations:

  • Doesn't work with join.
  • Support input type of text field only.
  • Doesn't support field formatting and field validation.

  
                                    $pdocrud = new PDOCrud();
                                    $pdocrud->setSettings("tableCellEdit", true);
                                    echo $pdocrud->dbTable("orders")->render();
                                

Orders

Showing 1 to 10 of 20 entries

# ID Order no Order date Customer name Order amount Order status Actions
1 172 27 2025-11-04 Xenos Clarke 1000 67
2 173 35 2025-09-02 Deacon Tyson 4 Listo
3 174 0 0000-00-00 Cooper Jensen 3
4 176 0 0000-00-00 10
5 178 33 2025-09-02 Deacon Tyson 111 ok
6 179 33 2025-09-02 Deacon Tyson 111 ok
7 182 1 2025-07-01 Deacon Tyson 82325 Pending
8 184 576749678 2025-09-03 Cooper Jensen 798797 asdas
9 185 0 0000-00-00 Xenos Clarke 0 1
10 186 -1 2025-10-02 Cooper Jensen 0 ??
# ID Order no Order date Customer name Order amount Order status Actions