Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //Показать все категории
- function categories() {
- $db = new SQLite3(DB_NAME);
- $results = $db->query("SELECT DISTINCT category FROM articles");
- $articles = $db->querySingle("SELECT COUNT(*) as count FROM articles WHERE category LIKE '%$category%'");
- while ($row = $results->fetchArray()) {
- echo 'Категория: <a href="?category=' . $row['category'] . '">' . $row['category'] . '</a> Статей: (' . $articles . ')';
- }
- $db->close();
- }
- //Показать все категории
- function categories() {
- $db = new SQLite3(DB_NAME);
- $results = $db->query("SELECT DISTINCT category FROM articles");
- while ($row = $results->fetchArray()) {
- $articles = $db->querySingle("SELECT COUNT(*) as count FROM articles WHERE category LIKE '%".$row['category']."%'");
- echo 'Категория: <a href="?category=' . $row['category'] . '">' . $row['category'] . '</a> Статей: (' . $articles . ')';
- }
- $db->close();
- }
- //Показать все категории
- function categories() {
- $db = new SQLite3(DB_NAME);
- // Один вызов со всем что нужно
- $results = $db->query("SELECT DISTINCT category, COUNT(category) as count FROM articles Group by category");
- while ($row = $results->fetchArray()) {
- echo 'Категория: <a href="?category=' . $row['category'] . '">' . $row['category'] . '</a> Статей: (' . $row['count'] . ')';
- }
- $db->close();
- }
Add Comment
Please, Sign In to add comment