~~~html $filename = "../public/static/data/location.txt";//文件相對路徑 $json_string = file_get_contents($filename);//讀取json內容 $data = json_decode($json_string); foreach ($data as $key =>$value){ Db::name('chorog_city')->insert((array)$value); } ~~~ *php*處理*json*字符串*插入數據庫*問題 *千次閱讀* 2019-03-29 15:37:53 # php?處理json字符串的問題 ~~~php <?php $json = '{"a":1,"b":2,"c":3,"d":4,"e":5}'; $jsonArr = json_decode($json, TRUE); extract($jsonArr); //數組中將變量導入到以當前符號表 echo "a=$a;b=$b;c=$c;d=$d;e=$e;"; ?> ~~~ 另外也可以像遍歷數組一樣遍歷得到的對象。 ~~~php <?php $json = '{"a":1,"b":2,"c":3,"d":4,"e":5}'; $jsonObj = json_decode($json); foreach($jsonObj as $jk=>$jv) { $$jk = $jv; } echo "a=$a;b=$b;c=$c;d=$d;e=$e;"; //也可得到相同的結果 ?> ~~~ ?另外通過[json\_decode](https://www.baidu.com/s?wd=json_decode&tn=SE_PcZhidaonwhc_ngpagmjz&rsv_dl=gh_pc_zhidao)獲得的json對象，也可以通過"$jsonObj->a"這樣的方式獲取其值。 ~~~php $json = '{"a":1,"b":2,"c":3,"d":4,"e":5}'; //已數組形式返回 $a = json_decode($json, TRUE); //為對應鍵值的變量賦值 foreach($a as $k=>$v){ eval('$'.$k.' = '.$v.';'); } //實測有效 echo $a; echo '<p>'; echo $b; echo '<p>'; echo $c; echo '<p>'; echo $d; echo '<p>'; echo $e; echo '<p>'; ~~~