How to insert multiple select values into database?

Question

I want to select multiple choice and insert the values in database. How can I do this?

     <select name="instructor" multiple>
      <option value="9000">Zaher</option>
      <option value="9001">Samih</option>
      <option value="9010">Majd</option>
     <select>

    $instructor=$_GET['instructor'];
    if(isset($_SESSION['courses']) && isset($_SESSION['semester'])){

       $coursechosen= $_SESSION['courses'];
        $semesterchosen=$_SESSION['semester'];
    $query="Insert INTO coordinators(instructor_id,course_code,semester) 
    VALUES ('$instructor','$coursechosen','$semesterchosen')";

    mysql_query($query);
    }

Please check the link:- http://bytes.com/topic/php/answers/956318-how-insert-multiple-values-into-mysql-multiple-select-option-form — Alive to die - Anant, Apr 04 '15 at 11:58
You have a SQL injection opportunity in `$instructor` - don't go live without fixing this! It is recommended to switch to a newer database library, so you can use parameter binding, which will help avoid this problem. — halfer, Apr 04 '15 at 12:15
[Read this](http://stackoverflow.com/questions/60174/how-can-i-prevent-sql-injection-in-php). — halfer, Apr 04 '15 at 13:15

score 4 · Answer 1 · answered Jun 29 '17 at 15:43

<select name="instructor[]" multiple>
      <option value="9000">Zaher</option>
      <option value="9001">Samih</option>
      <option value="9010">Majd</option>
     <select>

// Your PHP code
<?php
foreach ($_GET['instructor'] as $value) {
            $instructor.= $value.", ";
        }

    if(isset($_SESSION['courses']) && isset($_SESSION['semester'])){

       $coursechosen= $_SESSION['courses'];
        $semesterchosen=$_SESSION['semester'];
    $query="Insert INTO coordinators(instructor_id,course_code,semester) 
    VALUES ('$instructor','$coursechosen','$semesterchosen')";

    mysql_query($query);
    }
?>

score 2 · Accepted Answer · answered Apr 04 '15 at 12:00

2

<select name="instructor[]" multiple>
<?php 
foreach ($_POST['instructor'] as $icon) 
{
 ///your insert code//


}?>

answered Apr 04 '15 at 12:00

Vivek Singh

2,453
1
14
27

@AssoumZoghbi plz tick my answer so another can get help easily – Vivek Singh Apr 04 '15 at 12:15
sorry but how can i let the value selected visible when i submit until i re select another one? – aaaz Apr 04 '15 at 16:54
sorry 4 wat?? and this is another question @Assoum Zoghbi – Vivek Singh Apr 05 '15 at 05:15
i mean i have another question. how can i let the value selected visible when i submit until i re select another one?@vicky – aaaz Apr 05 '15 at 12:17
if you have another question than you have to post it again than you can get answer – Vivek Singh Apr 05 '15 at 13:04

Mojtaba Rahmandoost · Answer 3 · 2020-12-06T18:11:30.647

0

        <select name="instructor[]" multiple>
              <option value="9000">Zaher</option>
              <option value="9001">Samih</option>
              <option value="9010">Majd</option>
             <select>
                <input type="submit" value="send" name="send">
         
       //php code
        <?php
        if (isset($_POST['send']))
    {
        if (isset($_POST['instructor']))
        {
            $instructor= implode(',',$_POST['instructor']);
            $query="INSERT INTO `database` VALUES ('0','$instructor')";

mysql_query($query);
        }
        else
        {
            print "no selected";
        }
    }
        
        ?>

edited Dec 06 '20 at 18:11

answered Dec 04 '20 at 19:21

Mojtaba Rahmandoost

1
1

1

Code-only answers like this are often down-voted here. Please [edit](https://stackoverflow.com/posts/65099721/edit) your answer and explain what you changed or how it works. – Arthur Pereira Dec 05 '20 at 00:19
implode() returns a string containing a string representation of all the array elements in the same order, with the glue string between each element. https://www.php.net/manual/en/function.implode.php – Mojtaba Rahmandoost Dec 06 '20 at 18:21

score 0 · Answer 4 · answered Apr 12 '22 at 12:44

First use instructor as instructor[] so will become an array

<select name="instructor[]" multiple>
  <option value="9000">Zaher</option>
  <option value="9001">Samih</option>
  <option value="9010">Majd</option>
 <select>

In php file 
$instructor = $_POST['instructor'];

USE THE IMPLODE FUNCTION OF PHP
$instructor= implode(",",$instructor);

so result will be 9000,9001,9010
NOW $instructor = 9000,9001,9010;

$sql = "INSERT INTO `TABLE`(`instructor`) VALUES ('{$instructor }')";

How to insert multiple select values into database?

4 Answers4