From 5aa7c4f9499135dd12162045e441f5215ee050aa Mon Sep 17 00:00:00 2001
From: Maksymilian Jopek <maks@jopek.eu>
Date: Sun, 26 Mar 2023 18:31:50 +0200
Subject: Full working app

---
 php/get-data.php | 27 +++++++++++++++++++++++++++
 1 file changed, 27 insertions(+)
 create mode 100644 php/get-data.php

(limited to 'php/get-data.php')

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;
+}
-- 
cgit v1.3.1