More options for table content formatting
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'digjainwi_allsanghinfodev.products' doesn't exist
You can format table column for date, image, html,read more, description and conditional logic formatting and many more other options. date format allows you to pass any standard php date formatting string and table will be formatted according to that. image format makes column value as image tag. long description can be made short with some character limit. conditional logic like if product price is greater than 200 than make that background highlight. Similar way view form formatting can be done. Click here to check example of view form formatting options.
$pdocrud = new PDOCrud();
$pdocrud->crudTableCol(array("product_line","product_image","product_name","product_description","product_price"));
// date formatting (pass date format)
$pdocrud->tableColFormatting("added_date", "date",array("format" =>"m-d-Y"));
// convert to any html like url or any html with actual value passed as {col-name}
$pdocrud->tableColFormatting("product_line", "html",array("type" =>"html",
"str"=>"{col-name}"));
$pdocrud->tableColFormatting("product_name", "html",array("type" =>"html",
"str"=>"{col-name}"));
//convert to image column
$pdocrud->tableColFormatting("product_image", "image");
//convert long column text to small text with read more
$pdocrud->tableColFormatting("product_description", "readmore", array("length"=>4,"showreadmore"=>true));//not showing read more
//conditional logic for formatting table colums - e.g apply css style for cells with product price>200
$pdocrud->tableDataFormatting("col", "style", array("product_price",">", "55"),array("background:#f00","color:#ff0"));
//$pdocrud->tableDataFormatting("row", "style", array("product_price",">", "55"),array("background:#000","color:#ff0"));
echo $pdocrud->dbTable("products")->render();