How to fetch the data in AngularJs from a PHP server running MySQL ?

Question

I have a database on local computer and same on remote, I want to sync both server any suggestion on how to proceed?

Answer 1

AngularJS is perfect for displaying data from a Database. Just make sure the data is in JSON format.

<div ng-app="myApp" ng-controller="customersCtrl">

<table>
  <tr ng-repeat="x in names">
    <td>{{ x.Name }}</td>
    <td>{{ x.Country }}</td>
  </tr>
</table>

</div>

<script>
var app = angular.module('myApp', []);
app.controller('customersCtrl', function($scope, $http) {
    $http.get("http://xyz.com/angular_mysql.php")
    .then(function (response) {$scope.names = response.data.records;});
});
</script>