我有一个外部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"]]}
如何在PHP中循环遍历这些数据,同时从外部URL
您的数据看起来像JSON字符串,所以使用json_decode()
并迭代它。
$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);
}
我认为你需要php curl,然后是json_decode。
引用:
- 通过curl从url获取JSON数据
- http://php.net/manual/en/function.curl-exec.php