将mysql数据插入div

将mysql数据插入div

试图完成一个教程,并试图改型。
我知道整段代码可能与当前无关,
但它可以帮助我分解各个部分并理解整体。

也就是说,我正在尝试将mysql数据插入div而不是表中。
(考虑到更灵敏的CSS设计可能性)

任何帮助都是极好的。

<?php
// Script Error Reporting
error_reporting(E_ALL);
ini_set('display_errors', '1');
?>
<?php
// Run a select query to get my letest 4 items
// Connect to the MySQL database
include "storescripts/connect_to_mysql.php";
$dynamicList = "";
$sql = mysql_query("SELECT * FROM products ORDER BY date_added DESC LIMIT 4");
$productCount = mysql_num_rows($sql); // count the output amount
if ($productCount > 0) {
    while($row = mysql_fetch_array($sql)){
             $id = $row["id"];
             $product_name = $row["product_name"];
             $price = $row["price"];
             $date_added = strftime("%b %d, %Y", strtotime($row["date_added"]));
             $dynamicList .= '<table width="100%" border="0" cellspacing="0" cellpadding="6">
        <tr>
          <td width="17%" valign="top"><a href="product.php?id=' . $id . '"><img style="border:#666 1px solid;" src="inventory_images/' . $id . '.jpg" alt="' . $product_name . '" width="77" height="102" border="1" /></a></td>
          <td width="83%" valign="top">' . $product_name . '<br />
            $' . $price . '<br />
            <a href="product.php?id=' . $id . '">View Product Details</a></td>
        </tr>
      </table>';
    }
} else {
    $dynamicList = "We have no products listed in our store yet";
}
mysql_close();
?>
<!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>The Shop</title>
<link rel="stylesheet" href="style/style.css" type="text/css" media="screen" />
</head>
<body>
<div align="center" id="mainWrapper">
  <?php include_once("template_header.php");?>
  <div id="pageContent">
  <table width="85%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="14%" valign="top"><h3></h3>
      <p><br />
        <br />
        </p></td>
    <td width="66%" align="center">
        <h3>The Shop </h3>
      <p><?php echo $dynamicList; ?><br />
        </p>
      <p><br />
      </p></td>
    <td width="20%" valign="top"><h3></h3>
        <p></p></td>
  </tr>
</table>

  </div>
  <?php include_once("template_footer.php");?>
</div>
</body>
</html>

最佳答案

我假设这应该使您朝正确的方向前进(相应地忽略...)

<?php
  ...
  $dynamicList .= '
  <div>
    <a href="product.php?id=' . $id . '"><img style="border:#666 1px solid;" src="inventory_images/' . $id . '.jpg" alt="' . $product_name . '" width="77" height="102" border="1" /></a>
  </div>
  <div>' . $product_name . '<br />
    $' . $price . '<br />
    <a href="product.php?id=' . $id . '">View Product Details</a>
  </div>';
  ...
?>

...

<div id="pageContent">
  <h3>The Shop </h3>
  <?php echo $dynamicList; ?>
</div>

关于php - 将mysql数据插入div,我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/24871290/

10-11 08:02