How to check if any items in an array (php) is in a table (mysql)

Question

I have made a random character generator, but how can I check if an result already exist in the database?
E.g., if I want 5000 results, and 1 result is equal to an result in the database, it must create a new result in the for-loop.

$previous = array();

for ($i=1; $i<=$quantity; $i++){
                       
    $unique_found = false;
    while(!$unique_found){
        $a = substr(str_shuffle("1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ"), 0, 4);
        $b = substr(str_shuffle("1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ"), 0, 4);
        $c = substr(str_shuffle("1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ"), 0, 4);
        $d = substr(str_shuffle("1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ"), 0, 4);

        $code = "$a-$b-$c-$d";

        if(!in_array($code,$previous)){
            $unique_found = true;
            $previous[] = $code;
            echo .$code .'<br>';
        }
    }

}

You can check into database but what if your data is too much ? I like to suggest Timestamp(); of php which will provide you unique key every time. — AkshayP
– AkshayP, Commented Mar 10, 2015 at 9:26

CT14.IT · Accepted Answer · 2015-03-10 09:23:39Z

1

Populate the $previous array with results in the database already.

$previous = array();
$sql = "SELECT `code` FROM `table`";
$result = $conn->query($sql);
while($row = $result->fetch_assoc()){
    $previous[] = $row['code'];
}

for ($i=1; $i<=$aantal; $i++){
    // ....

answered Mar 10, 2015 at 9:23

CT14.IT

1,7671 gold badge17 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to check if any items in an array (php) is in a table (mysql)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related