function createDefaultDatabase() { $pdo = \defaultTodoPdo(); $createTable = $pdo->exec(' CREATE TABLE IF NOT EXISTS `users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `username` varchar(255) NOT NULL COMMENT "Username", `email` varchar(255) NOT NULL COMMENT "Email", `password` varchar(255) NOT NULL COMMENT "Password", `fullname` varchar(255) NOT NULL COMMENT "Full name", `website` varchar(255) DEFAULT NULL COMMENT "Website", `active` int(11) NOT NULL COMMENT "0", PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; INSERT INTO `users` (`id`, `username`, `email`, `password`, `fullname`, `website`, `active`) VALUES (1, "harikt", "*****@*****.**", "$2y$10$PAzgJnHd/gTQzNznVg7un.HGEuGHYtYACCFknGuf.4diSunu3MA7C", "Hari KT", "http://harikt.com", 1), (2, "pmjones", "*****@*****.**", "$2y$10$vtW.Fu8fhWuuCZz6s/jus.ilkzOMjMGwbzdkZNUzIVZLc.PV/6dVG", "Paul M Jones", "http://paul-m-jones.com", 1); '); $createTable = $pdo->exec(' CREATE TABLE IF NOT EXISTS `todo` ( `todoId` int(11) NOT NULL AUTO_INCREMENT, `description` varchar(255) NOT NULL COMMENT "String description of this Todo", `userId` int(11) DEFAULT NULL COMMENT "Id of the User connected to this Todo", PRIMARY KEY (`todoId`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; '); }
public function define(Container $di) { /* why can't a trait be set? $u = User(); $m = new \Domain\Todo\Mapper; $t = new \Domain\Todo\TodoEntity; $p = new \Aura\Payload\Payload(); $di->params['Domain\Todo\ApplicationService\EditItem']['user'] = $u; $di->params['Domain\Todo\ApplicationService\EditItem']['mapper'] = $m; $di->params['Domain\Todo\ApplicationService\EditItem']['payload'] = $p; $di->params['Domain\Todo\ApplicationService\AddItem']['user'] = $u; $di->params['Domain\Todo\ApplicationService\AddItem']['mapper'] = $m; $di->params['Domain\Todo\ApplicationService\AddItem']['payload'] = $p; $di->params['Domain\Todo\ApplicationService\GetList']['user'] = $u; $di->params['Domain\Todo\ApplicationService\GetList']['mapper'] = $m; $di->params['Domain\Todo\ApplicationService\GetList']['payload'] = $p; $di->params['Domain\Todo\ApplicationService\DeleteItem']['user'] = $u; $di->params['Domain\Todo\ApplicationService\DeleteItem']['mapper'] = $m; $di->params['Domain\Todo\ApplicationService\DeleteItem']['payload'] = $p; */ $databaseHandle = \defaultTodoPdo(); $di->params['Aura\\Sql\\ExtendedPdo']['dsn'] = $databaseHandle; $di->set('aura/payload', $di->lazyNew('Aura\\Payload\\Payload')); $di->set('user', $di->lazyNew('Domain\\User\\User')); $di->types['User'] = $di->lazyGet('user'); $di->params['Aura\\Auth\\AuthFactory']['cookie'] = $_COOKIE; $di->params['Aura\\Auth\\Verifier\\PasswordVerifier']['algo'] = PASSWORD_DEFAULT; // should be optional }
<?php // use josegonzalez\Dotenv\Loader as Dotenv; require '../vendor/autoload.php'; startSession(); loadDotEnv(__DIR__); $authFactory = new \Aura\Auth\AuthFactory($_COOKIE); $auth = $authFactory->newInstance(); // // $pdo = \defaultTodoPdo(); $cols = array('username', 'password', 'email', 'fullname', 'website'); $from = 'users'; $where = 'active = 1'; $hash = new \Aura\Auth\Verifier\PasswordVerifier(PASSWORD_DEFAULT); $pdoAdapter = $authFactory->newPdoAdapter($pdo, $hash, $cols, $from, $where); // $loginService = $authFactory->newLoginService($pdoAdapter); try { if (isset($_POST['username']) && isset($_POST['password'])) { $loginService->login($auth, array('username' => $_POST['username'], 'password' => $_POST['password'])); $auth->setUserName($_POST['username']); } } catch (\Aura\Auth\Exception\UsernameMissing $e) { echo "The 'username' field is missing or empty."; } catch (\Aura\Auth\Exception\PasswordMissing $e) { echo "The 'password' field is missing or empty."; } catch (\Aura\Auth\Exception\UsernameNotFound $e) { echo "The username you entered was not found."; } catch (\Aura\Auth\Exception\MultipleMatches $e) {