PHP后端

<?php
# 建立连接
$servername='127.0.0.1:3306';
$username='root';
$password='';
$conn=new mysqli($servername,$username,$password); 
if ($conn->connect_error){
    echo "连接失败";
}
else {
    echo "连接成功";
}
echo "<br>";

# 创建数据库mai
$sql="create database fei";
if ($conn->query($sql)==true){
    echo "创建成功";
}
else {
    echo "创建不成功".$conn->error;
}
echo "<br>";
    
#关闭连接 连接jiang数据库
$conn->close();
$servername='127.0.0.1:3306';
$username='root';
$password='';
$dbname='fei';
$conn=new mysqli($servername,$username,$password,$dbname); 
if ($conn->connect_error){
    echo "连接失败";
}
else {
    echo "连接成功";
}
echo "<br>";
    
#创建数据表
$table='create table mfp (account char(10) not null primary key,passwd char(10),username char(10))';
if ($conn->query($table)==true){
    echo "创建成功";
}
else {
    echo "创建不成功".$conn->error;
}
echo "<br>";
    
#插入数据
$sql="insert into mfp (account,passwd,username)
                  values('admin','password','admin'),
                        ('Jack','jackto123','Jack'),
                        ('Alice','aliceto456','Alice')";
if ($conn->query($sql)==true){
    echo "数据插入成功";}
else {
    echo "数据插入不成功".$conn->error;
}
echo "<hr>";
$account=$_POST['account'];
$passwd=$_POST['passwd'];
$sql='select * from mfp ';
$result=$conn->query($sql); 
if ($result->num_rows>0){
while($row=$result->fetch_array()){
    if($row['account']==$account && $row['passwd']==$passwd){
        echo "恭喜".$row['username']."登陆成功！";
        exit;}
}}

$sql='select * from mfp ';
$result=$conn->query($sql);
if ($result->num_rows>0){
while($row=$result->fetch_array()){
if($row['account']!=$account && $row['passwd']!=$passwd){
        echo"非法登录！";
        exit;}
        }}
?>