计算机Web开发课程作业-学生成绩管理-实现成绩的增删改查（源码）

<?php require_once("./link/conn.php"); $id=isset($_POST['id'])?$_POST['id']:$_GET['id']; switch($id){ case "0":{ $sql="insert into tg(tuname,tcg) value('".$_POST['uname']."','".$_POST['cg']."')"; echo dosql($sql); } break; //================================================================================================== case "1":{ $str="<table class='table' >"; $str.="<tr><th>姓名</th><th>语文成绩</th><th>操作</th></tr>"; $sql="select id,tuname,tcg from tg"; $conn = new mysqli($GLOBALS['servername'], $GLOBALS['username'], $GLOBALS['password'], $GLOBALS['dbname']); mysqli_set_charset($conn,"utf8"); $result =$conn->query($sql); if (mysqli_num_rows($result) > 0) { while($row = mysqli_fetch_assoc($result)) { $str.="<tr><td>". $row["tuname"]."</td><td>".$row["tcg"]."</td><td>"; $str.="<button onclick='upit(".$row["id"].")' class='btn btn-info' >修改</button>&nbsp;&nbsp;"; $str.="<button onclick='deleteit(".$row["id"].")' class='btn btn-info' >删除</button>"; $str.="</td></tr>"; } } $conn->close(); $str.="</table>"; echo $str; } break; //================================================================================================== case "2":{ $sql="delete from tg where id=".$_POST['rid']; echo dosql($sql); } break; //================================================================================================== case "3":{ $str=""; $sql="select tuname,tcg from tg where id=".$_POST['rid']; $conn = new mysqli($GLOBALS['servername'], $GLOBALS['username'], $GLOBALS['password'], $GLOBALS['dbname']); mysqli_set_charset($conn,"utf8"); $result =$conn->query($sql); if (mysqli_num_rows($result) > 0) { while($row = mysqli_fetch_assoc($result)) { $str=$row["tuname"]."|".$row["tcg"]; } } $conn->close(); echo $str; } break; //================================================================================================== case "4":{ $sql="update tg set tuname='".$_POST['uname']."',tcg='".$_POST['cg']."' where id=".$_POST['rid']; echo dosql($sql); } break; } ?>