Getting data from a multiple select dropdown with PHP to insert into MySQL

Question

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>

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.

shadyyx · Accepted Answer · 2012-05-10 14:04:11Z

4

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...

edited May 10, 2012 at 14:04

answered May 10, 2012 at 13:29

shadyyx

16.1k7 gold badges62 silver badges98 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

에이바바 Over a year ago

I don't understand how to loop through the array to insert into MySQL.

에이바바 Over a year ago

if (isset($_POST['submitted'])) { foreach($_POST AS $key => $value) { $_POST[$key] = $mysqli->real_escape_string($value); } Cannot take an array so I know I have to do something before this.

shadyyx Over a year ago

@에이바 I edited my code. I cannot say how the INSERT have to look like cos I don't know what other data are You inserting and how...

djot · Accepted Answer · 2012-05-10 13:30:39Z

1

foreach ($_POST['days'] AS $key => $value) {
  // INSERT ... where $value is one of the values
}

answered May 10, 2012 at 13:30

djot

2,9474 gold badges21 silver badges28 bronze badges

1 Comment

에이바바 Over a year ago

Could I implode $_POST['days'] then insert it like if (isset($_POST['submitted'])) { foreach($_POST AS $key => $value) { $_POST[$key] = $mysqli->real_escape_string($value); } ?

Collectives™ on Stack Overflow

Getting data from a multiple select dropdown with PHP to insert into MySQL

2 Answers 2

3 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related