php - 在php中的选择选项上设置输入值

Question

我有一个用于选择产品的表格。在所选产品的基础上，我想更新表单中的其余字段。

The Form display with select option

在选择产品名称时，我希望使用 php 从数据库中填写表单的其余详细信息。

这是创建表的代码。

<table id="productTable" class="table-c">
                  <tr>
                    <th class="text-center" style="width: 5%;">SR No.</th>
                    <th class="text-center" style="width: 45%">DESCRIPTION</th>
                    <th class="text-center" style="width: 10%">HSN/SAC</th>
                    <th class="text-center" style="width: 10%">QTY IN-HAND</th>
                    <th class="text-center" style="width: 10%">ENTER OUTWARD QTY</th>
                    <th class="text-center" style="width: 5%">Delete</th>
                  </tr>
                  <tr style="text-align: center;" id="products">
                    <?php $j=0; $j++; ?>
                    <td><?php echo $j; ?></td>
                    <td><select class="form-control" name="code" id="productID" style="width: 429px;">
                      <?php

                      $sql = "SELECT * FROM `product`";
                      $result = $conn->query($sql);

                      if ($result->num_rows > 0) {
                          // output data of each row
                          while($row = $result->fetch_assoc()) {
                            echo "<option id='".$row['code']."' value='".$row['pname']."'>".$row['pname']."</option>";
                          }
                      } else {
                          echo "0 results";
                      }
                      ?>
                      </select>
                    </td>
                    <td><input type="number" name="hsnNo" id="hsnNo" readonly></td>
                    <td><input type="number" name="qty" id="qty" readonly></td>
                    <td class="coljoin"><input type="number" format="2" name="amount"></td>
                    <td>
                      <span class="fa fa-trash"></span>
                    </td>
                  </tr>
                </table>

我应该怎么做？

Answer 1

这是 PHP 代码:-

<form>
    <select name="customer" id="customer_id">
        <option value="">-- Select customer Name -- </option>
        <option value="1">John</option>
        <option value="2">Smith</option>                               
    </select>
   Address: <input name="add" type="text" value="">
   Mobile:  <input name="mobile" type="text" value="">
    EMail-Id:<input name="email" type="text" value="">
 </form>

这是 JS 代码:-

<script src="http://ajax.googleapis.com/ajax/libs/jquery/1.11.0/jquery.min.js"></script>
<script>
    $(document).ready(function() {
        $("#customer_id").change(function() {
                var id = $(this).val();
                var dataString = 'cid='+id;
                //alert(dataString);
                $.ajax({
                    url: 'dataAjax.php',
                    type: 'post',
                    data: dataString,
                    success: function(response) {

                      // Parse the jSON that is returned
                        var Vals    =   JSON.stringify(response);
                        // These are the inputs that will populate
                        $("input[name='add']").val(Vals.add);
                        $("input[name='mobile']").val(Vals.mobile);
                        $("input[name='email']").val(Vals.email);
                         }
            });
        });
    });
</script>

这是其他 PHP 文件代码:-

<?php
// This is where you would do any database call
if(!empty($_POST)) {
    // Send back a jSON array via echo
    echo json_encode(array("add"=>'India',"mobile"=>'1234567890','email'=>'demo@demo.com'));

}
?>