Advertisement
Guest User

mysqli demo

a guest
Jan 27th, 2015
293
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.60 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. $db_conf = array();
  14. $db_conf["type"] = "mysqli";
  15. $db_conf["server"] = PHPGRID_DBHOST; // or you mysql ip
  16. $db_conf["user"] = PHPGRID_DBUSER; // username
  17. $db_conf["password"] = PHPGRID_DBPASS; // password
  18. $db_conf["database"] = PHPGRID_DBNAME; // database
  19.  
  20. // include and create object
  21. include(PHPGRID_LIBPATH."inc/jqgrid_dist.php");
  22. $g = new jqgrid($db_conf);
  23.  
  24. // set few params
  25. $grid["caption"] = "Sample Grid";
  26. $g->set_options($grid);
  27.  
  28. // set database table for CRUD operations
  29. $g->table = "clients";
  30.  
  31. // render grid
  32. $out = $g->render("list1");
  33.  
  34. ?>
  35. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
  36. <html>
  37. <head>
  38. <meta charset="UTF-8">
  39. <link rel="stylesheet" type="text/css" media="screen" href="../../lib/js/themes/redmond/jquery-ui.custom.css"></link>
  40. <link rel="stylesheet" type="text/css" media="screen" href="../../lib/js/jqgrid/css/ui.jqgrid.css"></link>
  41.  
  42. <script src="../../lib/js/jquery.min.js" type="text/javascript"></script>
  43. <script src="../../lib/js/jqgrid/js/i18n/grid.locale-en.js" type="text/javascript"></script>
  44. <script src="../../lib/js/jqgrid/js/jquery.jqGrid.min.js" type="text/javascript"></script>
  45. <script src="../../lib/js/themes/jquery-ui.custom.min.js" type="text/javascript"></script>
  46. </head>
  47. <body>
  48. <div style="margin:10px">
  49. <?php echo $out?>
  50. </div>
  51. </body>
  52. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement