我正在尝试在两列(并排)中动态显示产品列表,但我不确定如何使用表格来做到这一点
这是我的代码,在一列中显示所有产品
$productCount = sqlsrv_num_rows($stmt); // count the output amount
$columncount = 0;
$dynamicList = '<table width="744" border="0" cellpadding="6"><tr>';
while($row = sqlsrv_fetch_array($stmt)){
$id = $row["productID"];
$product_name = $row["product_name"];
$product_price = $row["product_price"];
$dynamicList .= '<td width="135"><a href="product_details.php?productID=' . $id . '"><img src="images/products/Small/Men/' . $id . '.jpg" alt="' . $product_name . '" width="129" height="169" border="0"></a></td>
<td width="593" valign="top">' . $product_name . '<br>
£' . $product_price . '<br>
<a href="product_details.php?productID=' . $id . '">View Product Details</a></td>';
if($columncount == 2){
$dynamicList .= '</tr><tr>';
$columncount = 0;
}else
$columncount++;
}
$dynamicList .= '</tr></table>';
<?php echo $dynamicList; ?><br>
如何让我的商品显示在两列而不是一列中?
使用工作解决方案更新了我的帖子
您正在为结果集中的每一行创建一个表
它应该是这样的:
$columncount = 0;
$dynamicList = '<table width="744" border="0" cellpadding="6"><tr>';
while($row = sqlsrv_fetch_array($stmt)){
$id = $row["productID"];
$product_name = $row["product_name"];
$product_price = $row["product_price"];
$dynamicList .= '<td width="135"><a href="product_details.php?productID=' . $id . '"><img src="images/products/Men/' . $id . '.jpg" alt="' . $product_name . '" width="129" height="169" border="0"></a></td>
<td width="593" valign="top">' . $product_name . '<br>
£' . $product_price . '<br>
<a href="product_details.php?productID=' . $id . '">View Product Details</a></td>';
if($columncount == 3){
$dynamicList .= '</tr><tr>';
$columncount = 0;
}else
$columncount++;
}
$dynamicList .= '</tr></table>';
echo $dynamicList;
//a quick solution will be store the number of result rows
$nrow=number_of_rows($result);
//set a counter of the while loop
$count=0;
//and in the while loop put if else condition
$dynamicList = '<table width="744" border="0" cellpadding="6"><tr>';
while($row = sqlsrv_fetch_array($stmt)){
$id = $row["productID"];
$product_name = $row["product_name"];
$product_price = $row["product_price"];
//display the first half of your table in teh left column
if($coun<$nrow/2){
$dynamicList .= '
<td width="135"><a href="product_details.php?productID=' . $id . '"><img src="images/products/Men/' . $id . '.jpg" alt="' . $product_name . '" width="129" height="169" border="0"></a></td>
<td width="593" valign="top">' . $product_name . '<br>
£' . $product_price . '<br>
<a href="product_details.php?productID=' . $id . '">View Product Details</a></td>';
$count++;
//display 2 item only per row
if($count%2)
$dynamicList .= '</tr>';
}else{
//repeate the code but for the rest of the table
}//end else
}//end while
//close the table and display it on the browser
$dynamicList .='</table>';
echo $dynamicList;