Tul xxx Tul

Viewing: Transaction.php

<?php
class Transaction {
    private $db;
    public function __construct() {
        $this->db = (new Database())->connect();
    }
    public function getByUser($user_id) {
        $stmt = $this->db->prepare('SELECT * FROM transactions WHERE user_id = ?');
        $stmt->execute([$user_id]);
        return $stmt->fetchAll(PDO::FETCH_ASSOC);
    }
    public function getByProject($project_id) {
        $stmt = $this->db->prepare('SELECT * FROM transactions WHERE project_id = ?');
        $stmt->execute([$project_id]);
        return $stmt->fetchAll(PDO::FETCH_ASSOC);
    }
    public function getAll() {
        $stmt = $this->db->query('SELECT * FROM transactions');
        return $stmt->fetchAll(PDO::FETCH_ASSOC);
    }
    public function create($user_id, $project_id, $type, $description, $amount, $date) {
        $stmt = $this->db->prepare('INSERT INTO transactions (user_id, project_id, type, description, amount, date) VALUES (?, ?, ?, ?, ?, ?)');
        return $stmt->execute([$user_id, $project_id, $type, $description, $amount, $date]);
    }
}

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