$category_id = (int) $category_id;
$query = $pdo->prepare('SELECT * FROM articles WHERE article_category = ? ORDER BY article_id ' . $val);
$query->bindValue(1, $category_id);
$query->execute();
return $query->fetchAll();
}
// fetch article with id number
public function fetch_article($id = '1')
{
global $pdo;
$id = (int) $id;
$query = $pdo->prepare("SELECT * FROM articles WHERE article_id = ?");
$query->bindValue(1, $id);
$query->execute();
return $query->fetchAll();
}
}
?>
// Simple use cms class
<?php
$perpage = 44;
$page = '1';
$catid = '2';
if (isset($_GET['page'])) {
$page = (int) $_GET['page'];
}
$article = new Cms();
$articles = $article->fetch_all_pagine_cat($catid, $page, $perpage);
$cat = $article->fetch_category();
