个人中心
gpt4 book ai didi

mysql - 将多列 MySql 记录转换为响应式显示

转载 作者：行者123 更新时间：2023-11-30 21:54:47 25 4
gpt4 key购买 nike

我一直在绞尽脑汁试图在我过去使用表格来响应的网站中列出成员。我想用 Bootstrap 设计一个新网站，但似乎找不到正确的方法来让记录按照我以前的方式进行格式化。现在它被锁定为 4 横跨，但如果我能让记录填满可用宽度，那就没问题了。谁能帮忙？

下面是我用html显示的代码:

<!-- access ppocc_members -->
<?php require_once('Connections/ppocc_members.php'); ?>
<?php
mysql_select_db($database_ppocc_members, $ppocc_members);
$query_ppoccfrontpage = "SELECT id, uploaded_file_name, StudioName, Phone1, `Website URL` FROM form_results WHERE CurrentMember = 'yes' AND form_results.WebsiteAd = 'yes' ORDER BY RAND() ";
$ppoccfrontpage = mysql_query($query_ppoccfrontpage, $ppocc_members) or die(mysql_error());
$row_ppoccfrontpage = mysql_fetch_assoc($ppoccfrontpage);
$totalRows_ppoccfrontpage = mysql_num_rows($ppoccfrontpage);
?>
<!-- end access ppocc_members -->

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Test Member Database</title>
</head>

<body>



    <p align="left"><font color="#879ECB" size="6" face="Georgia, Times New Roman, Times, serif">W</font><font color="#666666" size="3" face="Georgia, Times New Roman, Times, serif">elcome
        to the Professional Photographers of Cape Cod website, where you can
        find the most extensive list on the net of over 20 Cape Cod
      professional photographers and videographers 
      specializing <br>
      in all areas
        of photography as well as videography. <a href="members/findaphotographer_speciality.php">Find
        a Photographer</a>, and other
      information for <br>
      Brides &amp; Grooms, families, seniors and others interested in the finest
      photography
offered <br>
by many of Cape Cod's most experienced photographers.<br> 
    </font><font size="3" face="Georgia, Times New Roman, Times, serif"><br>
<font color="#879ECB" size="2">Click on any image below to get more information about a member studio</font></font><font color="#666699" size="3" face="Georgia, Times New Roman, Times, serif"> </font></p>
    <table bgcolor="#FFFFFF" >
  <!--DWLayoutTable-->
  <tr>
    <?php
$ppoccfrontpage_endRow = 0;
$ppoccfrontpage_columns = 4; // number of columns
$ppoccfrontpage_hloopRow1 = 0; // first row flag
do {
    if($ppoccfrontpage_endRow == 0  && $ppoccfrontpage_hloopRow1++ != 0) echo "<tr>";
   ?>
    <td width="184" height="218" align="center" valign="top" bgcolor="#FFFFFF"><p align="center"><a href="members/details2.php?recordID=<?php echo $row_ppoccfrontpage['id']; ?>">      <img src="members/files/<?php echo $row_ppoccfrontpage['uploaded_file_name']; ?>" alt="Click For More Details" name="StudioImage" border="0"></a></p>      
      <p align="center"><a href="members/details2.php?recordID=<?php echo $row_ppoccfrontpage['id']; ?>"><font color="#879ECB" size="1" face="Verdana, Arial, Helvetica, sans-serif"><em><font color="#999999">Studio
              Profile</font></em><strong><br>
              <?php echo $row_ppoccfrontpage['StudioName']; ?></strong></font></a><a href="details2.php?recordID=<?php echo $row_ppoccfrontpage['id']; ?>"><font color="#000000" size="1" face="Verdana, Arial, Helvetica, sans-serif"><br>
              </font></a><font color="#999999" size="1" face="Verdana, Arial, Helvetica, sans-serif"><?php echo $row_ppoccfrontpage['Phone1']; ?><br>
            </font><font color="#999999" size="2" face="Verdana, Arial, Helvetica, sans-serif"><a href="<?php echo $row_ppoccfrontpage['Website URL']; ?>" target="_blank"><font size="1"><em>Visit
            Website</em><br>  
            <font color="#000000"><?php echo $row_ppoccfrontpage['StudioName']; ?></font></font></a></font></p>
    </td>
    <?php  $ppoccfrontpage_endRow++;
if($ppoccfrontpage_endRow >= $ppoccfrontpage_columns) {
  ?>
  </tr>
  <tr>
    <td height="13"></td>
    </tr>
  <?php
 $ppoccfrontpage_endRow = 0;
  }
} while ($row_ppoccfrontpage = mysql_fetch_assoc($ppoccfrontpage));
if($ppoccfrontpage_endRow != 0) {
while ($ppoccfrontpage_endRow < $ppoccfrontpage_columns) {
    echo("<td>&nbsp;</td>");
    $ppoccfrontpage_endRow++;
}
echo("</tr>");
}?>
</table>


</body>
</html>

这是我目前使用mysql的网站。www.ppocc.org

最佳答案

在使用 Bootstrap 时，您应该使用网格系统 而不是表格。

Bootstrap v4 示例:

<div class="row">
    <div class="col"></div>
    <div class="col"></div>
    <div class="col"></div>
    <div class="col"></div>
</div>

这里是 Bootstraps documentation .

请注意，类在 v4 中发生了巨大变化，因此如果您使用的是其他版本，您应该引用有关网格系统的版本文档。

关于mysql - 将多列 MySql 记录转换为响应式显示，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/45665172/

25 4 0
文章推荐： c# - 如何在 c# 中使用带有 "not"的 css 选择器？
文章推荐： c# - 如何更改文件名以保存在特定文件夹中
文章推荐： python - 下载多个 PDF 时出现问题
文章推荐： c# - Prism EventAggregator 订阅执行两次
行者123
个人简介

我是一名优秀的程序员,十分优秀！

滴滴打车优惠券免费领取
滴滴打车优惠券
全站热门文章
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com