要通過 PHP 實(shí)現(xiàn)動(dòng)態(tài)排名調(diào)整,你可以根據(jù)特定的條件對(duì)數(shù)據(jù)進(jìn)行排序和顯示。以下是一個(gè)簡(jiǎn)單的示例,展示了如何使用 PHP 和 MySQL 實(shí)現(xiàn)動(dòng)態(tài)排名調(diào)整:
students
的表,其中包含學(xué)生的 ID、姓名和分?jǐn)?shù):CREATE TABLE students (
id INT PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(255) NOT NULL,
score INT NOT NULL
);
INSERT INTO students (name, score) VALUES ('Alice', 90);
INSERT INTO students (name, score) VALUES ('Bob', 80);
INSERT INTO students (name, score) VALUES ('Cathy', 95);
INSERT INTO students (name, score) VALUES ('David', 75);
<?php
// 連接到 MySQL 數(shù)據(jù)庫(kù)
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
die("連接失敗: " . $conn->connect_error);
}
// 查詢學(xué)生的分?jǐn)?shù)
$sql = "SELECT id, name, score FROM students ORDER BY score DESC";
$result = $conn->query($sql);
// 顯示排名結(jié)果
echo "<table border='1'>
<tr>
<th>排名</th>
<th>姓名</th>
<th>分?jǐn)?shù)</th>
</tr>";
if ($result->num_rows > 0) {
$rank = 1;
while($row = $result->fetch_assoc()) {
echo "<tr>";
echo "<td>" . $rank . "</td>";
echo "<td>" . $row["name"] . "</td>";
echo "<td>" . $row["score"] . "</td>";
echo "</tr>";
$rank++;
}
} else {
echo "0 結(jié)果";
}
echo "</table>";
// 關(guān)閉數(shù)據(jù)庫(kù)連接
$conn->close();
?>
這個(gè)示例將根據(jù)學(xué)生的分?jǐn)?shù)降序排列,并顯示排名結(jié)果。你可以根據(jù)需要修改查詢條件和排序方式。