时间戳

首页 > 解决方案 > 如何在表格视图中回显数据

php - 如何在表格视图中回显数据

问题描述

我有这个从数据库获取数据的代码，但它只显示表中的一行，另一行将显示在表外

我希望所有数据都显示在表格中

！这是我的照片

这是我连接数据库的代码

<?
session_start();
require('../config.php');
require('../data.php');
require('../fungsi.php');
functionUserLock();
$userStatus=$r["suspend"];
functionUserBlocked($userStatus);
include "head.php";
?>

  <div class="row">

    <div class="col-lg-12">

      <div class="panel panel-red">
        <div class="panel-heading">
          <? echo $phname ; ?> History</div>
        <div class="panel-body">

          <div class="table-responsive">
            <table class="table table-hover table-bordered">

              <thead>
                <tr>

                  <th>
                    <center>Id Trx</center>
                  </th>
                  <th>
                    <center>Date</center>
                  </th>
                  <th>
                    <center>Amount</center>
                  </th>
                  <th>
                    <center>Pair</center>
                  </th>
                  <th>
                    <center>Not Pair</center>
                  </th>

                  <th>
                    <center>Available for
                      <? echo $skgh; ?>
                    </center>
                  </th>
                  <th>
                    <center>Stats</center>
                  </th>
                  <th colspan="2">
                    <center>Option</center>
                  </th>

                </tr>

              </thead>
              <br>
              <tbody>

这是mycode的一部分，它显示在表格中，但只显示一行，另一行不在表格中

<?
$lole=$_COOKIE["username"];
$tabla = mysql_query("SELECT * FROM tb_ph where username='$lole'  and status!='ditahan' ORDER BY id DESC limit 0,1000000"); 
while ($registro = mysql_fetch_array($tabla)) { 
$yereka=$registro["verify"];
$perek=$registro["username"];
$pereka=$registro["id"];
$ferpax=$registro["id"];
$ferpaxd=$registro["username"];



$wedokan=$derekasu * $derekasur;


 $hari = date("H");
  $token=md5($frozenIdTrx.$hari);
            echo "
<tr>

<td>". $registro["idtrx"] ."</td>
<td>". date("d M Y H:i:s A",$registro["date"]) ."</td>
<td>$matauang ". number_format($registro["paket"]) ." </td>
<td>$matauang ". number_format($derekc) ." </td>
<td>$matauang ". number_format($registro["saldo"]) ." </td>
<td>$matauang ". number_format($foolas) ." </td>
<td>". $mystats ."</td>
<td><div data-target=\"#DETAIL$ferpax\" data-toggle=\"modal\" class=\"btn btn-success btn-xs\" style=\"float:center;\"><center>DETAIL</center></div>
</td>
</tr>

";
?>

 
</tbody>


</table>
   
      


<div id="DETAIL<? echo $registro["id"]; ?>" tabindex="-1" role="dialog" aria-labelledby="modal-responsive-label" aria-hidden="true" class="modal fade">
                    <div class="modal-dialog">
                        <div class="modal-content">
                            <div class="modal-header">
                                <button type="button" data-dismiss="modal" aria-hidden="true" class="close">&times;</button>
                                <h4 id="modal-responsive-label" class="modal-title">Detail Transactions</h4></div>
                            <div class="modal-body">

              
<? echo showPhOrderMemberKananModal($ferpaxd,$ferpax); ?> <br>
<? echo showPhOrderMemberKananModalList($ferpaxd,$ferpax); ?>


 <div class="modal-footer">
                                <button type="button" data-dismiss="modal" class="btn btn-default">Close</button>

                            </div>
                        </div>
                    </div>
                </div>
</div>
<?
}
?>
<?
include "foot.php";
?>

标签： php

解决方案

我不知道，但看起来你没有在正确的地方关闭你的循环。

另外，您是否检查过原始查询结果以确保返回的行不止一行？

    <?
$lole=$_COOKIE["username"];
$tabla = mysql_query("SELECT * FROM tb_ph where username='$lole'  and status!='ditahan' ORDER BY id DESC limit 0,1000000"); 
while ($registro = mysql_fetch_array($tabla)) { 
$yereka=$registro["verify"];
$perek=$registro["username"];
$pereka=$registro["id"];
$ferpax=$registro["id"];
$ferpaxd=$registro["username"];



$wedokan=$derekasu * $derekasur;


 $hari = date("H");
  $token=md5($frozenIdTrx.$hari);
            echo "
<tr>

<td>". $registro["idtrx"] ."</td>
<td>". date("d M Y H:i:s A",$registro["date"]) ."</td>
<td>$matauang ". number_format($registro["paket"]) ." </td>
<td>$matauang ". number_format($derekc) ." </td>
<td>$matauang ". number_format($registro["saldo"]) ." </td>
<td>$matauang ". number_format($foolas) ." </td>
<td>". $mystats ."</td>
<td><div data-target=\"#DETAIL$ferpax\" data-toggle=\"modal\" class=\"btn btn-success btn-xs\" style=\"float:center;\"><center>DETAIL</center></div>
</td>
</tr>

";

} // **<------- You need to close the loop here maybe....**
?>

 
</tbody>


</table>
   
      


<div id="DETAIL<? echo $registro["id"]; ?>" tabindex="-1" role="dialog" aria-labelledby="modal-responsive-label" aria-hidden="true" class="modal fade">
                    <div class="modal-dialog">
                        <div class="modal-content">
                            <div class="modal-header">
                                <button type="button" data-dismiss="modal" aria-hidden="true" class="close">&times;</button>
                                <h4 id="modal-responsive-label" class="modal-title">Detail Transactions</h4></div>
                            <div class="modal-body">

              
<? echo showPhOrderMemberKananModal($ferpaxd,$ferpax); ?> <br>
<? echo showPhOrderMemberKananModalList($ferpaxd,$ferpax); ?>


 <div class="modal-footer">
                                <button type="button" data-dismiss="modal" class="btn btn-default">Close</button>

                            </div>
                        </div>
                    </div>
                </div>
</div>
<?
} **// then remove this one i think**
?>

推荐阅读