/**
* @param CommentsBindingModel $model
* @throws \Exception
*/
private static function insert(CommentsBindingModel $model)
{
$db = Database::getInstance('app');
$query = "INSERT INTO comments (comment_text, user_id, date_time) VALUES (?, ?, ?)";
$result = $db->prepare($query);
$result->execute([$model->getComment(), $model->getUserId(), $model->getDateTime()]);
}
<?php
error_reporting(E_ERROR | E_WARNING | E_PARSE);
session_start();
require_once 'Autoloader.php';
\Mobius\Autoloader::init();
$uri = $_SERVER['REQUEST_URI'];
$self = $_SERVER['PHP_SELF'];
$directories = str_replace(basename($self), '', $self);
$requestString = str_replace($directories, '', $uri);
$requestString = strtolower($requestString);
$requestParams = explode("/", $requestString);
$controller = array_shift($requestParams);
$action = array_shift($requestParams);
\Mobius\Core\Database::setInstance(\Mobius\Config\DatabaseConfig::DB_INSTANCE, \Mobius\Config\DatabaseConfig::DB_DRIVER, \Mobius\Config\DatabaseConfig::DB_USER, \Mobius\Config\DatabaseConfig::DB_PASS, \Mobius\Config\DatabaseConfig::DB_NAME, \Mobius\Config\DatabaseConfig::DB_HOST);
if ($controller == "index.php") {
$controller = 'users';
$action = 'register';
}
$app = new \Mobius\Application($controller, $action, $requestParams);
$app->start();
//to register user you must go: http://localhost:(your port)/MobiusTask/users/register
//to login user you must go: http://localhost:(your port)/MobiusTask/users/login
//I use port 8004, to work links you must change 8004 to your port.
//SQL script in repository.
/**
* @param $username
* @return bool
* @throws \Exception
*/
public function exists($username)
{
$db = Database::getInstance('app');
$result = $db->prepare("SELECT id FROM users WHERE username = ?");
$result->execute([$username]);
return $result->rowCount() > 0;
}
