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