用PHP实现注册登录,原理就是注册时往数据库中插入用户信息比如用户名和密码等,登陆即验证输入的账号密码在数据库中是否存在。
1、注册界面html代码:
function getdata() {
var name = $("#Name").val();
$.post("checkname.php", { "Name": name }, function(data, status) {
if (status == "success") {
if (data=='0') {
//alert("可以使用"+data);
document.getElementById("show").innerHTML="用户名可用";
$("#show").css("color", "green");
document.getElementById("sub").disabled=false;
}
else {
//alert(data);
document.getElementById("show").innerHTML="用户名已被注册";
document.getElementById("sub").disabled=true;
$("#show").css("color", "red");
}
// document.getElementById("show").innerHTML=data;
}
else {
alert("ajax处理错误")
}
});
}
用户注册用户名: | οnblur="getdata();"/>(2-8个汉字或者5-16位数字或者字母) |
密码: | (5-16位数字或者字母) |
2、动态检查用户名是否可用代码(checkname.php)
<?php
//echo "";
$name=$_POST['Name'];
$con=mysql_connect("localhost:3306","root","");
mysql_query("set character set 'utf8'");//读库
mysql_query("set names 'utf8'");//写库
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
else{
mysql_select_db("userinfo",$con);
$sel = mysql_query("SELECT * FROM userlogin WHERE Name = '$name'");
if ($result = mysql_fetch_object($sel))
{
echo '1';
}
else {
echo '0';
}
exit();
}
?>
3、实现注册代码(checkreg.php)
<?php
echo "";
$name=$_POST['Name'];
$password=$_POST['Password'];
$n=strlen($name);
$p=strlen($password);
if($n==0){
echo "";
}elseif(!($n>=5 && $n<=16)){
echo "";
}elseif($p==0){
echo "";
}elseif(!($p>=5 && $p<=16)){
echo "";
}else{
$con=mysql_connect("localhost:3306","root","");
mysql_query("set character set 'utf8'");//读库
mysql_query("set names 'utf8'");//写库
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("userinfo",$con);
$sl="INSERT INTO userlogin (Name,Password)
VALUES
('$_POST[Name]','$_POST[Password]')";
if (!mysql_query($sl,$con))
{
die('Error: ' . mysql_error());
}
else{
echo "";
mysql_close();
}
}
?>
4、登陆界面(login.html)
用户登陆用户名: | |
密码: | |
5、实现登陆代码(login.php)
echo "";
$username=$_POST['Name'];
$password=$_POST['Password'];
$con=mysql_connect("localhost:3306","root","");
mysql_query("set character set 'utf8'");//读库
mysql_query("set names 'utf8'");//写库
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
else{
mysql_select_db("userinfo",$con);
$sel = mysql_query("SELECT * FROM userlogin WHERE Name = '$username'");
if ($result = mysql_fetch_object($sel))
{
if($result->Password!=$_POST['Password']){
echo "";
}
else{
$_SESSION['Name']=$username;
echo "
location.href='userpage.php';
";
}
//echo $name;
//echo $password;
}
else {
//echo $name;
//echo $password;
echo "";
}
}
?>