/**
* @param string $hallName
* @return bool
*/
private function hallNameExists(string $hallName) : bool
{
$query = "SELECT id FROM halls WHERE name = ?";
$result = $this->db->prepare($query);
$result->execute([$hallName]);
return $result->rowCount() > 0;
}
/**
* @param int $id
* @throws ApplicationException
*/
public function getById(int $id)
{
$query = "SELECT\n u.id,\n u.username,\n u.fullname\n FROM users AS u\n WHERE u.id = ?";
$result = $this->db->prepare($query);
$result->execute([$id]);
if ($result->rowCount() < 1) {
throw new ApplicationException("User not found.");
}
return $result->fetch();
}
/**
* @return array
* @throws \Exception
*/
public function getAllRoles() : array
{
$db = Database::getInstance('app');
$result = $db->prepare("SELECT id, name FROM roles");
$result->execute([]);
return $result->fetchAll();
}
/**
* @param string $conferenceTitle
* @return bool
*/
private function conferenceTitleExists(string $conferenceTitle, int $id = -1) : bool
{
$query = "SELECT id FROM conferences WHERE title = ? AND id != ?";
$result = $this->db->prepare($query);
$result->execute([$conferenceTitle, $id]);
return $result->rowCount() > 0;
}
/**
* @param AbstractController $controller
* @return bool
*/
public static function saveController($controller)
{
if (is_a($controller, AbstractController::class)) {
$vars = get_object_vars($controller->getModel());
Database::getInstance()->insert($controller->getModel()->getTableName(), $vars);
return true;
}
return false;
}
public function start()
{
try {
Database::createNonExistingDatabase(DatabaseConfig::DB_NAME);
Database::setInstance(DatabaseConfig::DB_INSTANCE, DatabaseConfig::DB_DRIVER, DatabaseConfig::DB_USER, DatabaseConfig::DB_PASS, DatabaseConfig::DB_NAME, DatabaseConfig::DB_HOST);
} catch (\Exception $e) {
require_once "error.php";
exit;
}
Manager::getInstance()->start();
HttpContext::getInstance()->getIdentity()->setCurrentUser();
$this->frontController->dispatch();
}
public static function verifyCookie()
{
if (Cookie::exists(Config::get('cookie', 'name'))) {
$token = Cookie::get(Config::get('cookie', 'name'));
$toVerify = hash("sha512", $token . Utils::getClientIP());
if ($data = Database::getInstance()->get(call_user_func(self::getModelClass() . '::getTableName'), ['token' => $toVerify], ['user_uuid'])) {
if (array_key_exists(0, $data) && is_array($data[0])) {
$data = $data[0];
}
if (array_key_exists('user_uuid', $data)) {
return $data['user_uuid'];
}
}
Cookie::remove(Config::get('cookie', 'name'));
}
return false;
}
/**
* @param string $table
* @return bool
* @throws \Exception
*/
private function tableExists(string $table) : bool
{
$db = Database::getInstance('app');
$result = $db->prepare("SHOW TABLES LIKE ?");
$result->execute([$table]);
return $result->rowCount() > 0;
}
public static function index()
{
echo "<h1> DEFAULT STATE ALL POSTS </h1>";
$dbh = \Framework\Database\Database::getInstance();
//var_dump($dbh);
}
<?php
/**
* Copyright 2015 OhYea777
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
require_once '../src/Framework/bootstrap.php';
use Framework\Database\Database;
use Framework\Misc\Config;
Config::registerConfigFile('../config.json');
Database::getInstance();
/**
* @param int $userId
* @return UserProfileViewModel
* @throws \Exception
*/
public function getUserInfo(int $userId) : UserProfileViewModel
{
$db = Database::getInstance('app');
$result = $db->prepare("SELECT id, username, password, fullname FROM users WHERE id = ?");
$result->execute([$userId]);
$userRow = $result->fetch();
$user = new UserProfileViewModel();
$user->setId($userRow["id"])->setUsername($userRow["username"])->setFullName($userRow["fullname"]);
return $user;
}
public function __destruct()
{
\Framework\Database\Database::closeConnection();
}
public static function getUUIDBy($params)
{
return Database::getInstance()->get(call_user_func(self::getModelClass() . '::getTableName'), $params, ['uuid', 'password_hash']);
}
