在下面的代码中,我试图为“ OrderNo & AWB ”动态传递值。
$sql="SELECT order_id , alternateno FROM do_order";
$con=mysqli_connect("localhost","root","","do_management");
if ($result=mysqli_query($con,$sql))
{
while ($row=mysqli_fetch_row($result))
{
$data =
array (
'OrderNo' => '$row[order_id]',
'ManifestDetails' =>
array (
'AWB' => '$row[alternateno]',
'PaymentStatus' => 'COD',
),
);
}
mysqli_free_result($result);
}
mysqli_close($con);
$url = "http://1234.1234.1234.1234";
$data = json_encode($data);
$curl = curl_init($url);
$curl_response = curl_exec($curl);
curl_close($curl);
echo $curl_response ."\n";
每次在浏览器中调用 URL 时,都会显示以下错误消息:
"ReturnMessage":"具有相同订单 ID ($row[order_id]) 的 AWB no 已经存在","AWBNo":"$row[alternateno]"
但是,如果我为OrderNo
(16445) & AWB
(16445)提供静态值,则它可以正常工作:
"ReturnMessage":"成功","AWBNo":"16445"
所以看来我没有正确传递值,请指导我。
mysqli_fetch_row()
生成索引数组的数组。使用[0]
fororder_id
和[1]
for的列索引访问结果集数据alternateno
。您还必须在存储$row[0]
和$row[1]
in时删除单引号$data
。
现在,您的查询将返回一个包含n行的结果集。您的while()
循环将覆盖、覆盖和覆盖,$data
并且仅保留最终迭代的行数据。
如果要将所有行的数据存储到$data
,请写入$data[]
以将新行数据推送到$data
数组中。
未经测试的代码:
if (!$con = mysqli_connect("localhost", "root", "", "do_management")) {
echo "connection error";
} elseif (!$result = mysqli_query($con, "SELECT order_id, alternateno FROM do_order")) {
echo "query error";
} else {
$url = "http://114.143.206.69:803/StandardForwardStagingService.svc/AddManifestDetails";
while ($row = mysqli_fetch_row($result)) { // fetch_row does not generate associative keys
$data = [
'OrderNo' => $row[0],
'ManifestDetails' => ['AWB' => $row[1], 'PaymentStatus' => 'COD']
];
$curl = curl_init($url);
curl_setopt($curl, CURLOPT_HTTPHEADER, ["Content-Type: application/json"]);
curl_setopt($curl, CURLOPT_HTTPAUTH, CURLAUTH_BASIC);
curl_setopt($curl, CURLOPT_RETURNTRANSFER, true);
curl_setopt($curl, CURLOPT_POST, true);
curl_setopt($curl, CURLOPT_POSTFIELDS, json_encode($data));
curl_setopt($curl, CURLOPT_SSL_VERIFYPEER, false);
curl_setopt($curl, CURLOPT_VERBOSE, true);
$curl_response = curl_exec($curl);
curl_close($curl);
echo $curl_response ."\n";
}
mysqli_free_result($result);
}
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句