prepare($sql);
$stmt->bind_param("s", $username);
$stmt->execute();
$result = $stmt->get_result();
if ($result->num_rows > 0) {
$error = "Username already exists";
} else {
// Check if email already exists
$sql = "SELECT * FROM wp_authors WHERE email = ?";
$stmt = $conn->prepare($sql);
$stmt->bind_param("s", $email);
$stmt->execute();
$result = $stmt->get_result();
if ($result->num_rows > 0) {
$error = "Email already exists";
} else {
// Hash password
$hashed_password = password_hash($password, PASSWORD_DEFAULT);
// Insert new user
$sql = "INSERT INTO wp_authors (name, username, email, password) VALUES (?, ?, ?, ?)";
$stmt = $conn->prepare($sql);
$stmt->bind_param("ssss", $name, $username, $email, $hashed_password);
if ($stmt->execute()) {
$_SESSION['success'] = "Registration successful! Please login.";
header("Location: login.php");
exit();
} else {
$error = "Registration failed";
}
}
}
}
}
?>
Sign Up