$formdata['password'] = filter_input($input_method, "password", FILTER_SANITIZE_STRING);
//if any of the form fields are empty
if (empty($formdata['username'])) {
$errors['username'] = "******";
}
if (empty($formdata['password'])) {
$errors['password'] = "******";
}
if (empty($errors)) {
// since none of the form fields were empty,
// store the form data in variables
$username = $formdata['username'];
$password = $formdata['password'];
// create a UserTable object and use it to retrieve
// the users
$connection = connection::getInstance();
$userTable = new UserTable($connection);
$user = $userTable->getUserByUn($username);
// since password fields match, see if the username
// has already been registered - if it is then throw
// and exception
if ($user == null) {
$errors['username'] = "******";
} else {
if ($password !== $user->getPassword()) {
$errors['password'] = "******";
}
}
}
if (!empty($errors)) {
throw new Exception("There were errors. Please fix them.");
public function getAmount($type)
{
$b = connection::getInstance()->prepare("SELECT count(*) as count FROM {$type}");
$b->execute();
$resColumn = $b->fetchAll();
if ($resColumn == null) {
return null;
}
return $resColumn[0]["count"];
}
