错误:使用AngularJS、AJAX对表行进行分页时未定义valLists - ERROR : valLists is undefined in pagination of table rows using AngularJS, AJAX

我使用部分代码http://www.jitendrazaa.com/blog/webtech/web/pagination-and-sorting-of-data-table-using-angularjs/为AngularJS分页，但我想使用数据从MySQL数据库表称为'user'…但我面临一个错误，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);  
?>

下面是select函数:

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:我确信select函数工作良好，并带来如下数据:

[{"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;
       });
   // ...   
}