Test 5
public function getAllBlogPosts()
{
$sql = "SELECT * FROM blog_posts WHERE status = 1 ORDER BY created_at DESC";
$res = $this->db->query($sql);
$posts = [];
if ($res) {
while ($row = $res->fetch_object()) {
$posts[] = $row;
}
}
return $posts;
}
public function getBlogPostBySlug($slug)
{
// ovde NE mora ni da se slugifikuje ako već u bazi čuvaš slug
$slug = mysqli_real_escape_string($this->db, $slug);
$sql = "SELECT * FROM blog_posts WHERE slug = '$slug' AND status = 1 LIMIT 1";
$res = $this->db->query($sql);
if ($res && $row = $res->fetch_object()) {
return $row;
}
return null;
}
← Nazad na blog
