private function addAccount() { $db = Application::dbConnect(); $enteredName = $db->real_escape_string($this->enteredName); $passwordHash = md5($this->enteredPassword); $regdate = date('Y-m-d H:i:s', time()); $lastVisit = $regdate; $query = "INSERT INTO `users` (`name`, `password`, `regdate`, `lastvisit`) VALUES (\n\t\t\t\t\t\t'" . $enteredName . "',\n\t\t\t\t\t\t'" . $passwordHash . "',\n\t\t\t\t\t\t'" . $regdate . "',\n\t\t\t\t\t\t'" . $lastVisit . "'\n\t\t\t\t\t\t)"; $db->query($query); if (mysqli_errno($db)) { throw new \Exception(Messages::MYSQL_ERROR); } }
private function deleteAccount() { $db = Application::dbConnect(); $id = intval($this->id); $query = "DELETE FROM `users`\n WHERE `id` = " . $id; $db->query($query); if (mysqli_errno($db)) { throw new \Exception(Messages::MYSQL_ERROR); } }