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

# ID Order no Order date Customer name Order amount Order status Actions
1 40 93062 2016-09-08 Cooper Jensen 32 qsdCompleted
2 41 76778 2016-09-08 Deacon Tyson 77 Pending
3 42 66729 2024-12-02 Xenos Clarke 45 Completed
4 43 62940 2016-09-08 Xenos Clarke 20 Completed
5 44 22241 2016-09-08 Deacon Tyson 29 Completed
6 45 40334 2016-09-08 Xenos Clarke 87 Completed
7 46 30771 2016-09-08 Xenos Clarke 461 Completed
8 47 96349 2016-09-08 Xenos Clarke 71 Completed
9 48 72881 2016-09-08 Xenos Clarke 18 Completed
10 50 77099 2016-09-08 Deacon Tyson 20 Completed
# ID Order no Order date Customer name Order amount Order status Actions