From f9e2090a1028712ecc6e1b0c71390c821689b414 Mon Sep 17 00:00:00 2001 From: Syndamia Date: Thu, 1 Apr 2021 09:43:48 +0300 Subject: Implemented getById from DB and changed some method names --- src/models/DB.php | 7 +++++++ src/models/JobOffer.php | 11 +++++++++-- 2 files changed, 16 insertions(+), 2 deletions(-) (limited to 'src/models') diff --git a/src/models/DB.php b/src/models/DB.php index 299b05a..b973e4b 100644 --- a/src/models/DB.php +++ b/src/models/DB.php @@ -37,6 +37,13 @@ class DB { $this->connection->exec($query); } + function getById(string $tableName, int $id) { + $sth = $this->connection->prepare("SELECT * FROM `{$tableName}` WHERE id = {$id}"); + $sth->execute(); + + return $sth->fetch(PDO::FETCH_OBJ); + } + function getAllValues(string $tableName) { $sth = $this->connection->prepare("SELECT * FROM `{$tableName}`"); $sth->execute(); diff --git a/src/models/JobOffer.php b/src/models/JobOffer.php index 7603211..3bb1791 100644 --- a/src/models/JobOffer.php +++ b/src/models/JobOffer.php @@ -19,14 +19,21 @@ class JobOffer extends DBModel { self::$DB->createTable(self::TABLE_NAME, self::TABLE_COLUMNS); } + /** + * @return JobOffer + */ + static function getFromDBById(int $id) { + return self::$DB->getById(self::TABLE_NAME, $id); + } + /** * @return JobOffer[] */ - static function getAll() { + static function getAllFromDB() { return self::$DB->getAllValues(self::TABLE_NAME); } - static function insertInDB(JobOffer $jb) { + static function insertIntoDB(JobOffer $jb) { self::$DB->insertValue(self::TABLE_NAME, $jb->title, $jb->description, $jb->company, $jb->salary); } } -- cgit v1.3.1-26-gb76a