如何使用php向数据库提交数据

1、在checkreg.php中写以下内容:

<?php
header('Content-type:text/html;charset=utf-8');
if(isset($_POST['submit'])){
    if(empty($_POST['user-name'])){
        echo "<script>alert('用户名不能为空');window.location.href='login-register.html'</script>";
        }
    if(empty($_POST['user-password'])){
        echo "<script>alert('密码不能为空');window.location.href='login-register.html'</script>";
        }
    if($_POST['user-password']!= $_POST['user-repassword']){
        echo "<script>alert('密码不一致');window.location.href='login-register.html'</script>";
        }
        $userName = $_POST['user-name'];
        $userPassword = $_POST['user-password'];
        
        
        
        $conn = @mysqli_connect('localhost','admin','Fromchina1','mymarket');
        $sql = "insert into mymarket value(null ,'{$userName}','{$userPassword}')";
        $query = mysqli_query($conn,$sql);
        
        if($query){
            echo "<script>alert('注册成功');window.location.href='index.html'</script>";
        }else{
            echo "<script>alert('注册失败');window.location.href='login-register.html'</script>";
        }   
    }else{
        exit("<h1>非submit提交</h1>");
    }
?>

如果提交未成功，可以试着关闭防火墙，即可成功