时间戳

首页 > 解决方案 > 根据从多选下拉列表中选择的价格数据总和

javascript - 根据从多选下拉列表中选择的价格数据总和

问题描述

根据选择，我希望在 totalamount 输入框中显示总数据价格

 <HTML>
   <body>
<form name="myForm" action="insert.php" onsubmit="return validateForm()" method="post" id="myForm" style="width=90%" enctype="multipart/form-data" required>
<label>Test Name:</label>
     <select id="framework" name="framework[]" multiple class="form-control" >
<option value="HDL Cholesterol" data-price="180">HDL Cholesterol</option>
<option value="Total Cholesterol" data-price=180180180>Total Cholesterol</option>
<option value="Triglycerides (TG)" data-price=180285180>Triglycerides (TG)</option>
<option value="Sugar (Glucose) Fasting (FBS)" data-price=28570285>Sugar (Glucose) Fasting (FBS)</option>
<option value="Sugar (Glucose) Post Prandial (PPBS)" data-price=707070>Sugar (Glucose) Post Prandial (PPBS)</option>
<option value="Sugar (Glucose) Random (RBS)" data-price=707070>Sugar (Glucose) Random (RBS)</option>
<option value="Reticulocyte Count" data-price=7055070>Reticulocyte Count</option>
<option value="Total Thyroxine (T4)" data-price=550198550>Total Thyroxine (T4)</option>
<option value="Total Triiodothyronine (T3)" data-price=198198198>Total Triiodothyronine (T3)</option>
<option value="TSH (Thyroid Stimulating Hormone)" data-price=198240198>TSH (Thyroid Stimulating Hormone)</option>
<option value="Alkaline Phosphatase (ALP)" data-price=240210240>Alkaline Phosphatase (ALP)</option>
<option value="Aspartate Aminotransferase (SGOT )" data-price=210190210>Aspartate Aminotransferase (SGOT )</option>
<option value="Bilirubin Total" data-price=190130190>Bilirubin Total</option>
<option value="Calcium" data-price=130176130>Calcium</option>
<option value="Iron" data-price=176380176>Iron</option>
</select>
<td><label>Total Amount:</label><input type="number" name="totalamount">
</body>
</html>

标签： javascriptphpmysqldrop-down-menu

解决方案

我正在使用以下功能，你能请他吗

on deselecting dropdown option, value remains with no changes
function is to get comma separated testcode to testcode inputbox and totalamount to totalamoun text box 
        <html>`enter code here`
    <body>
          // query to fetch data from database
        $data="";
        $query = "SELECT testcode,testname,mrp FROM pricelist";
        $resultSet = mysqli_query($conn, $query);
        if ($resultSet)
        {
          while($row = mysqli_fetch_array($resultSet)) {
            $data .="<option value='".$row['testname']."' data-price='".$row['mrp']."' data-id='".$row['testcode']."'>".$row['testname']."</option>";
          }
        }
        //form 
        <div class="form-group1">
        <label>Test Name:</label>
             <select id="framework" name="framework[]" multiple class="form-control" >
                  <?php echo $data; ?>
             </select>
            </div>
          </td>    
          <td><label>Test Code:</label><input type="text" id="testcode" name="testcode"></td>    
        <tr class="line_items">    
          <td><label>Total Amount:</label><input type="number" id="totalamount" name="totalamount">
        //jquery function
        <script>
        var total=0;
        var code="";
        $('#framework').on('change', function(){
          var mPrice = $(this).find('option:selected').data('price');
          var mCode = $(this).find('option:selected:last').data('id');
          if (mPrice != null){
            total+=mPrice;
            code +=mCode+',';
            $('#totalamount').val(total);
            $('#testcode').val(code);
          } else {
            
          }
        });
    </body>
        </html>

推荐阅读