Advertisement
Guest User

Untitled

a guest
Feb 20th, 2015
251
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.11 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('localhost','root','root');
  15. mysql_select_db(phpgridtest);
  16. $grid["rownumbers"] = true;
  17. $grid["page"] = 2;
  18. $grid["pgbuttons"] = false;
  19. $grid["pgtext"] = null;
  20. $grid["viewrecords"] = true;
  21. $grid["toolbar"] = "top";
  22. $grid["altRows"] = true;
  23.  
  24. // include and create object
  25. include(PHPGRID_LIBPATH."inc/jqgrid_dist.php");
  26. $g = new jqgrid();
  27.  
  28. // set few params
  29. $grid["caption"] = "Sample Grid";
  30. $g->set_options($grid);
  31.  
  32.  
  33. // set database table for CRUD operations
  34. $g->table = "taaldadra";
  35.  
  36. // render grid
  37. $out = $g->render("list1");
  38.  
  39.  
  40. ?>
  41. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
  42. <html>
  43. <head>
  44. <link rel="stylesheet" type="text/css" media="screen" href="lib/js/themes/redmond/jquery-ui.custom.css"></link>
  45. <link rel="stylesheet" type="text/css" media="screen" href="lib/js/jqgrid/css/ui.jqgrid.css"></link>
  46.  
  47. <script src="lib/js/jquery.min.js" type="text/javascript"></script>
  48. <script src="lib/js/jqgrid/js/i18n/grid.locale-en.js" type="text/javascript"></script>
  49. <script src="lib/js/jqgrid/js/jquery.jqGrid.min.js" type="text/javascript"></script>
  50. <script src="lib/js/themes/jquery-ui.custom.min.js" type="text/javascript"></script>
  51. </head>
  52. <body>
  53.  
  54.  
  55. <div >
  56. <?php
  57. echo $out;
  58. ?>
  59.  
  60.  
  61.  
  62. <script type="text/javascript">
  63. var myTableArray = [];
  64. var SelectTable=$("list1");
  65. var SelectAllRows=SelectTable.find('tr');
  66. $(SelectAllRows).each(function() {
  67. var arrayOfThisRow = [];
  68. var tableData = $(this).find('td');
  69. if (tableData.length > 0) {
  70. tableData.each(function()
  71. {
  72. arrayOfThisRow.push($(this).text());
  73.  
  74. });
  75.  
  76. myTableArray.push(arrayOfThisRow);
  77. alert(myTableArray);
  78. }
  79. });
  80.  
  81.  
  82.  
  83.  
  84.  
  85. </script>
  86. </div>
  87.  
  88.  
  89.  
  90.  
  91. </body>
  92. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement