<?php

include __DIR__ . '/../class/Article.php';
include __DIR__ . '/DB.php';

class News
{
    protected $db;
    protected $data;

    public function __construct()
    {
        $this->db = new DB;
    }

    public function getAllNews()
    {
        // id = type serial
        $dataNews = $this->db->query('SELECT * FROM `news` ORDER BY `id`DESC', []);
        $this->data = [];
        foreach ($dataNews as $value){
            $this->data[] = new Article($value['title'], $value['content'], $value['author'], $value['id']);
        }
        return $this->data;
    }

    public function getArticle($id)
    {
        $this->data = [];
        $article = $this->db->query('SELECT * FROM `news` WHERE id=:id', [':id' => $id]);
        foreach ($article as $value){
            $this->data[] = new Article($value['title'], $value['content'], $value['author'], $value['id']);
        }
        return $this->data;
    }

}