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

Add

Showing 1 to 10 of 30 entries

Go
# ID Order no Order date Customer name Order amount Order status Actions
1 66 36440 2016-09-08 Heather Terrell 8 Completed
2 67 37251 2016-09-08 Rose Barry 64 Completed
3 68 35643 2016-09-08 Bernard Gilmore 95 Completed
4 69 9551 2016-09-08 Meghan Mack 89 Completed
5 70 44898 2016-09-08 Lillith Terrell 43 Completed
6 71 91617 2016-09-08 Jaquelyn James 57 Completed
7 72 78062 2016-09-08 Karly Beard 56 Completed
8 73 87594 2016-09-08 Kareem Cooke 7 Completed
9 74 24386 2016-09-08 Amethyst Bass 70 Completed
10 75 49890 2016-09-08 Silas Bates 27 Completed
# ID Order no Order date Customer name Order amount Order status Actions