Example of OPCDataGrid usage

example_opcdatagrid.php

<?php 
$res = db('select product_id,name,short_description from products order by name asc');
$dg = new OPCDataGrid($res);
    
$dg->fields(array(
    'name' => 'Product Name',
    'short_description' => 'Description'
));

$dg->addField('Added', 'added', 'this field has been added',array('after'=>'short_description'));
    
$dg->modify('name', function($value,$row) {
    return '<a href="'.url_for('products',$row['product_id']).'">'.$value.'</a>';
});
    
$dg->modify('short_description',function($value,$row){
    $str = trim(substr($value,0,60));
    return $str.'...';
});

$dg->render();
?>