php - 使用 curl 获取成功消息后更新数据库中的值

Question

使用 curl 在 url 中传递值后，我收到以下消息：

{"AddManifestDetails":[{"AuthKey":"Valid","ReturnMessage":"successful",}]

如果ReturnMessage 成功，那么我想更新数据库中的值，我尝试了以下代码：

<?php

$data = 
array (
'OrderNo' => $order_id,
'AirWayBillNO' => $resultc[0]['awb'],
);

$url = "http://114.143.206.69:803/StandardForwardStagingService.svc/AddManifestDetails";

$data = json_encode($data);
$curl = curl_init($url);

curl_setopt($curl, CURLOPT_POSTFIELDS, $data);

$curl_response = curl_exec($curl);
curl_close($curl);
echo $curl_response ."\n";
$res=json_decode($curl_response);

foreach ($res->curl_response as $values) 
{
if($values->ReturnMessage=='successful')
    {
      $usql="update  do_order set tracking_id='".$resultc[0]['awb']."',shipping_name='xpress', where order_id='".$order_id."'";       
      $result=$db_handle->executeUpdate($usql);  
      echo "1";die;
    }
    else
    {
      echo $values->ReturnMessage;die;
    }
}

这是完整的代码：https ://pastebin.com/EvcEY0xp

结果：

注意：未定义的属性：stdClass::$curl_response

警告：为 foreach() 提供的参数无效

标签： phpcurl

Answer 1

$res将已经包含来自 curl 请求的解码响应，该响应只有 1 个属性 - AddManifestDetails。

尝试以下操作：

<?php

$data = 
array (
'OrderNo' => $order_id,
'AirWayBillNO' => $resultc[0]['awb'],
);

$url = "http://114.143.206.69:803/StandardForwardStagingService.svc/AddManifestDetails";

$data = json_encode($data);
$curl = curl_init($url);

curl_setopt($curl, CURLOPT_POSTFIELDS, $data);

$curl_response = curl_exec($curl);
curl_close($curl);
echo $curl_response ."\n";
$res=json_decode($curl_response);

if($res->AddManifestDetails[0]->ReturnMessage=='successful')
{
    $usql="update  do_order set tracking_id='".$resultc[0]['awb']."',shipping_name='xpress' where order_id='".$order_id."'";       
    $result=$db_handle->executeUpdate($usql);  
    echo "1";
    die;
}
else
{
    echo $res->AddManifestDetails[0]->ReturnMessage;
    die;
}