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 为什么使用javacv转封装rtsp为rtmp时出现如下问题:[h264 @ 000000004faf7500]no frame?
  • ¥15 乘性高斯噪声在深度学习网络中的应用
  • ¥15 运筹学排序问题中的在线排序
  • ¥15 关于docker部署flink集成hadoop的yarn,请教个问题 flink启动yarn-session.sh连不上hadoop,这个整了好几天一直不行,求帮忙看一下怎么解决
  • ¥30 求一段fortran代码用IVF编译运行的结果
  • ¥15 深度学习根据CNN网络模型,搭建BP模型并训练MNIST数据集
  • ¥15 C++ 头文件/宏冲突问题解决
  • ¥15 用comsol模拟大气湍流通过底部加热(温度不同)的腔体
  • ¥50 安卓adb backup备份子用户应用数据失败
  • ¥20 有人能用聚类分析帮我分析一下文本内容嘛