且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何在表格中插入多个复选框值?

更新时间:2022-12-11 21:06:23

您应指定

<input type="checkbox" name="Days[]" value="Daily">Daily<br>

作为数组.

在所有名称Days中添加[],并像在数组中那样在php上工作.

Add [] to all names Days and work at php with this like an array.

之后,您可以在db的不同列上INSERT值,或者使用implode并将值保存到一列中.

After it, you can INSERT values at different columns at db, or use implode and save values into one column.

没有测试过,但是您可以尝试这样.不要忘记用mysqli替换mysql.

Didn't tested it, but you can try like this. Don't forget to replace mysql with mysqli.

<html>
<body>
<form method="post" action="chk123.php">
Flights on: <br/>
<input type="checkbox" name="Days[]" value="Daily">Daily<br>
<input type="checkbox" name="Days[]" value="Sunday">Sunday<br>
<input type="checkbox" name="Days[]" value="Monday">Monday<br>
<input type="checkbox" name="Days[]" value="Tuesday">Tuesday <br>
<input type="checkbox" name="Days[]" value="Wednesday">Wednesday<br>
<input type="checkbox" name="Days[]" value="Thursday">Thursday <br>
<input type="checkbox" name="Days[]" value="Friday">Friday<br>
<input type="checkbox" name="Days[]" value="Saturday">Saturday <br>
<input type="submit" name="submit" value="submit">
</form>
</body>
</html>


<?php

// Make a MySQL Connection
mysql_connect("localhost", "root", "") or die(mysql_error());
mysql_select_db("test") or die(mysql_error());

$checkBox = implode(',', $_POST['Days']);

if(isset($_POST['submit']))
{       
    $query="INSERT INTO example (orange) VALUES ('" . $checkBox . "')";     

    mysql_query($query) or die (mysql_error() );

    echo "Complete";

}

?>