API tools faq
paste
Guest User

phpGrid

a guest
May 29th, 2016
82
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.19 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2. /**
  3.  * PHP Grid Component
  4.  *
  5.  * @author Abu Ghufran <gridphp@gmail.com> - http://www.phpgrid.org
  6.  * @version 2.0.0
  7.  * @license: see license.txt included in package
  8.  */
  9.  
  10. include_once("../../config.php");
  11.  
  12. include(PHPGRID_LIBPATH."inc/jqgrid_dist.php");
  13.  
  14. // Database config file to be passed in phpgrid constructor
  15. $db_conf = array(  
  16.                     "type"      => PHPGRID_DBTYPE,
  17.                     "server"    => PHPGRID_DBHOST,
  18.                     "user"      => PHPGRID_DBUSER,
  19.                     "password"  => PHPGRID_DBPASS,
  20.                     "database"  => PHPGRID_DBNAME
  21.                 );
  22.  
  23. $g = new jqgrid($db_conf);
  24.  
  25. $g->table = "gda_details";
  26.  
  27.  
  28.     // set few params
  29.     $grid["caption"] = "Global Data Access";
  30.     $grid["autowidth"] = true;
  31.     $grid["multiselect"] = true;
  32.     $grid["resizable"] = true;
  33.     $g->set_options($grid);
  34.  
  35. $col = array();
  36. $col["title"] = "GDAid";
  37. $col["name"] = "GDAid";
  38. $col["hidden"] = true;
  39. $col["editrules"] = array("edithidden"=>true);
  40. $cols[] = $col;
  41.    
  42.     $g->set_actions(array( 
  43.                             "add"=>true, // allow/disallow add
  44.                             "edit"=>true, // allow/disallow edit
  45.                             "delete"=>true, // allow/disallow delete
  46.                             "bulkedit"=>true, // allow/disallow delete
  47.                             "showhidecolumns"=>true, // allow/disallow delete
  48.                             "rowactions"=>true, // show/hide row wise edit/del/save option
  49.                             "autofilter" => true, // show/hide autofilter for search
  50.                             "search" => "advance"
  51.                         )
  52.                     );
  53.  
  54.          
  55.     // render grid
  56.     $out = $g->render("list1");
  57.  
  58.  
  59. ?>
  60. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
  61. <html>
  62. <head>
  63.     <link rel="stylesheet" type="text/css" media="screen" href="../../lib/js/themes/redmond/jquery-ui.custom.css"></link>  
  64.     <link rel="stylesheet" type="text/css" media="screen" href="../../lib/js/jqgrid/css/ui.jqgrid.css"></link> 
  65.  
  66.     <script src="../../lib/js/jquery.min.js" type="text/javascript"></script>
  67.     <script src="../../lib/js/jqgrid/js/i18n/grid.locale-en.js" type="text/javascript"></script>
  68.     <script src="../../lib/js/jqgrid/js/jquery.jqGrid.min.js" type="text/javascript"></script> 
  69.     <script src="../../lib/js/themes/jquery-ui.custom.min.js" type="text/javascript"></script>
  70. </head>
  71. <body>
  72.     <div>
  73.     <?php echo $out?>
  74.     </div>
  75. </body>
  76. </html>
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!