From a89937ec79577fd78af6fe40450ca53dd2d3604f Mon Sep 17 00:00:00 2001
From: Mischa POSLAWSKY <perl@shiar.org>
Date: Mon, 21 Oct 2019 08:44:48 +0200
Subject: [PATCH] reply: setup database to fetch objects

Avoid repetition on each fetch in upcoming usage.
---
 database.inc.php | 5 ++++-
 widget/reply.php | 2 +-
 2 files changed, 5 insertions(+), 2 deletions(-)

diff --git a/database.inc.php b/database.inc.php
index 6a82507..2183358 100644
--- a/database.inc.php
+++ b/database.inc.php
@@ -8,7 +8,10 @@ class DB
 
 	function __construct($config, $options = [])
 	{
-		$options += [ PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION ];
+		$options += [
+			PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
+			PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_OBJ,
+		];
 		$this->dbh = new PDO($config, NULL, NULL, $options);
 	}
 
diff --git a/widget/reply.php b/widget/reply.php
index cfa9487..3a16e2c 100644
--- a/widget/reply.php
+++ b/widget/reply.php
@@ -27,7 +27,7 @@ $query = $Db->query('SELECT * FROM comments WHERE page = ? ORDER BY created', [$
 
 print '<ul class="replies">';
 
-while ($row = $query->fetch(PDO::FETCH_OBJ)) {
+while ($row = $query->fetch()) {
 	$rowuser = new User("profile/{$row->author}");
 	print '<li>';
 	printf('<strong>%s</strong> <small class=date>%s</small>',
-- 
2.30.0