Raffle Number Generator

raffle.php

<?php
    // Generate Random Raffle Number
    // Default array reference
    $raffle = range(1, 100);

    // Fetch used raffle number
    $used = "SELECT * FROM $raffletemp";
    $query = $mysqli->query($used);
    while ($u = mysqli_fetch_array($query)) {
        $r[] = $u['used'];
    }

    // remove the used number in the new array
    if (isset($r)) {
        $c_raffle = array_diff($raffle, $r);
        shuffle($c_raffle);

        if (array_filter($c_raffle)) {
            // If registration not full
            $raffleno = $c_raffle[0];
            $data = mysqli_query( $mysqli, "INSERT INTO $raffletemp (used) VALUES ('$raffleno')" );
        }

    } else {
        // default range 1-100 for first timer
        shuffle($raffle);

        if (array_filter($raffle)) {
            // If registration not full
            $raffleno = $raffle[0];
            $data = mysqli_query( $mysqli, "INSERT INTO $raffletemp (used) VALUES ('$raffleno')" );
        }
    }

echo "$raffleno";

?>