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

# ID Order no Order date Customer name Order amount Order status Actions
1 70 58 2016-09-08 Xenos Clarke 43 Completed
2 76 18 2016-09-08 Xenos Clarke 24 Completed
3 77 75674 2016-09-08 Xenos Clarke 39 Completed
4 78 65775 2016-09-10 Xenos Clarke 25 Completed
5 79 37102 2016-09-08 Xenos Clarke 7 Completed
6 80 74040 2016-09-08 Xenos Clarke 59 Completed
7 81 89592 2016-09-08 Xenos Clarke 76 Completed
8 82 84334 2016-09-08 Deacon Tyson 4 Completed
9 83 91414 2016-09-08 Deacon Tyson 91 Completed
10 84 89834 2016-09-08 Xenos Clarke 41 Completed
# ID Order no Order date Customer name Order amount Order status Actions