Formula based table content formatting
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'digjainwi_allsanghinfodev.products' doesn't exist
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();