douxiongye5779 2016-02-09 12:59
浏览 74

如何从API解析传入的JSON响应并使用PHP更新MySql数据库?

I am working on the backend panel of an e-commerce site and we are required to send order details to our Delivery vendor's REST API so that details get updated on their own dashboard and they schedule a pickup from our warehouse automatically. I have sent a JSON formatted request having the package details to which I have received a JSON success response back from the API.

Now I am facing an issue.

How can i parse this response and update my MySQL database according to it? The JSON response gets displayed on the website and It's just plain text. It's all on the frontend and goes away when i refresh the page.

Since I have no knowledge of what is the name of the POST parameter the response has, I cannot "catch" the json by PHP ( $_POST['...'] ) and manipulate it's content by using regular expressions.

I have to parse the contents of the response and update the package's "tracking_number" if API's response is "success", in MYSql database.

How to go about it? Am I being clear with my query?

HERE ARE THE IMAGES : The JSON being displayed right on the website

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 使用C#,asp.net读取Excel文件并保存到Oracle数据库
    • ¥15 C# datagridview 单元格显示进度及值
    • ¥15 thinkphp6配合social login单点登录问题
    • ¥15 HFSS 中的 H 场图与 MATLAB 中绘制的 B1 场 部分对应不上
    • ¥15 如何在scanpy上做差异基因和通路富集?
    • ¥20 关于#硬件工程#的问题,请各位专家解答!
    • ¥15 关于#matlab#的问题:期望的系统闭环传递函数为G(s)=wn^2/s^2+2¢wn+wn^2阻尼系数¢=0.707,使系统具有较小的超调量
    • ¥15 FLUENT如何实现在堆积颗粒的上表面加载高斯热源
    • ¥30 截图中的mathematics程序转换成matlab
    • ¥15 动力学代码报错,维度不匹配