From: Mischa POSLAWSKY <perl@shiar.org>
Date: Mon, 21 Oct 2019 06:44:48 +0000 (+0200)
Subject: reply: setup database to fetch objects
X-Git-Tag: v4.1~8
X-Git-Url: http://git.shiar.net/minimedit.git/commitdiff_plain/a89937ec79577fd78af6fe40450ca53dd2d3604f

reply: setup database to fetch objects

Avoid repetition on each fetch in upcoming usage.
---

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>',