From 5fc857449011f76ed7677aad40576790310d23e1 Mon Sep 17 00:00:00 2001 From: ilotterytea Date: Sun, 20 Apr 2025 16:06:19 +0500 Subject: feat: moved from SQLite to MySQL --- src/emotes/single_page.php | 14 ++++++++------ 1 file changed, 8 insertions(+), 6 deletions(-) (limited to 'src/emotes/single_page.php') diff --git a/src/emotes/single_page.php b/src/emotes/single_page.php index fb87789..900003c 100644 --- a/src/emotes/single_page.php +++ b/src/emotes/single_page.php @@ -1,3 +1,6 @@ + @@ -76,17 +79,16 @@ $link = "#"; if ($emote->get_uploaded_by()) { - $db = new SQLite3("../../database.db"); - $stmt = $db->prepare("SELECT username FROM users WHERE id = :id"); - $stmt->bindValue(":id", $emote->get_uploaded_by()); - $results = $stmt->execute(); + $db = new PDO(DB_URL, DB_USER, DB_PASS); + $stmt = $db->prepare("SELECT username FROM users WHERE id = ?"); + $stmt->execute([$emote->get_uploaded_by()]); - if ($row = $results->fetchArray()) { + if ($row = $stmt->fetch()) { $username = $row["username"]; $link = "/users/" . $emote->get_uploaded_by(); } - $db->close(); + $db = null; } echo ""; -- cgit v1.2.3