From 067e78d5d64adbf52c911f0f65cdaa7f8156e903 Mon Sep 17 00:00:00 2001
From: Syndamia <kamen.d.mladenov@protonmail.com>
Date: Wed, 31 Mar 2021 20:41:37 +0300
Subject: Added database initialisation to DB model; added a script for
 watching file changes

---
 src/index.php     |  7 ++++++-
 src/models/DB.php | 31 +++++++++++++++++++++++++++++++
 2 files changed, 37 insertions(+), 1 deletion(-)
 create mode 100644 src/models/DB.php

(limited to 'src')

diff --git a/src/index.php b/src/index.php
index d87d760..86562ab 100644
--- a/src/index.php
+++ b/src/index.php
@@ -1 +1,6 @@
-<p>Hello</p>
+<p>Hello World!</p>
+<?php
+	include_once("models/DB.php");
+
+	$db = new DB();
+?>
diff --git a/src/models/DB.php b/src/models/DB.php
new file mode 100644
index 0000000..f6db512
--- /dev/null
+++ b/src/models/DB.php
@@ -0,0 +1,31 @@
+<?php
+class DB {
+	private static $servername = "localhost";
+	private static $username = "root";
+	private static $password = "password";
+	private static $dbname = "devrix_job_board";
+
+	private $connection;
+
+	function __construct() {
+		$this->connection = mysqli_connect(self::$servername, self::$username, self::$password);
+
+		if (!$this->connection) {
+			die(mysqli_connect_error());
+		}
+
+		// Make sure the actual db exists
+		$createDBQuery = "CREATE DATABASE IF NOT EXISTS " . self::$dbname . ";";
+
+		if (!mysqli_query($this->connection, $createDBQuery)) {
+			die(mysqli_error($this->connection));
+		}
+
+		// Make the actual connection to the database
+		mysqli_select_db($this->connection, self::$dbname);
+	}
+
+	function __destruct() {
+		mysqli_close($this->connection);
+	}
+}
-- 
cgit v1.3.1-26-gb76a