php - 我如何使用 HTML 复选框将 1 或 0 插入 mysql bool 值

Question

我正在尝试为作业创建注册表单，但我遇到了困难，因为我必须允许管理员权限，所以我决定在我的表中创建一个名为管理员的列作为 bool 值，即真或假。在我的注册表单上，我希望使用一个复选框，如果选中，则他们是管理员，如果没有，则他们不是。

如何使 mysql 语句的复选框 = 1 或 0？

这里是注册代码:

     <form method="POST" action="new-user 2.php">
             <td>Full Name</td><td>
             <input type="text" name="name"></td>
            </tr> 
            <tr>
             <td>Email</td>
             <td> 
             <input type="text" name="email"></td> 
             </tr> 
             <tr>
            <td>UserName</td>
            <td> 
            <input type="text" name="user">
            </td> </tr> 
            <tr> 
            <td>Password</td>
            <td> 
            <input type="password" name="pass">
            </td>
            </tr> 
            <tr>
            <td>Confirm Password </td>
            <td><input type="password" name="cpass">
            </td> 
            </tr> 
            </tr> 
            <tr>
            <td>Administrator </td>
            <td><input type="checkbox" name="cbox" />
            </td> 
            </tr> 
            <tr> 
            <td>
            <input id="button" type="submit" name="submit" value="Register">
            </td> 
            </tr> 
        </form>
    </table>
    </fieldset>
    </div> 
    </div>
</body>
</html>
<?php
if(isset($_POST['cbox']))
{
    $administrator ='1';
}
else
{
    $administrator ='0';
}
?>

谢谢

更新:

新的user2.php代码如下:

require_once('connection.php');
function NewUser() 
{ 
#$salt = 'sadfh9832asd34rf28asjvddap';
#$crypt = crypt ($salt .$password);

    $fullname = $_POST['name'];
    $userName = $_POST['user'];
    $email = $_POST['email'];
    $administrator =$_POST['administrator'];
    #$password = crypt($_POST['pass']);
        $password = md5($_POST['pass']);
        echo "<hr>".$_POST['pass'] . "=[$password]<hr>";
    #$password = stripslashes($password); 
    #$password = mysql_real_escape_string($password);

    $query = "INSERT INTO `WebsiteUsers`(`fullname`, `userName`, `email`, `pass`, `administrator`)  VALUES ('$fullname','$userName','$email','$password', 'administrator')"; 
    $data = mysql_query ($query)or die(mysql_error()); 
        echo "<hr>$query<hr>";

    if($data) 
    { 
    echo "YOUR REGISTRATION IS COMPLETED..."; 
    } 
}

 function SignUp() 
 { 
     if(!empty($_POST['user'])) //checking the 'user' name which is from Sign-Up.html, is it empty or have some text
     { $query = mysql_query("SELECT * FROM WebsiteUsers WHERE userName = '$_POST[user]' 
     AND pass = '$_POST[pass]'") or die(mysql_error());

     if(!$row = mysql_fetch_array($query) or die(mysql_error())) 
     { 
     newuser(); 
     } 
     else
     { 
     echo "SORRY...YOU ARE ALREADY A REGISTERED USER..."; }
     } 
} 
if(isset($_POST['submit']))
{ 
     SignUp(); 
} 

#header("location:index.html");
 ?>

<?php
$cookie_name = "cookieuser";
$cookie_value = $fullname;
setcookie($cookie_name, $cookie_value, time() + (86400 * 30), "/"); // 86400 = 1 day
?>

Answer 1

为复选框指定一个值，如下所示

<input type="checkbox" name="cbox" value="1" />

然后检查该值是否像这样分配给 $_POST 变量。

if($_POST['cbox'] == '1')

下面列出了完整的代码。我做了一些修改。

     <form method="POST" action="new-user 2.php">
             <td>Full Name</td><td>
             <input type="text" name="name"></td>
            </tr> 
            <tr>
             <td>Email</td>
             <td> 
             <input type="text" name="email"></td> 
             </tr> 
             <tr>
            <td>UserName</td>
            <td> 
            <input type="text" name="user">
            </td> </tr> 
            <tr> 
            <td>Password</td>
            <td> 
            <input type="password" name="pass">
            </td>
            </tr> 
            <tr>
            <td>Confirm Password </td>
            <td><input type="password" name="cpass">
            </td> 
            </tr> 
            </tr> 
            <tr>
            <td>Administrator </td>
            <td><input type="checkbox" name="cbox" value="1" />
            </td> 
            </tr> 
            <tr> 
            <td>
            <input id="button" type="submit" name="submit" value="Register">
            </td> 
            </tr> 
        </form>
    </table>
    </fieldset>
    </div> 
    </div>
</body>
</html>


<?php
if(isset($_POST['cbox']))
{
    if($_POST['cbox'] == '1'){
        $administrator ='1';
    }else{
        $administrator ='0';
    }
}else
{
    $administrator ='0';
}
?>