<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Load Grid using vertical scroll</title>
</head>
<body>
<?php
$dg = new C_DataGrid("SELECT * FROM orders", "orderNumber", "orders");
// change column titles
$dg->set_col_title("orderNumber", "Order No.");
$dg->set_col_title("orderDate", "Order Date");
$dg->set_col_title("shippedDate", "Shipped Date");
$dg->set_col_title("customerNumber", "Customer No.");
// hide a column
$dg->set_col_hidden("requiredDate");
// change default caption
$dg->set_caption("Orders List");
// set export type
$dg->enable_export('EXCEL');
// enable integrated search
$dg->enable_search(true);
// set height and weight of datagrid
$dg->set_dimension(800, 600);
// increase pagination size to 40 from default 20
$dg->set_pagesize(40);
// use vertical scroll to load data
$dg->set_scroll(true);
$dg->display();
?>
</body>
</html>
$dg->set_col_fileupload("BeforeAfter1", "/formstackdb/images/", "C:\\inetpub\\wwwroot\\formstackdb\\");
/*
$dg -> set_col_fileupload("BeforeAfter2", "/formstackdb/images/", "C:\\inetpub\\wwwroot\\formstackdb\\");
$dg -> set_col_fileupload("BeforeAfter3", "/formstackdb/images/", "C:\\inetpub\\wwwroot\\formstackdb\\");
$dg -> set_col_fileupload("BeforeAfter4", "/formstackdb/images/", "C:\\inetpub\\wwwroot\\formstackdb\\");
*/
// enable integrated search
$dg->enable_search(true);
// enable inline editing
$dg->enable_edit("FORM", "CRUD");
$dg->set_form_dimension(1200, 700);
// set export type
$dg->enable_export('EXCEL');
// $dg -> enable_export('CSV');
// Page Size
$dg->set_pagesize(15);
$dg->enable_resize(true);
// $dg -> enable_autowidth(true);
$dg->enable_autoheight(true);
// $dg -> set_scroll(true);
$dg->enable_kb_nav(true);
// beta. be careful
// Set grid colors & theme
$dg->set_theme('cobalt');
// $dg -> set_row_color('#BDE7F2', 'lightblue', '#DDE8F5');
// always the last line in the grid section.
$dg->display();
?>
<script type="text/javascript">
$(function() {
// declare and prepare phpgrid
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 {
</div><!-- /.navbar-collapse -->
</div><!-- /.container-fluid -->
</nav>
<div class="container">
<div class="row">
<div class="col-md-12" id="clientDiv">
<?php
$mysqli = MysqliConfiguration::getMysqli();
/*phpgrid.com/documentation/*/
$dg = new C_DataGrid("SELECT * FROM clients", "rowId", "clients");
$dg->set_multiselect(true);
$dg->enable_search(true);
//$dg->enable_export('EXCEL');
$dg->set_pagesize(100);
$dg->enable_edit('INLINE', 'D');
$dg->display();
?>
<button type="button" onclick="saveSelectedRows();">Create Job Files</button>
</div>
<div class="row">
<div class="col-lg-12" id="outputDiv">
</div>
</div>
<div class="row">
<div class="col-lg-12" id="contentDiv">
<h2>Updating the Client Database ... </h2>
