dedecms pc+wap数据同步

<?php
// 数据库连接
$mysqli = new mysqli("localhost", "username", "password", "dedecms");

if ($mysqli->connect_error) {
    die("连接失败: " . $mysqli->connect_error);
}

// 定时同步任务
$schedule = new Cron\Cron();
$schedule->add(new Cron\Job\ShellJob('php /path/to/sync_script.php', '0 * * * *'));

// 执行同步任务
$schedule->run();

// 同步脚本示例
$sync_script = <<<EOT
<?php
// 数据库连接
\$mysqli = new mysqli("localhost", "username", "password", "dedecms");

if (\$mysqli->connect_error) {
    die("连接失败: " . \$mysqli->connect_error);
}

// 获取PC端最新数据
\$pc_data = \$mysqli->query("SELECT * FROM pc_table WHERE updated_at > NOW() - INTERVAL 1 HOUR")->fetch_all();

// 更新WAP端数据
foreach (\$pc_data as \$data) {
    \$mysqli->query("UPDATE wap_table SET content = '" . addslashes(\$data['content']) . "' WHERE id = " . \$data['id']);
}

\$mysqli->close();
EOT;

file_put_contents('/path/to/sync_script.php', $sync_script);

$mysqli->close();
?>