我有一個菜單，其中某些頁面具有打開下拉菜單的子頁面。我有兩個 SQL 表：'pages' => page_id, page_name; 'subpages' => subpage_id, page_id, page_name;當我通過表單插入子頁面時，它們獲得與所選父頁面相同的 page_id。問題是，所有菜單元素都顯示下拉箭頭——即使是那些沒有子頁面的元素。僅當頁面有子頁面時如何打??？這就是我要的：if pages.page_id=subpages.page_id print <button class="dropdown-btn"> <?php echo $page['page_name']; ?> <i class="fa fa-caret-down"></i> </button>else print <a href="#"><?php echo $page['page_name']; ?></a>索引.php：<?php foreach ($pages as $page) { ?> <button class="dropdown-btn"> <?php echo $page['page_name']; ?> <i class="fa fa-caret-down"></i> </button> <div class="dropdown-container"><?php foreach ($subpages as $subpage) { if($subpage['page_id'] == $page['page_id']) {?> <a href="../subpage.php?id=<?php echo $subpage['subpage_id']; ?>"> <?php echo $subpage['subpage_name']; ?> </a><?php } } ?> </div><?php } ?>任何幫助表示贊賞！
1 回答
神不在的星期二
TA貢獻1963條經驗 獲得超6個贊
首先，我會Subpage像這樣改變課程：
class Subpage {
public function fetch_all(){
global $pdo;
$query = $pdo->prepare("SELECT * FROM subpages");
$query->execute();
return $query->fetchAll();
}
// Static function: Fetch all subpages of single page
public static function fetch_all_page($page_id){
global $pdo;
$query = $pdo->prepare("SELECT * FROM subpages WHERE page_id = ?");
$query->bindValue(1, $page_id);
$query->execute();
return $query->fetchAll();
}
public function fetch_data($subpage_id) {
global $pdo;
$query = $pdo->prepare("SELECT * FROM subpages WHERE subpage_id =
?");
$query->bindValue(1, $subpage_id);
$query->execute();
return $query->fetch();
}
}
你的 index.php 將變成：
<?php foreach ($pages as $page) { ?>
<?php $subpages = Subpage::fetch_all_page($page['page_id']); ?>
<button class="dropdown-btn">
<?php echo $page['page_name']; ?>
<?php if (count($subpages)): ?>
<i class="fa fa-caret-down"></i>
<?php endif; ?>
</button>
<div class="dropdown-container">
<?php foreach ($subpages as $subpage): ?>
<a href="../subpage.php?id=<?php echo $subpage['subpage_id']; ?>">
<?php echo $subpage['subpage_name']; ?>
</a>
<?php endforeach; ?>
</div>
<?php } ?>
- 1 回答
- 0 關注
- 221 瀏覽
添加回答
舉報
0/150
提交
取消