gridphp/CI Controller (Welcome.php)

## CI Controller (Welcome.php)
<?php
defined('BASEPATH') OR exit('No direct script access allowed');

class Welcome extends CI_Controller {

	/**
	 * Index Page for this controller.
	 *
	 * Maps to the following URL
	 * 		http://example.com/index.php/welcome
	 *	- or -
	 * 		http://example.com/index.php/welcome/index
	 *	- or -
	 * Since this controller is set as the default controller in
	 * config/routes.php, it's displayed at http://example.com/
	 *
	 * So any other public methods not prefixed with an underscore will
	 * map to /index.php/welcome/<method_name>
	 * @see http://codeigniter.com/user_guide/general/urls.html
	 */
	public function index()
	{
		$db_conf = array();
		$db_conf["type"] = "mysqli"; // mysql,oci8(for oracle),mssql,postgres,sybase
		$db_conf["server"] = "127.0.0.1";
		$db_conf["user"] = "root";
		$db_conf["password"] = "";
		$db_conf["database"] = "griddemo";

		require_once("lib/inc/jqgrid_dist.php");
		$g = new jqgrid($db_conf);

		$grid = array();
		// set table for CRUD operations
		$grid["caption"] = "Test CI GRID";
		$grid["rowNum"] = 10;//10,15 -- tinggi grid
		$grid["autowidth"] = true;
		$grid["height"] = 450;

		$grid["subGrid"] = true;
		$grid["subgridurl"] = "http://testing/ci/index.php/welcome/indexDetail";

		$g->set_options($grid);

		// render grid
		$g->select_command = "select * FROM clients";
		$g->table = "clients";

		$data['grid'] = $g->render("list1");
		$this->load->view('welcome_message',$data);
	}

	public function indexDetail()
	{

		$db_conf = array();
		$db_conf["type"] = "mysqli"; // mysql,oci8(for oracle),mssql,postgres,sybase
		$db_conf["server"] = "127.0.0.1";
		$db_conf["user"] = "root";
		$db_conf["password"] = "";
		$db_conf["database"] = "griddemo";

		require_once("lib/inc/jqgrid_dist.php");
		$g = new jqgrid($db_conf);

		$grid = array();
		// set table for CRUD operations
		$grid["caption"] = "Test CI GRID";
		$grid["rowNum"] = 10;//10,15 -- tinggi grid
		$grid["autowidth"] = true;
		$grid["height"] = 450;
		$g->set_options($grid);

		// render grid
		$g->select_command = "select * FROM clients";
		$g->table = "clients";

		$data['grid'] = $g->render("list1");
		$this->load->view('welcome_message',$data);
	}
}

## CI View (welcome_message.php)
<?php
defined('BASEPATH') OR exit('No direct script access allowed');
?><!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="utf-8">
	<title>Welcome to CodeIgniter</title>

	<style type="text/css">

	::selection { background-color: #E13300; color: white; }
	::-moz-selection { background-color: #E13300; color: white; }

	body {
		background-color: #fff;
		margin: 40px;
		font: 13px/20px normal Helvetica, Arial, sans-serif;
		color: #4F5155;
	}

	a {
		color: #003399;
		background-color: transparent;
		font-weight: normal;
	}

	h1 {
		color: #444;
		background-color: transparent;
		border-bottom: 1px solid #D0D0D0;
		font-size: 19px;
		font-weight: normal;
		margin: 0 0 14px 0;
		padding: 14px 15px 10px 15px;
	}

	code {
		font-family: Consolas, Monaco, Courier New, Courier, monospace;
		font-size: 12px;
		background-color: #f9f9f9;
		border: 1px solid #D0D0D0;
		color: #002166;
		display: block;
		margin: 14px 0 14px 0;
		padding: 12px 10px 12px 10px;
	}

	#body {
		margin: 0 15px 0 15px;
	}

	p.footer {
		text-align: right;
		font-size: 11px;
		border-top: 1px solid #D0D0D0;
		line-height: 32px;
		padding: 0 10px 0 10px;
		margin: 20px 0 0 0;
	}

	#container {
		margin: 10px;
		border: 1px solid #D0D0D0;
		box-shadow: 0 0 8px #D0D0D0;
	}
	</style>
