Summary Files Commits Branches @commit @diff @stats
path: root / src / models
diff options
context:
space:
mode:
Commit42a0e2f72fed0a947242b004a0fc6eb4a664174b (patch)
Author
 Syndamia <kamen.d.mladenov@protonmail.com>
2021-04-03 16:04:28 +0300
Committer
 Syndamia <kamen.d.mladenov@protonmail.com>
2021-04-03 16:04:28 +0300
Files42808af0d2c6c2f14df7b7a5e976df936bcd66a0 /src/models
devrix-job-board-42a0e2f72fed0a947242b004a0fc6eb4a664174b.tar
devrix-job-board-42a0e2f72fed0a947242b004a0fc6eb4a664174b.tar.gz
devrix-job-board-42a0e2f72fed0a947242b004a0fc6eb4a664174b.zip
Parent39fd52b1aaf2fde1236fdef21df65ba768f598ed (diff)
Updated all double quotes to single quotes where possible
4 files changed, 36 insertions, 36 deletions
-rw-r--r--src/models/Company.php6
-rw-r--r--src/models/DB.php46
-rw-r--r--src/models/DBModel.php2
-rw-r--r--src/models/JobOffer.php18
diff --git a/src/models/Company.php b/src/models/Company.php
index 1dfb05e..965531e 100644
--- a/src/models/Company.php
+++ b/src/models/Company.php
@@ -1,5 +1,5 @@
<?php
-include_once("models/DBModel.php");
+include_once('models/DBModel.php');
class Company extends DBModel {
public string $name;
@@ -12,11 +12,11 @@ class Company extends DBModel {
* Everything from here is static functionality
*/
- public const TABLE_NAME = "companies";
+ public const TABLE_NAME = 'companies';
static function __constructStatic() {
$columns = array(
- "name " . DB::STRING_TYPE,
+ 'name ' . DB::STRING_TYPE,
);
self::$DB->createTable(self::TABLE_NAME, $columns);
}
diff --git a/src/models/DB.php b/src/models/DB.php
index 8174831..0f06573 100644
--- a/src/models/DB.php
+++ b/src/models/DB.php
@@ -3,34 +3,34 @@
* The model that has the database functionality. DO NOT instantiate this class! If you need an instance, extend the DBModel class!
*/
class DB {
- private static $servername = "localhost";
- private static $username = "root";
- private static $password = "password";
- private static $dbname = "devrix_job_board";
+ private static $servername = 'localhost';
+ private static $username = 'root';
+ private static $password = 'password';
+ private static $dbname = 'devrix_job_board';
- public const STRING_TYPE = "VARCHAR(100)";
- public const FLOAT_TYPE = "DOUBLE(16,4)";
- public const INTEGER_TYPE = "INT";
+ public const STRING_TYPE = 'VARCHAR(100)';
+ public const FLOAT_TYPE = 'DOUBLE(16,4)';
+ public const INTEGER_TYPE = 'INT';
private PDO $connection;
function __construct() {
// Try to connect
try {
- $this->connection = new PDO("mysql:host=" . self::$servername, self::$username, self::$password);
+ $this->connection = new PDO('mysql:host=' . self::$servername, self::$username, self::$password);
$this->connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch (PDOException $e) {
- echo "[DB Exception]: " . $e->getMessage();
+ echo '[DB Exception]: ' . $e->getMessage();
}
// Make sure the actual db exists
- $createDBQuery = "CREATE DATABASE IF NOT EXISTS " . self::$dbname . ";";
+ $createDBQuery = 'CREATE DATABASE IF NOT EXISTS ' . self::$dbname . ';';
$this->connection->exec($createDBQuery);
// Connect to the actual database
- $this->connection->exec("USE " . self::$dbname);
+ $this->connection->exec('USE ' . self::$dbname);
}
/**
@@ -63,20 +63,20 @@ class DB {
$query .= "{$column}, ";
}
- $query .= "PRIMARY KEY (id), ";
+ $query .= 'PRIMARY KEY (id), ';
foreach ($foreignKeys as $fk) {
$query .= "{$fk}, ";
}
- $query = rtrim($query, ", ");
- $query .= ");";
+ $query = rtrim($query, ', ');
+ $query .= ');';
try {
$this->connection->exec($query);
}
catch (PDOException $e) {
- echo "[DB Exception]: " . $e->getMessage();
+ echo '[DB Exception]: ' . $e->getMessage();
}
}
@@ -92,22 +92,22 @@ class DB {
$query = "INSERT INTO {$tableName} VALUES(NULL, ";
foreach($values as $value) {
- if (gettype($value) == "string") {
+ if (gettype($value) == 'string') {
$query .= "'{$value}', ";
}
else {
$query .= "{$value}, ";
}
}
- $query = rtrim($query, ", ");
+ $query = rtrim($query, ', ');
- $query .= ");";
+ $query .= ');';
try {
$this->connection->exec($query);
}
catch (PDOException $e) {
- echo "[DB Exception]: " . $e->getMessage();
+ echo '[DB Exception]: ' . $e->getMessage();
}
}
@@ -146,9 +146,9 @@ class DB {
$query = "UPDATE {$tableName} SET ";
for ($i = 0; $i < sizeof($values); $i += 2) {
- $query .= "{$values[$i]} = " . (gettype($values[$i+1]) == "string" ? "'{$values[$i+1]}'" : $values[$i+1]) . ", ";
+ $query .= "{$values[$i]} = " . (gettype($values[$i+1]) == 'string' ? "'{$values[$i+1]}'" : $values[$i+1]) . ', ';
}
- $query = rtrim($query, ", ");
+ $query = rtrim($query, ', ');
$query .= " WHERE id = {$id};";
@@ -156,7 +156,7 @@ class DB {
$this->connection->exec($query);
}
catch (PDOException $e) {
- echo "[DB Exception]: " . $e->getMessage();
+ echo '[DB Exception]: ' . $e->getMessage();
}
}
@@ -170,7 +170,7 @@ class DB {
$this->connection->exec("DELETE FROM {$tableName} WHERE id = {$id}");
}
catch (PDOException $e) {
- echo "[DB Exception]: " . $e->getMessage();
+ echo '[DB Exception]: ' . $e->getMessage();
}
}
}
diff --git a/src/models/DBModel.php b/src/models/DBModel.php
index 4e10c18..a9f931c 100644
--- a/src/models/DBModel.php
+++ b/src/models/DBModel.php
@@ -1,5 +1,5 @@
<?php
-include_once("DB.php");
+include_once('DB.php');
/**
* A class, mainly for holding the static DB class intance. You can also get your model id from here.
diff --git a/src/models/JobOffer.php b/src/models/JobOffer.php
index b86ff86..4fd7acc 100644
--- a/src/models/JobOffer.php
+++ b/src/models/JobOffer.php
@@ -1,6 +1,6 @@
<?php
-include_once("models/DBModel.php");
-include_once("models/Company.php");
+include_once('models/DBModel.php');
+include_once('models/Company.php');
/**
* Model that contains the required JobOffer properties. It also contains the request methods to the job_offers table.
@@ -22,17 +22,17 @@ class JobOffer extends DBModel {
* Everything from here is static functionality
*/
- public const TABLE_NAME = "job_offers";
+ public const TABLE_NAME = 'job_offers';
static function __constructStatic() {
$columns = array(
- "title " . DB::STRING_TYPE,
- "description " . DB::STRING_TYPE,
- "companyId " . DB::INTEGER_TYPE, // Requires a foreign key
- "salary " . DB::FLOAT_TYPE,
+ 'title ' . DB::STRING_TYPE,
+ 'description ' . DB::STRING_TYPE,
+ 'companyId ' . DB::INTEGER_TYPE, // Requires a foreign key
+ 'salary ' . DB::FLOAT_TYPE,
);
$foreignKeys = array(
- DB::genFK("companyId", Company::TABLE_NAME, "id")
+ DB::genFK('companyId', Company::TABLE_NAME, 'id')
);
self::$DB->createTable(self::TABLE_NAME, $columns, $foreignKeys);
}
@@ -77,7 +77,7 @@ class JobOffer extends DBModel {
* @param JobOffer $jb
*/
static function updateFromDB($jb) {
- self::$DB->updateById(self::TABLE_NAME, $jb->id, "title", $jb->title, "description", $jb->description, "companyId", $jb->companyId, "salary", $jb->salary);
+ self::$DB->updateById(self::TABLE_NAME, $jb->id, 'title', $jb->title, 'description', $jb->description, 'companyId', $jb->companyId, 'salary', $jb->salary);
}
/* Delete */