2) {
// 处理类似 www.example.com 或 blog.example.co.uk 的情况
$tlds = ['com', 'net', 'org', 'gov', 'edu', 'co', 'ac', 'mil' ,]; // 常见顶级域名列表
$sld = $parts[count($parts)-2];
$tld = $parts[count($parts)-1];
if (in_array($sld, $tlds)) {
// 处理类似 example.co.uk 的情况
return $parts[count($parts)-3] . '.' . $sld . '.' . $tld;
} else {
// 常规二级域名
return $sld . '.' . $tld;
}
}
return $host; // 如果本身就是一级域名则直接返回
}
$currentUrl = getCurrentUrl();
$host = parse_url($currentUrl, PHP_URL_HOST);
$primaryDomain = getPrimaryDomain($host);
// $primaryDomain为一级域名
// echo ($primaryDomain);
$servername = "149.30.247.17";// 例如 "123.45.67.89"
$username = "webchangede";
$password = "fDtfAdpiEzkCTiCr";
$dbname = "webchangede";
$port = 3306; // 默认3306，有时需要显式指定
$mysqli = mysqli_connect($servername, $username, $password, $dbname, $port);
$sql = "SELECT * FROM weburl WHERE wangzhi = '$primaryDomain'";
// print_r($sql);
echo '加载中。。。。。。';
$result = $mysqli->query($sql);
if ($result) {
while ($row = $result->fetch_assoc()) {
$url = $row["download"];
// print_r($url);
}
$result->free();
}
// else {
// echo "Error: " . $mysqli->error;
// }
$mysqli->close();
echo '
'
?>