修改
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Document</title>
<script type="text/javascript" src="../js/jquery.js"></script>
</head>
<script type="text/javascript">
function deletes($id){
var id=$id;
if (id) {
$.get("../conn/delect.php",{'id':id},function(data){
if (data==200) {
alert("正确");
window.location.href=window.location.href;
}else{
alert("cuouw");
}
});
}
}
</script>
<style>
table{
margin: 0 auto;
}
.table3_12 table {
width:100%;
margin:15px 0
}
.table3_12 th {
background-color:#50C2FF;
color:#FFFFFF
}
.table3_12,.table3_12 th,.table3_12 td
{
font-size:0.95em;
text-align:center;
padding:4px;
border:1px solid #20adfe;
border-collapse:collapse;
}
.table3_12 tr:nth-child(odd){
background-color:#c4eafe;
}
.table3_12 tr:nth-child(even){
background-color:#fdfdfd;
}
tr td{
width: 150px;
height: 30px;
}
tr th{
width: 150px;
height: 30px;
}
</style>
<body>
<table class="table3_12">
<tr>
<th>ID</th><th>用户名</th><th>密码</th><th>性别</th><th>系部</th><th>班级</th><th>电话</th><th>操作</th><th>修改</th>
</tr>
<?php
header("content-type:text/html;charset=utf-8");
include_once("../conn/conn.php");
$sql="SELECT * FROM user ";
$r=mysqli_query($link,$sql);
while ($n=mysqli_fetch_array($r)) {
?>
<tr>
<td><?php echo $n["id"]; ?></td><td><?php echo $n["name"]; ?></td><td><?php echo $n["password"]; ?></td><td><?php echo $n["sex"]; ?></td><td><?php echo $n["college"]; ?></td><td><?php echo $n["class"]; ?></td><td><?php echo $n["tel"]; ?></td><td><button href="" onclick="deletes(<?php echo $n['id'];?>);">删除</button></td><td><a href="jiade.php?id=<?php echo $n['id'];?>"> 修改</a></td>
</tr>
<?php
}
?>
</table>
</body>
</html>
<?php
header("Content-Type: text/html; charset=utf-8");
include_once("../conn/conn.php");
$id=$_GET["id"];
$sql="SELECT * FROM user where id='$id' ";
$r=mysqli_query($link,$sql);
$n=mysqli_fetch_array($r);
?>
<input type="hidden" id="id" value="<?php echo $n["id"]; ?>">
<p>name:</p>
<input type="text" id="name" value="<?php echo $n["name"]; ?>">
<p>possword:</p>
<input type="text" id="password" value="<?php echo $n["password"]; ?>">
<p>sex:</p>
<input type="text" id="sex" value="<?php echo $n["sex"]; ?>">
<p>college:</p>
<input type="text" id="college" value="<?php echo $n["college"]; ?>">
<p>class:</p>
<input type="text" id="ban" value="<?php echo $n["class"]; ?>">
<p>tel:</p>
<input type="text" id="tel" value="<?php echo $n["tel"]; ?>">
<input type="button" name="" id="but" value="修改">
<script type="text/javascript" src="../js/jquery.js"></script>
<script type="text/javascript">
$(document).ready(function(){
$("#but").click(function(){
var id=$("#id").val();
var name=$("#name").val();
var password=$("#password").val();
var sex=$("#sex").val();
var college=$("#college").val();
var ban=$("#ban").val();
var tel=$("#tel").val();
$.post("../conn/xiugai.php",{'id':id,'name':name,'password':password,'sex':sex,'college':college,'ban':ban,'tel':tel},function(data){
if (data==200) {
alert("ok");
window.location.href="user.php";
}
});
});
});
</script>
<?php
include_once("conn.php");
$id=$_POST["id"];
$name=$_POST["name"];
$password=$_POST["password"];
$sex=$_POST["sex"];
$college=$_POST["college"];
$ban=$_POST["ban"];
$tel=$_POST["tel"];
$sql="UPDATE user SET name='$name',password='$password',sex='$sex',college='$college', class='$ban',tel='$tel' where id=$id ";
$r=mysqli_query($link,$sql);
if ($r) {
echo 200;
}else{
echo 201;
}
?>
浙公网安备 33010602011771号