How to get json data from php in angularjs

Question

I already searched lot of stuff but it doesn't help. I want my data from php to be like this :

$scope.places = [{name: 'John'},{name: 'Jane'}];

My problem is I dont know how to achieve this thing. Here'e my angularjs looks like:

$scope.getNames = function(){
     $http.post('get',{}).then(function(response){
            $scope.places = response.data;
     });
};

$scope.getNames();

PHP

$sql = "SELECT * FROM tblplace";
$res = $con->query($sql);
while($row = mysqli_fetch_array($res)){
    // code here.
}

HTML

<select class="form-control places">
    <option value="empty">Select</option>
    <option ng-repeat="place in places" value="{{place.name}}">  {{place.name}}</option>
 </select>

How to do it? Thanks!

Ela Buwa · Accepted Answer · 2017-03-26 03:32:12Z

1

You need to use json_encode in your php output.

$json_array = array();
$sql = "SELECT * FROM tblplace";
$res = $con->query($sql);
while($row = mysqli_fetch_array($res)){
   $temp_arr['name'] = $row['name'];
   $json_array[] = $temp_arr;
}
echo json_encode($json_array);

Adjust the while loop accordingly. Haven't used php so I'm a bit fuzzy on the syntax.

answered Mar 26, 2017 at 3:32

Ela Buwa

1,7043 gold badges22 silver badges46 bronze badges

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

1 Comment

Ela Buwa Over a year ago

Glad I could help. :D

Collectives™ on Stack Overflow

How to get json data from php in angularjs

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