如何从PHP中的MYSQL数据库的下拉列表中插入选中的复选框数据

Question

我有一个注册表单，用户可以通过复选框选择多个选项。但是现在当我尝试将选定的数据插入到数据库中时，它不起作用。下面是一些代码：

HTML代码：

<div class="col-md-6"> 
            <div class="form-group"> 
             <label for="decisions3">Skills</label> 
             <select name="langOpt2[]" id="langOpt2" multiple="multiple" class="form-control" required data-validation-required-messge="This field is required"> 



              <?php $selectskill = 'select * from skills where status=1'; 
              $dataskill = mysql_query($selectskill); 
              while($resultskill = mysql_fetch_object($dataskill)) 
              {?> 
               <option value="<?=$resultskill->skill_name?>"<?php if($result001->skill_name==$resultskill->skill_name){?> selected="selected"<?php } ?> > 
               <?=$resultskill->skill_name?> 
              </option> 
              <?php } 
              ?> 
             </select> 
            </div> 

的JS

<script> 
$('#langOpt').multiselect({ 
    columns: 1, 
    placeholder: 'Select Languages' 
}); 

$('#langOpt2').multiselect({ 
    columns: 1, 
    placeholder: 'Select Languages', 
    search: true 
}); 

$('#langOpt3').multiselect({ 
    columns: 1, 
    placeholder: 'Select Languages', 
    search: true, 
    selectAll: true 
}); 

$('#langOptgroup').multiselect({ 
    columns: 4, 
    placeholder: 'Select Languages', 
    search: true, 
    selectAll: true 
}); 
</script> 

，而PHP的： 此代码将数据插入到数据库中。我使用旧的PHP版本插入数据。只是为了练习。

<?php 
if(isset($_POST['submit'])){ 
include("test/admin/includes/db.php");  
$skills=$_POST['langOpt2']; 

foreach($_POST['langOpt2'] as $skills){ 
mysql_query("insert into `job_seeker_reg` (`j_skills`) values('','$skills')"); 
}} 
?> 

Answer 1

贝娄代码帮助解决您的问题。我举个例子是选择科目。你可以使用选项菜单来完成你的任务。

HTML代码：

select subject: <select name="Subject" id="dob-day"> 
 
     <option ">-----</option> 
 
\t \t <option value="Maths">Maths</option> 
 
\t \t <option value="Science">Science</option> 
 
    \t \t \t <option value="Computer Science">Computer Science</option> 
 
\t \t <option value="Languages">English</option> 
 
\t \t <option value="Others">Others</option> 
 
</select>

PHP代码：

<?php 
$dbhost = "localhost";// enter host 
$dbuser = "root";// enter root 
$dbpass = ""; // enter password 
$dberror1 = "Could not connect to the database connection"; 
$dberror2 = "Could not connect to the database"; 

$conn = mysqli_connect($dbhost,$dbuser,$dbpass) or die ($dberror1); 
$select_db = mysqli_select_db($conn,'your_database_name') or die ($dberror2); 

$subject = $_POST['Subject']; 
$sql = "INSERT INTO your_table_name (Subject) VALUES ('$subject')"; 

$result= mysqli_query($conn,$sql); 
if($result){ 
    echo "Enter is success........."; 
} 
?>