<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>phpGrid Edit Form Layout</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"); // enable edit $dg->enable_edit("FORM", "CRUD"); $dg->set_col_property("orderNumber", array("formoptions" => array("rowpos" => 1, "colpos" => 1))); $dg->set_col_property("orderDate", array("formoptions" => array("rowpos" => 1, "colpos" => 2))); $dg->set_col_property("requiredDate", array("formoptions" => array("rowpos" => 2, "colpos" => 1))); $dg->set_col_property("shippedDate", array("formoptions" => array("rowpos" => 2, "colpos" => 2))); $dg->set_col_property("status", array("formoptions" => array("rowpos" => 3, "colpos" => 1))); $dg->set_col_property("customerNumber", array("formoptions" => array("rowpos" => 3, "colpos" => 2))); $dg->set_col_property("comments", array("formoptions" => array("rowpos" => 4, "colpos" => 1))); $dg->set_form_dimension(700, 300); $dg->display(); ?> </body> </html>
$dg->set_col_property("FormstackImage5", array("formoptions" => array("rowpos" => 15, "colpos" => 1))); $dg->set_col_property("FormstackImage6", array("formoptions" => array("rowpos" => 15, "colpos" => 2))); $dg->set_col_property("FormstackImage7", array("formoptions" => array("rowpos" => 15, "colpos" => 3))); $dg->set_col_property("FormstackImage8", array("formoptions" => array("rowpos" => 15, "colpos" => 4))); // File upload section $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.