php，控制生成时复制名称

Question

i'm new in php. i just want to generate random names (or what you want...). it does works! but when i put in the middle of the code one "do/while" to control and avoid duplicates names it DOES NOT WORKS.... why? what's wrog with my code? i'm exhauste, destroyed.

<?php
require_once 'config.php';
require_once 'dbconn.php';

function getnome() {
    $nome = ['tin', 'pin', 'nid', 'din', 'vin'];

    return $nome[mt_rand(0, count($nome) - 1)];
}

for ($f =0; $f<6; $f++) {
    $arr = [];
    do {
    $x = getnome();
       }
    while (in_array($x, $arr));
    $arr[]=$x;

    $query = "INSERT INTO ants (ant_id, nome) VALUES (NULL, '".getnome()."')";
        $res = $mysqli->query($query);
        if (!$res) {
            echo('<br>Error' . $mysqli->error);
        } else {
            echo $mysqli->affected_rows . ' created';
        }

}
?>

enter image description here

Answer 1

A simpler way to get unique values out of an array is to randomize the array and then process it in order.

$stmt = $mysqli->prepare("INSERT INTO ants (nome) VALUES (?)");
$stmt->bind_param("s", $a_nome);
$nome = ['tin', 'pin', 'nid', 'din', 'vin'];
shuffle($nome);
foreach ($nome as $a_nome) {
    $stmt->execute();
}