PHP MySQL 查询返回许多数组，但只需要一个

Question

$connection = db_connect();
$query = mysqli_query($connection, "
SELECT * FROM birouri 
WHERE disponibilitate = 'LIBER' 
AND locatie_actuala = 'Orhideea' 
AND pauza = '' 
AND closed_program = '' 
AND feedback = '' 
LIMIT 1") or die(mysqli_error($connection));
            $row = mysqli_fetch_assoc($query);
            $username = $row['username'];
            $nr_birou = $row['nr_birou'];
            $disponibilitate = $row['disponibilitate'];
            $locatie_actuala = $row['locatie_actuala'];
            $pauza = $row['pauza'];
            $closed_program = $row['closed_program'];
            $feedback = $row['feedback'];
            $inregistrare_clienti = $row['inregistrare_clienti'];
            var_dump($row);

在数据库中，我有 6 行符合我的查询条件。

var_dump($row); 返回我 1 个数组(第一行(重复了 7 次，但我只需要显示一个。 Limit 1不起作用。

请帮忙。

Answer 1

更改此设置

$row = mysqli_fetch_assoc($query);
            $username = $row['username'];
            $nr_birou = $row['nr_birou'];
            $disponibilitate = $row['disponibilitate'];
            $locatie_actuala = $row['locatie_actuala'];
            $pauza = $row['pauza'];
            $closed_program = $row['closed_program'];
            $feedback = $row['feedback'];
            $inregistrare_clienti = $row['inregistrare_clienti'];

对此，它将起作用

while($row = mysqli_fetch_assoc($query)){
            $username = $row['username'];
            $nr_birou = $row['nr_birou'];
            $disponibilitate = $row['disponibilitate'];
            $locatie_actuala = $row['locatie_actuala'];
            $pauza = $row['pauza'];
            $closed_program = $row['closed_program'];
            $feedback = $row['feedback'];
            $inregistrare_clienti = $row['inregistrare_clienti'];
}

有 8 列，因此您的代码运行 8 次，但如果运行 while 循环，它只会运行一次