使用PHP从多选下拉列表中获取数据以插入MySQL [英] Getting data from a multiple select dropdown with PHP to insert into MySQL

问题描述

我在数据库中有一个用SET数据类型创建的日子列表.

I have a list of days in my database created with the SET datatype.

SET('Mon','Tue','Wed','Thr','Fri','Sat','Sun')

我希望用户能够使用多次选择下拉菜单选择要放入数据库的几天:

I want a user to be able to select multiple days to put into the database using a multiple select dropdown:

<select name='days' id='days' size=4 multiple>
<option name=Mon value=Mon> Mon </option>
<option name=Tue value=Tue> Tue </option>
<option name=Wed value=Wed> Wed </option>
<option name=Thr value=Thr> Thr </option>
<option name=Fri value=Fri> Fri </option>
<option name=Sat value=Sat> Sat </option>
<option name=Sun value=Sun> Sun </option>
</select>

如何从此下拉列表中获取数据以插入到我的mysql查询中?

How can I grab the data from this dropdown to insert into my mysql query?

现在我的查询是这样的:

Right now my query is like this:

$sql2 = " UPDATE tblFacilityHrsDateTimes SET `startEventDate`='{$_POST['startEventDate']}',`endEventDate`='{$_POST['endEventDate']}', `startTime`='{$_POST['startTime']}',`endTime`='{$_POST['endTime']}',`recurrence`='{$_POST['recurrence']},`finalDate`='{$_POST['finalDate']}' WHERE `id` = '$id' "; $mysqli->query($sql2) or die($mysqli->error);

当前，选择框保持不变，它仅能抓住用户选择的某一天.

Currently with the select box as is, it only grabs one of the days selected by a user.

推荐答案

首先，您选择的名称应带有方括号:

First, Your select should have name with square brackets:

<select name='days[]' id='days' size=4 multiple="multiple">

这样，当用户选择更多值(选项)并提交表单时，您将收到他选择的值数组.

This way when a user select more values (options) and submit the form You will receive an array of values he selected.

然后，您必须遍历此数组并插入每条记录:

Then You have to loop through this array and insert each record:

foreach($_POST['days'] as $k => $v) {
    // here do the INSERT query with value $v
}

但是您在选择框下的查询告诉我们，这还不是故事的结局...

But Your query under the select box is telling us that this is not the end of the story...

这篇关于使用PHP从多选下拉列表中获取数据以插入MySQL的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！