环境:树莓派上搭建LNMPWeb服务器
HTML+PHP+MySQL实现用户的注册及登陆功能
HTML实现注册界面及登陆界面
sign_up.html //注册界面
sign_in.html //登陆界面
PHP文件实现接收用户注册/登陆数据功能
sign_up.php //接收用户注册数据
sign_in.php //接收用户登陆数据
MySQP存储用户登录数据信息
使用PHP连接MySQP
PDO方式操作
登录MySQL并创建数据库
$servername = "localhost";
$DBName = "";
$DBUsername = "";
$DBPassword = "";
$conn = new PDO("mysql:host=$servername", $DBUsername, $DBPassword);
$sql = "create database $DBName";
conn->exec(sql);
echo "create db success" . "<br>";
链接数据库并创建用户表
$conn = new PDO( "mysql;host=$servername;dbname=$DBName", $DBUsername, $DBPassword);
$createtablesql = "";
$conn->exec($createtablesql);
echo "create table success" . "<br>"