BIM-Monitor/script/php/display.php

<?php
    include "connectSQL.php";

    $sql = "SELECT * FROM components";
    $fetchResult = sqlsrv_query($conn, $sql);

    
    while ($row = sqlsrv_fetch_array($fetchResult)) {
        $row["FBX檔名"] = str_replace(".fbx", "", $row["FBX檔名"]);
        $row["MD5FBX檔名"] = str_replace(".fbx", "", $row["MD5FBX檔名"]);
        
		echo '<li> <a href="./index.php?pic=' . $row["MD5FBX檔名"] . '">'. $row["FBX檔名"].'</a> </li>';
	}    
?>