使用Angular和PHP删除数据

Delete data with Angular and PHP

本文关键字：删除 数据 PHP Angular 使用      更新时间：2023-09-26

我想用PHP和Angular表单MySQL删除数据。这是我的代码：

角度

    $scope.delete = function(){
    that = this;
    $http.get("delete.php").success(function(data){
        $scope.users.splice(that.$index, 1)
    })
}

PHP

$data = json_decode(file_get_contents("php://input"));
$subject = mysql_real_escape_string($data->subject);
mysql_select_db("angular") or die(mysql_error());
$tbl="Customers";
$subject = $_GET ['index'];
$sql="DELETE FROM $tbl WHERE subject = '$subject'";
$result = mysql_query($sql, $con);
if($result){
    echo "Deleted Successfully";
}else {
    echo "ERROR";
}

数据库

I have a table "Customers" with subject and body cell

JavaScript代码工作正常，但刷新数据后仍然有效
我哪里错了？

如注释中所述，您的代码容易受到sql注入攻击

您需要将subject添加到您的请求中

角度

$scope.delete = function(){
var subject = // get subject somehow ...
that = this;
$http.get("delete.php?subject=" + subject)
   .success(function(data){
       $scope.users.splice(that.$index, 1)
    })
}

php

$tbl="Customers";
$subject = $_GET ['subject'];
$sql="DELETE FROM $tbl WHERE subject = '$subject'";
$result = mysql_query($sql, $con);
if($result){
    echo "Deleted Successfully";
}else {
    echo "ERROR";
}
相关文章：