require_once "../conf.php";
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Data Formatting</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");
$dg->display();
?>
</body>
</html>
require_once 'phpgrid/conf.php';
$dg = new C_DataGrid("SELECT id,sch1,titel FROM {$prTable}", "id", "{$prTable}");
$dg->set_locale('el');
$dg->set_caption(mb_convert_encoding("Προγράμματα Σχολικών Δραστηριοτήτων {$prSxetos}", "utf-8", "iso-8859-7"));
$dg->set_col_property("id", array("name" => "A/A", "width" => 15));
//$dg ->set_col_property("done", array("name"=>"done", "width"=>15));
//$dg ->set_col_property("agree", array("name"=>"done", "width"=>15));
$dg->set_col_title("id", "A/A");
$dg->set_col_title("sch1", mb_convert_encoding("Όνομα Σχολείου", "utf-8", "iso-8859-7"));
$dg->set_col_title("titel", mb_convert_encoding("Τίτλος προγράμματος", "utf-8", "iso-8859-7"));
//$dg ->set_col_title("done", mb_convert_encoding("Ξεκίνησε;", "utf-8","iso-8859-7" ));
//$dg ->set_col_title("agree", mb_convert_encoding("Δήλ.Ολοκλ.", "utf-8","iso-8859-7" ));
$dg->enable_search(true);
$dg->set_dimension(1100, 700);
$dg->set_pagesize(30);
$dg->set_col_dynalink("id", "prog.php", "id");
$dg->set_col_dynalink("titel", "prog.php", "id");
// get data from CAS server
if (!$prDebug) {
$_SESSION['admin'] = 0;
$sch_name = phpCAS::getAttribute('description');
$uid = phpCAS::getUser();
$em1 = $uid . "@sch.gr";
$em2 = phpCAS::getAttribute('mail');
if (!strcmp($uid, 'dipeira') || !strcmp($uid, 'taypeira')) {
$_SESSION['admin'] = 1;
}
$_SESSION['email1'] = $em1;
$_SESSION['email2'] = $em2;
} else {
$sch_name = $prsch_name;
<?php
require_once "../conf.php";
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Display Dynamic Hyperlink</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/", array('productCode', 'productScale', 'buyPrice'), '&foo=bar', '_new');
// display dynamic url from with id from another column
$dg->set_col_dynalink("productLine", "http://www.example.com/", "productName", "&foo=bar");
$dg->display();
?>
</body>
</html>
