如何在数据库中插入多个选择值 - How to insert multiple select values into database?

How to insert multiple select values into database?

本文关键字：选择插入数据库 | 更新日期: 2023-09-27

我想选择多个选项并在数据库中插入值。我该怎么做？

     <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);
    }

<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);
    }
?>

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

}?>

        <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";
        }
    }
        
        ?>

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 }')";