Pasted

<?php
/**
 * PHP Grid Component
 *
 * @author Abu Ghufran <[email protected]> - 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");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html>
<head>
    <link rel="stylesheet" type="text/css" media="screen" href="../../lib/js/themes/redmond/jquery-ui.custom.css"></link>
    <link rel="stylesheet" type="text/css" media="screen" href="../../lib/js/jqgrid/css/ui.jqgrid.css"></link>
 
    <script src="../../lib/js/jquery.min.js" type="text/javascript"></script>
    <script src="../../lib/js/jqgrid/js/i18n/grid.locale-en.js" type="text/javascript"></script>
    <script src="../../lib/js/jqgrid/js/jquery.jqGrid.min.js" type="text/javascript"></script>
    <script src="../../lib/js/themes/jquery-ui.custom.min.js" type="text/javascript"></script>
</head>
<body>
<div>
    <?php echo $out?>
</div>
</body>
</html>