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 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
3 42 66729 2016-09-08 Xenos Clarke 90
4 43 62940 2016-09-08 20
5 45 40334 2016-09-08 87
6 46 30771 2016-09-08 461
7 47 96349 2016-09-08 71
8 48 72881 2016-09-08 18
9 49 3691 2016-09-08 Callum Solomon 75
10 50 77099 2016-09-08 Nola Rojas 20
# ID Order no Order date Customer name Order amount Order status Actions