'."\n"; echo ''."\n"; // 首页 echo " \n"; echo " https://www.idhao.vip/\n"; echo " ".date('Y-m-d')."\n"; echo " daily\n"; echo " 1.0\n"; echo " \n"; // ========= Dujiao-Next 数据库读取商品 ========= // 填入你的数据库信息 $db_host = 'localhost'; $db_user = 'kmkm'; $db_pwd = 'kmkm'; $db_name = 'kmkm'; $conn = mysqli_connect($db_host,$db_user,$db_pwd,$db_name); mysqli_set_charset($conn,"utf8"); $sql = "SELECT id,update_time FROM goods WHERE status=1"; $res = mysqli_query($conn,$sql); while($row = mysqli_fetch_assoc($res)){ $goods_url = "https://www.idhao.vip/goods/".$row['id']; $lastdate = date('Y-m-d',strtotime($row['update_time'])); echo " \n"; echo " $goods_url\n"; echo " $lastdate\n"; echo " weekly\n"; echo " 0.8\n"; echo " \n"; } mysqli_close($conn); echo ''; ?>