ansaurus

Question

Answer 1

A:

Assuming you have the XML stored in a variable name $xmlString and the user id in the variable $user_id you could use the following code:

$delete = "http://www.ourwiki.com/@api/DELETE:users/$user_id/properties/%s";
$xml = new SimpleXMLElement($xmlString);

foreach($xml->property as $property) {
  $name = $property['name']; // the name is stored in the attribute
  file_get_contents(sprintf($delete, $name));
}

Or if you know all the possible properties it would be easier to have a function which does all those calls in one go without the need to read the properties prior.

$properties = array(); // array of property names
$delete = "http://www.ourwiki.com/@api/DELETE:users/$user_id/properties/%s";

foreach($properties as $property) {
  $name = $property['name'];
  file_get_contents(sprintf($delete, $name));
}

mhitza 2010-08-18 09:03:12

Thanks, I will try this. Apparently when making a call to /properties it will list all the properties associated with the user. The user properties is key value where the key and value can be anything so there is no way of being able to know all options unfortunately.

Aaron 2010-08-18 17:33:38

I understand that I need to get the XML which I believe is done by calling api (http://www.ourwiki.com/@api/users/=john_smith%40ourwiki.com/properties) But how would I take that response and store it in a variable? It would be great if a user could type in email and it would make the call to get xml and perform the delete.

Aaron 2010-08-18 17:47:13

By issuing a call to the `file_get_contents('ourwiki.com/@api/users/=john_smith%40ourwiki.com/properties')` will return the XML, which afterwards you can pass to the `SimpleXMLElement` class.

mhitza 2010-08-18 18:44:24

Ok cool, so I can just assign this to the $xmlString and SimpleXMLElement should be able to read it?

Aaron 2010-08-18 19:17:58

Yes, that is all to it.

mhitza 2010-08-18 19:34:49

would it be easy to add a place for a user to type in the username and it pass that to the $userid? the username will be in the form [email protected]

Aaron 2010-08-19 16:31:22

So I'm trying to run this script on the server but i'm not having much luck. When trying to troubleshoot where the problem is, it doesn't seem to be giving me the properties when I do #xmlString=file_get_contents('ourwiki.com/@api/users/=john_smith%40ourwiki.com/properties'). I've tried to echo xmlString and it is empty, however when i run ourwiki.../properties directly it gives me the xml

Aaron 2010-08-19 22:22:33

The `allow_url_fopen` option may be disabled in your environment. Make sure to check the `phpinfo()` information for this case. If so, you should go the other way around: opening a socket, making a request, and parsing the response.

mhitza 2010-08-19 22:27:26

allow_url_fopen says On for Local and Master values. I even tried testing using ini_get which tells me that its enabled. Does this mean I still would need to open socket, make request, etc? Also, I tried using wget on the server with ourwiki.com/.../properties, it connects, says HTTP request sent, awaiting response...401 Unauthorized Authorization failed. Could this be part of the problem? I'm not sure if wget will work since we're talking about getting xml but its just a thought. Any ideas?

Aaron 2010-08-20 19:26:12

So i've been testing this on a VM and I've gotten much further. I was having an failed to open stream, and by supplying credentials it allowed file_get_contents to work! Now, it is telling me, "Warning: sprintf() Too few arguments" Do you know how I could fix this by any chance?

Aaron 2010-08-25 14:36:44

Check that both `$delete` and `$property` hold the values they should, no `null` values.

mhitza 2010-08-25 22:40:35

Whats the best way to check for that? It almost seems that each entry has this "too few arguments" since it printed it about 30 times when I tried running the script. I did attempt the api call for properties on a test user and the name is always set to an actual value so its not empty. Not sure if that helps at all.

Aaron 2010-08-26 00:33:36

`var_dump(array($delete, $property))` inside the loop.

mhitza 2010-08-26 00:52:17

Thanks, i'll have to do this once i get to work in the morning since i don't have access to the VM now. I'll update you with the results.

Aaron 2010-08-26 01:13:05

I just added a link above at the end of the post, it includes what is returned after checking $delete and $property values. Before it you'll see var_dump($xmlString) just in case you weren't sure.

Aaron 2010-08-26 12:45:14

I've edited my code. As it turned out I didn't read the attribute name in the second example.

mhitza 2010-08-26 12:51:39

I was actually using the first example, since we aren't able to know all the possible properties. Is there something I might need to change there?

Aaron 2010-08-26 13:45:16

Aha, I suspect he `%40` in the url, replace it with `@`

mhitza 2010-08-26 13:59:37

Closer...the warning went away and now it just looks to be hanging on the api call with DELETE. It is saying, "failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found" This is what I have for $delete... $delete = "http://admin:[email protected]/@api/DELETE:users/$user_id/properties/%s"

Aaron 2010-08-26 14:06:24

So I was given an example of deleting property with curl (property "foo") curl -u username:password -X DELETE -i http://server.address/@api/pages/=bar/properties/foo . Is this something we could incorporate instead of using the current DELETE call as we have it? Apparently this is "supposed" to work

Aaron 2010-08-26 16:53:53

ansaurus

tags:

views:

answers:

Using Delete call through API in PHP

related questions