Last active
June 14, 2020 20:11
-
-
Save gridphp/272a3063359c8b5938355ed59c7711d4 to your computer and use it in GitHub Desktop.
Code Ignitor - PHP Grid demo - https://www.gridphp.com
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?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); | |
} | |
} |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?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> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment