$dg->set_col_title("InstallType", "Install Type");
$dg->set_col_title("THDStoreNumber", "THD Store #");
$dg->set_col_title("FormstackImage1", "Image 1");
$dg->set_col_title("FormstackImage2", "Image 2");
$dg->set_col_title("FormstackImage3", "Image 3");
$dg->set_col_title("FormstackImage4", "Image 4");
$dg->set_col_title("FormstackImage5", "Image 5");
$dg->set_col_title("FormstackImage6", "Image 6");
$dg->set_col_title("FormstackImage7", "Image 7");
$dg->set_col_title("FormstackImage8", "Image 8");
$dg->set_col_title("BeforeAfter1", "Upload 1");
$dg->set_col_title("BeforeAfter2", "Upload 2");
$dg->set_col_title("BeforeAfter3", "Upload 3");
$dg->set_col_title("BeforeAfter4", "Upload 4");
// Set Column to image type
$dg->set_col_img("FormstackImage1");
$dg->set_col_img("FormstackImage2");
$dg->set_col_img("FormstackImage3");
$dg->set_col_img("FormstackImage4");
$dg->set_col_img("FormstackImage5");
$dg->set_col_img("FormstackImage6");
$dg->set_col_img("FormstackImage7");
$dg->set_col_img("FormstackImage8");
$dg->set_col_img("BeforeAfter1");
/*
$dg -> set_col_img("BeforeAfter2");
$dg -> set_col_img("BeforeAfter3");
$dg -> set_col_img("BeforeAfter4");
*/
// Set column Alignments
$dg->set_col_align('pk', 'center');
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Resize by using mouse</title>
</head>
<body>
<?php
$dg = new C_DataGrid("select * from products", "productCode", "productcode");
$dg->set_col_title("productCode", "Product Code");
$dg->set_col_title("productName", "Product Name");
$dg->set_col_title("productLine", "Product Line");
// display static Url
$dg->set_col_link("productUrl");
// display dynamic url. e.g.http://www.example.com/?productCode=101&foo=bar
$dg->set_col_dynalink("productCode", "http://www.example.com/", "productCode", '&foo=bar');
// column format
$dg->set_col_currency("buyPrice");
$dg->set_col_format("quantityInStock", "integer", array("thousandsSeparator" => ",", "defaultValue" => "0"));
$dg->set_col_format("MSRP", 'currency', array("prefix" => "\$", "suffix" => '', "thousandsSeparator" => ",", "decimalSeparator" => ".", "decimalPlaces" => '2', "defaultValue" => '0.00'));
// the above line is equivalent to the following helper function
$dg->set_col_currency("MSRP", "\$", '', ",", ".", "2", "0.00");
// display image
$dg->set_col_img("Image");
// enable resize by dragging mouse
$dg->enable_resize(true, 300, 500, true);
$dg->display();
?>
</body>
</html>
