Implemented value insertion into DB

2 files changed, 22 insertions, 0 deletions

diff --git a/src/models/DB.php b/src/models/DB.php
index 77e08a5..299b05a 100644
--- a/src/models/DB.php
+++ b/src/models/DB.php
@@ -43,4 +43,22 @@ class DB {
 
 		return $sth->fetchAll(PDO::FETCH_OBJ);
 	}
+
+	function insertValue(string $tableName, ...$values) {
+		$query = "INSERT INTO {$tableName} VALUES(NULL, ";
+
+		foreach($values as $value) {
+			if (gettype($value) == "string") {
+				$query .= "'{$value}', ";
+			}
+			else {
+				$query .= "{$value}, ";
+			}
+		}
+		$query = rtrim($query, ", ");
+
+		$query .= ");";
+
+		$this->connection->exec($query);
+	}
 }
diff --git a/src/models/JobOffer.php b/src/models/JobOffer.php
index 736d644..7603211 100644
--- a/src/models/JobOffer.php
+++ b/src/models/JobOffer.php
@@ -25,4 +25,8 @@ class JobOffer extends DBModel {
 	static function getAll() {
 		return self::$DB->getAllValues(self::TABLE_NAME);
 	}
+
+	static function insertInDB(JobOffer $jb) {
+		self::$DB->insertValue(self::TABLE_NAME, $jb->title, $jb->description, $jb->company, $jb->salary);
+	}
 }