漏刻有时API接口实战开发系列(7)：PHP将API获取的json数据自动同步到mysql数据库的解决方案

通过API端口将获取JSON数据

   //执行获取json数据;
        $content = posturl($url, $data, $webAPI);
        $dataInfo = $content["data"];

将JSON数据同步到mysql数据库；

1. 判断唯一ID，是否在数据库中存在；
2. 存在，则执行更新操作；
3. 不存在，则执行添加操作；

 //将数据复制到对应的数据库;
        for ($i = 0; $i fetch('battle', 'member_id,data_id', array('data_id' => trim(addslashes($dataInfo[$i]["_id"]))), ' member_id DESC');
            if (!$row) {//如果不存在数据，则新增数据;
                $db->insert('battle', array('data_id' => $data_id, 'member_scan' => $member_scan, 'member_depart' => $member_depart, 'member_serial' => $member_serial, 'member_name' => $member_name, 'member_nation' => $member_nation,
                    'member_uties' => $member_uties, 'member_driving' => $member_driving, 'member_grade' => $member_grade, 'member_birth' => $member_birth, 'member_enlist' => $member_enlist,
                    'member_political' => $member_political, 'member_native' => $member_native, 'user_name' => $user_name, 'submit_time' => $submit_time, 'update_time' => $update_time));
            } else { //如果已经存在改数据，则更新数据;
                $db->update('battle', array('member_scan' => $member_scan, 'member_depart' => $member_depart, 'member_serial' => $member_serial, 'member_name' => $member_name, 'member_nation' => $member_nation,
                    'member_uties' => $member_uties, 'member_driving' => $member_driving, 'member_grade' => $member_grade, 'member_birth' => $member_birth, 'member_enlist' => $member_enlist,
                    'member_political' => $member_political, 'member_native' => $member_native, 'user_name' => $user_name, 'update_time' => $update_time), "data_id='" . $row['data_id'] . "'");
            }
        }

Done！