对于PHP和MysqL的连接在许多blog上都有说明,为了将MysqL中的查询,修改,插入等操作掌握,本文介绍了一下如何采用MysqL做一个登录注册修改密码的网页。
其中,如下
1.登录-
即为对数据库中的内容给予查询,并验证html中的信息与数据库是否匹配;2.注册-
即为对数据库中的内容进行插入,注册帐号与密码;3.修改密码-
即为对数据库中的内容进行修改。这三个操作,我用了8个PHP和html文本来建立 具体见代码部分 1.登录的主界面index.html:
<Meta charset="UTF-8">登录注册修改密码系统主页
<script type="text/javascript">
function alter() {
var username=document.getElementById("username").value;
var oldpassword=document.getElementById("oldpassword").value;
var newpassword=document.getElementById("newpassword").value;
var assertpassword=document.getElementById("assertpassword").value;
var regex=/^[/s]+$/;
if(regex.test(username)||username.length==0){
alert("<a href="https://www.jb51.cc/tag/yonghuming/" target="_blank" class="keywords">用户名</a>格式不对");
return false;
}
if(regex.test(oldpassword)||oldpassword.length==0){
alert("密码格式不对");
return false;
}
if(regex.test(newpassword)||newpassword.length==0) {
alert("新密码格式不对");
return false;
}
if (assertpassword != newpassword||assertpassword==0) {
alert("两次密码输入不一致");
return false;
}
return true;
}
5.修改密码的后台操作alter_password.PHP:
<Meta charset="UTF-8">
正在修改密码
$con = mysql_connect ( "localhost","root" );
if (! $con) {
die ( '数据库连接失败' . $mysql_error () );
}
mysql_select_db ( "user_info",$con );
$dbusername = null;
$dbpassword = null;
$result = mysql_query ( "select * from user_info where username ='{$username}' and isdelete =0;" );
while ( $row = mysql_fetch_array ( $result ) ) {
$dbusername = $row ["username"];
$dbpassword = $row ["password"];
}
if (is_null ( $dbusername )) {
?>
<script type="text/javascript">
alert("用户名不存在");
window.location.href="alter_password.html";
if (! $con) {
die ( '数据库连接失败' . $mysql_error () );
}
mysql_select_db ( "user_info",$con );
$dbusername = null;
$dbpassword = null;
$result = mysql_query ( "select * from user_info where username ='{$username}' and isdelete =0;" );
while ( $row = mysql_fetch_array ( $result ) ) {
$dbusername = $row ["username"];
$dbpassword = $row ["password"];
}
if (is_null ( $dbusername )) {
?>
<script type="text/javascript">
alert("用户名不存在");
window.location.href="alter_password.html";
<script type="text/javascript">
alert("密码修改成功");
window.location.href="index.html";
6.注册帐号的主界面register.html: