public function install() { try { $this->queryBuilder->createDatabase(Config::getDatabaseName())->useDatabase(Config::getDatabaseName())->createTable('users', ['user_id' => 'smallint(6) NOT NULL PRIMARY KEY AUTO_INCREMENT', 'user_name' => 'varchar(30) NOT NULL', 'email' => 'varchar(30) NOT NULL', 'user_password' => 'char(60) NOT NULL'], ['ENGINE=InnoDB', 'DEFAULT CHARSET=utf8']); } catch (\Exception $e) { echo $e->getMessage(); } }
/** * @param string $attribute * @param string $value * @return UserVO * @throws \Exception */ public function findBy(string $attribute, string $value) { $params = [$attribute => $value]; $row = $this->queryBuilder->useDatabase(Config::getDatabaseName())->select()->from(self::TABLE)->where($attribute, '=')->execute($params)->getRow(); $userVO = new UserVO(); $userVO->setEmail($row['email']); $userVO->setUserName($row['user_name']); $userVO->setUserPassword($row['user_password']); return $userVO; }