AngularJS connecting to Arrest-MySQL not working for PUT and POST

[roestigraben]

Hello,

Iam learning AngularJS and started to do an application (really more following a tutorial) that implements CRUD services. So, I have seen Arrest-MySQL and was happy to see a simple yet powerful REST API easy to use.
The GET methods were uo and running quite quickly, as well as the DELETE operations. Then problems started with PUT. As PUT did not work, I tried to try with POST first, but here I got into problems.

Maybe somebody can give the fight hints on how to proceed. (I must say that I am not at all an expert in php)

In order to understand better, I did try to interface with the API with the help of a REST Console (Actually I tried with REST Console 4.0.2 and Simple Rest Console)
Funnily, PUT was working great, but POST did not on both :-(

I past hereunder the network activity on PUT and POST. Several difference are notable
The RequestURL, the PUT, the request payload are differnet to a certain extent.

MAny thanks for any help
Peter

PUT coming from my AngularJS App. There is a response saying code 200: success, but the database is not updated.

Request URL:http://localhost:8888/angular18/api/allIP/16name=USB2PHY1port&provider=TR%26D
Request Method:PUT
Status Code:200 OK
Request Headersview parsed
PUT /angular18/api/allIP/16?name=USB2PHY1port&provider=TR%26D HTTP/1.1
Host: localhost:8888
Connection: keep-alive
Content-Length: 789
Accept: application/json, text/plain, /
Origin: http://localhost:8888
X-Requested-With: XMLHttpRequest
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_6_8) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.110 Safari/537.36
Content-Type: application/json;charset=UTF-8
Referer: http://localhost:8888/angular18/
Accept-Encoding: gzip,deflate,sdch
Accept-Language: en-US,en;q=0.8
Cookie: SQLiteManager_currentLangue=2
Query String Parametersview parsed
name=USB2PHY1port&provider=TR%26D
Request Payloadview parsed
{"id":"16","name":"USB2PHY1port","provider":"TR&D","technology":"40LP","cost":"250","description":"specifically done for STE project AVU9600. 1V8 GO2 compatible","type":"USB2.0 PHY","maturity_status":"MAT5","status_date":"Q1/11","next_Maturity":"MAT10","next_Date":"Q3/11","startMAT10":"Q1/11","completeMAT10":"Q3/11","completeMAT20":"Q2/12","HED":"n","HED_criticality":"","HED_MAT20_request":"Q1/11","CCI":"y","CCI_criticality":"","CCI_MAT20_request":"Q1/11","STE":"y","STE_criticality":"2","STE_MAT20_request":"Q2/11","APG":"n","APG_criticality":"3","APG_MAT20_request":"Q1/11","IMS":"n","IMS_criticality":"1","IMS_MAT20_request":"Q1/11","contactName1":"Adrian","contactName2":"","reserved1":"23345","reserved2":"334-88","reserved3":"Tue Feb 21 21:41:50 GMT+0100 2012","reserved4":"LYS"}
Response Headersview parsed
HTTP/1.1 200 OK
Date: Sat, 29 Jun 2013 06:56:28 GMT
Server: Apache/2.2.21 (Unix) mod_ssl/2.2.21 OpenSSL/0.9.8x DAV/2 PHP/5.3.6
X-Powered-By: PHP/5.3.6
Content-Length: 44
Keep-Alive: timeout=5, max=100
Connection: Keep-Alive
Content-Type: application/json

Here is the PUT method (albeit not on the same id in the database) done with the console and which is successful

