这样的json数据如何解析

2012-05-16

这样的json数据怎么解析JScript codevar myTransActionsData {data: [ {stock_name: \u7231\u4ed5\

这样的json数据怎么解析

JScript code

var myTransActionsData = {'data': [ {'stock_name': "\u7231\u4ed5\u8fbe",'stock_symbol': '002403','transaction_time': '2010-09-10 09:32:31','flag': 'sell','price': '17.52','amount': '39900','display': 'black'}, {'stock_name': "\u7231\u4ed5\u8fbe",'stock_symbol': '002403','transaction_time': '2010-09-09 13:05:16','flag': 'buy','price': '17.65','amount': '39900','display': 'black'}, {'stock_name': "\u987a\u7f51\u79d1\u6280",'stock_symbol': '300113','transaction_time': '2010-09-07 10:53:08','flag': 'sell','price': '84.98','amount': '8300','display': 'black'}, {'stock_name': "\u987a\u7f51\u79d1\u6280",'stock_symbol': '300113','transaction_time': '2010-09-06 13:01:47','flag': 'buy','price': '79.80','amount': '8300','display': 'black'}, {'stock_name': "\u987a\u7f51\u79d1\u6280",'stock_symbol': '300113','transaction_time': '2010-09-03 09:31:08','flag': 'sell','price': '78.87','amount': '8300','display': 'black'}, {'stock_name': "\u987a\u7f51\u79d1\u6280",'stock_symbol': '300113','transaction_time': '2010-09-02 09:37:44','flag': 'buy','price': '75.54','amount': '8300','display': 'black'}, {'stock_name': "\u6d77\u683c\u901a\u4fe1",'stock_symbol': '002465','transaction_time': '2010-09-02 09:30:27','flag': 'sell','price': '49.10','amount': '13000','display': 'black'}, {'stock_name': "\u6d77\u683c\u901a\u4fe1",'stock_symbol': '002465','transaction_time': '2010-09-01 14:01:05','flag': 'buy','price': '49.54','amount': '13000','display': 'black'}, {'stock_name': "\u987a\u7f51\u79d1\u6280",'stock_symbol': '300113','transaction_time': '2010-09-01 13:46:08','flag': 'sell','price': '72.98','amount': '8800','display': 'black'}, {'stock_name': "\u987a\u7f51\u79d1\u6280",'stock_symbol': '300113','transaction_time': '2010-08-27 09:34:52','flag': 'buy','price': '64.16','amount': '8800','display': 'black'}, {'stock_name': "\u91d1\u53d1\u79d1\u6280",'stock_symbol': '600143','transaction_time': '2010-08-27 09:30:59','flag': 'sell','price': '10.99','amount': '52100','display': 'black'}, {'stock_name': "\u91d1\u53d1\u79d1\u6280",'stock_symbol': '600143','transaction_time': '2010-08-26 13:59:58','flag': 'buy','price': '10.92','amount': '52100','display': 'black'}, {'stock_name': "\u534e\u4ec1\u836f\u4e1a",'stock_symbol': '300110','transaction_time': '2010-08-26 10:35:36','flag': 'sell','price': '22.57','amount': '25300','display': 'black'}, {'stock_name': "\u534e\u4ec1\u836f\u4e1a",'stock_symbol': '300110','transaction_time': '2010-08-25 09:31:05','flag': 'buy','price': '23.88','amount': '25300','display': 'black'}, {'stock_name': "\u90d1\u7164\u673a",'stock_symbol': '601717','transaction_time': '2010-08-24 10:41:38','flag': 'sell','price': '32.63','amount': '18400','display': 'black'}],'count' : 541,pagesize: 15,'status' : '1000'}myTransActionsData['pages'] = Math.ceil(parseInt(myTransActionsData['count'])/parseInt(myTransActionsData['pagesize']))

我用这种方法

$str=file_get_contents($url);
$data=json_decode($str);
得不到数据。
我主要是想遍历data里面的数据，得到里面的值。

[解决办法]
主要是后面的【'count' : 541, pagesize: 15,】格式不对，要处理一下

PHP code

<?php$str=<<<JSON{ 'data': [ { 'stock_name': "\u7231\u4ed5\u8fbe", 'stock_symbol': '002403', 'transaction_time': '2010-09-10 09:32:31', 'flag': 'sell', 'price': '17.52', 'amount': '39900', 'display': 'black' }, { 'stock_name': "\u7231\u4ed5\u8fbe", 'stock_symbol': '002403', 'transaction_time': '2010-09-09 13:05:16', 'flag': 'buy', 'price': '17.65', 'amount': '39900', 'display': 'black' }, { 'stock_name': "\u987a\u7f51\u79d1\u6280", 'stock_symbol': '300113', 'transaction_time': '2010-09-07 10:53:08', 'flag': 'sell', 'price': '84.98', 'amount': '8300', 'display': 'black' }, { 'stock_name': "\u987a\u7f51\u79d1\u6280", 'stock_symbol': '300113', 'transaction_time': '2010-09-06 13:01:47', 'flag': 'buy', 'price': '79.80', 'amount': '8300', 'display': 'black' }, { 'stock_name': "\u987a\u7f51\u79d1\u6280", 'stock_symbol': '300113', 'transaction_time': '2010-09-03 09:31:08', 'flag': 'sell', 'price': '78.87', 'amount': '8300', 'display': 'black' }, { 'stock_name': "\u987a\u7f51\u79d1\u6280", 'stock_symbol': '300113', 'transaction_time': '2010-09-02 09:37:44', 'flag': 'buy', 'price': '75.54', 'amount': '8300', 'display': 'black' }, { 'stock_name': "\u6d77\u683c\u901a\u4fe1", 'stock_symbol': '002465', 'transaction_time': '2010-09-02 09:30:27', 'flag': 'sell', 'price': '49.10', 'amount': '13000', 'display': 'black' }, { 'stock_name': "\u6d77\u683c\u901a\u4fe1", 'stock_symbol': '002465', 'transaction_time': '2010-09-01 14:01:05', 'flag': 'buy', 'price': '49.54', 'amount': '13000', 'display': 'black' }, { 'stock_name': "\u987a\u7f51\u79d1\u6280", 'stock_symbol': '300113', 'transaction_time': '2010-09-01 13:46:08', 'flag': 'sell', 'price': '72.98', 'amount': '8800', 'display': 'black' }, { 'stock_name': "\u987a\u7f51\u79d1\u6280", 'stock_symbol': '300113', 'transaction_time': '2010-08-27 09:34:52', 'flag': 'buy', 'price': '64.16', 'amount': '8800', 'display': 'black' }, { 'stock_name': "\u91d1\u53d1\u79d1\u6280", 'stock_symbol': '600143', 'transaction_time': '2010-08-27 09:30:59', 'flag': 'sell', 'price': '10.99', 'amount': '52100', 'display': 'black' }, { 'stock_name': "\u91d1\u53d1\u79d1\u6280", 'stock_symbol': '600143', 'transaction_time': '2010-08-26 13:59:58', 'flag': 'buy', 'price': '10.92', 'amount': '52100', 'display': 'black' }, { 'stock_name': "\u534e\u4ec1\u836f\u4e1a", 'stock_symbol': '300110', 'transaction_time': '2010-08-26 10:35:36', 'flag': 'sell', 'price': '22.57', 'amount': '25300', 'display': 'black' }, { 'stock_name': "\u534e\u4ec1\u836f\u4e1a", 'stock_symbol': '300110', 'transaction_time': '2010-08-25 09:31:05', 'flag': 'buy', 'price': '23.88', 'amount': '25300', 'display': 'black' }, { 'stock_name': "\u90d1\u7164\u673a", 'stock_symbol': '601717', 'transaction_time': '2010-08-24 10:41:38', 'flag': 'sell', 'price': '32.63', 'amount': '18400', 'display': 'black' } ], 'count' : 541, pagesize: 15, 'status' : '1000' } JSON;$str=str_replace('\'','"',$str);$str=preg_replace('/"\s*:([^"]+),\s*"/',"\":\"$1\",\"",$str);print_r(json_decode($str,true)); 
 
[解决办法]
探讨
$str=preg_replace('/"\s*:([^"]+),\s*"/',"\":\"$1\",\"",$str);

这一句话的意思是？

[解决办法]
PHP code<?phpheader("Content-Type:text/html; Charset=UTF-8");$str = file_get_contents('http://app.vstock.jrj.com.cn/api/myTransaction/?uid=091220010012659154&size=15&page=19&exp_stock=&created_start=&created_end=&t=1337046299.426');preg_match('/\'data\': (.*),\s\'count\' : (\d*),\spagesize: (\d*),\s\'status\' : \'(\d*)\'/isU',$str,$match);$str = trim($match[1]);$str = str_replace("'", '"', $str);$data = json_decode($str);echo "<br />data:";print_r($data);echo "<br />count:" . $match[2];echo "<br />pagesize:" . $match[3];echo "<br />status:" . $match[4];?>
[解决办法]
探讨

你的原码可以
但是我用file_get_content  打开连接 得到的字符串就是不行。

CSS code

$url = 'http://app.vstock.jrj.com.cn/api/myTransaction/?uid=091220010012659154&amp;size=15&amp;page=19&amp;exp_stock=&amp;created_start=&a……

热点排行