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 85 entries

# ID Order no Order date Customer name Order amount Order status Actions
1 51 37429 2021-03-11 Xenos Clarke 78 Completed
2 52 1234567 2016-09-08 Xenos Clarke 26 Completed
3 55 83323 2016-09-08 Xenos Clarke 37 Completed
4 56 409 2016-09-08 Cooper Jensen 68 Completed
5 57 50683 2016-09-08 Deacon Tyson 28 Completed
6 59 48121 2016-09-08 1 Completed
7 61 37748 2016-09-08 Cooper Jensen 73 Completed
8 63 37920 2016-09-08 67 Completed
9 64 28431 2016-09-08 5 Completed
10 65 94701 2016-09-08 25 Completed
# ID Order no Order date Customer name Order amount Order status Actions