Request URL:http://localhost:8888/angular18/api/allIP/18
Request Method:PUT
Status Code:200 OK
Request Headersview parsed
PUT /angular18/api/allIP/18 HTTP/1.1
Host: localhost:8888
Connection: keep-alive
Content-Length: 46
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_6_8) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/27.0.1453.110 Safari/537.36
Origin: chrome-extension://fhjcajmcbmldlhcimfajhfbgofnpcjmb
Content-Type: application/xml
Accept: /
Accept-Encoding: gzip,deflate,sdch
Accept-Language: en-US,en;q=0.8
Cookie: SQLiteManager_currentLangue=2
Request Payload
name=hansnew&provider=synopsys&technology=28lp
Response Headersview parsed
HTTP/1.1 200 OK
Date: Sat, 29 Jun 2013 07:18:03 GMT
Server: Apache/2.2.21 (Unix) mod_ssl/2.2.21 OpenSSL/0.9.8x DAV/2 PHP/5.3.6
X-Powered-By: PHP/5.3.6
Content-Length: 44
Keep-Alive: timeout=5, max=100
Connection: Keep-Alive
Content-Type: application/json

[nmstoker]

Maybe you've abandoned this (it's been a while!) but as I'm facing similar issues, thought I'd mention one point: I believe it's useful to look at the actual JSON response returned, not just the HTTP response (which is 200 in your case above).

I get a 200, but looking at the content of the response, I get what's shown in the README.md, as:

{ "error": { "message": "No Content", "code": 204 } }

I'm no PHP guru myself, but am trying to figure out what's going wrong... no break-through so far though!

[nmstoker]

Sorry - just saw the discussion at the end of #1 where you seem to have found the cause of the problem

[roestigraben]

Hi Neil,

it¹s been a while indeed. Many thanks to try to help

I found my way around in between.
I could explain what I did if you are interested .
Just let me know and give me a little time to respond as i am very busy
currently (say over the weekend)

BR
Peter

From: Neil Stoker [email protected]
Reply-To: gilbitron/Arrest-MySQL
<reply+i-16172179-abc8ac87bb60f7c5236db1169bc9986a2716f1cd-4879307@reply.git
hub.com>
Date: Monday 28 April 2014 19:05
To: gilbitron/Arrest-MySQL [email protected]
Cc: roestigraben [email protected]
Subject: Re: [Arrest-MySQL] AngularJS connecting to Arrest-MySQL not
working for PUT and POST (#4)

been

[roestigraben]

As said, don¹t hesitate to ask how I did it

From: Neil Stoker [email protected]
Reply-To: gilbitron/Arrest-MySQL
<reply+i-16172179-abc8ac87bb60f7c5236db1169bc9986a2716f1cd-4879307@reply.git
hub.com>
Date: Monday 28 April 2014 19:08
To: gilbitron/Arrest-MySQL [email protected]
Cc: roestigraben [email protected]
Subject: Re: [Arrest-MySQL] AngularJS connecting to Arrest-MySQL not
working for PUT and POST (#4)

Sorry - just saw the discussion at the end of #1
#1 where you seem to have
found the cause of the problem

‹
Reply to this email directly or view it on GitHub
#4 (comment) .

[nmstoker]

Hi Peter,

If you could give details that would be really helpful - of course, only when it suits and things are less busy for you!

Many thanks,
Neil

[roestigraben]

PUT and POST are different from GET and DELETE as they move actual data from the application to the database. AngularJS and jQuery Ajax are different in that AngularJS uses JSON dataformat while jQuery uses like the concatenation of the key=value pairs as id=33&title=myTitle&.......

For those two methods I finally use the $http service rather than $resource.

I also force the headers to be specifically like below
headers: {'Content-Type': 'application/x-www-form-urlencoded'}

the code to add a new record is then

var CreateCtrl = function ($scope, $location, $http, Todo) {
$scope.save = function(){
// use a variable dataConstruct to construct the payload
var dataConstruct = ('name=' + $scope.item.name + '&provider=' + $scope.item.provider + '&technology=' + $scope.item.technology);
//console.log(dataConstruct);
$http({method: 'POST',
url: 'api/allIP',
data: dataConstruct,
headers: {'Content-Type': 'application/x-www-form-urlencoded'}
}).
success(function(data, status) {
$scope.status = status;
$scope.data = data;
$location.path('/');
}).
error(function(data, status) {
$scope.data = data || "Request failed";
$scope.status = status;
});
};
};

I hope this brings you one step forward

[nmstoker]

Hi Peter,
This is very helpful - thank you for sharing the details!
Kind regards,
Neil