From a945feb02f6d64df2219ea1044251a7fe2ea98fc Mon Sep 17 00:00:00 2001
From: Mateja <mail@matejamaric.com>
Date: Sat, 3 Apr 2021 00:37:03 +0200
Subject: Initial commit.

---
 querydb.php | 17 +++++++++++++++++
 1 file changed, 17 insertions(+)
 create mode 100644 querydb.php

(limited to 'querydb.php')

diff --git a/querydb.php b/querydb.php
new file mode 100644
index 0000000..dade409
--- /dev/null
+++ b/querydb.php
@@ -0,0 +1,17 @@
+<?php
+$user = "example_user";
+$password = "password";
+$database = "example_database";
+$table = "todo_list";
+
+try {
+  $db = new PDO("mysql:host=localhost;dbname=$database", $user, $password);
+  echo "<h2>TODO</h2><ol>";
+  foreach($db->query("SELECT content FROM $table") as $row) {
+    echo "<li>" . $row['content'] . "</li>";
+  }
+  echo "</ol>";
+} catch (PDOException $e) {
+    print "Error!: " . $e->getMessage() . "<br/>";
+    die();
+}
-- 
cgit v1.2.3