view_products()下面僅顯示我的表中的一項(xiàng)數(shù)據(jù)，product該表包含 20 條數(shù)據(jù)。取決于您放置在顯示第一個(gè)數(shù)據(jù)的return $output;內(nèi)部或顯示最后一個(gè)數(shù)據(jù)的外部的位置。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貢獻(xiàn)1798條經(jīng)驗(yàn) 獲得超3個(gè)贊
原因是您正在重置$output循環(huán)第一行中$output = "<div class=\"col-lg-4 col-md-6 portfolio-item filter-app wow fadeInUp\">"; 的內(nèi)容因此，如果您將 return 放在循環(huán)末尾，則在第一個(gè)循環(huán)中它將返回第一條記錄并退出該函數(shù)，如果您將其放在函數(shù)的末尾，在每個(gè)循環(huán)$output中將被清除，并且該循環(huán)的內(nèi)容將僅被寫入，$output因此在函數(shù)的末尾，您將只擁有最后一個(gè)循環(huán)的內(nèi)容$output
您可以設(shè)置$output為空字符串，然后將所有內(nèi)容附加到循環(huán)中。$output還要在塊中設(shè)置 的值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 關(guān)注
- 275 瀏覽
添加回答
舉報(bào)
0/150
提交
取消