删除页面
<center>
<form method="post" action="<?php echo $_SERVER['URL'] ?>" onsubmit="return confirm('请确认删除');">
姓名: <input type="text" name="user_name">
<input type="submit" name="update" value="删除">
</center>
效果图如下：
实现
// 调用修改函数
if ($_GET[update])
{
modify("update");
}
// 调用添加函数
elseif($_GET[add])
{
modify("add");
}
elseif($_GET[delete])
{
modify("delete");
}
modify()函数的实现
// 修改数据函数
/*
点击修改超链接，跳转到修改页面
表单中，名字项指定要修改记录
权限和职务项为可修改内容
*/
function modify($operation)
{
if(isset($_POST['update']))
{
// 有root权限修改，修改
if($operation == "update" && judge("update"))
{
$user_name = $_POST[user_name];
$sql = "UPDATE admin_info SET pemission = '$_POST[pemission]', position ='$_POST[position]' WHERE user_name = '$user_name'";
mysql_query($sql);
mysql_close($db);
display();
}
// 添加
elseif(judge("add") && $operation == "add")
{
$user_name = $_POST[user_name];
$sql = "insert into admin_info (user_name, pemission, position) values ('$_POST[user_name]','$_POST[pemission]','$_POST[position]')";
mysql_query($sql);
mysql_close($db);
display();
}
// 删除
elseif(judge("delete") && $operation == "delete")
{
$user_name = $_POST[user_name];
// 获取确认情况
$sql = "delete from admin_info where user_name = "$user_name"";
mysql_query($sql);
}
}
}
judge()函数的实现
// 判断修改用户名是否存在和该用户是否具有权限
function judge($operation)
{
global $NAME;
// 修改用户名
$user_name = $_POST['user_name'];
// 连接数据库，获取数据
$db = mysql_connect("localhost", "root", "123456");
mysql_select_db("linyimin",$db);
// 该用户是否存在
$sql = "select * from admin_info where user_name = "$user_name"";
$result = mysql_query($sql);
$num = mysql_num_rows($result);
// 输入名称不存在
if ($num == 0 && $operation != "add")
{
$user_name = $_POST['user_name'];
echo "<script type='text/javascript'>dis_alert("$user_name",2);</script>";
return 0;
}
else
{
// 判断有没有权限(只有root权限可以修改)
$sql = "select * from admin_info where user_name = "$NAME"";
$result = mysql_query($sql);
$pemission = mysql_result($result,0,'pemission');
// 没有root权限，报错
if(strcmp($pemission,"root") != 0)
{
$user_name = $_POST['user_name'];
echo "<script type='text/javascript'>dis_alert("$user_name",1);</script>";
return 0;
}
else
return 1;
}
}
