view_products()下面僅顯示我的表中的一項數據，product該表包含 20 條數據。取決于您放置在顯示第一個數據的return $output;內部或顯示最后一個數據的外部的位置。while loopwhile loop<?php echo view_products(); ?>$dbhost = "localhost";$dbuser = "root";$dbpass = "password@edadmin";$dbname = "estore";$dbconn = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);//Test if connection occurred,if (mysqli_connect_errno()) { die("Database connection failed: " . mysqli_connect_error() . " (" . mysqli_connect_errno() . ")");}function view_products(){ global $dbconn; $sql = "SELECT * FROM product"; $result = mysqli_query($dbconn, $sql); if (mysqli_num_rows($result) > 0) { while ($products = mysqli_fetch_assoc($result)) { $output = "<div class=\"col-lg-4 col-md-6 portfolio-item filter-app wow fadeInUp\">"; $output .= "<div class=\"portfolio-wrap\"><figure>"; $output .= "<img src=" . $products['ProductImage'] . " class=\"img-fluid\" alt=\"\">"; $output .= "<a href=" . $products['ProductImage'] . " data-lightbox=\"portfolio\" data-title=\"App 1\" class=\"link-preview\" title=\"Preview\"><i class=\"ion ion-eye\"></i></a>"; $output .= "</figure>"; $output .= " <div class=\"portfolio-info\">"; $output .= "<p><a href=\"#\">" . $products['ProductName'] . " </a></p>"; $output .= "<p>" . "₦ " . $products['ProductAmount'] . "</p>"; $output .= "</div></div></div>"; return $output; } } else { return "No product yet"; } // return $output;}
1 回答
呼如林
TA貢獻1798條經驗 獲得超3個贊
原因是您正在重置$output循環第一行中$output = "<div class=\"col-lg-4 col-md-6 portfolio-item filter-app wow fadeInUp\">"; 的內容因此，如果您將 return 放在循環末尾，則在第一個循環中它將返回第一條記錄并退出該函數，如果您將其放在函數的末尾，在每個循環$output中將被清除，并且該循環的內容將僅被寫入，$output因此在函數的末尾，您將只擁有最后一個循環的內容$output
您可以設置$output為空字符串，然后將所有內容附加到循環中。$output還要在塊中設置 的值else，然后在最后返回$output
function view_products()
{
global $dbconn;
$sql = "SELECT * FROM product";
$result = mysqli_query($dbconn, $sql);
if (mysqli_num_rows($result) > 0) {
$output = "";
while ($products = mysqli_fetch_assoc($result)) {
$output .= "<div class=\"col-lg-4 col-md-6 portfolio-item filter-app wow fadeInUp\">";
$output .= "<div class=\"portfolio-wrap\"><figure>";
$output .= "<img src=" . $products['ProductImage'] . " class=\"img-fluid\" alt=\"\">";
$output .= "<a href=" . $products['ProductImage'] . " data-lightbox=\"portfolio\" data-title=\"App 1\" class=\"link-preview\" title=\"Preview\"><i class=\"ion ion-eye\"></i></a>";
$output .= "</figure>";
$output .= " <div class=\"portfolio-info\">";
$output .= "<p><a href=\"#\">" . $products['ProductName'] . " </a></p>";
$output .= "<p>" . "₦ " . $products['ProductAmount'] . "</p>";
$output .= "</div></div></div>";
}
} else {
$output = "No product yet";
} // return $output;
return $output;
}
- 1 回答
- 0 關注
- 262 瀏覽
添加回答
舉報
0/150
提交
取消