PHPize Online / SQLize Online  /  SQLtest Online

<?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>"; }