我有一个php脚本,从mysql数据库表中选择信息,然后使用一个wire循环将其流入表格中,然后为每个单元格创建信息列(日期,图像,图像,图像,图像,图像,图像,图像,图像,图像,图像,图像,图像,,图像,图像,,图像,,图像,图像,,图像,,图像,,图像,,图像,,图像,图像,,图像,数字为loge)句子)。我的问题是这些列是并排的,在我的页面上运行并延伸到远处(http://dankirchoff.com/drawingweek.php)。我需要某种"运输返回"以将其保存在网页上。我正在尝试使用"索引"字段作为计数器的模量,但不起作用。有什么建议吗?
<?php
include ("inc_connect.php");
if ($link !== FALSE) {
$db = "dkfineart_01";
mysqli_select_db($db);
$TableName = "drawingoftheweek";
$sql = "SELECT * FROM $TableName";
if ($res = mysqli_query($link, $sql)) {
if (mysqli_num_rows($res) > 0) {
while ($drawresults = mysqli_fetch_array($res)) {
$drawing[] = $drawresults;
}
echo "<table style='margin-left:190px; width:500px;'><tr>";
foreach ($drawing as $draw) {
echo "<td style='padding:20px 20px 0 0'>" . date('m/d/Y', strtotime($draw['date'])) . "</td>";
}
echo "</tr><tr>";
foreach ($drawing as $draw) {
echo "<td style='padding:0 20px 0 0'>" . "<img src='images/" . $draw['image'] . ".jpg' width='400px'>" . "</td>";
}
echo "</tr><tr>";
foreach ($drawing as $draw) {
echo "<td width='400px' style='padding:0 20px 0 0'>" . $draw['drawingtext'] . "</td>";
}
echo "</tr>";
foreach ($drawing as $draw) {
$index = $draw['index'];
if ($index % 2 === 0) {
echo "<br />";
}
}
echo "</table>";
}
mysqli_free_result($res);
}
else {
echo "No matching records are found.";
}
}
else {
echo "Unable to select from table. " . mysqli_error($link);
}
mysqli_close($link);
?>
我的建议是使用表面以外的其他东西来布置并使用CSS创建断裂。这具有允许您迭代结果一次,而不是将它们存储在数组中并多次迭代。例如:
<style>
#dodWrapper {
margin-left:190px;
}
.dod {
width:500px;
display: inline-block;
}
.dodDate {
padding:20px 20px 0 0;
}
.dodImage {
padding:0 20px 0 0;
}
.dodImage img {
width:400px;
}
.dodText {
padding:0 20px 0 0;
width:400px;
}
</style>
<?php
include ("inc_connect.php");
if ($link !== FALSE) {
$db = "dkfineart_01";
mysqli_select_db($db);
$TableName = "drawingoftheweek";
$sql = "SELECT * FROM $TableName";
if ($res = mysqli_query($link, $sql)) {
if (mysqli_num_rows($res) > 0) {
echo "<div id='dodWrapper'>";
while ($draw = mysqli_fetch_array($res)) {
echo "<div class='dod'>";
echo "<div class='dodDate'>";
echo date('m/d/Y', strtotime($draw['date']));
echo "</div>";
echo "<div class='dodImage'>";
echo "<img src='images/" . $draw['image'] . ".jpg'>";
echo "</div>";
echo "<div class='dodText'>";
echo $draw['drawingtext'];
echo "</div>";
echo "</div>";
}
echo "</div>";
}
mysqli_free_result($res);
}
else {
echo "No matching records are found.";
}
}
else {
echo "Unable to select from table. " . mysqli_error($link);
}
mysqli_close($link);
?>
这使用div代替表格和显示:内联块本质上像对待每个块一样对待每个块,并在"线"结束时断开。