student

尽长安

于 2020-06-30 21:13:01 发布

阅读量152

点赞数

分类专栏： php

本文链接：https://blog.csdn.net/qq_43124652/article/details/107050704

版权

php 专栏收录该内容

2 篇文章 0 订阅

订阅专栏

head.html

<!DOCTYPE html>
<html>
	<head>
		<meta charset="UTF-8">
		<title></title>
	</head>
	<body>
		<ul>
			<li><a href="add.php">增加</a></li>
			<li><a href="show.php">删除</a></li>
			<li><a href="show.php">修改</a></li>
			<li><a href="show.php">查询</a></li>
		</ul>
	</body>
</html>

add.php

<?php
	require_once("head.html");
	require_once("dbop.php");
?>
<?php
	if(isset($_GET['stuid'])){
		require('check.php');
		$vail = check();
		if($vail){
			$sql="INSERT INTO student (`stuid`,`name`,`sex`,`class`,`tel`)".
			"VALUES('{$_GET['stuid']}','{$_GET['name']}','{$_GET['sex']}','{$_GET['class']}','{$_GET['tel']}')";
			if(query($sql)==true){
				echo "增加成功";
			}else{
				echo "增加失败";
			}
		}else{
			echo "格式错误";
		}
	}
?>
<form action="add.php" method="get">
	<label>学号</label>
	<input type="text" name="stuid" id="" /><br />
	<label>姓名</label>
	<input type="text" name="name" id="name" value="" /><br />
	<label>性别</label>
	<input type="text" name="sex" id="" /><br />
	<label>班级</label>
	<input type="text" name="class" id="" /><br />
	<label>电话</label>
	<input type="text" name="tel" id="" /><br />
	<input type="submit" value="新增加" />
	
</form>

check.php

<?php
	function check(){
		$arr = str_split($_GET['tel']);
		foreach($arr as $a){
			if($a<'0'||$a>'9'){
				return false;
			}
		}
		$sql = "select count(stuid) from student where stuid='{$_GET['stuid']}' ";
		$ans=query($sql);
		$cnts=$ans->fetch_array();
		if($cnts[0]!=0){
			return false;
		}
		return true;
	}
?>

dbop.php

<?php
	function query($sql){
		$db=new mysqli("localhost","root","","dome");
		$db->query("set names utf8");
		$ret = $db->query($sql);
		$db->close();
		return $ret;
	}
?>

del.php

<?php
	require_once("dbop.php");
?>
<?php
	$did = $_GET['id'];
	echo $did;
	$sql="delete from `student` where `id`='$did' ";
	echo $sql;
	query($sql);
	header("Location:show.php");
?>

show.php

<?php
	//查询并显示所有学生的信息
	require_once("head.html");
	require_once("dbop.php");
?>
<?php
	$sql="select * from student";
	$ans=query($sql);
?>
<table border="1px solid black ">
	<tr>
		<th>数据库id</th>
		<th>学号</th>
		<th>姓名</th>
		<th>性别</th>
		<th>班级</th>
		<th>电话</th>
		<th>功能</th>
	</tr>
	<?php
		while($ro=mysqli_fetch_array($ans)){
	?>	
	<tr>
		<td><?php echo $ro['id'];?></td>
		<td><?php echo $ro['stuid'];?></td>
		<td><?php echo $ro['name'];?></td>
		<td><?php echo $ro['sex'];?></td>
		<td><?php echo $ro['class'];?></td>
		<td><?php echo $ro['tel'];?></td>
		<td><a href="del.php?id=<?php echo $ro['id']; ?>" style="color: #1C86EE;">删除</a>
			<a href="update.php?id=<?php echo $ro['id']; ?>" style="color: #1C86EE;">修改</a></td>
	</tr>
	<?php } ?>
</table>

up.php

<?php
	require_once("dbop.php");
	$id=$_GET['id'];
	$stuid=$_POST['stuid'];
	$name=$_POST['name'];
	$sex=$_POST['sex'];
	$class=$_POST['class'];
	$tel=$_POST['tel'];
?>
<?php
	$sql="update student set stuid='".$stuid."',name='".$name."',sex='".$sex."',class='".$class."',tel='".$tel.
	"' WHERE id='".$id."'";
//	echo $sql;
	if(query($sql)){
		echo "修改成功";
	}else{
		echo "修改失败";
	}
	header("Location:show.php");
?>

update.php

<?php
	require_once("head.html");
	require_once("dbop.php");
	require('check.php');
	$id=$_GET['id'];
	$sql="SELECT * FROM student WHERE id='".$id."'";
	$ans=query($sql);
	if($ro=mysqli_fetch_array($ans)){
?>
<form action="up.php?id=<?php echo $id;?> " method="post">
	<label>数据库id</label>
	<input type="text" name="id" id="id" value="<?php echo $id;?>" disabled="disabled" /><br />
	<label>学号</label>
	<input type="text" name="stuid" id="" value="<?php echo $ro['stuid'];?>"/><br />
	<label>姓名</label>
	<input type="text" name="name" id="name" value="<?php echo $ro['name'];?>" /><br />
	<label>性别</label>
	<input type="text" name="sex" id="" value="<?php echo $ro['sex'];?>"/><br />
	<label>班级</label>
	<input type="text" name="class" id="" value="<?php echo $ro['class'];?>"/><br />
	<label>电话</label>
	<input type="text" name="tel" id="" value="<?php echo $ro['tel'];?>"/><br />
	<input type="submit" value="修改" />
</form>
<?php }?>

尽长安

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
student

head.html<!DOCTYPE html><html> <head> <meta charset="UTF-8"> <title></title> </head> <body> <ul> <li><a href="add.php">增加</a></li> <li><a href="show.php
复制链接

扫一扫