As a newcomer to both AngularJS and PHP, I have been struggling to find comprehensive documentation on using $resource to update records in a database. While I did come across a helpful tutorial here that covers most aspects of $resource usage, I am having difficulty with updating and deleting records in the database.
Below is my code for the resource service:
var configServices = angular.module("configServices", []);
configServices.factory('Category', ['$resource', function($resource){
return $resource("/configurator/api/categories/:id", {id:"@category_id"},
{update:{
mothod: 'PUT',
isArray: false
}
})
}])
This is my service code:
this.updateCategory = function(_data){
var newUpdate = Category.get({id:_data.category_id}, function(result){
newUpdate.data = _data;
newUpdate.$update(function(res){
console.log("Got respose from update call" + res);
})
})
}
While I have been following the tutorial closely, I am still unable to successfully update or delete records in the database. Any assistance in identifying where I may be going wrong would be greatly appreciated.
PHP:
private function updateCategory($data){
$_id = implode("", $this->args);
$query = "UPDATE cg_category SET category_name = '$data[category_name]' WHERE category_id = '$data[category_id]'";
$result = mysqli_query($this->db, $query) or mysql_error();
if($result)
{
$this->response($this->json(array("Success" => true)), 200);
}
}