AngularJS ng-repeat not showing data in table

Question

I have a problem with output from MySQL

getCustomers.php is

$query="select distinct c.ancestry, c.trusted from members c order by c.id";
$result = $mysqli->query($query) or die($mysqli->error.__LINE__);
$arr = array();
if($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
    $arr[] = json_encode($row);
}
}

# JSON-encode the response
$json_response = json_encode($arr);
// # Return the response
echo $json_response;

and controler code:

app.controller('customersCrtl', function ($scope, $http, $timeout) {
$http.get('ajax/getCustomers.php').success(function(data){
    $scope.list = data;
    $scope.currentPage = 1; //current page
    $scope.entryLimit = 100; //max no of items to display in a page
    $scope.filteredItems = $scope.list.length; //Initially for no filter  
    $scope.totalItems = $scope.list.length;
});
$scope.setPage = function(pageNo) {
    $scope.currentPage = pageNo;
};
$scope.filter = function() {
    $timeout(function() { 
    $scope.filteredItems = $scope.filtered.length;
    }, 10);
};
$scope.sort_by = function(predicate) {
    $scope.predicate = predicate;
    $scope.reverse = !$scope.reverse;
};
});

Problem is that i get from MySQL this format (e.g.):

["{\"ancestry\":\"12865794218\",\"trusted\":\"128\"}"]

but expectable is:

[{"ancestry":"1286794218","trusted":"126"}]

so, if I write constants in data it works perfectly fine

$scope.list = [{"ancestry":"1286794218","trusted":"126"}];

Thanks for any help.

the " \ " are correct. the javascript show an error when you catch the array? — Jesus Carrasco
– Jesus Carrasco, Commented Aug 9, 2017 at 22:55
check this answer to clarify the backslash. stackoverflow.com/a/10314758/8303694 — Jesus Carrasco
– Jesus Carrasco, Commented Aug 9, 2017 at 22:57

Don't Panic · Accepted Answer · 2017-08-09 23:01:13Z

1

You're double-encoding your response. The backslashes are there because the second application of json_encode escapes the double quotes in the output of the first one. Remove the json_encode from inside your while loop.

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        $arr[] = $row;                        // don't encode here
    }
}

Then just encode it once afterward (as you already are.)

$json_response = json_encode($arr);

edited Aug 9, 2017 at 23:01

answered Aug 9, 2017 at 22:50

Don't Panic

41.9k11 gold badges70 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

piitr Over a year ago

Thank you very much :) and have another question.... How can i use non-standard symbols (ščžážý) in MySQL?... While with these symbols also not working.

Fotis Over a year ago

This could be the subject to a separate question. I think you need to set a UTF-8 collation to your database and apply the same on your connection from the PHP script to the database. Similar Question: stackoverflow.com/questions/9968438/…

Fotis · Accepted Answer · 2017-08-09 22:50:57Z

1

I think you need to use header('Content-Type: application/json'); in your php code, so that the server responds with a JSON content type.

There is also a duplicate json_encode in your code, inside your while loop so you're doing duplicate json encoding, hence the unexpected output

answered Aug 9, 2017 at 22:50

Fotis

1,36216 silver badges31 bronze badges

Comments

Vic · Accepted Answer · 2017-08-09 22:49:03Z

0

use JSON.parse() on your response. JSON.parse docs

answered Aug 9, 2017 at 22:49

Vic

4244 silver badges7 bronze badges

Collectives™ on Stack Overflow

AngularJS ng-repeat not showing data in table

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related