</head>
<body>

<div id="container">
	<h1>Welcome to CodeIgniter!</h1>

	<div id="body">
		<p>The page you are looking at is being generated dynamically by CodeIgniter.</p>

		<p>If you would like to edit this page you'll find it located at:</p>
		<code>application/views/welcome_message.php</code>

		<p>The corresponding controller for this page is found at:</p>
		<code>application/controllers/Welcome.php</code>

		<p>If you are exploring CodeIgniter for the very first time, you should start by reading the <a href="user_guide/">User Guide</a>.</p>
	</div>

	<p class="footer">Page rendered in <strong>{elapsed_time}</strong> seconds. <?php echo  (ENVIRONMENT === 'development') ?  'CodeIgniter Version <strong>' . CI_VERSION . '</strong>' : '' ?></p>
</div>

	<link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url() ?>lib/js/themes/redmond/jquery-ui.custom.css"></link>
	<link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url() ?>lib/js/jqgrid/css/ui.jqgrid.css"></link>

	<script src="<?php echo base_url() ?>lib/js/jquery.min.js" type="text/javascript"></script>
	<script src="<?php echo base_url() ?>lib/js/jqgrid/js/i18n/grid.locale-en.js" type="text/javascript"></script>
	<script src="<?php echo base_url() ?>lib/js/jqgrid/js/jquery.jqGrid.min.js" type="text/javascript"></script>
	<script src="<?php echo base_url() ?>lib/js/themes/jquery-ui.custom.min.js" type="text/javascript"></script>

	<div style="margin:10px">
	<?php echo $grid?>
	</div>

