blob: b2069a2184d52da436a11765bf81ce035a943b38 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
|
<?php
function username_exists(string $username): bool
{
$sql = "SELECT * FROM users WHERE user_name = ?;";
$result = Database::get()->query($sql, "s", $username);
return !empty($result);
}
function register_user(string $username, string $pass_hash)
{
$sql = "INSERT INTO users(user_name, user_pass, user_date) VALUES(?, ?, NOW());";
Database::get()->query($sql, "ss", $username, $pass_hash);
}
function change_password(User $user, string $pass_hash)
{
$sql = "UPDATE users SET user_pass = ? WHERE user_id = ?;";
Database::get()->query($sql, "si", $pass_hash, $user->id);
}
|
