Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
<?php
$pdo->query("create table users (id int, username int)");
$pdo->query("insert into users values (1, 200)");
$username = 200;
$conn = $pdo;
$sql = 'SELECT count(id) as count FROM users WHERE username=?';
$query = $conn->prepare($sql);
$query->execute([$username]);
$count_users = $query->fetch();
if ((int)$count_users['count'] === 0) {
$sql = "INSERT INTO users (`username`, `password`, `email`)
VALUES ('$username', '$password', '$email')";
} else {
echo "<script>alert('Логин уже занят')</script>";
}