<?php

class Transaction
{
    public $mysqli;

    public function __construct()
    {
        $this->mysqli = new mysqli('localhost', 'akiniktransactions', '.3[HO07+LWo{', 'akiniktransactions');
    }

    public function verify($txnid, $journal, $ref_number)
    {
        $stmt = $this->mysqli->prepare("SELECT * FROM transactions WHERE (txnid = ? AND journal = ? AND original_ref_number = ? AND uploaded = 'false') AND (status = 'successful' OR status = 'pay later')");
        $stmt->bind_param('sss', $txnid, $journal, $ref_number);
        $stmt->execute();
        $stmt->store_result();
        $count_rows = $stmt->num_rows();
        $stmt->close();
        if ($count_rows == 0) {
            return 'Please enter a valid txn ID.';
        }
        return null;
    }
    public function uploaded($txnid, $journal, $ref_number)
    {
        $stmt = $this->mysqli->prepare("UPDATE transactions SET uploaded = 'true' WHERE (txnid = ? AND journal = ? AND original_ref_number = ?)");
        $stmt->bind_param('sss', $txnid, $journal, $ref_number);
        $stmt->execute();
        $stmt->close();
    }
}

$transaction = new Transaction;