diff options
1 files changed, 31 insertions, 0 deletions
| -rw-r--r-- | src/models/DB.php | 31 |
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); + } +} |