Full working app

1 files changed, 27 insertions, 0 deletions

diff --git a/php/get-data.php b/php/get-data.php
new file mode 100644
index 0000000..42d58e9
--- /dev/null
+++ b/php/get-data.php
@@ -0,0 +1,27 @@
+<?php
+function getChartData($getPK = false): array
+{
+  $user = 'clientApps';
+  $pass = 'clientApps';
+  $db = 'ClientApps';
+  $out = [];
+
+  $pdo = new PDO("mysql:dbname=$db;host=localhost;charset=utf8mb4", $user, $pass);
+  $pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
+
+  if ($getPK === true) {
+    $stmt = $pdo->prepare("SELECT id, data FROM chart_x");
+    $stmt->execute();
+    $out[0] = $stmt->fetchAll(PDO::FETCH_ASSOC);
+  } else {
+    $stmt = $pdo->prepare("SELECT data FROM chart_x");
+    $stmt->execute();
+    $out[0] = $stmt->fetchAll(PDO::FETCH_COLUMN);
+  }
+
+  $stmt = $pdo->prepare("SELECT data FROM chart_y");
+  $stmt->execute();
+  $out[1] = $stmt->fetchAll(PDO::FETCH_COLUMN);
+
+  return $out;
+}