PDOCrud Replace column value

Many times, we need to display different value of column than the value saved for example we save status as 0,1 and display as "Approved" "Not Approved". This can be easily achieved using the PDOCrud using tableColFormatting function and replacing the value of column.

  
                                $pdocrud = new PDOCrud(); 
                                //column_name, replace, array of value and replace value array (you can also write in one statement, rather than two)
                                $pdocrud->tableColFormatting("order_status", "replace",array("Completed" =>""));
                                $pdocrud->tableColFormatting("order_status", "replace",array("Pending" =>""));
                                echo $pdocrud->dbTable("orders")->render();
                                

Orders

Showing 1 to 10 of 73 entries

# ID Order no Order date Customer name Order amount Order status Actions
1 39 578 2016-09-30 Xenos Clarke 943
2 40 93062 2016-09-08 Cooper Jensen 44 qsdCompleted
3 41 76778 2016-09-08 Deacon Tyson 77
4 42 66729 2016-09-08 Dawn Potter 90
5 43 62940 2016-09-08 Zane Calderon 20
6 44 22241 2016-09-08 Cecilia Carney 29
7 45 40334 2016-09-08 Connor Marquez 87
8 46 30771 2016-09-08 Gillian Kirk 461
9 47 96349 2016-09-08 Wallace Gillespie 71
10 48 72881 2016-09-08 Risa Ayers 18
# ID Order no Order date Customer name Order amount Order status Actions