$http service и взаимодействие с БД
 

У меня есть сервис в котором описаны функции вывода данных, добавления данных и удаления данных

app.service("friendService", function( $http, $q ) {

        // Return public API.
        return({
            addFriend: addFriend,
            getFriends: getFriends,
            removeFriend: removeFriend
        });


        // ---
        // PUBLIC METHODS.
        // ---


        // I add a friend with the given name to the remote collection.
        function addFriend( name ) {

            var request = $http({
                method: "post",
                url: "server.php",
                params: {
                    action: "add"
                },
                data: {
                    name: name
                }
            });

            return( request.then( handleSuccess, handleError ) );

        }


        // I get all of the friends in the remote collection.
        function getFriends() {

            var request = $http({
                method: "get",
                url: "server.php",
                params: {
                    action: "get"
                }
            });

            return( request.then( handleSuccess, handleError ) );

        }


        // I remove the friend with the given ID from the remote collection.
        function removeFriend( id ) {

            var request = $http({
                method: "delete",
                url: "server.php",
                params: {
                    action: "delete"
                },
                data: {
                    id: id
                }
            });

            return( request.then( handleSuccess, handleError ) );

        }


        function editFriend( id, name ) {

                var request = $http({
                    method: "put",
                    url: "server.php",
                    params: {
                        action: "put"
                    },
                    data: {
                        id: id,
                        name: name
                    }
                });

                return( request.then( handleSuccess, handleError ) );

            }


        // ---
        // PRIVATE METHODS.
        // ---


        // I transform the error response, unwrapping the application dta from
        // the API response payload.
        function handleError( response ) {

            // The API response from the server should be returned in a
            // nomralized format. However, if the request was not handled by the
            // server (or what not handles properly - ex. server error), then we
            // may have to normalize it on our end, as best we can.
            if (
                ! angular.isObject( response.data ) ||
                ! response.data.message
                ) {

                return( $q.reject( "An unknown error occurred." ) );

            }

            // Otherwise, use expected error message.
            return( $q.reject( response.data.message ) );

        }


        // I transform the successful response, unwrapping the application data
        // from the API response payload.
        function handleSuccess( response ) {

            return( response.data );

        }

    }
);

и есть контроллер где эти функции вызываются

app.controller("DemoController", function( $scope, friendService ) {

        // I contain the list of friends to be rendered.
        $scope.friends = [];

        // I contain the ngModel values for form interaction.
        $scope.form = {
            name: ""
        };

        loadRemoteData();


        // ---
        // PUBLIC METHODS.
        // ---


        // I process the add-friend form.
        $scope.addFriend = function() {

            // If the data we provide is invalid, the promise will be rejected,
            // at which point we can tell the user that something went wrong. In
            // this case, I'm just logging to the console to keep things very
            // simple for the demo.
            friendService.addFriend( $scope.form.name )
                .then(
                    loadRemoteData,
                    function( errorMessage ) {

                        console.warn( errorMessage );

                    }
                )
            ;

            // Reset the form once values have been consumed.
            $scope.form.name = "";

        };


        // I remove the given friend from the current collection.
        $scope.removeFriend = function( friend ) {
            console.log(friend.id);

            // Rather than doing anything clever on the client-side, I'm just
            // going to reload the remote data.
            friendService.removeFriend( friend.id )
                .then( loadRemoteData )
            ;

        };

         $scope.editFriend = function( friend ) {

            // Rather than doing anything clever on the client-side, I'm just
            // going to reload the remote data.
            friendService.editFriend( friend.id )
                .then( loadRemoteData )
            ;

        };


        // ---
        // PRIVATE METHODS.
        // ---


        // I apply the remote data to the local scope.
        function applyRemoteData( newFriends ) {

            $scope.friends = newFriends;

        }


        // I load the remote data from the server.
        function loadRemoteData() {

            // The friendService returns a promise.
            friendService.getFriends()
                .then(
                    function( friends ) {

                        applyRemoteData( friends );

                    }
                )
            ;

        }

    }
);

и конечно существует сервер где обрабатываются запросы в БД

<?php
define("DB_HOST", "localhost");
define("DB_LOGIN", "root");
define("DB_PASSWORD", "000000");
define("DB_NAME", "users");


mysql_connect(DB_HOST, DB_LOGIN, DB_PASSWORD);
mysql_select_db(DB_NAME);



if ($_SERVER['REQUEST_METHOD'] == 'GET') {
    $result = mysql_query("select * from `name` ");

    $data = array();

    while ($row = mysql_fetch_array($result)) {
      $data[] = $row;
    }
        print json_encode($data);
}

if ($_SERVER['REQUEST_METHOD'] == "POST") {
  $data = json_decode(file_get_contents("php://input"));
  $name = mysql_real_escape_string($data->name);
  $email = mysql_real_escape_string($data->email);
  $telephone = mysql_real_escape_string($data->telephone);
  $city = mysql_real_escape_string($data->city);
  $address = mysql_real_escape_string($data->address);
  $state = mysql_real_escape_string($data->state);
  $zip = mysql_real_escape_string($data->zip);



  $sql = "INSERT INTO `name`(`name`)VALUES('".$name."')";
  mysql_query($sql) or die(mysql_error());
} 

if($_SERVER['REQUEST_METHOD'] == 'DELETE')
{
  $params = array();
  parse_str(file_get_contents('php://input'), $params);
   $id = $params['id'];
  
  $sql = "DELETE FROM name
      WHERE id = $id";
  mysql_query($sql) or die(mysql_error());
  
}


    

?>

Вывод и добавление работают правильно, а вот удаление нет, но и ошибок никаких не выдает, если нажать на кнопку удалить, то вроде все правильно работает если посмотреть в консоль, запрос вроде срабатывает, и id нужный тоже получает, пожалуйста кто понимает в чем дело объясните а то надо уже сдавать работу, и все уже готово, только вот тут уперся в тупик...(