<head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>Select Multiple Rows</title> <script type="text/javascript"> function ShowSelectedRows(){ var rows = getSelRows(); alert(rows); } </script> </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("INLINE", "CRUD"); // read only columns, one or more columns delimited by comma $dg->set_col_readonly("orderDate, customerNumber"); // required fields $dg->set_col_required("orderNumber, customerNumber"); // multiple select $dg->set_multiselect(true); $dg->display(); ?>
<?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>Add Click Event to Hyperlink</title> </head> <body> <?php $dg = new C_DataGrid("select * from products", "productCode", "products"); $dg->set_col_title("productCode", "Product Code"); $dg->set_col_title("productName", "Product Name"); $dg->set_col_title("productLine", "Product Line"); $dg->set_col_format("productLine", "showlink", array("baseLinkUrl" => "javascript:", 'target' => '_self', "showAction" => "myFunction(jQuery('#products'),'", "addParam" => "');")); $dg->set_col_format("productName", "showlink", array("baseLinkUrl" => "javascript:", 'target' => '_self', "showAction" => "phpGridSiteAjaxSearch(jQuery('#products'),'", "addParam" => "');")); $dg->display(); ?> <script type="text/javascript"> myFunction = function (grid,param) { var ar = param.split('='); if (grid.length > 0 && ar.length === 2 && ar[0] === '?id') { var rowid = ar[1]; var prodDesc = grid.getCell(rowid, 'productDescription'); alert(prodDesc); }
<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>Fomrstack Database</title> </head> <body> <img src="http://54.84.139.183/formstackdb/images/InhouzLogo.jpg" alt="InHouzLogo.jpg" style="width:195px;height:78px;"> <?php // Always the first line in the grid section $dg = new C_DataGrid("SELECT * FROM formstack", "pk", "formstack"); // change default caption $dg->set_caption("Orders List"); // change column titles $dg->set_col_title("pk", "Row No."); $dg->set_col_title("OrderNumber", "Order Number"); $dg->set_col_title("DateTime", "Date Time"); $dg->set_col_title("FirstName", "First Name"); $dg->set_col_title("LastName", "Last Name"); $dg->set_col_title("Address1", "Address 1"); $dg->set_col_title("Address2", "Address 2"); $dg->set_col_title("AddressCity", "City"); $dg->set_col_title("AddressState", "State"); $dg->set_col_title("AddressZip", "Zip"); $dg->set_col_align('email', 'EMail'); $dg->set_col_title("InstallerRating", "Installer Rating"); $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");
<title> <?php echo iconv('Windows-1253', 'UTF-8', 'Προγράμματα Σχολικών Δραστηριοτήτων $prSxetos'); ?> </title> </head> <body> <?php // 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";
<?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>HTML Edit Controls</title> </head> <body> <?php $dg = new C_DataGrid("select * from employees", "employeeNumber", "employees"); $dg->set_col_title("employeeNumber", "Emp No."); $dg->set_col_title("lastName", "Last Name"); $dg->set_col_title("firstName", "First Name"); $dg->set_col_title("isActive", "Active?"); $dg->set_col_format("email", "email"); $dg->set_col_format("isActive", "checkbox"); $dg->enable_edit("FORM", "CRUD"); $dg->set_row_color("", ""); $dg->set_col_hidden('employeeNumber', true); $dg->set_col_edittype("isActive", "checkbox", "1:0"); $dg->set_col_edittype("reportsTo", "select", "Select employeeNumber, concat(firstName, ' ', lastName) from employees", false); $dg->set_col_edittype("officeCode", "autocomplete", "Select officeCode,city from offices", false); // - or - //$dg -> set_col_edittype("officeCode", "autocomplete", "1:San Francisco;2:Boston;3:NYC;4:Paris;5:Tokyo;6:Sydney;7:London"); $dg->enable_search(true); $dg->display(); ?>