Tul xxx Tul

Viewing: ProjectUpdate.php

<?php

class ProjectUpdate extends BaseModel
{
    protected string $table = 'project_updates';
    protected array $fillable = ['project_id','description','progress','created_by','created_at'];

    public function getUpdatesByProject(int $projectId): array
    {
        $st=$this->db->prepare('SELECT project_updates.*, users.name AS user_name FROM project_updates LEFT JOIN users ON users.id=project_updates.created_by WHERE project_id=:project_id ORDER BY project_updates.created_at DESC');
        $st->execute(['project_id'=>$projectId]);
        return $st->fetchAll();
    }
}

User / IP	: 216.73.216.159
Host / Server	: 45.84.207.204 / aircan.me
System	: Linux lt-bnk-web1726.main-hosting.eu 5.14.0-611.36.1.el9_7.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Mar 3 11:23:52 EST 2026 x86_64