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

Go
# Product name Product price Product sell price Tax Product discount Actions
1 2001 Ferrari Enzo 95.59 207 0 0.00
2 1958 Setra Bus 77.90 136 0 0.00
3 1969 Corvair Monza 89.14 151 0 0.00
4 1968 Dodge Charger 75.16 117 0 0.00
5 1969 Ford Falcon 83.05 173 0 0.00
6 1970 Plymouth Hemi Cuda 31.92 79 0 0.00
7 1957 Chevy Pickup 55.70 118 0 0.00
8 1969 Dodge Charger 58.73 115 0 0.00
9 1940 Ford Pickup Truck 58.33 116 0 0.00
10 1993 Mazda RX-7 83.51 141 0 0.00
# Product name Product price Product sell price Tax Product discount Actions