Show data from PHP call to angularJS site

Question

Appreciate the help up-front! Having trouble displaying the data I get back from PHP onto an AngularJS site. I've looked at past threads on the topic, but none of them have helped.

What I can say is that the PHP/data I am getting back looks fine. It just looks like there is a disconnect between maybe my JS file and my HTML file.

Any thoughts would be much appreciated.

//PHP CODE

$result = $conn->query("SELECT * FROM insights");

$insightsArray = array();
while($row = $result->fetch_array(MYSQLI_ASSOC))
{

$insightsArray[] = $row;

}

echo json_encode($insightsArray);

$conn->close();

//JS CODE

var myApp = angular.module('myApp', []);

myApp.config(['$qProvider', function ($qProvider) {
    $qProvider.errorOnUnhandledRejections(false);
}]);

myApp.controller('getInsights', function($scope, $http) {
   $http.get("/getInsights.php")
   .then(function(data){
       $scope.insightsArray = data;
   });

});

//HTML

<html ng-app="myApp">
<head>
<title>Get Insight</title>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/angularjs/1.6.4/angular.js"></script>

</head>
<body>

<div ng-controller="getInsights">

<ul>
<li ng-repeat="insight in insightsArray">{{insight.insighttype}}</li>

</ul>
</div>
<script src="/angularJS.js"></script>
</body>
</html>

Vivz · Accepted Answer · 2017-08-07 14:59:47Z

1

Change your controller like this. You have to access the data property of your response.

myApp.controller('getInsights', function($scope, $http) {
   $http.get("/getInsights.php")
   .then(function(data){
       $scope.insightsArray = data.data;
   });

});

answered Aug 7, 2017 at 14:59

Vivz

6,6282 gold badges19 silver badges34 bronze badges

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

Collectives™ on Stack Overflow

Show data from PHP call to angularJS site

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related