ubantu下用php和mysql实现注册功能

向右看齐 2022-01-22 09:53 193阅读 0赞

前端表单代码（**register.php**）：

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
    <html>
    <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
    <title>Insert title here</title>
    </head>
    <body>
    
    <br/><br/><br/><br/><br/><br/><br/>
    
    <form action="regcheck.php" method="post">  
        ID(纯数字)：<input type="text" name="id"/>  
        <br/>  
        mail：<input type="text" name="mail"/>  
        <br/>  
        name：<input type="text" name="name"/>  
        <br/>  
        密　码:<input type="text" name="pwd"/>  
        <br/>  
        确认密码：<input type="text" name="confirm"/>  
        <br/>  
        <input type="Submit" name="Submit" value="注册"/>  
    </form>
    
    
    
    </body>
    </html>

后台处理代码（**regcheck.php**）

<?php  
    
        if(isset($_POST["Submit"]) && $_POST["Submit"] == "注册")  
        {  
            $id = $_POST["id"];  
    	$name = $_POST["name"];
    	$mail = $_POST["mail"];
            $pwd = $_POST["pwd"];  
            $pwd_confirm = $_POST["confirm"];  
    
    	echo $id;  
    	echo "<br/>";
    	echo $name;
    	echo "<br/>"; 
    	echo $mail;
    	echo "<br/>";
    	echo $pwd;
    	echo "<br/>";
    	echo $pwd_confirm;
    	echo "<br/>";
    
    
     	if ($name == ''){
                echo '<script>alert("请输入用户名！");history.go(-1);</script>';
                exit(0);
            }
            if ($pwd == ''){
                echo '<script>alert("请输入密码");history.go(-1);</script>';
                exit(0);
            }
    	if ($mail == ''){
                echo '<script>alert("请输入mail");history.go(-1);</script>';
                exit(0);
            }
            if ($pwd != $pwd_confirm){
                echo '<script>alert("密码与确认密码应该一致");history.go(-1);</script>';
                exit(0);
            }
            if($pwd == $pwd_confirm){
                $conn = new mysqli('localhost','led','123456','db_cexu');
                if ($conn->connect_error){
                    echo '数据库连接失败！';
                    exit(0);
                }else {
                    $sql = "select id from cexu_data where id = '$id'";
                    $result = $conn->query($sql);
                    $number = mysqli_num_rows($result);
    		echo $number;
    
                    if ($number) {
                        echo '<script>alert("用ID已经存在");history.go(-1);</script>';
                    } else {
                        $sql_insert = "insert into cexu_data (id,name,mail,pwd) values('$id','$name','$mail','$pwd')";
                        $res_insert = $conn->query($sql_insert);
                        if ($res_insert) {
                            echo "success!";
                        } else {
                            echo "<script>alert('系统繁忙，请稍候！');</script>";
                        }
                    }
                }
            }else{
                echo "<script>alert('提交未成功！'); history.go(-1);</script>";
            }
    
    
    }
    
    ?>

前端注册页面：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9saXUtZW5kb25nLmJsb2cuY3Nkbi5uZXQ_size_16_color_FFFFFF_t_70][]

后台跳转页面：

![20190605212312318.png][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9saXUtZW5kb25nLmJsb2cuY3Nkbi5uZXQ_size_16_color_FFFFFF_t_70 1][]

参考：

[https://blog.csdn.net/qq\_29656961/article/details/78924085][https_blog.csdn.net_qq_29656961_article_details_78924085]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9saXUtZW5kb25nLmJsb2cuY3Nkbi5uZXQ_size_16_color_FFFFFF_t_70]: /images/20220122/69747a37da334eb0bab733736aca7df1.png
[20190605212312318.png]: /images/20220122/f9725d920b224132883ff0eb2e8ac887.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9saXUtZW5kb25nLmJsb2cuY3Nkbi5uZXQ_size_16_color_FFFFFF_t_70 1]: /images/20220122/d8019a73fd984ef189f60dc41177bef9.png
[https_blog.csdn.net_qq_29656961_article_details_78924085]: https://blog.csdn.net/qq_29656961/article/details/78924085