From d3833d2a50371b5ebc989ca9b4a999a5f7f74c98 Mon Sep 17 00:00:00 2001
From: Georgi Nikolov <ggeorgi60@gmail.com>
Date: Fri, 17 Jan 2025 20:07:55 +0200
Subject: Added example mariadb code in php

---
 src/archive_page.php | 12 +++++++++++-
 1 file changed, 11 insertions(+), 1 deletion(-)

(limited to 'src/archive_page.php')

diff --git a/src/archive_page.php b/src/archive_page.php
index bd1f872..9c37fb0 100644
--- a/src/archive_page.php
+++ b/src/archive_page.php
@@ -42,9 +42,19 @@
     }
 
     $WEBSITE_CATEGORY = 'page_url';
+    $DATABASE_NAME = 'db';
+    $TABLE_NAME = 'users';
     $website_url = $_POST[$WEBSITE_CATEGORY];
     $website_exists = does_website_exist($website_url) ? "true" : "false";
-    echo "Website exists: $website_exists";
+    echo "Website exists: $website_exists" . "<br/>";
+
+    try {
+        $db = new PDO("mysql:host=localhost;dbname=$DATABASE_NAME", $user, $password);
+        echo $db->query("DESCRIBE $TABLE_NAME");
+    } catch (PDOException $e) {
+        print "Error!: " . $e->getMessage() . "<br/>";
+        die();
+    }
 ?>
 </p>
 </body>
-- 
cgit v1.2.3