是否可以在不重復(fù)上述所有內(nèi)容的情況下從第二種方法執(zhí)行查詢(xún)?或者我應(yīng)該將所有內(nèi)容合并為一個(gè)功能?public function selectAd() { $query = " SELECT category,title,content,date_added from ads "; $stmt = $this->getConnection()->prepare($query); $stmt->execute(); $count = $stmt->rowCount(); if ($count > 0) { $result = $stmt->fetchAll(PDO::FETCH_ASSOC); foreach ($result as $row) { echo '<div class="result">'; echo "Title: <b>".$row['title']."</b>"; echo "<h6>Category:".ucfirst($row['category'])."</h6>" .$row['content']."<br>". "Date: ".$row['date_added']; echo '</div>'; echo "<br>"; } } else { echo "<u><br>Nothing to show yet</u>"; } } public function randomAds() { $query = " SELECT * FROM ads ORDER BY RAND() LIMIT 5; "; // steps from method above }
我可以在不重復(fù)的情況下執(zhí)行 SELECT 查詢(xún)嗎?
人到中年有點(diǎn)甜
2021-09-18 10:55:26