Hello I want to ask how to make same as email but now with name "already taken" I tried but didn't work.
<?php
$mysqli = require __DIR__ . "/database.php";
// Check if $_GET["name"] is set and not empty
$name = isset($_GET["name"]) ? trim($_GET["name"]) : "";
// Check if email is not empty after trimming
if (!empty($name)) {
$escaped_name = $mysqli->real_escape_string($name);
$sql = "SELECT * FROM user WHERE name = '$escaped_name'";
$result = $mysqli->query($sql);
if ($result !== false) {
$is_available = $result->num_rows === 0;
echo json_encode(["available" => $is_available]);
} else {
die("Error: " . $mysqli->error);
}
} else {
echo json_encode(["error" => "Invalid or empty email parameter"]);
}
?>