这里来写一个表详细的php用户注册登录,这里我用的集成是WampServer 数据库的创建要在PHPmyadmin 里面操作。
1.数据库,数据表的创建
这个是随意命名的 可以直接在WampServer的PHPmyadmin里面直接创建 比较快捷。
<!DOCTYPE>
<html>
<head>
<meta charset=utf-8" />
<title>用PHP创建新数据库和表</title>
</head>
<body>
<?php
if(trim ($_POST['password'])!=trim($_POST['repassword'])){
exit('两次密码不一致,请重输')
}
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
// Create database
if (mysql_query("CREATE DATABASE my_db",$con))
{
echo "Database created";
}
else
{
echo "Error creating database: " . mysql_error();
}
// Create table in my_db database
mysql_select_db("my_db", $con);
$sql = "CREATE TABLE Persons
(
username varchar(15),
password varchar(15),
emal varchar(15),
phen varchar(15)
)";
mysql_query($sql,$con);
mysql_close($con);
?>
</body>
</html>
2.注册页面
命名:zcym.html
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<title></title>
<style>
form{
position: absolute;
top:50%;
left:50%;
transform: translate(-50%,-50%);
border:0px;
color:#521a00;
box-shadow:1px 2px 20px 6px #fff;
text-align: center;
font-size:x-small;
margin:10px;
padding:5px;
}
body{
background-image: url(lb%20img/茶杯-01.jpg);
background-size:1100px 1200px;
}
</style>
</head>
<body>
<form name = "femo1" method = "post" action = "zcxr2.php">
<div>
用户名 :<input type="text" name = "username" style="background-color: transparent;">
<br>
<br>
密码 :<input type="password" name = "password"style="background-color: transparent;">
<br>
重复密码:<input type="password" name = "repassword" style="background-color: transparent;">
<br>
邮箱 :<input type="email" name = "emal"style="background-color: transparent;">
<br>
电话 :<input type="text" name = "phen" style="background-color: transparent;">
<br>
<br>
<input type="submit" value="注册" style="background-color