From e9ba7fbcff47f0e4a03d74b857e9864d67a8b163 Mon Sep 17 00:00:00 2001 From: Syndamia Date: Thu, 1 Apr 2021 09:37:42 +0300 Subject: Implemented value insertion into DB --- src/models/DB.php | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) (limited to 'src/models/DB.php') 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); + } } -- cgit v1.3.1-23-gd82d