接口问题

Question

已有接口网址：http://u**.zhi**.com/api/conlist?page=1&size=1，打开是json数据：{"status":1,"message":"操作成功","result":{"contractlist":[{"ContractNo":"C*55-20*04","NovelID":8821,"BookName":"测试保底","SiteType":201,"ContractByte":78,"TemplateName":"BD_Year","ContractStime":"2016年07月18日","ContractEtime":"2123年07月18日","ValidYear3":6,"UserNickName":"小甜*","TrueName":"张东","IDCard":"11***62","IDValidDate":"\/Date(63***000)\/","BankName":"中国工商银行","BankCardNo":"62***24","Tel":"18*480","QQ":"85*5","EditorName":""},{"ContractNo":"C*003","NovelID":8820,"BookName":"测试书","SiteType":201,"ContractByte":98,"TemplateName":"FC_Year","ContractStime":"2019年07月18日","ContractEtime":"2029年07月18日","ValidYear3":12,"UserNickName":"小甜*","TrueName":"张东","IDCard":"110**6462","IDValidDate":"\/Date(61***0000)\/","BankName":"中国工商银行","BankCardNo":"6225*24","Tel":"18*80","QQ":"85**45","EditorName":""},{"C************
怎么把这些数据插入到mysql数据库中呢？请指教 php小白、、、在线等、、

Answer 1

了解一下几个东西
1.如果GET 这个页面的json数据
2.如果将json数据转换成数组
3.如何遍历数组将数据插入mysql
2-3之间如果还有不明白的知识点就很多了，比如如何连接数据库,如何创建表.....希望你已经掌握这些知识.

Answer 2

你需要把你的这个json数据转换为数组， 然后数组循环遍历插入数据库

Answer 3

就是不知道接下来怎么写、找不到获取页面json数据兵转换的函数、没做过接口、不知道怎么写、求指导

Answer 4

$host = "你的接口网站地址";
$data = json_decode(file_get_contents($host),true);
var_dump($data);