建议 :先简单了解一下html,css,js,php,mysql,不会的多查百度,百度无敌
1.先连接数据库:
connection.php
<?php
$servername="localhost";
$username="";//数据库的用户名
$password="";//数据库密码
$db="";数据库名称
$conn=mysqli_connect($servername,$username,$password,$db);
?>
2.创建数据表
/*我寻思着怎么创建一个能记录注册的身份信息和留言内容的数据表,
后来想想干脆就做两个数据表,一个有用户名,密码,邮件等的,另一个
只有用户名和留言内容,反正用户名不能有重复的*/
<?php
require("connection.php");
if(!$conn){
die("连接失败”:".mysqli_error($conn));
}
$table="user_datas";//用户注册信息
$sql="CREATE TABLE $table(
id INT(50) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
idtop VARCHAR(50) NOT NULL,
userpassword VARCHAR(50) NOT NULL,
email VARCHAR(50),
phone VARCHAR(11),
reg_date TIMESTAMP
)";
if(mysqli_query($conn,$sql)){
echo "Table $table created successfully".PHP_EOL;
}else{
echo "Table $table created faile";
}
$table="user_messages";//用户留言内容
$sql="CREATE TABLE $table(
id INT(50) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
idtop VARCHAR(50) NOT NULL,
bbs VARCHAR(200),
reg_date TIMESTAMP
)";
if(mysqli_query($conn,$sql)){
echo "Table $table created successfully";
}else{
echo "Table $table created faile";
}
mysqli_close($conn);
?>
3.注册页面(毕竟一开始数据库里面没信息,可以根据类似的思路写代码)
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<link rel="stylesheet" type="text/css" href="css/注册页面.css" />
<title>Document</title>
<script>
function checkName() {
var inputNode = document.getElementById("id");
var spanNode = document.getElementById("iderr");
var content = inputNode.value;
var reg = /^[0-9]*$/;//注意这里无双引号,但是这里可把我眼睛给看瞎去
if (content == "") {
spanNode.innerHTML = "账号不能为空".fontcolor("red");
return false;
}
if ((content.length) < 6) {
spanNode.innerHTML = "账号至少为6位".fontcolor("red");
return false;
}
if (reg.test(content)) {
spanNode.innerHTML = "正确".fontcolor("green");
return true;
} else {
spanNode.innerHTML = "只允许数字".fontcolor("red");
return false;
}
}
function checkpassword() {
var password = document.getElementById("password");
var content = password.value;
var spanNode = document.getElementById("passworderr");
var reg = /^[0-9a-zA-Z]*$/;
if ((password.length) < 6) {
spanNode.innerHTML = "密码至少为6位".fontcolor("red");
return false;
}
if (!reg.test(content)) {
spanNode.innerHTML = "只允许字母和数字".fontcolor("red");
return false;
}
if (content != "") {
spanNode.innerHTML = "已填".fontcolor("green");
return true