regex to extract this string or use json decode

Question

In PHP what would the regex be to extract "taken" from below, considering that it is dynamic and is always after status:

HTTP/1.0 200 OK
Date: Sat, 09 Feb 2013 23:07:09 GMT
Accept-Ranges: bytes
Server: Noelios-Restlet-Engine/1.1.7
Content-Type: application/json;charset=UTF-8
Content-Length: 147
X-Cache: MISS from geonisis-2.eurodns.com
X-Cache-Lookup: MISS from geonisis-2.eurodns.com:80
Via: 1.0 geonisis-2.eurodns.com (squid/3.1.10)
Connection: keep-alive

{"service":"availability","domain":"","timestamp":1360451229,"content":{"domainList":[{"status":"taken","name":""}]}}

The following shows that I should be using json decoded. How would one achieve this?

The above in generated using:

$process = curl_init($host);
curl_setopt($process, CURLOPT_HTTPHEADER, array('Content-Type: application/xml', $additionalHeaders));
curl_setopt($process, CURLOPT_HEADER, 1);
curl_setopt($process, CURLOPT_USERPWD, $username . ":" . $password);
curl_setopt($process, CURLOPT_TIMEOUT, 30);
curl_setopt($process, CURLOPT_POST, 1);
curl_setopt($process, CURLOPT_POSTFIELDS, $payloadName);
curl_setopt($process, CURLOPT_RETURNTRANSFER, TRUE);
$return = curl_exec($process);

better to parse the JSON string, and then select from the object — Billy Moon
– Billy Moon, Commented Feb 10, 2013 at 10:28
You could remove the header from the response by setting CURLOPT_HEADER to 0 (false) instead of 1 (true). — Supericy
– Supericy, Commented Feb 10, 2013 at 10:37

Supericy · Accepted Answer · 2013-02-10 10:36:18Z

3

Remove the header from the response by changing:

curl_setopt($process, CURLOPT_HEADER, false);

And then decode the JSON string with:

$data = json_decode($curlResponse, true);

answered Feb 10, 2013 at 10:36

Supericy

5,8911 gold badge23 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ranty · Accepted Answer · 2013-02-10 10:31:32Z

2

If you discard headers from the response, you can use:

$json = '{"service":"availability","domain":"","timestamp":1360451229,
"content":{"domainList":[{"status":"taken","name":""}]}}';
$data = json_decode($json, TRUE);
echo $data['content']['domainList'][0]['status'];

answered Feb 10, 2013 at 10:31

Ranty

3,3833 gold badges26 silver badges25 bronze badges

1 Comment

Ranty Over a year ago

Disable inclusion of header in the response: curl_setopt($process, CURLOPT_HEADER, FALSE); and you will get only the JSON string

itsid · Accepted Answer · 2013-02-10 10:33:01Z

1

Why care about the header? That's a JSON string, just decode it and you'll have an object that you can access easily

in php:

$jsonobj = json_decode('{"service":"availability","domain":"","timestamp":1360451229,    "content":{"domainList":[{"status":"taken","name":""}]}}');

in javascript:

var jsonobj = JSON.parse('{"service":"availability","domain":"","timestamp":1360451229,"content":{"domainList":[{"status":"taken","name":""}]}}');

answered Feb 10, 2013 at 10:33

itsid

8117 silver badges16 bronze badges

1 Comment

itsid Over a year ago

remove the header from the curl response curl_setopt($process, CURLOPT_HEADER, false); and just parse the response like above

Emanuil Rusev · Accepted Answer · 2013-02-10 10:49:43Z

$string = '
    HTTP/1.0 200 OK
    Date: Sat, 09 Feb 2013 23:07:09 GMT
    Accept-Ranges: bytes
    Server: Noelios-Restlet-Engine/1.1.7
    Content-Type: application/json;charset=UTF-8
    Content-Length: 147
    X-Cache: MISS from geonisis-2.eurodns.com
    X-Cache-Lookup: MISS from geonisis-2.eurodns.com:80
    Via: 1.0 geonisis-2.eurodns.com (squid/3.1.10)
    Connection: keep-alive

    {"service":"availability","domain":"","timestamp":1360451229,"content":{"domainList":[{"status":"taken","name":""}]}}';

$parts = explode("\n", $string);
$json = end($parts);
$data = json_decode($json);

$status = $data->content->domainList[0]->status; die;

echo $status;

Edit (based on the question update):

Remove the CURLOPT_HEADER line from your cURL request. This would simplify the response and make it easier to parse.

Kerem · Accepted Answer · 2013-02-10 10:48:50Z

0

If you need to work with headers, you have two options;

// first: regex
preg_match('~"status":"(.*?)"~i', $return, $match);
// print_r($match);
echo $match[1]; // taken

// second: json encode
$response = explode("\r\n\r\n", $return, 3);
// print_r($response);
$json_object = json_decode($response[2]);
$json_array  = json_decode($response[2], true); // toArray
// echo $json_object->content->domainList[0]->status;
echo $json_array['content']['domainList'][0]['status'];

answered Feb 10, 2013 at 10:48

Kerem

11.6k5 gold badges61 silver badges58 bronze badges

Collectives™ on Stack Overflow

regex to extract this string or use json decode

5 Answers 5

Comments

1 Comment

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

1 Comment

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related