使用AngularJS显示数据库中的数据

Question

I want to diplay data from db in my page .

This is my code in
JS :

 $scope.save = function() {
   var data = {
     subject: $scope.composeStory.subject,
     body: $scope.composeStory.body
   }


   $http.post(
       "insert.php", {
         'subject': $scope.composeStory.subject,
         'body': $scope.composeStory.body
       }
     )
     .success(function(data, status, headers, config) {
       console.log("inserted Successfully");
     });
 };

and Php

include('config.php');

$data = json_decode(file_get_contents("php://input"));
$subject = mysql_real_escape_string($data->subject);
$body = mysql_real_escape_string($data->body);
mysql_select_db("angular") or die(mysql_error());
mysql_query("INSERT INTO story (subject,body) VALUES ('$subject', '$body')");
Print "Your information has been successfully added to the database.";

$query = "SELECT * FROM story";
$result = mysql_query($query);

$arr = array();
while ($row = mysql_fetch_array($result)) {
    $subject = $row['name'];
    $body = $row['description'];
    $arr[] = $row;
}
echo json_encode($arr);  

Json

[{"0":"","subject":"","1":"","body":""},
 {"0":"","subject":"","1":"","body":""},
 {"0":"Soheil","subject":"Soheil","1":"Sadeghbayan","body":"Sadeghbayan"},
 {"0":"adsas","subject":"adsas","1":"asdasdasda","body":"asdasdasda"},
 {"0":"Say","subject":"Say","1":"Something","body":"Something"}]

it saved to db perfectly , but i dont know how to display data from database to my page ?

Answer 1

For retrieval of data create a factory-service which would use $http GET method, with the url pointing to your php file which returns the $data array in the format: echo json_encode($data);

This is a recent example I posted on another question:

demoApp.factory('simpleFactory', ['$http', function($http){

    return {

        getCustomer: function(){

            return $http.get("json/customers.php").then(
                function(response){
                    var customers = [];
                    customers = response.data;
                },
                function(error){
                    console.log(error);
                });
        }
    }
}]);