public static function emailFind($email)
{
$db = Database::connect();
//TODO: Change to prepared statement
if ($stmt = $db->query("SELECT id FROM Users WHERE email = '{$email}'")) {
if ($data = $stmt->fetch(\PDO::FETCH_ASSOC)) {
return new self($data["id"]);
} else {
//No user with that email
return false;
}
} else {
throw \Exception\DatabaseError::build($db);
}
}
public function delete()
{
$db = Database::connect();
if ($stmt = $db->prepare("DELETE FROM {$this->table} WHERE id=:id LIMIT 1;")) {
$stmt->bindParam(":id", $this->id);
if ($stmt->execute()) {
foreach ($this->getPublicProperties() as $p) {
$this->{$p} = null;
}
return true;
} else {
throw \Exception\DatabaseError::build($stmt);
}
} else {
throw \Exception\DatabaseError::build($db);
}
}
