diff options
| author | ilotterytea <iltsu@alright.party> | 2025-04-20 16:06:19 +0500 |
|---|---|---|
| committer | ilotterytea <iltsu@alright.party> | 2025-04-20 16:06:19 +0500 |
| commit | 5fc857449011f76ed7677aad40576790310d23e1 (patch) | |
| tree | a8bbff085c1cd83d5070c1bf4c013e79cfe8f938 /src | |
| parent | 10cde47798f2a7b10a84a22f53aeddab1ceea720 (diff) | |
feat: moved from SQLite to MySQL
Diffstat (limited to 'src')
| -rw-r--r-- | src/accounts.php | 15 | ||||
| -rw-r--r-- | src/config.php | 5 | ||||
| -rw-r--r-- | src/emotes/single_page.php | 14 |
3 files changed, 22 insertions, 12 deletions
diff --git a/src/accounts.php b/src/accounts.php index 4273964..330ad3c 100644 --- a/src/accounts.php +++ b/src/accounts.php @@ -1,4 +1,6 @@ <?php +include_once "config.php"; + function authorize_user() { session_start(); @@ -11,13 +13,14 @@ function authorize_user() return; } - $db = new SQLite3("../../database.db"); + include_once "config.php"; + + $db = new PDO(DB_URL, DB_USER, DB_PASS); - $stmt = $db->prepare("SELECT id, username FROM users WHERE secret_key = :secret_key"); - $stmt->bindValue("secret_key", $_COOKIE["secret_key"]); - $results = $stmt->execute(); + $stmt = $db->prepare("SELECT id, username FROM users WHERE secret_key = ?"); + $stmt->execute([$_COOKIE["secret_key"]]); - if ($row = $results->fetchArray()) { + if ($row = $stmt->fetch()) { $_SESSION["user_id"] = $row["id"]; $_SESSION["user_name"] = $row["username"]; } else { @@ -25,5 +28,5 @@ function authorize_user() setcookie("secret_key", "", time() - 1000); } - $db->close(); + $db = null; }
\ No newline at end of file diff --git a/src/config.php b/src/config.php new file mode 100644 index 0000000..188b7bb --- /dev/null +++ b/src/config.php @@ -0,0 +1,5 @@ +<?php +// DATABASE +define("DB_USER", "kochan"); +define("DB_PASS", "kochan"); +define("DB_URL", "mysql:host=localhost;dbname=tinyemotes;port=3306");
\ No newline at end of file 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 @@ +<?php +include_once "../../src/config.php"; +?> <html> <head> @@ -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 "<a href=\"$link\">"; |