Ip-Ban

Question

Hello!
Please tell me the following script:
in the database my sql if the string = "Yes", then the user is blocked by the ip, if "No", then it is blocked
Thank you.

Answer 1

$sql = "SELECT * FROM user WHERE ip = '$ip";
$result = mysqli_query($conn, $sql);

while ($row = mysqli_fetch_assoc($result)) {
$string = $row["is_banned"];
}

if ($string === "No") {
/* User is not banned */
} else {
/* User is banned */
}