prepare("INSERT INTO rockai_task_imagelist
(id, status, progress, thumb, url, submitTime, startTime, finishTime, source_cmd,cmd)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?,?)
ON DUPLICATE KEY UPDATE
status = VALUES(status),
progress = VALUES(progress),
thumb = VALUES(thumb),
url = VALUES(url),
submitTime = VALUES(submitTime),
startTime = VALUES(startTime),
finishTime = VALUES(finishTime),
source_cmd = VALUES(source_cmd),
cmd = VALUES(cmd)");
// 绑定参数
$stmt->bind_param("isssssssss", $taskId, $status, $progress, $thumb, $url, $submitTime, $startTime, $finishTime, $sourceCmd,$cmd);
$success_count=0;
foreach ($imageList as $imageData) {
$taskId = $imageData['id'];
$status = $imageData['status'];
$progress = $imageData['progress'];
$thumb = $imageData['thumb'];
$url = $imageData['url'];
$submitTime = $imageData['submitTime']/1000;
$startTime = $imageData['startTime']/1000;
$finishTime = $imageData['finishTime']/1000;
$sourceCmd = json_encode($imageData);
$cmd=$imageData['prompt'];
if($thumb=='') $thumb=$imageData['originalImgUrl'];
if($url=='') $url=$imageData['originalImgUrl'];
// 执行预处理语句
if (!$stmt->execute()) {
echo date('Y-m-d H:i:s')."插入或更新数据时出错: " . $stmt->error . "
";
} else {
//echo "任务 ID {$taskId} 处理成功
";
$success_count++;
}
}
echo date('Y-m-d H:i:s')."成功同步AI平台数据-".$success_count."条";
// 关闭预处理语句
$stmt->close();
// 关闭数据库连接
$conn->close();
$auto_time=5; //几秒后自动刷新本页面
?>
倒计时秒后自动刷新本页面！