我需要有一个网站，可以从数据库中回声出随机名称，然后淡出他们顺利。我目前使用的代码是刷新整个页面，它使页面闪烁和名称更改不顺利。
<!doctype html>
<html><head><meta http-equiv=REFRESH CONTENT=15;url=index.php>
<title>Student Display</title></head>
<body>
<img src="U" width="499" height="128" alt=""/>
<center>
<span style="font-family: 'Lucida Grande', 'Lucida Sans Unicode', 'Lucida Sans', 'DejaVu Sans', Verdana, sans-serif; font-size: 72px; color: #013b6a;">
<p>
<p>
<p>
<?php
//delayed refresh
$db_host = "localhost:/test";
$db_user = "test";
$db_pwd = "password";
$database = "test";
$table = "Sheet1";
if (!mysql_connect($db_host, $db_user, $db_pwd))
die("Can't connect to database");
if (!mysql_select_db($database))
die("Can't select database");
// sending query
$result = mysql_query("SELECT * FROM {$table} ORDER BY RAND() LIMIT 0,1");
if (!$result) {
die("Query to show fields from table failed");
}
// Display the name and date
while($row = mysql_fetch_assoc($result))
{
echo $row['Firstname'] . " ";
echo " " . $row['Surname'] . " ";
echo "<br>";
echo " " . $row['Year'] . " ";
}
?>
</span>
</center>
</body></html>
您需要将查询数据库的代码与呈现页面的代码分开。您可以使用AJAX技术从查询数据库的脚本请求一个新名称，而无需重新加载页面，然后使用jQuery动画技术淡出旧值并淡入新值。