From cab93e4b4b26611d59bee711f221e88f4d392dc2 Mon Sep 17 00:00:00 2001 From: Jacob Casper Date: Sat, 9 Apr 2022 16:15:32 -0500 Subject: [PATCH] Start tracking comments --- upload.php | 6 ++++++ 1 file changed, 6 insertions(+) diff --git a/upload.php b/upload.php index 883fa51..d69e283 100644 --- a/upload.php +++ b/upload.php @@ -47,6 +47,12 @@ if ($_SERVER['REQUEST_METHOD'] === 'POST') { $post_stmt->bindValue(':id', $post_id); $post_stmt->bindValue(':user', $user); $post_stmt->bindValue(':time', $post_time); + + $comment_stmt = $db->prepare('INSERT into comments VALUES (:id, :post_id, :body)'); + $comment_stmt->bindValue(':id', uuid_v4()); + $comment_stmt->bindValue(':post_id', $post_id); + $comment_stmt->bindValue(':body', $_POST['comment'] ?? ''); + $comment_stmt->execute(); $post_stmt->execute(); $db->exec('COMMIT'); -- 2.20.1