Skip to content

Instantly share code, notes, and snippets.

@oscaremmanuel

oscaremmanuel/gist:363271082dd6a2aeb3dc6b91fd17289b

Created December 6, 2018 18:14
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save oscaremmanuel/363271082dd6a2aeb3dc6b91fd17289b to your computer and use it in GitHub Desktop.
Save oscaremmanuel/363271082dd6a2aeb3dc6b91fd17289b to your computer and use it in GitHub Desktop.
Download ZIP
grid source code
Raw
gistfile1.txt
<?php
/**
* PHP Grid Component
*
* @author Abu Ghufran <gridphp@gmail.com> - http://www.phpgrid.org
* @version 2.0.0
* @license: see license.txt included in package
*/
error_reporting(E_ALL);
//include_once("auth.php");
$db_conf = array();
$db_conf["type"] = "pdo";
$db_conf["server"] = "firebird:host=localhost/30500;dbname=X:/Data/REDSEGURO.fdb";
$db_conf["user"] = "SYSDBA";
$db_conf["password"] = "masterkey";
$db_conf["database"] = "";
include("/lib/inc/jqgrid_dist.php");
$g = new jqgrid($db_conf);
$g->debug = 0;
// set few params
$grid["caption"] = "Afiliados Discapacidad";
$grid["rowList"] = array(10,20,30,'All');
$opt["responsive"] = true;
$opt["globalsearch"] = true;
$opt["altRows"] = true;
$opt["rowNum"] = 10;
$opt["rowheight"] = 30;
$opt["add_options"]["width"] = "500";
$opt["edit_options"]["width"] = "500";
$opt["view_options"]["width"] = "500";
$opt["height"] = "100%";
$opt["resizable"] = true; // defaults to false
$g->set_options($grid);
$g->set_actions(array(
"add"=>true, // allow/disallow add
"edit"=>true, // allow/disallow edit
"delete"=>true, // allow/disallow delete
"showhidecolumns"=>true,
"rowactions"=>true, // show/hide row wise edit/del/save option
"autofilter" => true, // show/hide autofilter for search
"search" => "group", // show/hide autofilter for search
)
);
// set database table for CRUD operations
$g->table = "SUCURSALES";
$g->select_command = "SELECT * FROM SUCURSALES";
// render grid
$out = $g->render("list1");
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>PHP Grid Framework Demos | www.phpgrid.org</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta name="description" content="">
<meta name="author" content="">
<!-- Le styles -->
<link href="bootstrap/css/bootstrap.min.css" rel="stylesheet">
<style type="text/css">
body {
padding-top: 60px;
padding-bottom: 0px;
}
.sidebar-nav {
padding: 9px 0;
}
.nav
{
margin-bottom:10px;
}
.accordion-inner a {
font-size: 13px;
font-family:tahoma;
}
.alert {
padding:8px 14px 8px 14px;
}
</style>
<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/jquery.jqGrid.min.js" type="text/javascript"></script>
<script src="lib/js/themes/jquery-ui.custom.min.js" type="text/javascript"></script>
<!-- to enable spanish -->
<script src="lib/js/jqgrid/js/i18n/grid.locale-es.js" type="text/javascript"></script>
</head>
<body>
<div style="margin:100px">
<?php echo $out?>
</div>
</body>
</html>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment