json loop php with array without id

Question

I have this json array without id and variable email number:

Array contains multiple email separated by a comma:

[{"email":"[email protected]","timestamp":1516820089,"smtp-id":"\u003c14c5d75ce93.dfd.64b469@ismtpd-555\u003e","event":"processed","category":"cat facts","sg_event_id":"FDl9L7nP4zJXgLYUGhqqoA==","sg_message_id":"14c5d75ce93.dfd.64b469.filter0001.16648.5515E0B88.0"},
 {"email":"[email protected]","timestamp":1516820089,"smtp-id":"\u003c14c5d75ce93.dfd.64b469@ismtpd-555\u003e","event":"deferred","category":"cat facts","sg_event_id":"jbtTInm9Pej80gzRXRg9Pg==","sg_message_id":"14c5d75ce93.dfd.64b469.filter0001.16648.5515E0B88.0","response":"400 try again later","attempt":"5"},
 {"email":"[email protected]","timestamp":1516820089,"smtp-id":"\u003c14c5d75ce93.dfd.64b469@ismtpd-555\u003e","event":"delivered","category":"cat facts","sg_event_id":"XUBvHRS8T0eD_Eea8IECDA==","sg_message_id":"14c5d75ce93.dfd.64b469.filter0001.16648.5515E0B88.0","response":"250 OK"},
 {"email":"[email protected]","timestamp":1516820089,"smtp-id":"\u003c14c5d75ce93.dfd.64b469@ismtpd-555\u003e","event":"open","category":"cat facts","sg_event_id":"Wp2888u5ZaJX7Pd-_DbFpA==","sg_message_id":"14c5d75ce93.dfd.64b469.filter0001.16648.5515E0B88.0","useragent":"Mozilla/4.0 (compatible; MSIE 6.1; Windows XP; .NET CLR 1.1.4322; .NET CLR 2.0.50727)","ip":"255.255.255.255"},
 {"email":"[email protected]","timestamp":1516820089,"smtp-id":"\u003c14c5d75ce93.dfd.64b469@ismtpd-555\u003e","event":"click","category":"cat facts","sg_event_id":"7iXIm9S5SAuhRmoy4QIZZg==","sg_message_id":"14c5d75ce93.dfd.64b469.filter0001.16648.5515E0B88.0","useragent":"Mozilla/4.0 (compatible; MSIE 6.1; Windows XP; .NET CLR 1.1.4322; .NET CLR 2.0.50727)","ip":"255.255.255.255","url":"http://www.sendgrid.com/"},
 {"email":"[email protected]","timestamp":1516820089,"smtp-id":"\u003c14c5d75ce93.dfd.64b469@ismtpd-555\u003e","event":"bounce","category":"cat facts","sg_event_id":"3HJSeIIA2FzBjQxXvlf2hQ==","sg_message_id":"14c5d75ce93.dfd.64b469.filter0001.16648.5515E0B88.0","reason":"500 unknown recipient","status":"5.0.0"},
 {"email":"[email protected]","timestamp":1516820089,"smtp-id":"\u003c14c5d75ce93.dfd.64b469@ismtpd-555\u003e","event":"dropped","category":"cat facts","sg_event_id":"8acL8P-wxlb0CJoxBEjYuQ==","sg_message_id":"14c5d75ce93.dfd.64b469.filter0001.16648.5515E0B88.0","reason":"Bounced Address","status":"5.0.0"},
 {"email":"[email protected]","timestamp":1516820089,"smtp-id":"\u003c14c5d75ce93.dfd.64b469@ismtpd-555\u003e","event":"spamreport","category":"cat facts","sg_event_id":"cgn6ggkYz1S7XT5D5nRo9w==","sg_message_id":"14c5d75ce93.dfd.64b469.filter0001.16648.5515E0B88.0"},
 {"email":"[email protected]","timestamp":1516820089,"smtp-id":"\u003c14c5d75ce93.dfd.64b469@ismtpd-555\u003e","event":"unsubscribe","category":"cat facts","sg_event_id":"suFV8ITF-9ND3j1SrlW-fA==","sg_message_id":"14c5d75ce93.dfd.64b469.filter0001.16648.5515E0B88.0"},
 {"email":"[email protected]","timestamp":1516820089,"smtp-id":"\u003c14c5d75ce93.dfd.64b469@ismtpd-555\u003e","event":"group_unsubscribe","category":"cat facts","sg_event_id":"KljxrqIWTvF0mEshFKnw1Q==","sg_message_id":"14c5d75ce93.dfd.64b469.filter0001.16648.5515E0B88.0","useragent":"Mozilla/4.0 (compatible; MSIE 6.1; Windows XP; .NET CLR 1.1.4322; .NET CLR 2.0.50727)","ip":"255.255.255.255","url":"http://www.sendgrid.com/","asm_group_id":10},
 {"email":"[email protected]","timestamp":1516820089,"smtp-id":"\u003c14c5d75ce93.dfd.64b469@ismtpd-555\u003e","event":"group_resubscribe","category":"cat facts","sg_event_id":"F7oTvsqxOIQyRWyLJeXIjA==","sg_message_id":"14c5d75ce93.dfd.64b469.filter0001.16648.5515E0B88.0","useragent":"Mozilla/4.0 (compatible; MSIE 6.1; Windows XP; .NET CLR 1.1.4322; .NET CLR 2.0.50727)","ip":"255.255.255.255","url":"http://www.sendgrid.com/","asm_group_id":10}]

