php convert string with new lines into array?

Question

I am getting data from an API and the resulting string is

[RESPONSE]
PROPERTY[STATUS][0]=ACTIVE
PROPERTY[REGISTRATIONEXPIRATIONDATE][0]=2012-04-04 19:48:48
DESCRIPTION=Command completed successfully
QUEUETIME=0
CODE=200
RUNTIME=0.352

QUEUETIME=0
RUNTIME=0.8

EOF

I am trying to convert this into an array like

Array(
['PROPERTY[STATUS][0]'] => ACTIVE,
['CODE'] => 200,
...
);

So I am trying to explode it using the resulting file_get_content function with an explode like

$output = explode('=',file_get_contents($url));

But the problem is the returning values are not always returned in the same order, so I need to have it like $array['CODE'] = 200, and $array['RUNTIME'] = 0.352 however there does not seem to be any kind of new line characters? I tried \r\n, \n, <br>, \r\n\r\n in the explode function to no avail. But there is new lines in both notepad and the browser.

So my question is there some way to determine if a string is on a new line or determine what the character forcing the new line is? If not is there some other way I could read this into an array?

Czechnology · Accepted Answer · 2011-04-04 20:29:16Z

1

To find out what the breaking character is, you could do this (if $data contatins the string example you've posted):

echo ord($data[strlen('[RESPONSE]')]) . PHP_EOL;
echo ord($data[strlen('[RESPONSE]')+1]);          // if there's a second char

Then take a look in the ASCII table to see what it is.

EDIT: Then you could explode the data using that newly found character:

explode(ord($ascii_value), $data);

Btw, does file() return a correct array?

edited Apr 4, 2011 at 20:29

answered Apr 4, 2011 at 20:14

Czechnology

15k10 gold badges65 silver badges88 bronze badges

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

3 Comments

Czechnology Over a year ago

@Steven, when you have it's ASCII value, you can explode like this: explode(ord($ascii_value), $data);.

mario Over a year ago

+1 Nice approach. But he's not telling us what character it was(?). I demand to be told!!! :}

Capsule Over a year ago

LF, that's what I suggested in my answer, who the hell down-voted it?

Capsule · Accepted Answer · 2011-04-04 20:10:52Z

1

Explode on "\n" with double quotes so PHP understands this is a line feed and not a backslashed n ;-) then explode each item on =

answered Apr 4, 2011 at 20:10

Capsule

6,1531 gold badge24 silver badges28 bronze badges

2 Comments

Steven Over a year ago

"however there does not seem to be any kind of new line characters? I tried \r\n, \n, <br>, \r\n\r\n in the explode function to no avail. But there is new lines in both notepad and the browser." I tried that and it doesn't seem to be exploding. See lii.in/drop_catch.php for example

Capsule Over a year ago

Did you explode on '\n' or "\n"? The first one will fail

Matthew · Accepted Answer · 2011-04-04 20:11:25Z

1

Why not just use parse_ini_file() or parse_ini_string()?

It should do everything you need (build an array) in one easy step.

answered Apr 4, 2011 at 20:11

Matthew

48.5k11 gold badges90 silver badges101 bronze badges

2 Comments

Matthew Over a year ago

@mario, interesting that PHP only supports one set of brackets. That's a silly restriction that I was unaware of.

mario Over a year ago

I'm lookin at this from the upside: At least it supports one level of array syntax. Might not suffice in this case, but nice function to keep in mind.

Matteo Riva · Accepted Answer · 2011-04-04 20:14:02Z

0

Try

preg_split("/$/m", $str)

or

preg_split("/$\n?/m", $str)

for the split

answered Apr 4, 2011 at 20:14

Matteo Riva

25.1k13 gold badges75 silver badges105 bronze badges

Comments

mario · Accepted Answer · 2011-04-04 20:18:05Z

0

The lazy solution would be:

$response = strtr($response, "\r", "\n");
preg_match_all('#^(.+)=(.+)\s*$#m', $response, $parts);
$parts = array_combine($parts[1], $parts[2]);

Gives you:

Array (
 [PROPERTY[STATUS][0]] => ACTIVE
 [PROPERTY[REGISTRATIONEXPIRATIONDATE][0]] => 2012-04-04 19:48:48
 [DESCRIPTION] => Command completed successfully
 [QUEUETIME] => 0
 [CODE] => 200
 [RUNTIME] => 0.8

answered Apr 4, 2011 at 20:18

mario

146k20 gold badges243 silver badges293 bronze badges

Collectives™ on Stack Overflow

php convert string with new lines into array?

5 Answers 5

3 Comments

2 Comments

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

3 Comments

2 Comments

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related