个人中心
gpt4 book ai didi

javascript - 错误 : valLists is undefined in pagination of table rows using AngularJS, AJAX

转载 作者：行者123 更新时间：2023-11-29 21:58:59 46 4
gpt4 key购买 nike

我正在使用此代码的一部分 http://www.jitendrazaa.com/blog/webtech/web/pagination-and-sorting-of-data-table-using-angularjs/ 进行 AngularJS 分页，但我想使用名为“user”的 MySQL DB 表中的数据...但我面临一个错误，即 valLists 未定义，因此它返回 null 并且什么也不显示......我认为数据类型来自 select.php 导致了这个问题，我不知道如何解决它......任何帮助!

HTML 代码:

<body>
    <br />
        <br />
        <div ng-app="myApp">
            <div ng-controller="TableCtrl">

                <table class="table">
                    <thead>
                        <tr>
                            <th class="id">User Id
                            </th>
                            <th class="name">Name
                            </th>
                            <th class="phone">Phone
                            </th>
                        </tr>
                    </thead>
                    <tbody>
                        <tr ng-repeat="item in ItemsByPage[currentPage]">
                            <td>{{item.id}}</td>
                            <td>{{item.name}}</td>
                            <td>{{item.phone}}</td>
                        </tr>
                    </tbody>
                </table>

                <ul class="pagination">
                    <li><a href="#" ng-click="firstPage()">First</a>

                    </li>
                    <li ng-repeat="n in range(ItemsByPage.length)"> <a href="#" ng-click="setPage()" ng-bind="n+1">1</a>

                    </li>
                    <li><a href="#" ng-click="lastPage()">Last</a>

                    </li>
                </ul>
             </div>
      </div>
</body>

JavaScript 代码:

var myApp = angular.module('myApp', []);
        myApp.service('ListService', function () {                
            this.paged = function (valLists, pageSize) {
                retVal = [];                  
                for (var i = 0; i < valLists.length; i++) {
                    if (i % pageSize === 0) {
                        retVal[Math.floor(i / pageSize)] = [valLists[i]];
                    } else {
                        retVal[Math.floor(i / pageSize)].push(valLists[i]);
                    }
                }
                return retVal;
            };
        });

        var TableCtrl = myApp.controller('TableCtrl', function ($scope, ListService) {
            $scope.pageSize = 2;
            $scope.allItems = getData();

            $scope.resetAll = function () {
                $scope.List = $scope.allItems;
                $scope.newId = '';
                $scope.newName = '';
                $scope.newPhone = '';
                $scope.currentPage = 0;
            };
           function getData1(){
                 return [{
                         id : 33,
                         name : 'hala',
                         phone: 12345
                 }]
             };
            var d = new Array();
            function getData() {
                   $.ajax ({
                     url: "select.php",
                     type: 'POST',
                     //dataType: "json",
                     data: '',
                     success: function( data ) {
                        d = data;

                        // alert('succ');
                     },
                     error: function(  ) {

                         alert('Error select');
                     }
                     });    
                   //  alert(d);
               return d;
             }
$scope.pagination = function () {
                $scope.ItemsByPage = ListService.paged($scope.List, $scope.pageSize);

            };

            $scope.setPage = function () {
                $scope.currentPage = this.n;
            };

            $scope.firstPage = function () {
                $scope.currentPage = 0;
            };

            $scope.lastPage = function () {
                $scope.currentPage = $scope.ItemsByPage.length - 1;
            };

            $scope.range = function (input) {
                var ret = [];                    
                for (var i = 0; i < input; i++) {
                    if (i != 0 && i != input - 1) {
                        ret.push(i);
                    }
                }
                return ret;
            };

            $scope.resetAll();            
            $scope.pagination();

        });

select.php代码

<?php
header('Content-Type: application/json');
include 'connect.php';
$db = new database();
$db->setDb_name('training');
$db->connect();

$db->select('user',"*");
$data = $db->getResult();    
echo json_encode($data);  
?>

这里是选择功能:

public function select($table, $rows, $where = null){        
    $case = 0;   

    if($this->tableExists($table))
    {          
       $q = ' SELECT ' .$rows.' FROM '.$table;
        $query = @mysql_query($q);                   

        $this->numresults = mysql_num_rows($query);
        for($i = 0; $i < $this->numresults; $i++)
        {
            $r = mysql_fetch_array($query);
            $key = array_keys($r); 
            for($x = 0; $x < count($key); $x++)
            {
                // Sanitizes keys so only alphavalues are allowed
                if(!is_int($key[$x]))
                {
                    if(mysql_num_rows($query) > 1)
                        $this->result[$i][$key[$x]] = $r[$key[$x]];
                    else if(mysql_num_rows($query) < 1)
                        $this->result = null; 
                    else
                        $this->result[$key[$x]] = $r[$key[$x]]; 
                }
               // $this->result[$i][$key[$x]] = $r[$key[$x]];
            }
        }   
       // print_r ($this->result)."<br/>";


   }
    else
        return false; 

}

和 getResult() 函数:

public function getResult() {
    return $this->result;
}

注意1:当使用函数 getData1() 而不是 getData() 时，效果很好。注意2:我确信选择功能运行良好并带来如下数据:

[{"id":"3","name":"newname","phone":"321"},
{"id":"4","name":"nnnnnnnnnnn","phone":"66555566"},      {"id":"10","name":"dss","phone":"45321"},    {"id":"11","name":"www","phone":"1234"},    {"id":"15","name":"fghjkl","phone":"34567890"}]

最佳答案

尝试使用 Angular 的 $http 服务。像这样的东西。

var TableCtrl = myApp.controller('TableCtrl', function ($scope, ListService, $http) {
  // ...
  $http.post('select.php')
       .success(function(response) {
          $scope.allItems = response;
       });

   // ...   
}

关于javascript - 错误 : valLists is undefined in pagination of table rows using AngularJS, AJAX，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/32852587/

46 4 0
文章推荐： android - 如何在不打开其他使用 "geo"方案的应用程序的情况下打开 Google map ？
文章推荐： javascript - CoffeeScript:Github ATOM，Atom API 的 getSelection 替代方案？
文章推荐： javascript - 2个CSS div : Allow sortable items in (right) div to create new sortable row instead of (right) div clearing other (left) div
文章推荐： mysql - 根据标题匹配从一个数据库到另一个数据库的 SQL 更新
行者123
个人简介

我是一名优秀的程序员,十分优秀！

滴滴打车优惠券免费领取
滴滴打车优惠券
全站热门文章
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com