f ($_POST) {
$username = trim($_POST['username']);
$password = md5(trim($_POST['password']));
$nickname = trim($_POST['nickname'] ?? '');
$sql = "SELECT id FROM user WHERE username = ?";
$stmt = mysqli_prepare($conn, $sql);
mysqli_stmt_bind_param($stmt, "s", $username);
mysqli_stmt_execute($stmt);
if (mysqli_fetch_assoc(mysqli_stmt_get_result($stmt))) {
echo "";
} else {
$sql = "INSERT INTO user(username, password, nickname) VALUES(?, ?, ?)";
$stmt = mysqli_prepare($conn, $sql);
mysqli_stmt_bind_param($stmt, "sss", $username, $password, $nickname);
if (mysqli_stmt_execute($stmt)) {
echo "";
}
}
}
?>
用户注册 - 端午文化网
🌿 端午文化网站