<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>