我們正在嘗試根據標簽或下拉選單進行過濾，我們正在嘗試創建一個具有標簽的博客網站，這些標簽可用于過濾主頁標簽下拉選單上發布的內容：。Here should be the content in the page:這里應該是頁面中的內容：
<nav>
<ul>
<li><a href="Home_loggedin.php">Home</a></li>
<li><a href="">Tags<i class="material-icons">arrow_drop_down</i></a>
<ul class = "dropdown">
<li><a href="Home_loggedin.php">All</button></a></li>
<li><a href="Home_loggedin.php">Homemade</button></a></li>
<li><a href="Home_loggedin.php">Pro</button></a></li>
<li><a href="Home_loggedin.php">Resto</button></a></li>
</ul>
</li>
<!-- Posting -->
<div>
<?php
$query = "select * from posts order by date limit 8";
$result = mysqli_query($con,$query,$tagHomemade);
?>
<?php if(mysqli_num_rows($result) > 0):?>
<div>
<?php while ($row = mysqli_fetch_assoc($result)):?>
<?php
$user_id = $row['user_id'];
$query = "select username, image from users where id ='$user_id' limit 1";
$res = mysqli_query($con,$query);
$user_row = mysqli_fetch_assoc($res);
?>
<div class="card">
<div style ="display: flex;">
<div style ="flex:1", >
<div class="profile"><img class ="icon" src="<?=$user_row['image']?>"></div>
</div>
<div style ="flex:2;" >
<h5>Posted by: <?php echo $_SESSION['logged']['username']?>,
<?php echo date("jS M, Y",strtotime($row['date']))?>
</h5>
<h3><?php echo $row['tag']?>: <?php echo $row['title']?></h>
</div>
</div>
<div>
<?php if (file_exists($row['image']))?>
<div class="img" style="text-align:center;">
<img class="postPic" src="<?=$row['image']?>">
</div>
</div>
<div>
<?php if (!empty ($POST['post']));?>
<?php echo $row['post']?>
</div>
</div>
<?php endwhile;?>
</div>
</div>
<?php endif;?>`
</div>
uj5u.com熱心網友回復：
像這樣在 url 中設定標簽：
<li><a href="Home_loggedin.php?tag=homemade">Homemade</button></a></li>
$_GET['tag']然后你可以在你的代碼中得到它。然后把它放在 SQL 查詢上。
提示：強烈建議使用準備好的陳述句，不要$_GET['tag']直接在 SQL 代碼中使用。它可以防止 SQL 注入并關注特殊字符。
更新：
<nav>
<ul>
<li><a href="Home_loggedin.php">Home</a></li>
<li><a href="">Tags<i class="material-icons">arrow_drop_down</i></a>
<ul class = "dropdown">
<li><a href="Home_loggedin.php">All</button></a></li>
<li><a href="Home_loggedin.php?tag=handmade">Homemade</button></a></li>
<li><a href="Home_loggedin.php?tag=pro">Pro</button></a></li>
<li><a href="Home_loggedin.php?tag=resto">Resto</button></a></li>
</ul>
</li>
<!-- Posting -->
<div>
<?php
$where = !empty($_GET['tag']) ? "where tag = '" . $_GET['tag'] . "'" : "";
$query = "select * from posts $where order by date limit 8";
$result = mysqli_query($con,$query);
?>
<?php if(mysqli_num_rows($result) > 0):?>
<div>
<?php while ($row = mysqli_fetch_assoc($result)):?>
<?php
$user_id = $row['user_id'];
$query = "select username, image from users where id ='$user_id' limit 1";
$res = mysqli_query($con,$query);
$user_row = mysqli_fetch_assoc($res);
?>
<div class="card">
<div style ="display: flex;">
<div style ="flex:1", >
<div class="profile"><img class ="icon" src="<?=$user_row['image']?>"></div>
</div>
<div style ="flex:2;" >
<h5>Posted by: <?php echo $_SESSION['logged']['username']?>,
<?php echo date("jS M, Y",strtotime($row['date']))?>
</h5>
<h3><?php echo $row['tag']?>: <?php echo $row['title']?></h>
</div>
</div>
<div>
<?php if (file_exists($row['image']))?>
<div class="img" style="text-align:center;">
<img class="postPic" src="<?=$row['image']?>">
</div>
</div>
<div>
<?php if (!empty ($POST['post']));?>
<?php echo $row['post']?>
</div>
</div>
<?php endwhile;?>
</div>
</div>
<?php endif;?>
</div>
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/534752.html