- http://www.phpgrid.org
* @version 2.0.0
* @license: see license.txt included in package
*/
include_once("../../config.php");
include(PHPGRID_LIBPATH."inc/jqgrid_dist.php");
// Database config file to be passed in phpgrid constructor
$db_conf = array(
"type" => PHPGRID_DBTYPE,
"server" => PHPGRID_DBHOST,
"user" => PHPGRID_DBUSER,
"password" => PHPGRID_DBPASS,
"database" => PHPGRID_DBNAME
);
$g = new jqgrid($db_conf);
$grid["caption"] = "Sample Grid";
$g->set_options($grid);
$g->table = "clients";
$flds = array();
$flds[] = 'client_id';
$flds[] = 'name';
$flds[] = 'gender';
$flds[] = 'company';
$cols = array();
foreach($flds as $f) {
$col = array();
$col["title"] = ucwords(str_replace("_", " ", $f));
$col["name"] = $f;
if ($f == 'client_id') {
$col["hidden"] = true;
$col["editrules"] = array("edithidden" => false);
}
if ($f == 'company') {
$col['link'] = "http://www.mysite.com/Docs/{company}";
}
$col["editable"] = false;
$cols[] = $col;
}
$g->set_columns($cols, true);
$out = $g->render("list1");
?>