2 回答

TA贡献1854条经验 获得超8个赞
您可以检查更新查询是否成功,如下所示:
if($tracking_result) {
$pendnig = "UPDATE orders SET status = 'Pending' WHERE id = '$id'";
$pending_result = $mysqli->query($pending);
}
希望对你有帮助。

TA贡献1818条经验 获得超8个赞
我已经用新代码修复了它。
$sql = "SELECT * FROM orders WHERE status = 'Waiting for tracking'";
$result = $mysqli->query($sql);
if($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
$id = $row['id'];
$tracking = $row['tracking'];
$carrier = $row['carrier'];
$link = $row['link'];
// get DOM from URL or file
$html = file_get_html($link);
// find td tags with data-qa=shipment-tracking-number
foreach($html->find('td[data-qa=shipment-tracking-number]') as $tracking)
$tracking = $tracking->plaintext;
// find td tags with data-qa=shipment-carrier
foreach($html->find('td[data-qa=shipment-carrier]') as $carrier)
$carrier = $carrier->plaintext;
if(isset($tracking)) {
$tracking = "UPDATE orders SET tracking = '$tracking' WHERE id = '$id'";
$tracking_result = $mysqli->query($tracking);
if($tracking_result === true) {
$pendnig = "UPDATE orders SET status = 'Pending' WHERE id = '$id'";
$pending_result = $mysqli->query($pendnig);
}
}
if(isset($carrier)) {
$carrier = "UPDATE orders SET carrier = '$carrier' WHERE id = '$id'";
$carrier_result = $mysqli->query($carrier);
}
// clean up memory
$html->clear();
unset($html);
}
}
- 2 回答
- 0 关注
- 132 浏览
添加回答
举报