php实现跟页面数据跟新

来源：互联网发布：大数据依靠的技术编辑：程序博客网时间：2024/04/29 00:24

1.查询数据库数据并显示到页面并添加删除，更新密码功能’

select_user.php

<!doctype html>
<html>
<head>
<meta charset="utf-8">
</head>
<body>
<table border="1" width="100%" id="userTable">
<thead>
<tr>
<th>用户编号</th>
<th>用户名称</th>
<th>操作</th>
</tr>
</thead>
<tbody>
<?php
$conn = mysqli_connect("127.0.0.1","root","","bbs");
$sql = "SET NAMES UTF8";
mysqli_query($conn,$sql);
$sql = "SELECT * FROM t_user";
$result = mysqli_query($conn,$sql);
while(true){//14:41--14:43
$row = mysqli_fetch_assoc($result);
if($row===NULL){
break;
}
echo "<tr>";
echo "<td>$row[uid]</td>";
echo "<td>$row[uname]</td>";
echo "<td><a href='$row[uid]' class='btn-delete'>删除</a>
<a href='$row[uid]' class='btn-update'>更新</a></td>";
echo "</tr>";
}
?>
</tbody>
</table>
<script>
//1:获取表格父元素
var userTable = document.getElementById("userTable");
//2:为表格父元素绑定点击事件
//利用冒泡机制
userTable.addEventListener('click',function(e){
//3:获取事件目标对象
var target = e.target;//15:40--15:45
//4:判断如果目标对象class==btn-delete
if(target.className==='btn-delete'){
//5:阻止事件默认行为a自动跳href
e.preventDefault();
//5.1:获取当前用户uid值
var uid = target.getAttribute("href");
//6:弹出确认框 "您确认要删除5用户吗?"
var choice = window.confirm('您确认要删除'+uid+'号用户吗?');
if(choice){
///7:向user_del.php打电话自动
location.href = 'user_del.php?uid='+uid;
}
}
});

/1:为所有修改按钮绑定事件--点击
//事件冒泡 16:33---16:43
//1.1获取父元素 userTable
//1.2绑定点击事件
userTable.addEventListener('click',function(e){
//1.3获取目标对象
var target = e.target;
//1.4判断当前元素是否是更新按钮
if(target.className === 'btn-update'){
//1.5阻止事件默认行为
e.preventDefault();
//1.6(打电话)跳转修改前页面
//user_update_select.php
var uid = target.getAttribute("href");
//1.7:将当前用户uid作为参数传上面php
location.href = 'user_update_select.php?uid='+uid;
}
});

</script>
<body>
</html>

2. 跳转到跟新密码的界面

user_update_select.php

<?php
//1:获取用户提交参数uid
//2:显示当前uid值
// <h3>当前用户的编号是 5</h3>
//3:html 输出表单<form
//4:新密码<input
//5:提交按<input
$uid = $_REQUEST['uid'];
echo "<h3>当前用户编号是:$uid</h3>";
?>
<!doctype html>
<head>
<meta charset="utf-8">
</head>
<body>
<form action="user_update.php" method="post">
<input type="hidden" name="uid"
value="<?php echo $uid; ?>" />
新密码<input type="password" name="upwd" /><br/>
<input type="submit" value="更新" />
</form>
</body>
</html>

3. 提示跟新是否成功

user_update.php

<?php

//1:获取用户参数
//2:获取用户uid
$uid = $_REQUEST['uid'];
$upwd = $_REQUEST['upwd'];
//3:获取用户新密码
//4:连接数据库
$conn = mysqli_connect("127.0.0.1","root","","bbs");
//5:发送sql UPDATE
$sql = "UPDATE t_user SET upwd='$upwd' WHERE uid = $uid";
//6:判断 false true
$result = mysqli_query($conn,$sql);
//7:用户密码更新成功
//8:用户密码更新失败
if($result === false){
echo "密码更新失败";
}else{
echo "密码更新成功";
}

?>

阅读全文

0 0