douxun4173 2015-12-29 13:20 采纳率: 0%
浏览 45
已采纳

单击的复选框将显示另一个输入字段,如何将其放入数据库?

I have a working code where if I select multiple checkboxes, it will be saved in the database in separate rows (it is required). Also, I have a working code where if it checks a certain checkbox, another input field will show. Now, how do I save the checkbox value along the other input field that comes with it in the database?

This is the form:

<form class="form-horizontal form-label-left" name = "documentRequest" enctype="multipart/form-data" role="form" method="post" novalidate>

<div class = "second">

<div class="item form-group">
<label class="control-label col-md-3 col-sm-3 col-xs-12"> Document Request(s) <span class="required">*</span>
</label>
<div class="col-md-6 col-sm-6 col-xs-12">

<input type="checkbox" name="docs[]" id="doc1" value="Certificate of Residency" /> Certificate of Residency
<br/>
<div class = "col-xs-3">
    <input name="d1" class="form-control col-md-7 col-xs-12" required="required" type="number">
</div>

<div class = "clearfix"></div>

<input type="checkbox" name="docs[]" id="doc2" value="Barangay Clearance"  /> Barangay Clearance                                                    
<br />
<div class = "col-xs-3">
    <input name="d2" class="form-control col-md-7 col-xs-12" required="required" type="number">
</div>

    <div class = "clearfix></div>
</form>

This is my php code (this works; it saves multiple checkbox values):

<?php
include 'config.php';

if (isset($_POST['documentRequest']))
{

 $chkbox = $_POST['docs'];

 $i = 0;

 foreach($chkbox as $chk1)  
   {  
       $query = mysqli_query($conn, "INSERT INTO document(typeOfDoc) VALUES ('$chk1');"); 
   }  
 echo "Checkbox value is successfully submitted.";
 } ?>

This is the picture of the form: enter image description here

Can you all please help me? How do I save this? Thank you.

  • 写回答

1条回答 默认 最新

  • doubeishuai6598 2015-12-29 13:39
    关注
        Try this
    
     <?php
     include 'config.php';
    
        if (isset($_POST['documentRequest']))
         {
    
           $chkbox = $_POST['docs'];
    
             $i = 0;
    
             foreach($chkbox as $chk1)  
               {
                    if($chk1=='Certificate of Residency') 
                    {
                      $chek_val=$_POST['d1'];
                    }
                    else if($chk1=='Barangay Clearance') 
                    {
                      $chek_val=$_POST['d2'];
                    }
    
                   $query = mysqli_query($conn, "INSERT INTO document(typeOfDoc,docval) VALUES ('$chk1','$chek_val');"); 
               }  
             echo "Checkbox value is successfully submitted.";
             } ?
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 使用ue5插件narrative时如何切换关卡也保存叙事任务记录
  • ¥20 软件测试决策法疑问求解答
  • ¥15 win11 23H2删除推荐的项目,支持注册表等
  • ¥15 matlab 用yalmip搭建模型,cplex求解,线性化处理的方法
  • ¥15 qt6.6.3 基于百度云的语音识别 不会改
  • ¥15 关于#目标检测#的问题:大概就是类似后台自动检测某下架商品的库存,在他监测到该商品上架并且可以购买的瞬间点击立即购买下单
  • ¥15 神经网络怎么把隐含层变量融合到损失函数中?
  • ¥15 lingo18勾选global solver求解使用的算法
  • ¥15 全部备份安卓app数据包括密码,可以复制到另一手机上运行
  • ¥20 测距传感器数据手册i2c