duanang58939 2017-10-06 11:29
浏览 88
已采纳

如何在不同的文本框中打印数组值

I have these values inside a table here

and I want them to print in each of the textboxes like

this

Can anyone help me with that?

This is my code so far

PHP

<?php 
    $spnsrArr = $conn->query("SELECT bap_sponsors.* FROM bap_sponsors WHERE bap_id='$bapID'");

    $row = mysqli_fetch_array($spnsrArr);
         $spnsrName = $row['sponsors_name'];
         $spnsrAge = $row['sponsors_age'];
         $spnsrReligion = $row['sponsors_religion'];
         $spnsrPlace = $row['sponsors_residence'];

 ?>

HTML

<label>SPONSOR #1</label>
<div class="form-group">
  <div class="col-md-6">
    <h5>Name:</h5>
    <input type="text" name="$spnsName[]" class="form-control" value="<?php echo $spnsrName; ?>" disabled="" />
  </div>
  <div class="col-md-2">
    <h5>Age:</h5>
    <input type="number" name="age[]" class="form-control" value="<?php echo $spnsrAge; ?>" disabled="" />
  </div>
  <div class="col-md-4">
    <h5>Religion:</h5>
    <input type="text" name="spnsrreligion[]" class="form-control" value="<?php echo $spnsrReligion; ?>" disabled="" />
  </div>
  <div class="col-md-12">
    <h5>Residence:</h5>
    <input type="text" name="spnsrresidence[]" class="form-control" value="<?php echo $spnsrPlace; ?>" disabled="" /><br>
    <hr>
  </div>
</div>
  • 写回答

1条回答 默认 最新

  • douyouchou1085 2017-10-06 11:46
    关注

    Your query

    $spnsrArr = $conn->query("SELECT bap_sponsors.* FROM bap_sponsors WHERE bap_id='$bapID'");
    

    returns several rows. But

    $row = mysqli_fetch_array($spnsrArr);
    

    fetches only one.

    You should iterate over results, calling mysqli_fetch_array several times. This is usually done with while:

    $i = 0;
    while ($row = mysqli_fetch_array($spnsrArr)) {
        $spnsrName = $row['sponsors_name'];
        $spnsrAge = $row['sponsors_age'];
        $spnsrReligion = $row['sponsors_religion'];
        $spnsrPlace = $row['sponsors_residence'];
        $i++;
        ?>
        <label>SPONSOR #<?php echo $i;?></label>
        <div class="form-group">
          <div class="col-md-6">
            <h5>Name:</h5>
            <input type="text" name="spnsName[]" class="form-control" value="<?php echo $spnsrName; ?>" disabled="" />
          </div>
          <div class="col-md-2">
            <h5>Age:</h5>
            <input type="number" name="age[]" class="form-control" value="<?php echo $spnsrAge; ?>" disabled="" />
          </div>
          <div class="col-md-4">
            <h5>Religion:</h5>
            <input type="text" name="spnsrreligion[]" class="form-control" value="<?php echo $spnsrReligion; ?>" disabled="" />
          </div>
          <div class="col-md-12">
            <h5>Residence:</h5>
            <input type="text" name="spnsrresidence[]" class="form-control" value="<?php echo $spnsrPlace; ?>" disabled="" /><br>
            <hr>
          </div>
        </div>
    <?php
    }
    

    Also note I removed $ in name="$spnsName[]".

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 装 pytorch 的时候出了好多问题,遇到这种情况怎么处理?
  • ¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本
  • ¥15 手机接入宽带网线,如何释放宽带全部速度
  • ¥30 关于#r语言#的问题:如何对R语言中mfgarch包中构建的garch-midas模型进行样本内长期波动率预测和样本外长期波动率预测
  • ¥15 ETLCloud 处理json多层级问题
  • ¥15 matlab中使用gurobi时报错
  • ¥15 这个主板怎么能扩出一两个sata口
  • ¥15 不是,这到底错哪儿了😭
  • ¥15 2020长安杯与连接网探
  • ¥15 关于#matlab#的问题:在模糊控制器中选出线路信息,在simulink中根据线路信息生成速度时间目标曲线(初速度为20m/s,15秒后减为0的速度时间图像)我想问线路信息是什么