Guest User

Untitled

a guest
Jan 15th, 2016
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.04 KB | None | 0 0
  1. <?php
  2. /**
  3. * PHP Grid Component
  4. *
  5. * @author Abu Ghufran <gridphp@gmail.com> - http://www.phpgrid.org
  6. * @version 1.5.2
  7. * @license: see license.txt included in package
  8. */
  9.  
  10. // include db config
  11. include_once("../../config.php");
  12.  
  13. // set up DB
  14. mysql_connect(PHPGRID_DBHOST, PHPGRID_DBUSER, PHPGRID_DBPASS);
  15. mysql_select_db("griddemo");
  16.  
  17. // include and create object
  18. include(PHPGRID_LIBPATH."inc/jqgrid_dist.php");
  19.  
  20. $g = new jqgrid();
  21.  
  22. // set few params
  23. $grid["caption"] = "Sample Grid";
  24. $grid["autowidth"] = true;
  25. $g->set_options($grid);
  26.  
  27. // set database table for CRUD operations
  28. $g->table = "clients";
  29.  
  30. // render grid
  31. $out = $g->render("list1");
  32. ?>
  33. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
  34. <html>
  35. <head>
  36. <link rel="stylesheet" type="text/css" media="screen" href="../../lib/js/themes/redmond/jquery-ui.custom.css"></link>
  37. <link rel="stylesheet" type="text/css" media="screen" href="../../lib/js/jqgrid/css/ui.jqgrid.css"></link>
  38.  
  39. <script src="../../lib/js/jquery.min.js" type="text/javascript"></script>
  40. <script src="../../lib/js/jqgrid/js/i18n/grid.locale-en.js" type="text/javascript"></script>
  41. <script src="../../lib/js/jqgrid/js/jquery.jqGrid.min.js" type="text/javascript"></script>
  42. <script src="../../lib/js/themes/jquery-ui.custom.min.js" type="text/javascript"></script>
  43. </head>
  44. <body>
  45. <div style="margin:10px">
  46. <?php echo $out?>
  47. </div>
  48.  
  49. <script>
  50. jQuery(window).bind("click", function () {
  51.  
  52. var gid = "list1";
  53.  
  54. var oldWidth = jQuery("#"+gid).jqGrid("getGridParam", "width");
  55.  
  56.  
  57. // if (oldWidth < 500)
  58. {
  59. jQuery("#"+gid).jqGrid("hideCol","company");
  60. jQuery("#"+gid).jqGrid("hideCol","gender");
  61. }
  62.  
  63. var newWidth = jQuery(window).width() * 0.975;
  64. jQuery("#"+gid).jqGrid("setGridWidth", newWidth);
  65.  
  66. // else
  67. // {
  68. // jQuery("#"+gid).jqGrid("showCol","company");
  69. // jQuery("#"+gid).jqGrid("showCol","gender");
  70. // }
  71.  
  72. }).trigger("resize");
  73. </script>
  74. </body>
  75. </html>
Add Comment
Please, Sign In to add comment