alert(\"请填写课程名，学时和学分\")";
exit();
}
$sql = "select kcm from kc where kcm = '$kcm'";
$result = mysqli_query($db,$sql);
if(mysqli_num_rows($result)>0)
{
echo "";
exit();
}
$sql = "insert into kc(kcm,xs,xf) values('$kcm','$xs','$xf')";
$result = mysqli_query($db,$sql);
if($result)
{
echo "";
$result = mysqli_query($db,"select * from kc where kcm = '$kcm'");
$row = mysqli_fetch_array($result);
echo "
| 课程名 |
学时 |
学分 |
";
echo "| ".$row['kcm']," | ";
echo "".$row['xs']," | ";
echo "".$row['xf']," |
|---|
";
echo "
";
}
else{
echo "";
exit();
}
$sql = "select kcm,xs,xf from kc where kcm = '$kcm'";
$result = mysqli_query($db,$sql);
if($result)
{
$row = mysqli_fetch_array($result);
echo "
| 课程名 |
学时 |
学分 |
";
echo "| ".$row['kcm']." | ";
echo "".$row['xs']." | ";
echo "".$row['xf']." |
|---|
";
echo "
";
}
}
else if(strlen($xs)&&!strlen($kcm)&&!strlen($xf))
{
$sql = "select kcm,xs,xf from kc where xs = '$xs'";
$result = mysqli_query($db,$sql);
if(!mysqli_num_rows($result))
{
echo "";
exit();
}
if($result)
{
echo "| 学时 | 课程名 | 学分 |
|---|
";
while($row = mysqli_fetch_array($result))
{
echo "| ".$row['xs']." | ".
"".$row['kcm']." | ".
"".$row['xf']." | ".
"
|---|
";
}
echo "
";
}
}
else if(strlen($xf) && !strlen($xs) && !strlen($kcm))
{
$sql = "select xf,kcm,xs from kc where xf = '$xf'";
$result = mysqli_query($db,$sql);
if(!mysqli_num_rows($result))
{
echo "";
exit();
}
if($result)
{
echo "
| 学分 |
课程名 |
学时 |
";
while($row = mysqli_fetch_array($result))
{
echo "| ".$row['xf']." | ".
"".$row['kcm']." | ".
"".$row['xs']." | ".
"
|---|
";
}
echo "
";
}
}
else if(strlen($xs)&&!strlen($kcm)&&strlen($xf))
{
$sql = "select kcm,xs,xf from kc where xs = '$xs' and xf = '$xf'";
$result = mysqli_query($db,$sql);
if(!mysqli_num_rows($result))
{
echo "";
exit();
}
if($result)
{
echo "| 学时 | 课程名 | 学分 |
|---|
";
while($row = mysqli_fetch_array($result))
{
echo "| ".$row['xs']." | ".
"".$row['kcm']." | ".
"".$row['xf']." | ".
"
|---|
";
}
echo "
";
}
}
else{
$sql = "select kcm,xs,xf from kc ";
$result = mysqli_query($db,$sql);
if(!mysqli_num_rows($result))
{
echo "";
exit();
}
if($result)
{
echo "| 课程名 | 学分 | 学时 |
|---|
";
while($row = mysqli_fetch_array($result))
{
echo "| ".$row['kcm']." | ".
"".$row['xf']." | ".
"".$row['xs']." | ".
"
|---|
";
}
echo "
";
}
}
}
if(isset($_POST['删除']))
{
if(!strlen($kcm)&&!strlen($xs)&&!strlen($xf))
{
echo "";
exit();
}
$sql = "select kcm from kc where kcm = '$kcm'";
$result = mysqli_query($db,$sql);
if(!mysqli_num_rows($result))
{
echo "";
exit();
}
if(strlen($kcm))
{
$sql = "delete from kc where kcm = '$kcm'";
$result = mysqli_query($db,$sql);
if($result)
{
echo "";
exit();
}
else
{
echo "";
exit();
}
}
if(!strlen($kcm)&&strlen($xs)&&!strlen($xf))
{
$sql="delete from kc where xs = '$xs'";
$result = mysqli_query($db,$sql);
if($result)
{
echo "";
exit();
}
else
{
echo "";
exit();
}
}
if(!strlen($kcm)&&!strlen($xs)&&strlen($xf))
{
$sql="delete from kc where xf = '$xf'";
$result = mysqli_query($db,$sql);
if($result)
{
echo "";
exit();
}
else
{
echo "";
exit();
}
}
if(!strlen($kcm)&&strlen($xs)&&strlen($xf))
{
$sql="delete from kc where xs = '$xs' and xf = '$xf'";
$result = mysqli_query($db,$sql);
if($result)
{
echo "";
exit();
}
else
{
echo "";
exit();
}
}
}
if(isset($_POST['更新']))
{
if(!strlen($kcm)||!strlen($xs)||!strlen($xf))
{
echo "";
exit();
}
$sql = "update kc set xs= '$xs',xf = '$xf' where kcm = '$kcm'";
$result = mysqli_query($db,$sql);
if($result)
{
echo "";
$result = mysqli_query($db,"select kcm,xs,xf from kc where kcm = '$kcm'");
$row = mysqli_fetch_array($result);
echo "
| 课程名 |
学时 |
学分 |
|---|
";
echo "| ".$row['kcm']," | ";
echo "".$row['xs']," | ";
echo "".$row['xf']," |
|---|
";
echo "
";
}
else{
echo "";
}
}
?>