Angular SQL "limit" error

Question

I've got a simple angular sql-php-json data fetching.

The code works until some record. Then it's trows an error. It works with 51 record, crashes with 52... Obviously I need all the data. :)

What am I missing? Thank you.

Console error:

{}

javascript:

    var app = angular.module('myApp', []);
    app.controller('Ctrl', function($scope, $http) {
      $http.get(file)
      .then(function (response) {$scope.names = response.data.records;},
        function(error) {console.log(JSON.stringify(error));}
     );
  });

php:

header("Access-Control-Allow-Origin: *");
header("Content-Type: application/json; charset=UTF-8");    
include("connect.php");
$result = $conn->query("SELECT id, nev, cim, kapcsolat, bankszamlaszam, adoszam FROM szallito ORDER BY nev LIMIT 52"); 

$outp = "";
while($rs = $result->fetch_array(MYSQLI_ASSOC)) {
    if ($outp != "") {$outp .= ",";}
    $outp .= '{"id":"'  . $rs["id"].'",';
    $outp .= '"nev":"'. $rs["nev"].'",';
    $outp .= '"cim":"'. $rs["cim"].'",';
    $outp .= '"kapcsolat":"'. $rs["kapcsolat"].'",';
    $outp .= '"bankszamlaszam":"'. $rs["bankszamlaszam"].'",';
    $outp .= '"adoszam":"'  . $rs["adoszam"].'"}';
}
$outp ='{"records":['.$outp.']}';
$conn->close();

echo($outp);

Should be stringify. You could consider deleting the post if it's just a typo. I don't think this post will help others. — jeprubio
– jeprubio, Commented Nov 28, 2017 at 13:43
While JSON.stringify is spelled wrong - that's only prohibiting OP from logging the error - fix the typo and please post the actual error you're receiving from the server. — tymeJV
– tymeJV, Commented Nov 28, 2017 at 13:51
I've changed it, the error remains. I mean the new error is: {} — Sütemény András
– Sütemény András, Commented Nov 28, 2017 at 14:38

Sajeetharan · Accepted Answer · 2017-11-28 13:40:18Z

1

It is JSON.stringify

console.log(JSON.stringify(error));

answered Nov 28, 2017 at 13:40

Sajeetharan

223k65 gold badges370 silver badges409 bronze badges

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

1 Comment

Sütemény András Over a year ago

Sorry it doesn't helped, like I said the error remains... which is like this in the console.log -> {} (that's all what it says, and crashes. )

Collectives™ on Stack Overflow

Angular SQL "limit" error

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related