Viewing a response to: @oflyhigh/mssql-json
好像在PHP可以把这串字符转到数组再读数据是不是？我也不太懂。我前在 @justyy 的贴“ https://steemit.com/cn/@justyy/steem-api-transfer-history-ifttt-slack-how-to-use-steem-api-transfer-history-and-ifttt-to-sync-to-slack” 里看到json_decode()函数，好像可以。但如果是mssql环境下，没用过，基本不懂了。。。我等着学习吧
| author | tvb |
|---|---|
| permlink | re-oflyhigh-mssql-json-20170815t152622053z |
| category | cn |
| json_metadata | {"tags":["cn"],"users":["justyy"],"links":["https://steemit.com/cn/@justyy/steem-api-transfer-history-ifttt-slack-how-to-use-steem-api-transfer-history-and-ifttt-to-sync-to-slack”"],"app":"steemit/0.1"} |
| created | 2017-08-15 15:26:30 |
| last_update | 2017-08-15 15:28:03 |
| depth | 1 |
| children | 1 |
| last_payout | 2017-08-22 15:26:30 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.000 HBD |
| curator_payout_value | 0.000 HBD |
| pending_payout_value | 0.000 HBD |
| promoted | 0.000 HBD |
| body_length | 238 |
| author_reputation | 35,691,294,295,540 |
| root_title | 请MSSQL高手指点一下JSON的问题 |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 11,889,474 |
| net_rshares | 0 |
额
| author | oflyhigh |
|---|---|
| permlink | re-tvb-re-oflyhigh-mssql-json-20170815t160229767z |
| category | cn |
| json_metadata | {"tags":["cn"],"app":"steemit/0.1"} |
| created | 2017-08-15 16:02:30 |
| last_update | 2017-08-15 16:02:30 |
| depth | 2 |
| children | 0 |
| last_payout | 2017-08-22 16:02:30 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.000 HBD |
| curator_payout_value | 0.000 HBD |
| pending_payout_value | 0.000 HBD |
| promoted | 0.000 HBD |
| body_length | 1 |
| author_reputation | 6,489,038,371,925,329 |
| root_title | 请MSSQL高手指点一下JSON的问题 |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 HBD |
| percent_hbd | 10,000 |
| post_id | 11,892,850 |
| net_rshares | 0 |
hiveblocks