From 703b60ed3ca3fb1653c008d42fd2dcf481b72927 Mon Sep 17 00:00:00 2001 From: Erich Eckner Date: Thu, 28 Jul 2022 10:41:30 +0200 Subject: fix syntax error in SQL --- html/db.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/html/db.php b/html/db.php index f638286..503ef13 100644 --- a/html/db.php +++ b/html/db.php @@ -26,7 +26,7 @@ class MyDB extends SQLite3 { return $result; } function add_key($comment) { - $stm = $this -> prepare('INSERT INTO keys (key) VALUES (:key, :comment)'); + $stm = $this -> prepare('INSERT INTO keys (key, comment) VALUES (:key, :comment)'); $stm -> bindValue('key', bin2hex(random_bytes(64))); $stm -> bindValue('comment', $comment); $stm -> execute(); -- cgit v1.2.3-54-g00ecf