From b4c9a7fa69ffe6be856a2a0fd063f76584ed2096 Mon Sep 17 00:00:00 2001
From: Marvin Borner
Date: Wed, 19 Sep 2018 18:39:51 +0200
Subject: Added better requesting of data :zap:

---
 request.php         | 21 ---------------------
 request/request.php |  5 +++++
 2 files changed, 5 insertions(+), 21 deletions(-)
 delete mode 100644 request.php
 create mode 100644 request/request.php

diff --git a/request.php b/request.php
deleted file mode 100644
index e649103..0000000
--- a/request.php
+++ /dev/null
@@ -1,21 +0,0 @@
-<?php
-include 'mysql_conf.inc';
-
-print_r(getContent($argv[1]));
-
-function getContent($query)
-{
-    $conn = initDbConnection();
-    $checkStmt = $conn->prepare('SELECT url, title, description, lang FROM url_data WHERE title LIKE :query OR description LIKE :query');
-    $checkStmt->execute([':query' => '%' . $query . '%']);
-    return $checkStmt->fetchAll(PDO::FETCH_ASSOC);
-}
-
-function initDbConnection()
-{
-    global $servername, $dbname, $username, $password;
-    $conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
-    $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
-    $conn->exec('SET CHARACTER SET utf8');
-    return $conn;
-}
\ No newline at end of file
diff --git a/request/request.php b/request/request.php
new file mode 100644
index 0000000..0dc7a14
--- /dev/null
+++ b/request/request.php
@@ -0,0 +1,5 @@
+<?php
+include '../database/mysqlConf.inc';
+include '../database/Database.php';
+
+print_r(Database::getUrlData($_GET['search'] ?? ''));
\ No newline at end of file
-- 
cgit v1.2.3