PHP loop through data from external URL

Question

i have this content on an external URL:

{"sEcho":null,"iTotalRecords":97,"iTotalDisplayRecords":97,"aaData":[["<a href='#' onClick='return numberPortingShow(\"10621\");'><img border='0' class='tableImage' src='/ControlPanel/Images/Icon/application_view_icons.png' alt='View Porting Details' title='View Porting Details'/></a> <a href='#' onClick='return numberPortingShow(\"10621\");'>0123456789</a>","<a href='/ViewAccount?account_no=20726' target='_blank'>20726</a>","Single Analogue","19/05/2015 14:30","29/05/2015 17:00","Complete”],["<a href='#' onClick='return numberPortingShow(\"10621\");'><img border='0' class='tableImage' src='/ControlPanel/Images/Icon/application_view_icons.png' alt='View Porting Details' title='View Porting Details'/></a> <a href='#' onClick='return numberPortingShow(\"10621\");'>0987654321</a>","<a href='/ViewAccount?account_no=20726' target='_blank'>20726</a>","Single Analogue","19/05/2015 14:30","29/05/2015 17:00","Complete"]]}

how can i loop through this data in PHP, while reading it from an external URL

This looks like json encoded data. Use json_decode(). And have fun. Actually the headers you received from that url should have told you so. — arkascha
– arkascha, Commented Jul 19, 2015 at 18:44

marian0 · Accepted Answer · 2015-07-19 18:49:06Z

1

Your data looks like JSON string so use json_decode() and iterate over it.

$data = '{"sEcho":null,"iTotalRecords":97,"iTotalDisplayRecords":97,"aaData":[["<a href='#' onClick='return numberPortingShow(\"10621\");'><img border='0' class='tableImage' src='/ControlPanel/Images/Icon/application_view_icons.png' alt='View Porting Details' title='View Porting Details'/></a> <a href='#' onClick='return numberPortingShow(\"10621\");'>0123456789</a>","<a href='/ViewAccount?account_no=20726' target='_blank'>20726</a>","Single Analogue","19/05/2015 14:30","29/05/2015 17:00","Complete"],["<a href='#' onClick='return numberPortingShow(\"10621\");'><img border='0' class='tableImage' src='/ControlPanel/Images/Icon/application_view_icons.png' alt='View Porting Details' title='View Porting Details'/></a> <a href='#' onClick='return numberPortingShow(\"10621\");'>0987654321</a>","<a href='/ViewAccount?account_no=20726' target='_blank'>20726</a>","Single Analogue","19/05/2015 14:30","29/05/2015 17:00","Complete"]]}';
$dataArray = json_decode($data, true);
foreach ($dataArray as $key => $value) {
    var_dump($key);
    var_dump($value);
}

answered Jul 19, 2015 at 18:49

marian0

3,3573 gold badges31 silver badges38 bronze badges

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

4 Comments

charlie Over a year ago

in the $data variable, its commenting out some of it because of the # and its having some issues due to the ' and " - whats the best way to help this?

marian0 Over a year ago

@charlie I didn't notice, sorry. How you retrieve your data?

charlie Over a year ago

well, its coming from an external URL

marian0 Over a year ago

@charlie OK, and how you read it in your code? Are you using cURL or file_get_contents()?

Community · Accepted Answer · 2017-05-23 12:29:48Z

0

I think you need php curl, followed by json_decode.

References:

edited May 23, 2017 at 12:29

CommunityBot

11 silver badge

answered Jul 19, 2015 at 18:48

Sahil Ahuja

2,4931 gold badge17 silver badges12 bronze badges

Collectives™ on Stack Overflow

PHP loop through data from external URL

2 Answers 2

4 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related