Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- /**
- * PHP Grid Component
- *
- * @author Abu Ghufran <gridphp@gmail.com> - http://www.phpgrid.org
- * @version 1.5.2
- * @license: see license.txt included in package
- */
- // include db config
- include_once("lib/phpgrid/config.php");
- // set up DB
- mysql_connect(PHPGRID_DBHOST, PHPGRID_DBUSER, PHPGRID_DBPASS);
- mysql_select_db(PHPGRID_DBNAME);
- // include and create object
- include(PHPGRID_LIBPATH."inc/jqgrid_dist.php");
- $g = new jqgrid();
- // set table for CRUD operations
- $g->table = "hours";
- $grid["caption"] = "Bootstrap UI Testing";
- $grid["form"]["position"] = "center";
- $grid["autowidth"] = true;
- $grid["autoresize"] = true; // responsive effect
- $g->set_options($grid);
- $col = array();
- $col["title"] = "Date Submitted"; // caption of column
- $col["name"] = "dtsubmit"; // grid column name, must be exactly same as returned column-name from sql (tablefield or field-alias)
- $col["editable"] = true;
- $col["width"] = "30";
- $cols[] = $col;
- $col["title"] = "Date Volunteered"; // caption of column
- $col["name"] = "dtvol"; // grid column name, must be exactly same as returned column-name from sql (tablefield or field-alias)
- $col["editable"] = true;
- $col["required"] = true;
- $cols[] = $col;
- $col = array();
- $col["title"] = "Hours"; // caption of column
- $col["name"] = "hours"; // grid column name, must be exactly same as returned column-name from sql (tablefield or field-alias)
- $col["editable"] = true;
- $cols[] = $col;
- $col = array();
- $col["title"] = "Activity"; // caption of column
- $col["name"] = "activity"; // grid column name, must be exactly same as returned column-name from sql (tablefield or field-alias)
- $col["editable"] = true;
- $col["editoptions"] = array("defaultValue" => "Default Company");
- $cols[] = $col;
- $g->set_columns($cols);
- $g->set_actions(array(
- "add"=>true, // allow/disallow add
- "edit"=>true, // allow/disallow edit
- "delete"=>true, // allow/disallow delete
- "clone"=>true, // allow/disallow delete
- "rowactions"=>true, // show/hide row wise edit/del/save option
- "search" => "advance", // show single/multi field search condition (e.g. simple or advance)
- "showhidecolumns" => false
- )
- );
- // render grid
- $out = $g->render("list1");
- $themes = array("black-tie","blitzer","cupertino","dark-hive","dot-luv","eggplant","excite-bike","flick","hot-sneaks","humanity","le-frog","mint-choc","overcast","pepper-grinder","redmond","smoothness","south-street","start","sunny","swanky-purse","trontastic","ui-darkness","ui-lightness","vader");
- $i = rand(0,8);
- // if set from page
- if (is_numeric($_GET["themeid"]))
- $i = $_GET["themeid"];
- else
- $i = 14;
- ?>
- <!DOCTYPE html>
- <html lang="en">
- <head>
- <meta charset="utf-8">
- <title>PHP Grid Control Demos | www.phpgrid.org</title>
- <meta name="viewport" content="width=device-width, initial-scale=1.0">
- <meta name="description" content="">
- <meta name="author" content="">
- <!-- HTML5 shim, for IE6-8 support of HTML5 elements -->
- <!--[if lt IE 9]>
- <script src="http://html5shim.googlecode.com/svn/trunk/html5.js"></script>
- <![endif]-->
- <link rel="stylesheet" type="text/css" media="screen" href="lib/phpgrid/lib/js/themes/humanity/jquery-ui.custom.css">
- <link rel="stylesheet" type="text/css" media="screen" href="lib/phpgrid/lib/js/jqgrid/css/ui.jqgrid.css">
- <link href="lib/phpgrid/bootstrap/css/bootstrap.min.css" rel="stylesheet">
- <link rel="stylesheet" type="text/css" media="screen" href="lib/phpgrid/lib/js/jqgrid/css/ui.bootstrap.jqgrid.css">
- <script src="lib/phpgrid/lib/js/jquery.min.js" type="text/javascript"></script>
- <script src="lib/phpgrid/lib/js/jqgrid/js/i18n/grid.locale-en.js" type="text/javascript"></script>
- <script src="lib/phpgrid/lib/js/jqgrid/js/jquery.jqGrid.min.js" type="text/javascript"></script>
- <script src="lib/phpgrid/lib/js/themes/jquery-ui.custom.min.js" type="text/javascript"></script>
- </head>
- <body>
- <div class="row-fluid">
- <div class="span12">
- <div style="margin:10px">
- <form method="get">
- Choose Theme: <select name="themeid" onchange="form.submit()">
- <?php foreach($themes as $k=>$t) { ?>
- <option value=<?php echo $k?> <?php echo ($i==$k)?"selected":""?>><?php echo ucwords($t)?></option>
- <?php } ?>
- </select> -
- You can also have your customized theme (<a href="http://jqueryui.com/themeroller">jqueryui.com/themeroller</a>).
- </form>
- <?php echo $out?>
- </div>
- </div><!--/span-->
- </div><!--/row-->
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement