nieuws/replies: database class with query method

[minimedit.git] / widget / nieuws / replies.php

diff --git a/widget/nieuws/replies.php b/widget/nieuws/replies.php
index 54e552a0ff7cb86f7ade5fee3be6d7fcbd9a8777..13533c99fe09a35049f23d918ced22ecd5e591cb 100644 (file)
--- a/widget/nieuws/replies.php
+++ b/widget/nieuws/replies.php
@@ -8,8 +8,9 @@ if ($_POST) {
        try {
                $html = nl2br(htmlspecialchars($_POST['reply']));
                $html = "<p>$html</p>";
-               $query = $Db->prepare('INSERT INTO comments (page, message, author) VALUES (?, ?, ?)');
-               $query->execute([ $Page, $html, $User->login ]);
+               $query = $Db->query('INSERT INTO comments (page, message, author) VALUES (?, ?, ?)', [
+                       $Page, $html, $User->login
+               ]);
                if (!$query->rowCount()) {
                        throw new Exception('Fout bij opslaan');
                }
@@ -20,8 +21,7 @@ if ($_POST) {
        }
 }
 
-$query = $Db->prepare('SELECT * FROM comments WHERE page = ? ORDER BY created');
-$query->execute([$Page]);
+$query = $Db->query('SELECT * FROM comments WHERE page = ? ORDER BY created', [$Page]);
 
 print '<ul class="replies">';