PHP가 5명의 심사위원의 채점을 구현하는 방법에 대한 심층 분석

//（1）连接数据库
$connect=mysqli_connect("localhost","root","密码","test");
//（2）防止中文乱码
mysqli_query($connect,"set names utf8");
//（3）获取id值
$sid=$_GET['id'];
//（4）获取新数据
$mark1=$_POST['mark1'];
$mark2=$_POST['mark2'];
$mark3=$_POST['mark3'];
$mark4=$_POST['mark4'];
$mark5=$_POST['mark5'];
//（5）更新数据
mysqli_query($connect,"update score_table set mark1=$mark1,mark2=$mark2,mark3=$mark3,mark4=$mark4,mark5=$mark5 where sid=$sid");

//（1）连接数据库
$connect=mysqli_connect("localhost","root","密码","test");
//（2）防止中文乱码
mysqli_query($connect,"set names utf8");
//（3）查询所有数据
$sql="select * from score_table";
$query=mysqli_query($connect,$sql);
//（4）遍历数据
while($row=mysqli_fetch_array($query)){
    $average=($row['mark1']+$row['mark2']+$row['mark3']+$row['mark4']+$row['mark5'])/5;
    $sid=$row['sid'];
    //（5）更新数据
    mysqli_query($connect,"update score_table set average=$average where sid=$sid");
}