<?php

declare(strict_types=1);

namespace App\Model;

use Mosaico\Model\BaseModel;

class ProjectModel extends BaseModel
{
    public function getProjects()
    {
        $query = $this->connect()->query(
            "SELECT * 
            FROM projects
            WHERE is_active = 1
            ");
        return $query;
    }

    public function getProjectImages($id)
    {
        $query = $this->connect()->query(
            "SELECT
            image_id,
            image,
            title
            FROM project_images 
            WHERE project_id = " . $id . "
            ");
        return $query;
    }

}