WellnessResources.php

<?php
class WellnessResources
{
    protected static $mysqli;
    
    function __construct($user, $pass, $db)
    {
        self::$mysqli = new mysqli('localhost', $user, $pass, $db);
    }
    
    function getCategory($id)
    {
        $result = self::$mysqli->query('SELECT * FROM categories WHERE id='.(int)$id);
        $row = $result->fetch_assoc();
        return new Category($row['id'], $row['title']);
    }
    
    function getCategories()
    {
        return new Categories(self::$mysqli->query('SELECT * FROM categories ORDER BY title'));
    }
    
    function getArticles()
    {
        return new Articles(self::$mysqli->query('SELECT * FROM articles ORDER BY title'));
    }
    
    public static function getDB()
    {
        return self::$mysqli;
    }
}
?>