And i need to create a while/loop for getting separate email data, i have also tried with

$obj = json_decode( file_get_contents( 'php://input' ) );
foreach ($obj as $value) {    
   $value->email;
}

but it return always and only the first or last value

It is a webhooks of sendgrid =) sendgrid.com/docs/API_Reference/Webhooks/index.html — Marcus J.Kennedy
– Marcus J.Kennedy, Commented Jan 24, 2018 at 19:25
Did you check if $obj has the expected content? I just checked the code without getting the data from input and it works. — trik
– trik, Commented Jan 24, 2018 at 19:28
Really, code for insert in mysql with pdo is incorrect for while, i have fixed and my code work =) — Marcus J.Kennedy
– Marcus J.Kennedy, Commented Jan 24, 2018 at 19:37
All of the email addresses in email are [email protected] so how do you know it's the first or last one??? — AbraCadaver
– AbraCadaver, Commented Jan 24, 2018 at 19:45

TCooper · Accepted Answer · 2018-01-24 21:25:30Z

2

This should work for you if you know your array keys, and it eliminates the double loop.

$array = json_decode(file_get_contents( 'php://input' ), true);
foreach($array as $innerArray){
    $emails[] = $innerArray['email'];
    //or do whatever you want with each email as $innerArray['email'], repeat for each key.
}

edited Jan 24, 2018 at 21:25

answered Jan 24, 2018 at 21:01

TCooper

1,9701 gold badge14 silver badges20 bronze badges

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

Comments

Kaddath · Accepted Answer · 2018-01-24 19:26:14Z

2

you can try like this:

$obj = json_decode( file_get_contents( 'php://input' ) );
foreach ($obj as $item) {
   $props = get_object_vars($item);
   foreach ($props as $key => $value) {
       /*do what you like with $key and $value */
   }
}

answered Jan 24, 2018 at 19:26

Kaddath

6,1511 gold badge11 silver badges24 bronze badges

3 Comments

TCooper Over a year ago

Looks good, but why not just use the true option in json_decode and get an array > an object to start with?

Kaddath Over a year ago

you'd still have to do 2 loops, but you're right, i just assumed he wanted objects from his code

TCooper Over a year ago

Oh wow. Just reread the question - I thought he only wanted the email addresses. Would probably be better to have keys too.

Collectives™ on Stack Overflow

json loop php with array without id

2 Answers 2

Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related