1、首先在mysql命令控制台新建数据库
mysql> create database test;
Query OK, 1 row affected (0.04 sec)
mysql> use test;
Database changed
mysql> create table test_table(
-> id int(5) auto_increment primary key,
-> user char(10),
-> pass char(10),
-> text char(10),
-> sex char(1),
-> connect char(10));
Query OK, 0 rows affected (0.21 sec)
mysql>
2、登录注册代码
index.html
登录register.html
注册login.php
try {
$conn = new mysqli('localhost', 'root', '','test');
}
catch (Exception $e) {
die("数据库连接失败");
}
$conn->query("SET NAMES 'UTF8'");
$user = $_POST['user'];
$pass = $_POST['pass'];
$sql="SELECT * FROM test_table where user='$user' and pass='$pass'";
$rs=$conn->query($sql);
$row = $rs-> fetch_array();
// var_dump($row);
if($row['user']==$user&& $row['pass']==$pass){
echo $row['user']."登陆成功!";
}
else{
echo"登录失败,请重新登录!";
}
?>
register.php
header ( "Content-type:text/html;charset=utf-8" );
try {
$conn = new mysqli('localhost', 'root', '','test');
}
catch (Exception $e) {
die("数据库连接失败");
}
$conn->query("SET NAMES 'UTF8'");
$user = $_POST['user'];
$pass = $_POST['pass'];
$sex = $_POST['sex'];
$connect = $_POST['connect'];
$text = $_POST['text'];
$sql = "INSERT INTO test_table VALUES ('','{$user}' ,'{$pass}','{$text}','{$sex}' ,'{$connect}' )";
$result = $conn->query($sql);
// if ($result > 0) {
// echo "
// window.location='index.html'; //跳转到注册页
// ";
// } else {
// echo "
// window.history.back(); //返回上一页
// ";
// }
echo("注册成功!!!点击登录")
转载:https://blog.csdn.net/cai181191/article/details/79341614