angularjs 连接mysql_angularjs连接数据库查找删除操作

姓名	性别	年龄	操作

var app=angular.module('myApp',[]);

app.controller('myctrl',function($scope,$http){

$http({

method:'GET',

url:"php/angu_test_sel.php"

}).then(function successCallback(response){

$scope.list=response.data.msg;

},function errorCallback(response){

alert("数据请求失败");

});

$scope.del=function(event){

var id=event.target.getAttribute("uid");//获取当前对象的uid值

$http({

method:'GET',

params :{ id : id},//第一个id是后台php接受的参数名称  第二个id是本页面获取的删除的id值

url:"php/angu_test_del.php"

}).then(function successCallback(response){

window.location.reload();

},function errorCallback(response){

alert("删除失败");

});

}

})

header('Content-Type: text/html; charset=utf8');

$conn=mysql_connect("localhost","root","root");

mysql_query("use txt");

if($conn){

if($_GET){

$uid=$_GET["id"];

$sql="delete from test1 where userid=$uid";

$res=mysql_query($sql);

if($res>0){

echo '{"status":"1"}';

}else{

echo '{"status":"0"}';

}

}

}else{

echo '{"status":"-2"}';

}

mysql_close($conn);

?>

header('Content-Type: text/html; charset=utf8');

$conn=mysql_connect("localhost","root","root");

mysql_query("use txt");

if($conn){

$sql="select * from test1";

$res=mysql_query($sql);

if(mysql_num_rows($res)>0){

while($row=mysql_fetch_assoc($res)){

$arr[]= $row;

}

echo '{"status":"1","msg":'.json_encode($arr).'}';

}

}else{

echo '{"status":"-2";"msg":"fail to connect"}';

}

mysql_close($conn);

?>