I am trying to get the following queries to delete the user after it has reached the expirydate. It was working before but for some reason, I can't seem to get the variables to pass through...
$sql2 = "SELECT * FROM users WHERE banned = ? AND ? < antispam;";
$stmt = mysqli_stmt_init($conn);
if (!mysqli_stmt_prepare($stmt, $sql2)) {
echo 'SQL error';
exit();
} else {
mysqli_stmt_bind_param($stmt, "is", $banned, $date);
mysqli_stmt_execute($stmt);
$result2 = mysqli_stmt_get_result($stmt);
$resultCheck2 = mysqli_num_rows($result2);
$row2 = mysqli_fetch_assoc($result2);
$username = $row2['user_uid'];
$email = $row2['user_email'];
$first_name = $row2['user_first'];
$last_name = $row2['user_last'];
if ($resultCheck2 > 0) {
} else {
echo 'Hello! your username is: '.$username;
$sql3 = "DELETE FROM users WHERE user_uid = ? AND user_email = ?;";
$stmt = mysqli_stmt_init($conn);
if(!mysqli_stmt_prepare($stmt, $sql3)) {
echo "SQL error";
} else {
mysqli_stmt_bind_param($stmt, "ss", $username, $email);
mysqli_stmt_execute($stmt);