</body>
</html>
	<?php
	defined('BASEPATH') OR exit('No direct script access allowed');

	class Welcome extends CI_Controller {

	/**
	* Index Page for this controller.
	*
	* Maps to the following URL
	* http://example.com/index.php/welcome
	* - or -
	* http://example.com/index.php/welcome/index
	* - or -
	* Since this controller is set as the default controller in
	* config/routes.php, it's displayed at http://example.com/
	*
	* So any other public methods not prefixed with an underscore will
	* map to /index.php/welcome/<method_name>
	* @see http://codeigniter.com/user_guide/general/urls.html
	*/
	public function index()
	{
	$db_conf = array();
	$db_conf["type"] = "mysqli"; // mysql,oci8(for oracle),mssql,postgres,sybase
	$db_conf["server"] = "127.0.0.1";
	$db_conf["user"] = "root";
	$db_conf["password"] = "";
	$db_conf["database"] = "griddemo";

	require_once("lib/inc/jqgrid_dist.php");
	$g = new jqgrid($db_conf);

	$grid = array();
	// set table for CRUD operations
	$grid["caption"] = "Test CI GRID";
	$grid["rowNum"] = 10;//10,15 -- tinggi grid
	$grid["autowidth"] = true;
	$grid["height"] = 450;

	$grid["subGrid"] = true;
	$grid["subgridurl"] = "http://testing/ci/index.php/welcome/indexDetail";

	$g->set_options($grid);

	// render grid
	$g->select_command = "select * FROM clients";
	$g->table = "clients";

	$data['grid'] = $g->render("list1");
	$this->load->view('welcome_message',$data);
	}

	public function indexDetail()
	{

	$db_conf = array();
	$db_conf["type"] = "mysqli"; // mysql,oci8(for oracle),mssql,postgres,sybase
	$db_conf["server"] = "127.0.0.1";
	$db_conf["user"] = "root";
	$db_conf["password"] = "";
	$db_conf["database"] = "griddemo";

	require_once("lib/inc/jqgrid_dist.php");
	$g = new jqgrid($db_conf);

	$grid = array();
	// set table for CRUD operations
	$grid["caption"] = "Test CI GRID";
	$grid["rowNum"] = 10;//10,15 -- tinggi grid
	$grid["autowidth"] = true;
	$grid["height"] = 450;
	$g->set_options($grid);

	// render grid
	$g->select_command = "select * FROM clients";
	$g->table = "clients";

	$data['grid'] = $g->render("list1");
	$this->load->view('welcome_message',$data);
	}
	}
	<?php
	defined('BASEPATH') OR exit('No direct script access allowed');
	?><!DOCTYPE html>
	<html lang="en">
	<head>
	<meta charset="utf-8">
	<title>Welcome to CodeIgniter</title>

	<style type="text/css">

	::selection { background-color: #E13300; color: white; }
	::-moz-selection { background-color: #E13300; color: white; }

	body {
	background-color: #fff;
	margin: 40px;
	font: 13px/20px normal Helvetica, Arial, sans-serif;
	color: #4F5155;
	}

	a {
	color: #003399;
	background-color: transparent;
	font-weight: normal;
	}

	h1 {
	color: #444;
	background-color: transparent;
	border-bottom: 1px solid #D0D0D0;
	font-size: 19px;
	font-weight: normal;
	margin: 0 0 14px 0;
	padding: 14px 15px 10px 15px;
	}

	code {
	font-family: Consolas, Monaco, Courier New, Courier, monospace;
	font-size: 12px;
	background-color: #f9f9f9;
	border: 1px solid #D0D0D0;
	color: #002166;
	display: block;
	margin: 14px 0 14px 0;
	padding: 12px 10px 12px 10px;
	}

	#body {
	margin: 0 15px 0 15px;
	}

	p.footer {
	text-align: right;
	font-size: 11px;
	border-top: 1px solid #D0D0D0;
	line-height: 32px;
	padding: 0 10px 0 10px;
	margin: 20px 0 0 0;
	}

	#container {
	margin: 10px;
	border: 1px solid #D0D0D0;
	box-shadow: 0 0 8px #D0D0D0;
	}
	</style>
	</head>
	<body>

	<div id="container">
	<h1>Welcome to CodeIgniter!</h1>

	<div id="body">
	<p>The page you are looking at is being generated dynamically by CodeIgniter.</p>

	<p>If you would like to edit this page you'll find it located at:</p>
	<code>application/views/welcome_message.php</code>

	<p>The corresponding controller for this page is found at:</p>
	<code>application/controllers/Welcome.php</code>

	<p>If you are exploring CodeIgniter for the very first time, you should start by reading the <a href="user_guide/">User Guide</a>.</p>
	</div>

	<p class="footer">Page rendered in <strong>{elapsed_time}</strong> seconds. <?php echo (ENVIRONMENT === 'development') ? 'CodeIgniter Version <strong>' . CI_VERSION . '</strong>' : '' ?></p>
	</div>

	<link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url() ?>lib/js/themes/redmond/jquery-ui.custom.css"></link>
	<link rel="stylesheet" type="text/css" media="screen" href="<?php echo base_url() ?>lib/js/jqgrid/css/ui.jqgrid.css"></link>

	<script src="<?php echo base_url() ?>lib/js/jquery.min.js" type="text/javascript"></script>
	<script src="<?php echo base_url() ?>lib/js/jqgrid/js/i18n/grid.locale-en.js" type="text/javascript"></script>
	<script src="<?php echo base_url() ?>lib/js/jqgrid/js/jquery.jqGrid.min.js" type="text/javascript"></script>
	<script src="<?php echo base_url() ?>lib/js/themes/jquery-ui.custom.min.js" type="text/javascript"></script>

	<div style="margin:10px">
	<?php echo $grid?>
	</div>

	</body>
	</html>