Abstracted database :wrench: :package:

3 files changed, 10 insertions, 2 deletions

diff --git a/crawler/CrawlController.php b/crawler/CrawlController.php
index 53d5aac..5b20b75 100644
--- a/crawler/CrawlController.php
+++ b/crawler/CrawlController.php
@@ -6,9 +6,9 @@ header('Content-type: text/plain; charset=utf-8');
  * Time: 23:48
  */
 
-require_once 'mysql_conf.inc';
+require_once '../database/mysqlConf.inc';
+require_once '../database/Database.php';
 require_once 'WebRequest.php';
-require_once 'Database.php';
 require_once 'Algorithms.php';
 
 class CrawlController
diff --git a/crawler/Database.php b/database/Database.php
index f27803e..51e1430 100644
--- a/crawler/Database.php
+++ b/database/Database.php
@@ -69,6 +69,14 @@ class Database
         $stmt->execute([':url' => $url, ':title' => $data['title'] ?? '', ':description' => $data['description'] ?? '', ':lang' => $data['lang'] ?? 'en', ':hash' => md5($url)]);
     }
 
+    public static function getUrlData($query)
+    {
+        $conn = self::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);
+    }
+
     private static function initDbConnection(): PDO
     {
         global $servername, $dbname, $username, $password;
diff --git a/crawler/mysql_conf.inc b/database/mysqlConf.inc
index 5d70dd5..5d70dd5 100644
--- a/crawler/mysql_conf.inc
+++ b/database/mysqlConf.inc