是否可以在不重复上述所有内容的情况下从第二种方法执行查询?或者我应该将所有内容合并为一个功能?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 }
1 回答
- 1 回答
- 0 关注
- 129 浏览
添加回答
举报
0/150
提交
取消