我想用php和mysql开发一个足球运动员比较器网站。我在谷歌上搜索了好几个小时，但没有找到任何例子。
链接：https://pesdb.net/pes2021/?compare=4522+47179
https://www.pesmaster.com/pes-2021/compare/?id=1053098，1095755
我知道如何从mysql创建一个玩家的统计数据，但我不知道如何创建比较器。
如果您使用的是PHP PDO，那么它只是一个获取玩家信息的简单查询。
示例：
$get_player1_id = $_GET['p1'];
$get_player2_id = $_GET['p2'];
$query = $db->prepare("SELECT p.name, p.squad_number, p.position, p.offensive_awareness, p.ball_control, p.dribbling
FROM players AS p
WHERE p.p_id = :player1_id");
$query->bindValue(':player1_id', $get_player1_id, PDO::PARAM_INT);
$query->execute();
$num_rows = $query->rowCount();
if ($num_rows > 0) {
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
$p1_name = $row['name'];
$p1_squad_number = $row['squad_number'];
$p1_position = $row['position'];
$p1_offensive_awareness = $row['offensive_awareness'];
$p1_ball_control = $row['ball_control'];
$p1_dribbling = $row['dribbling'];
}
}
$query = $db->prepare("SELECT p.name, p.squad_number, p.position, p.offensive_awareness, p.ball_control, p.dribbling
FROM players AS p
WHERE p.p_id = :player2_id");
$query->bindValue(':player2_id', $get_player2_id, PDO::PARAM_INT);
$query->execute();
$num_rows = $query->rowCount();
if ($num_rows > 0) {
while ($row = $query->fetch(PDO::FETCH_ASSOC)) {
$p2_name = $row['name'];
$p2_squad_number = $row['squad_number'];
$p2_position = $row['position'];
$p2_offensive_awareness = $row['offensive_awareness'];
$p2_ball_control = $row['ball_control'];
$p2_dribbling = $row['dribbling'];
}
}
然后你只需要知道html来显示信息。
示例：
<?php
echo '<html>
<head>
<title>Compare '.$p1_name.' vs. '.$p2_name.'</title>
</head>
<body>
<table>
<tr>
<td>
<label>Player Name:</label>
</td>
<td>
<p>'.$p1_name.'</p>
</td>
<td>
<p>'.$p2_name.'</p>
</td>
</tr>
<tr>
<td>
<label>Squad Number:</label>
</td>
<td>
<p>'.$p1_squad_number.'</p>
</td>
<td>
<p>'.$p2_squad_number.'</p>
</td>
</tr>
<tr>
<td>
<label>Position:</label>
</td>
<td>
<p>'.$p1_position.'</p>
</td>
<td>
<p>'.$p2_position.'</p>
</td>
</tr>
<tr>
<td>
<label>Offensive Awareness:</label>
</td>
<td>
<p>'.$p1_offensive_awareness.'</p>
</td>
<td>
<p>'.$p2_offensive_awareness.'</p>
</td>
</tr>
<tr>
<td>
<label>Ball Control:</label>
</td>
<td>
<p>'.$p1_ball_control.'</p>
</td>
<td>
<p>'.$p2_ball_control.'</p>
</td>
</tr>
<tr>
<td>
<label>Dribbling:</label>
</td>
<td>
<p>'.$p1_dribbling.'</p>
</td>
<td>
<p>'.$p2_dribbling.'</p>
</td>
</tr>
</table>
</body>
</html>';
?>
要获得正确的变量，你需要你的URL如下：
www.example.com/compare？p1＝1000&p2=1001
1000和1001是分配给数据库中玩家的唯一id。