Example #1
0
 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);
     }
 }
Example #2
0
 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);
     }
 }