Trouble with Angular/Ajax/PHP not getting the data

Question

I'm having a simple problem that I cannot seem to resolve. I'm trying to return a simple set of data from mysql database using angular/ajax and php. The problem is nothing populates in the HTML. No errors in debugger. Here is my code.

HTML:

<?php
include("includes/header.php");
?>
<body ng-app="testapp">
  <div ng-ctrl="HomeController">
    <input type="text" ng-model="name">
    <p>{{name}}</p>

    <ul ng-repeat="user in users">
      <li>{{user.fname user.lname}}</li>
    </ul>


  </div>
  <script type="text/javascript" src="angular/testapp.js"></script>
  <script type="text/javascript" src="angular/TestController.js"></script>
</body>
<?php
  include("includes/footer.php");
?>

ANGULAR/AJAX

    angular.module("testapp").controller("TestController", function($scope, $http){
      $scope.name = "";

      $http({
        method: "POST",
        url: "../includes/getUsers.php"
      }).success(function(data){
        $scope.users = data;
      });

    });

Finally PHP getUsers.php:

  include("connection.php");

  $query = "SELECT fname, lname FROM user"

  $rows = $db->query($query);
  $data = array();
  while ($row = $rows->fetchAll(PDO:FETCH_ASSOC)) {
    $data[] = $row;
  }


  echo json_encode($data);

I'm not seeing any errors in the console in developer tools using chrome. — Eric Schumann
– Eric Schumann, Commented Oct 15, 2016 at 3:28
add an error handler and find out what it tells you. Can also inspect actual request in browser dev tools for clues — charlietfl
– charlietfl, Commented Oct 15, 2016 at 4:37

itzmukeshy7 · Accepted Answer · 2016-10-15 05:28:50Z

2

Try this ;)

This statement is causing problem:

while ($row = $rows->fetchAll(PDO:FETCH_ASSOC)) {

Here you are using constant FETCH_ASSOC of PDO class so replace : with ::

while ($row = $rows->fetchAll(PDO::FETCH_ASSOC)) {

and one more thing always set error_reporting(E_ALL); in development so that you can get all errors;

UPDATE

You should also add proper headers for JSON response also mentioned by @venkatesh-konatham:

header('Content-Type: application/json');
echo json_encode($data);

edited Oct 15, 2016 at 5:28

answered Oct 15, 2016 at 5:19

itzmukeshy7

2,6781 gold badge24 silver badges30 bronze badges

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

3 Comments

Eric Schumann Over a year ago

That was the problem. Thanks.

itzmukeshy7 Over a year ago

@EricSchumann If this answer solved you issue then accept it and close question;

Eric Schumann Over a year ago

Sorry. Newbie here.

Francisco Rosello · Accepted Answer · 2016-10-15 03:31:25Z

0

Try first to call your php code to verify if it's returning something.

After that, try to add an .error() in the $http call to verify if really succeds the request

answered Oct 15, 2016 at 3:31

Francisco Rosello

133 bronze badges

1 Comment

Eric Schumann Over a year ago

Verified that addUsers.php returns JSON string by including on index.php and echoing out to document.

Venkatesh Konatham · Accepted Answer · 2016-10-15 04:58:26Z

0

I think problem is bind json data to angularjs. Can you try adding content type on your php code like below on the header

header('Content-Type: application/json');

answered Oct 15, 2016 at 4:58

Venkatesh Konatham

8286 silver badges17 bronze badges

Collectives™ on Stack Overflow

Trouble with Angular/Ajax/PHP not getting the data

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related