Formula based Formatting of CRUD table column Format crud table column using formula

You can format table column using various formula functions. For example you can make any table column content to uppercase, first letter uppercase, lowercase or you can add prefix, suffix etc. 

  
                               $pdocrud = new PDOCrud();
                                // format field to 2 decimal point
                               $pdocrud->tableColFormatting("tax", "formula",array("type" =>"round","decimalpoint"=>2));
                               // format field to 2 decimal point
                               $pdocrud->tableColFormatting("product_discount", "formula",array("type" =>"number_format","decimalpoint"=>2));
                               // get ceil value of field
                               $pdocrud->tableColFormatting("product_price", "formula",array("type" =>"ceil"));
                               //get floor value of field
                               $pdocrud->tableColFormatting("product_sell_price", "formula",array("type" =>"floor"));

                               $pdocrud->crudTableCol(array("product_name", "product_price","product_sell_price","tax","product_discount"));
                               echo $pdocrud->dbTable("products")->render();

Formula based table content formatting

Products

Add

Showing 1 to 10 of 98 entries

Go
# Product name Product price Product sell price Tax Product discount Actions
1 Doesnt matters 20 2 5 0.00
2 0 0 0 0.00
3 0 0 0 0.00
4 0 0 0 0.00
5 RE 0 0 233 232.00
6 2002 Suzuki XREO 67 150 2 2.00
7 1969 Corvair Monza 90 151 0 0.00
8 1957 Chevy Pickup 56 118 0 0.00
9 1937 Lincoln Berline 61 102 0 0.00
10 1980s Black Hawk Helicopter 78 157 0 0.00
# Product name Product price Product sell price Tax Product discount Actions