PhP, Parse Json Element, Not in array

Question

I have following string. I need to extract just the Model: or the Orientaiton, or the Software and store as a variable. The problem I'm having is I don't know how to get individual variables. Any advice?

Model:  NIKON D200
Orientation:    0 
Resolution: 300.000 
ResolutionUnit: 2 
Software:   Nikon View 6.2.7 M
Date and Time:  2007:02:16 14:41:53
Exposure Time:  1/640 Sec
ISO Speed:  210
F Number:   8.0
Flash:  Yes, Strobe detected
Zoom Length:    32 mm
Exposure Program:   Manual
ISO Speed:  200 
Exposure Bias:  0.000 
Metering Mode:  Spot
Light Source:   Unknown
Zoom Length:    32 mm

explode on each line, then for each line explode on the first colon (ie. explode on colon, limit 2). Trim both sides, and use a foreach to find the "key" you want. — Niet the Dark Absol
– Niet the Dark Absol, Commented Dec 13, 2013 at 3:58
What you have there is not JSON. Please post the actual JSON data so we can better understand exactly what is needed to get the data you want. — Ken Herbert
– Ken Herbert, Commented Dec 13, 2013 at 3:58
@NiettheDarkAbsol To quote the question: "I have the following output in json". — Ken Herbert
– Ken Herbert, Commented Dec 13, 2013 at 3:59
@winterblood I fixed. I'm able to get everything as individual if it's an array, but not at ExifCamerainfo — user2600095
– user2600095, Commented Dec 13, 2013 at 4:00

craigmj · Accepted Answer · 2013-12-13 07:18:40Z

2

Here's a simple function to do the conversion to an associative array.

// Convert a series of key:value lines to an associative array
function KeyValueLinesToAssocArray($lines) {
    $linesArray = explode("\n", $lines);
    print("Entries: " . count($linesArray) . "<br />");
    $assoc = array();
    foreach ($linesArray as $kv) {
        $kvs = explode(":", $kv, 2);
        if (2>count($kvs)) continue;
        $assoc[trim($kvs[0])] = trim($kvs[1]);
    }
    return $assoc;
}

$data = <<<DATA
Model:  NIKON D200
Orientation:    0 
Resolution: 300.000 
ResolutionUnit: 2 
Software:   Nikon View 6.2.7 M
Date and Time:  2007:02:16 14:41:53
Exposure Time:  1/640 Sec
ISO Speed:  210
F Number:   8.0
Flash:  Yes, Strobe detected
Zoom Length:    32 mm
Exposure Program:   Manual
ISO Speed:  200 
Exposure Bias:  0.000 
Metering Mode:  Spot
Light Source:   Unknown
Zoom Length:    32 mm
DATA;

// Now split the ExifCameraInfo string into an associative array
$exif = KeyValueLinesToAssocArray($data);

print $exif["Model"];

edited Dec 13, 2013 at 7:18

answered Dec 13, 2013 at 4:06

craigmj

5,1172 gold badges21 silver badges22 bronze badges

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

5 Comments

user2600095 Over a year ago

I got that far; I want only the model or the orientation, etc. your solution prints out entire string, whereas I only want a single element. $camera = $decoded[0][IPTC]['ExifCameraInfo'];

craigmj Over a year ago

Ah, nice of you to downvote when your question is so vague. But easily fixed: split the string by newlines, break on first colon, then extract the appropriate values.

craigmj Over a year ago

Lol, no worries - somebody did! I think we're moving in different directions as you edit your post and I my answer ;-)

user2600095 Over a year ago

your above answer works great for the data variable you define above....for what i have it doesn't work for some reason...??

craigmj Over a year ago

Umm... I copied the data from your question above. Modify the function to : ` function KeyValueLinesToAssocArray($lines) { $linesArray = explode("\n", $lines); print("Entries: " . count($linesArray) . "<br />");` - see modification in code above. What does it print?

Collectives™ on Stack Overflow

PhP, Parse Json Element, Not in array

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related