我正在生成随机的团队array.All球员存储在数据库中没有团队。我需要从数据库分配20名球员到一支球队,并将他们的信息放入数组。我写的代码,但不知何故代码分配60名球员,而不是20在数据库中。我哪里出错了?
$Team = array();
$i=0;
while($i < 20)
{
$rand = rand(1,100);
$sql = $con->query("SELECT * FROM players where id='$rand'");
if($sql->num_rows > 0)
{
$data = $sql->fetch_array();
if($data['teamid'] == NULL)
{
$con->query("UPDATE players SET teamid='$teamid' WHERE id='$rand'");
$Team [$i]['name'] = $data['name'];
$Team [$i]['surfname'] = $data['surfname'];
$Team [$i]['rating'] = $data['rating'];
$Team [$i]['position'] = $data['position'];
$i++;
}
}
}
https://stackoverflow.com/questions/53623748
复制相似问题