private $PG_W = 210;
public function Header()
{
$this->SetFont('Arial', 'B', 12);
$this->Cell($this->PG_W, 8, "Equity Investment Bank Ltd.", 0, 0, 'L');
$this->Ln();
$this->Cell($this->PG_W, 5, "Transactions Statement", 0, 0, 'L');
$this->Ln(10);
$this->SetFont('Arial', 'B', 12);
$this->Cell($this->PG_W / 4, 5, "{$allnames}", 0, 0, 'L');
$this->Cell($this->PG_W / 4, 5, "P.O Box:", 0, 0, 'L');
$this->Cell($this->PG_W / 4, 5, "Town:", 0, 0, 'L');
$this->Cell($this->PG_W / 4, 5, "Tel. No:", 0, 0, 'L');
$this->Cell($this->PG_W / 4, 5, "Email:", 0, 0, 'L');
$this->Ln();
$this->Cell($this->PG_W / 4, 5, "Invoice Date:", 0, 0, 'L');
$this->Cell($this->PG_W / 4, 5, date("d/m/Y", time()), 0, 0, 'L');
$this->Cell($this->PG_W / 4, 5, "Address:", 0, 0, 'L');
$this->MultiCell($this->PG_W / 4, 5, "1 Some Road\nSome Town\nPost Code", 0, 'L');
$this->Ln(10);
}
public function Transactions()
{
}
}
$statement = new statement();
$statement->Open();
$statement->AddPage();
$statement->SetAuthor('Allan Kemboi');
$statement->SetTitle('Member Statement ');
$statement->Output();
public function execute($sql, $placeholders = array())
{
$stmt = new statement($this->dh);
return $stmt->query($sql, $placeholders);
}
