前端代码 ,显示数据库信息(own.php):
<html>
<head>
<meta charset="utf-8">
<title></title>
</head>
<body>
<div>
<form method='post' action='setting_own.php'>
<label>用户名:</label>
<br/>
<input type="text" size="28" name="username" value="<?php echo $rows['username'] ?>"/>
<br />
<label>邮箱:</label>
<br/>
<input type="text" size="30" name="email" value="<?php echo $rows['email'] ?>"/>
<br />
<input id="submit" type="submit" value="提交" />
</form>
</div>
</body>
</html>
php验证是否登录,获取用户个人信息(display_own.php):
<?php
session_start();//开启会话,必须在html前
if(isset($_SESSION['username'])){ //检查是否通过登录页面登录进来
$db = new mysqli('localhost','jsj181','5287271','SimplePhotos');//连接数据库
$result = $db->query("select * from login where username = '".$_SESSION['username']."'");//查询语句
$rows = mysqli_fetch_array($result);//查询数据库表每行数据,返回与读取行匹配的字符串数组。
//打印获取的信息
// var_dump($rows);
// var_dump($rows['username']);
include('own.php');//加载引入own.php文件
}else{//没有登录时跳到登录界面
echo '<script>window.location.href="login.php"</script>';
}
?>
php前端页面表单修改个人信息,保存修改信息到数据库(setting_own.php):
<?php
session_start();//开启会话,必须在html前
if(isset($_SESSION['username'])){ //检查是否通过登录页面登录进来
//post方法获取表单信息
$username = $_SSESSION['username'];
$email = $_POST['email'];
$db = new mysqli('localhost','jsj181','5287271','SimplePhotos');//连接数据库
$result = $db->query("update login set email = '".$email."' where username = '".$_SESSION['username']."'");//更新语句
if($result){
echo '<script>alert("保存成功");window.location.href="display_own.php"</script>';
}else{
echo '<script>alert("保存失败");window.location.href="display_own.php"</script>';
}
}else{//没有登录时跳到登录界面
echo '<script>window.location.href="login.php"</script>';
}
?>
图:
修改前:
修改后: