{"id":1493,"date":"2017-10-11T22:29:11","date_gmt":"2017-10-11T22:29:11","guid":{"rendered":"http:\/\/www.honobono-life.info\/wpeng\/?p=1493"},"modified":"2017-10-11T22:29:11","modified_gmt":"2017-10-11T22:29:11","slug":"angularjs-ui-grid-server-side-grid-pagination","status":"publish","type":"post","link":"http:\/\/www.honobono-life.info\/wpeng\/angularjs-ui-grid-server-side-grid-pagination\/","title":{"rendered":"AngularJS ui-grid Server side grid pagination"},"content":{"rendered":"<ul>\r\n<li>AngularJS : 1.6.5<\/li>\r\n<li>ui-grid : 4.0.6<\/li>\r\n<li>include file<\/li>\r\nui-grid.min.css,angular.min.js,ui-grid.min.js\r\n<\/ul>\r\n<!--more-->\r\n<link href=\"http:\/\/www.honobono-life.info\/wpeng\/wp-content\/themes\/ang\/css\/ui-grid-4.0.6.min.css\" rel=\"stylesheet\">\r\n<link href=\"http:\/\/www.honobono-life.info\/wpeng\/wp-content\/themes\/ang\/css\/grid-4.0.6.css\" rel=\"stylesheet\"><script type='text\/javascript' src='http:\/\/www.honobono-life.info\/wpeng\/wp-content\/themes\/ang\/js\/angular-1.6.5.min.js'><\/script><script type='text\/javascript' src='http:\/\/www.honobono-life.info\/wpeng\/wp-content\/themes\/ang\/js\/ui-grid-4.0.6.min.js'><\/script>\r\n<script type='text\/javascript' src='http:\/\/www.honobono-life.info\/wpeng\/wp-content\/themes\/ang\/js\/ui-pagination-server.js'><\/script>\r\n<div ng-app=\"googleMapApp\" role=\"tabpanel\">\r\n  <ul class=\"nav nav-tabs\">\r\n    <li class=\"active\"><a href=\"#demo1\" data-toggle=\"tab\">demo<\/a><\/li>\r\n    <li><a href=\"#html1\" data-toggle=\"tab\">markup<\/a><\/li>\r\n    <li><a href=\"#script1\" data-toggle=\"tab\">script<\/a><\/li>\r\n    <li><a href=\"#template1\" data-toggle=\"tab\">Server PHP<\/a><\/li>\r\n  <\/ul>\r\n  <div class=\"tab-content\">\r\n    <div class=\"tab-pane active\" id=\"demo1\">\r\n\r\n<div ng-controller=\"MyCtrl\">\r\n  <div class=\"row\">\r\n    <div class=\"col-sm-12\">\r\n      <div class=\"myGrid\" ui-grid=\"gridOptions\" ui-grid-pagination><\/div>\r\n    <\/div>\r\n  <\/div>\r\n<\/div>\r\n\r\n    <\/div>\r\n    <div class=\"tab-pane\" id=\"html1\">\r\n<pre>\r\n&lt;link href=\"http:\/\/www.example.com\/wp\/wp-content\/themes\/ang\/css\/ui-grid.min.css\" rel=\"stylesheet\">\r\n&lt;link href=\"http:\/\/www.example.com\/wp\/wp-content\/themes\/ang\/css\/grid.css\" rel=\"stylesheet\">\r\n&lt;script type='text\/javascript' src='http:\/\/www.example.com\/wp\/wp-content\/themes\/ang\/js\/ui-grid.min.js'>&lt;\/script>\r\n&lt;script type='text\/javascript' src='http:\/\/www.example.com\/wp\/wp-content\/themes\/ang\/js\/grid.js'>&lt;\/script>\r\n&lt;div ng-controller=\"MyCtrl\">\r\n  &lt;div class=\"row\">\r\n    &lt;div class=\"col-sm-12\">\r\n      &lt;div class=\"myGrid\" ui-grid=\"gridOptions\" ui-grid-pagination>&lt;\/div>\r\n    &lt;\/div>\r\n  &lt;\/div>\r\n&lt;\/div>\r\n<\/pre>\r\n    <\/div>\r\n\r\n    <div class=\"tab-pane\" id=\"script1\">\r\n\r\n<div ng-non-bindable><pre>\r\nvar myApp = angular.module('MyApp', ['ui.grid', 'ui.grid.pagination']);\r\n\r\nmyApp.controller('MyCtrl', ['$scope', '$http', function ($scope, $http) {\r\n    $scope.gridOptions = {\r\n      enablePaging: true,\r\n      showFooter: true,\r\n      paginationCurrentPage : 1,\r\n      paginationPageSizes: [3, 5, 8],\r\n      paginationPageSize: 3\r\n    };\r\n    $http.get('json-grid.php')\r\n      .then(function onSuccess(response) {\r\n        $scope.gridOptions.data = response.data;\r\n      });\r\n}]);\r\n\r\n(grid.css)\r\n.myGrid {\r\n  height: 300px;\r\n}\r\n<\/pre><\/div>\r\n    <\/div><!-- \/.tab-pane -->\r\n\r\n    <div class=\"tab-pane\" id=\"template1\">\r\n<pre>\r\n&lt;?php\r\nrequire(\"dbinfo.php\");\r\n$dsn = 'mysql:host=localhost;dbname='.$database.';charset=utf8';\r\ntry {\r\n  $dbh = new PDO($dsn, $username, $password,array(PDO::ATTR_EMULATE_PREPARES =>\r\nfalse,PDO::MYSQL_ATTR_INIT_COMMAND => \"SET CHARACTER SET `utf8`\"));\r\n} catch (PDOException $e) {\r\n  exit('DB connect error'.$e->getMessage());\r\n}\r\n$st = $dbh->query(\"SELECT * FROM grid_products WHERE 1\");\r\necho json_encode($st->fetchAll(PDO::FETCH_ASSOC));\r\n\r\n?>\r\n<\/pre>\r\n    <\/div><!-- \/.tab-pane -->\r\n\r\n  <\/div><!-- \/.tab-content -->\r\n<\/div><!-- \/.tabpanel -->","protected":false},"excerpt":{"rendered":"<p>AngularJS : 1.6.5 ui-grid : 4.0.6 include file ui-grid.min.css,angular.min.js,ui-grid.min.js<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[66],"tags":[],"amp_enabled":true,"_links":{"self":[{"href":"http:\/\/www.honobono-life.info\/wpeng\/wp-json\/wp\/v2\/posts\/1493"}],"collection":[{"href":"http:\/\/www.honobono-life.info\/wpeng\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.honobono-life.info\/wpeng\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.honobono-life.info\/wpeng\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.honobono-life.info\/wpeng\/wp-json\/wp\/v2\/comments?post=1493"}],"version-history":[{"count":2,"href":"http:\/\/www.honobono-life.info\/wpeng\/wp-json\/wp\/v2\/posts\/1493\/revisions"}],"predecessor-version":[{"id":1495,"href":"http:\/\/www.honobono-life.info\/wpeng\/wp-json\/wp\/v2\/posts\/1493\/revisions\/1495"}],"wp:attachment":[{"href":"http:\/\/www.honobono-life.info\/wpeng\/wp-json\/wp\/v2\/media?parent=1493"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.honobono-life.info\/wpeng\/wp-json\/wp\/v2\/categories?post=1493"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.honobono-life.info\/wpeng\/wp-json\/wp\/v2\/tags?post=1493"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}