mysql插入复选框数据_php – 将复选框值存储到mysql数据库

我在mysql db中存储复选框值时遇到问题(只有最后一个值存储在数据库中).

如何修复此代码以存储所有已检查的值？

Which, if any, of these activities did you do on the Internet in the last 30 days?

Used e-mail

Used instant messenger & chat room

Made a purchase for personal use

Downloaded/Played a video game

Obtained news/information/current events

Looked for employment (Used classified listings)

Looked for recipes

Downloaded a movie

include('config.php');

$tbl_name="temp_members_db";

$q1=$_POST['q1'];

$sql="INSERT INTO $tbl_name(q1)VALUES('$q1')";

?>

解决方法:

$q1=implode(',', $_POST['q1']);

标签：php,mysql,checkbox

来源： https://codeday.me/bug/20190930/1837029.html