已有接口网址: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小白、、、在线等、、
怎么把这些数据插入到mysql数据库中呢?请指教 php小白、、、在线等、、
1.如果GET 这个页面的json数据
2.如果将json数据转换成数组
3.如何遍历数组将数据插入mysql
2-3之间如果还有不明白的知识点就很多了,比如如何连接数据库,如何创建表.....希望你已经掌握这些知识.
$host = "你的接口网站地址";
$data = json_decode(file_get_contents($host),true);
var_dump($data);