Delete row in database using angular js

Question

I want delete when click in button , but my code not work . Here is my code html

<tr class="row" ng-repeat="data in vm.mydata >
                <td class="col-md-1"> <span>{{data.masp}}</span></td>
                <td class="col-md-1"> <span>{{data.hangsx}}</span></td>
        </tr>
    <i class="fa fa-trash-o fa-2x" aria-hidden="true" ng-click="vm.delete(data.masp)"></i>

angular

function dsController($http){
        var vm =this;
$http.get('/project/app/server/data/data.php')
             .then(onSuccess);

        function onSuccess(response){
            vm.mydata = response.data.records;
        } 
vm.delete = function(value){
            $http({
                method:'POST',
                url:'/project/app/server/action/xoa.php',
                data:({value:value}),
                headers : { 'Content-Type': 'application/x-www-form-urlencoded' }
            }).then(onSuccess,onError);
            function onSuccess(){
            $http.get('/project/app/server/data/data.php')
                .then(function(data){
                    vm.mydata = data.data.records;
                })
}

and here is php code : xoa.php

    //connect db
    if(!empty($_POST['value'])){
    $masp = $_POST['value'];
    $sql = "DELETE FROM sanpham WHERE masp= '$masp'";
    $result = mysqli_query($conn,$sql);
   if($result){
  echo 'OK';

} data.php

$rows = array();
if($result){
while($r = mysqli_fetch_assoc($result)) {
    $rows[] = $r;
}
print '{"records":' .json_encode($rows) ."}";

Where is my wrong . Pls help me

Why are you making an HTTP POST request for deleting an object? You should use HTTP DELETE. — Ben
– Ben, Commented Mar 27, 2017 at 16:29
Your above code seems fine. Can you please share the error if you are getting any? Or please confirm from db table that record deleted or not? — Mahesh Singh Chouhan
– Mahesh Singh Chouhan, Commented Mar 27, 2017 at 16:34
I think you forgot to add this line which you added just now? $result = mysqli_query($conn,$sql); — Mahesh Singh Chouhan
– Mahesh Singh Chouhan, Commented Mar 27, 2017 at 16:36
I change to delete but not work to . and data not remove from the table , and no error — Nguyễn Bảo Dũng
– Nguyễn Bảo Dũng, Commented Mar 27, 2017 at 16:36

Akashii · Accepted Answer · 2017-03-28 06:26:24Z

1

In html you add

vm.delete(data.masp,$index)

in js you change

vm.delete = function(value,index)
{
method:'GET',
url:'/project/app/server/data/data.php?value=' +value
}

answered Mar 28, 2017 at 6:26

Akashii

2,2815 gold badges19 silver badges32 bronze badges

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

Comments

coderwill · Accepted Answer · 2017-03-28 06:32:37Z

0

try like this :

                               vm.delete  = function (value) {
                                    var Response = $http({
                                        method:'POST',
                                            url:'/project/app/server/action/xoa.php',
                                            data:{value: JSON.stringify(value)},
                                    });
                                    return Response;
                                }

answered Mar 28, 2017 at 6:32

coderwill

8444 gold badges19 silver badges40 bronze badges

Collectives™ on Stack Overflow

Delete row in database using angular js

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related