📄 modifyinfo.php
字号:
<? ob_start(); ?>
<body background="../danse3.jpg">
<form action="modifyInfo.php" method="get">
<center>
<!--提示信息 begin-->
<center><strong>修改个人信息<strong></center><br><br><br>
<hr>
<!--提示信息 end-->
<!--内容 begin-->
<table width=540 border=2 cellpadding=0 cellspacing=1 bgcolor="#0099FF">
<tr><td bgcolor="#7dafdb">
<br>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr><td width="35%" align="right">用户名:</td>
<td align=left>
<?
include realpath('../Sysconf.php');//连接数据库
$username=$_COOKIE["username"];
echo $username;
?>
</td></tr>
<tr><td width="35%" align="right">昵称:</td>
<td align=left>
<input type="text" size="27" name = "nickname" title="昵称">
</td></tr>
<tr><td width="35%" align="right">真实姓名:</td>
<td align=left>
<input type="text" size="27" name = "firstname" title="真实姓名">
</td></tr>
<tr><td width="35%" align="right">QQ:</td>
<td align=left>
<input type="text" size="27" name = "QQ" title="QQ">
</td></tr>
</table><br>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr><td></td><td></td></tr>
<tr><td width="100%" colspan=2 align=center><input type=submit name=submit value="提交修改"></td></tr>
</table><br><br>
</td>
</tr>
</table>
</center>
</form>
</body>
<?
//include realpath('../Sysconf.php');//连接数据库
function query($name,$content){
$username=$_COOKIE["username"];
$sql="select * from user_base_information where user_name='$username';";
$result=mysql_query($sql);
$user_id=mysql_result($result,0,'user_id');
$sqlA="select '$name'
from user_extend_information
where user_id='$user_id';";
$result=mysql_query($sqlA);
if(mysql_fetch_row($result)==true)
return true;
return false;
}
function insert($name,$value){
$username=$_COOKIE["username"];
$sql="select * from user_base_information where user_name='$username';";
$result=mysql_query($sql);
$user_id=mysql_result($result,0,'user_id');
if($name=="QQ")
$sql="insert into user_extend_information(user_id,QQ) values('$user_id','$value');";
else
$sql="insert into user_extend_information(user_id,firstname) values('$user_id','$value');";
$info=$name."插入成功!";
$result=mysql_query($sql) or die("数据库更新失败!");
if($result==true)
echo "<script>alert('$info')</script>";
}
function update($name,$value){
$username=$_COOKIE["username"];
$sql="select * from user_base_information where user_name='$username';";
$result=mysql_query($sql);
$user_id=mysql_result($result,0,'user_id');
if($name=="QQ")
$sql="update user_extend_information set QQ='$value' where user_id='$user_id'";
else
$sql="update user_extend_information set firstname='$value' where user_id='$user_id'";
$result=mysql_query($sql) or die("数据库更新失败!");
$info=$name."更改成功!";
if($result==true)
echo "<script>alert('$info')</script>";
}
if($_GET["submit"]=="提交修改"){
$nickname = $_GET["nickname"];
$firstname = $_GET["firstname"];
$qq = $_GET["QQ"];
if($nickname!=""){
$username=$_COOKIE["username"];
$sql="update user_base_information
set nickname='$nickname'
where user_name='$username';";
$result=mysql_query($sql) or die("数据库更新失败!");
echo "<script>alert('昵称更改成功!')</script>";
}
if($firstname!=""){
if(query("firstname",$firstname)==true)
update("firstname",$firstname);
else
insert("firstname",$firstname);
}
if($qq!=""){
if(query("QQ",$qq)==true)
update("QQ",$qq);
else
insert("QQ",$qq);
}elseif($nickname=="" and $firstname=="" and $qq==""){
echo "<script>alert('至少一个不为空!')</script>";
echo "<script>history.back()</script>";
}
echo "<script>window.location.href='../safeCenter.php'</script>";
}
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -