使用while循环从mysql数据库中检查和检索数据 - Using while loop to check and retrieve data from mysql database

Using while loop to check and retrieve data from mysql database

我有音频文件存储在一个名为english ($path)的文件夹中，路径如下所示。文件名作为变量$Language1存储在mysql数据库中。通过使用$Language1，我想确保所有的音频文件都存在于文件夹中。该代码打印出存储在数据库中的所有文件名。但是它不能准确地告诉我文件夹中有哪些文件。

$servername = "localhost";
$user = "";
$password = "";
$dbname = "----";
// Create connection
$conn = mysqli_connect($servername, $user, $password, $dbname);
$query = "SELECT Language1 FROM LondonTEST";
$result = mysqli_query($conn, $query);
while($row = mysqli_fetch_array($result)) {
$Language1 = $row['Language1'];
$path = "/route/ to/ file/english/$Language1.mp3"; 
if (file_exists($path)) { 
    echo "The file $Language1 exists<br/>";
    } 
else
    { 
    echo "The file $Language1 does not exist<br/>";
    } 
} 
mysqli_close($conn);

这就行了

  $conn = mysqli_connect($servername, $user, $password, $dbname);
    $query = "SELECT Language1 FROM LondonTEST";
    $result = mysqli_query($conn, $query);
    if(mysqli_num_rows($result) > 0){ // to check any rows exists or not
        while($row = mysqli_fetch_array($result)) {
        $Language1 = $row['Language1'];
        $path = "/route/to/file/english/$Language1"; 
            if (file_exists($path)) { 
                echo "The file $Language1 exists<br/>";
            } 
            else { 
            echo "The file $Language1 does not exist<br/>";
            } 
        } 
    }
    mysqli_close($conn);