如何使用Php mysql和mamp插入和回显复选框


how to Insert and echo checkboxes with Php mysql and mamp

我真的很难让复选框工作,我已经看了教程却找不到帮助……我不确定如何在MAMP中设置复选框表以及如何插入它…

如果有人能帮上忙,那就太好了……

HTML:

<form action="mainpage2.php" method="POST">
  Search : <input type="text" name="firstname" id="name" />
  <input type="submit" name="confirm" value="Submit" />
  <input type="checkbox" name="tick[]" value="male" />
  <input type="checkbox" name="tick[]" value="female" />
  <input type="checkbox" name="tick[]" value="alien" />
</form>   
PHP:

if(isset($_POST['confirm'])) {
    $subject = $_POST['firstname']; 
    $subjec = $_POST['tick']; 
    $result = mysql_query("INSERT INTO chipsticks (Name,sports) VALUES ('$subject'),('subjec');",$database);

为了将其存储在数据库中,您需要将数组扁平化。

if(isset($_POST['confirm']))
{
    $subject = $_POST['firstname']; 
    $subjec = $_POST['tick']; 
    $sports = '';
    if(is_array($subjec) && count($subjec)>0)
    {
        $sports = implode(',',$subjec);
    }
    $result = mysql_query("INSERT INTO chipsticks (Name,sports) VALUES ('$subject','$sports')",$database);
}

也可以使用serialize

来代替内爆